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

View of /BioSimScratch/BssSchema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.3 - (download) (annotate)
Thu Apr 1 00:04:43 2004 UTC (15 years, 7 months ago) by efrank
Branch: MAIN
Changes since 1.2: +2 -0 lines
destroyBss:
	bliztes all tables, triggers and contraints.

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