[Bio] / BioSimScratch / BssSchema-pg.sql Repository:
ViewVC logotype

View of /BioSimScratch/BssSchema-pg.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (download) (annotate)
Tue Oct 19 19:33:32 2004 UTC (15 years ago) by efrank
Branch: MAIN
CVS Tags: post-st-migration2, sc2004-3, post-st-migration, sc2004-4, sc04-finalDay, sc2004-2, sc2004-1, sc2004-0, HEAD
make work for pg too


-- ---------------------------------------------------------------
drop   table KahDatabaseInfo;
create table KahDatabaseInfo (
--
-- Just record some config information for this database instance.
-- ---------------------------------------------------------------
--
	foundryType   	varchar	NOT NULL,
	foundryUrl   	varchar	NOT NULL
--         "url" is a misnomer
--
);


-- ----------------------------------------------------------------------
drop   sequence RxIdSequence;
create sequence RxIdSequence  increment by 1 start with  50000;
--
--
-- A sequence for inserting reactions


-- ----------------------------------------------------------------------
drop   sequence RecoIdSequence;
create sequence RecoIdSequence  increment by 1 start with  100;
--
--
-- A sequence for inserting reactions

-- ----------------------------------------------------------------------
drop   sequence ProcIdSequence;
create sequence ProcIdSequence  increment by 1 start with  50000;
--
--
-- A sequence for inserting reactions


-- ----------------------------------------------------------------------
drop   sequence EnzymeRoleIdSequence;
create sequence EnzymeRoleIdSequence increment by 1 start with 50000;
--
-- A sequence for inserting enzymeRoles (an (ec,chem-name) bound to a rx)
--

-- ----------------------------------------------------------------------
drop   sequence CompoundIdSequence;
create sequence CompoundIdSequence increment by 1 start with 50000;
--
-- A sequence for inserting compounds into the database
--

--@FnlChartTab
--@ExcelBasedECTables
--@CreateCatalog
--@TriggerCatalog

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3