Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== diff -u -ra7b8600cfd047060de28c119b09c0ca13222ff5b -r9dd2af2b02ec99dd3490c39cdd634b6c77f0527c --- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision a7b8600cfd047060de28c119b09c0ca13222ff5b) +++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 9dd2af2b02ec99dd3490c39cdd634b6c77f0527c) @@ -1077,7 +1077,7 @@ , patch_level INTEGER(11) NOT NULL , patch_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , patch_in_progress CHAR(1) NOT NULL DEFAULT 'F' - , PRIMARY KEY (system_name) + , PRIMARY KEY(system_name, patch_level) )ENGINE=InnoDB; CREATE TABLE lams_registration (