-ALTER TABLE LocTypeCode ADD CONSTRAINT pk_LocTypeCode PRIMARY KEY (code ASC);
-ALTER TABLE MapLinkCode ADD CONSTRAINT pk_MapLinkCode PRIMARY KEY (which_code ASC,code ASC);
-ALTER TABLE Method ADD CONSTRAINT pk_Method_mid PRIMARY KEY (method_id ASC);
-ALTER TABLE MethodClass ADD CONSTRAINT pk_MethodClass PRIMARY KEY (meth_class_id ASC);
-ALTER TABLE MethodLine ADD CONSTRAINT pk_MethodLine PRIMARY KEY (method_id ASC,line_num ASC);
-ALTER TABLE Moltype ADD CONSTRAINT pk_Moltype PRIMARY KEY (code ASC);
-ALTER TABLE Motif ADD CONSTRAINT pk_Motif PRIMARY KEY (motif_id ASC);
-ALTER TABLE ObsGenotype ADD CONSTRAINT pk_ObsGenotype PRIMARY KEY (gty_id ASC);
+ALTER TABLE LocTypeCode ADD CONSTRAINT pk_LocTypeCode PRIMARY KEY (code);
+ALTER TABLE MapLinkCode ADD CONSTRAINT pk_MapLinkCode PRIMARY KEY (which_code,code);
+ALTER TABLE Method ADD CONSTRAINT pk_Method_mid PRIMARY KEY (method_id);
+ALTER TABLE MethodClass ADD CONSTRAINT pk_MethodClass PRIMARY KEY (meth_class_id);
+ALTER TABLE MethodLine ADD CONSTRAINT pk_MethodLine PRIMARY KEY (method_id,line_num);
+ALTER TABLE Moltype ADD CONSTRAINT pk_Moltype PRIMARY KEY (code);
+ALTER TABLE Motif ADD CONSTRAINT pk_Motif PRIMARY KEY (motif_id);
+ALTER TABLE ObsGenotype ADD CONSTRAINT pk_ObsGenotype PRIMARY KEY (gty_id);