Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v
diff -u -r1.167 -r1.167.2.1
--- lams_common/db/sql/create_lams_11_tables.sql	20 Mar 2012 01:40:53 -0000	1.167
+++ lams_common/db/sql/create_lams_11_tables.sql	12 Oct 2014 18:01:33 -0000	1.167.2.1
@@ -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 (