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

View of /BioSimScratch/BssSchema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.2 - (download) (annotate)
Tue Aug 12 19:30:25 2003 UTC (16 years, 3 months ago) by park
Branch: MAIN
Changes since 1.1: +7 -0 lines
Add sequence for compound ID

-- ----------------------------------------------------------------------
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

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3