add_primary_key.sql

-- Alter tables exported from Serena/PVCS Tracker to have primary key.
-- Then we can use SqlAlchemy's SQLsoup to work with it.
-- Use like:
--   sqlplus $USERNAME/$PASSWORD@$HOST_FQDN_OR_IP/xe < add_primary_key.sql

ALTER TABLE TRKASSOC		add primary key	(associd);
ALTER TABLE TRKCH   		add primary key	(chid);
ALTER TABLE TRKCHG  		add primary key	(chgid);
-- Nonstandard: ALTER TABLE TRKCTL   add primary key	(CTLid);
ALTER TABLE TRKCTL  		add primary key	(ctltableid);
ALTER TABLE TRKDEP  		add primary key	(DEPid);
ALTER TABLE TRKFE   		add primary key	(FEid);
ALTER TABLE TRKFILE 		add primary key	(FILEid);
ALTER TABLE TRKFLD  		add primary key	(FLDid);
ALTER TABLE TRKFME  		add primary key	(FMEid);
ALTER TABLE TRKFOL  		add primary key	(FOLid);
ALTER TABLE TRKFORM 		add primary key	(FORMid);
ALTER TABLE TRKGLB  		add primary key	(GLBid);
ALTER TABLE TRKISTYPE 		add primary key	(ISTYPEid);
ALTER TABLE TRKMCE 		add primary key	(MCEid);
ALTER TABLE TRKMOD 		add primary key	(MODid);
ALTER TABLE TRKNOTE 		add primary key	(NOTEid);
ALTER TABLE TRKPERM 		add primary key	(PERMid);
ALTER TABLE TRKQRY 		add primary key	(QRYid);
ALTER TABLE TRKREG 		add primary key	(REGid);
ALTER TABLE TRKREL 		add primary key	(RELid);
ALTER TABLE TRKRELISTYPE    	add primary key	(RELISTYPEid);
ALTER TABLE TRKRELTYPE 	    	add primary key	(RELTYPEid);
ALTER TABLE TRKRPT 	    	add primary key	(RPTid);
ALTER TABLE TRKRSET 	    	add primary key	(RSETid);
ALTER TABLE TRKRUL 	    	add primary key	(RULid);
-- nonstandard: ALTER TABLE TRKSCRSL 	     add primary key	(SCRSLid);
ALTER TABLE TRKSCRSL 	    	add primary key	(id);
-- nonstandard: ALTER TABLE TRKSCRST 	    	add primary key	(SCRSTid);
ALTER TABLE TRKSCRST 	    	add primary key	(id);
ALTER TABLE TRKSTY 	    	add primary key	(STYid);
ALTER TABLE TRKTERM 	    	add primary key	(TERMid);
ALTER TABLE TRKTFE 	    	add primary key	(TFEid);
ALTER TABLE TRKTSE 	    	add primary key	(TSEid);
ALTER TABLE TRKTYPE 	    	add primary key	(TYPEid);
ALTER TABLE TRKUG 	    	add primary key	(UGid);
ALTER TABLE TRKUGE 	    	add primary key	(UGEid);
ALTER TABLE TRKUSR 	    	add primary key	(USRid);
ALTER TABLE TRKXPRJ 	    	add primary key	(XPRJid);