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

View of /BioSimScratch/BssSchema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.4 - (download) (annotate)
Fri Apr 9 14:48:10 2004 UTC (15 years, 7 months ago) by efrank
Branch: MAIN
Changes since 1.3: +1 -1 lines
Modified files:
	adjustments in data sizes and little details
	destroyBss can probably be simplified.

Added files:
	ReloadBssData loads data into an empty database.  It calls
	the other guys to do the work:  Aiba*, glyc*, loadbuchnera*, testCas*

	buildNewBssCatalog.py:  copies data from old style catalog to new.


1. destroyBss                   deletes EVERYTHING
2. sqlplus
        @Rebuild                rebuilds schema.  reloads some reactions etc.
3. ReloadBssData                puts some data back in...OLD style catalog
4. buildNewBssCatalog.py        copies data from old style catalog to new.

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