From: <tr...@us...> - 2002-09-09 10:23:08
|
Update of /cvsroot/basedb/basedb In directory usw-pr-cvs1:/tmp/cvs-serv4536 Modified Files: base_pg.sql Log Message: Re-added quotes around all mixed-case column names Index: base_pg.sql =================================================================== RCS file: /cvsroot/basedb/basedb/base_pg.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** base_pg.sql 8 Sep 2002 14:48:00 -0000 1.1 --- base_pg.sql 9 Sep 2002 10:23:04 -0000 1.2 *************** *** 22,26 **** id integer DEFAULT nextval('array_id_seq'::text) NOT NULL, batch integer DEFAULT '0' NOT NULL, ! orderNumber smallint DEFAULT '0' NOT NULL, barcode character varying(20) DEFAULT '' NOT NULL, destroyed smallint DEFAULT '0' NOT NULL, --- 22,26 ---- id integer DEFAULT nextval('array_id_seq'::text) NOT NULL, batch integer DEFAULT '0' NOT NULL, ! "orderNumber" smallint DEFAULT '0' NOT NULL, barcode character varying(20) DEFAULT '' NOT NULL, [...1591 lines suppressed...] -- --- 2221,2225 ---- -- ! CREATE INDEX addeddate_news_index ON News USING btree ("addedDate"); -- *************** *** 2237,2241 **** -- ! CREATE INDEX mol_rawbioassaydata_index ON RawBioAssayData USING btree (rawBioAssay, molecule); -- --- 2229,2233 ---- -- ! CREATE INDEX mol_rawbioassaydata_index ON RawBioAssayData USING btree ("rawBioAssay", molecule); -- |