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

View of /BioSimScratch/BssSchema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.5 - (download) (annotate)
Mon Jul 12 20:38:19 2004 UTC (15 years, 3 months ago) by efrank
Branch: MAIN
CVS Tags: post-st-migration2, mass-spec-01, sc2004-3, mass-spec-02, post-st-migration, forRick-14Jul04-1, forRick-14Jul04-0, sc2004-4, sc04-finalDay, sc2004-2, sc2004-1, sc2004-0, HEAD
Changes since 1.4: +16 -0 lines
KahOM/KahDataMgr:
	first pass at top level data manager to be returned from catalogentry read

Schema:
	added KahDatabaseInfo to put fid into database.
	create- changed so that no long initialize name of top catalogEntry (see below)
	destroyBss- changed !#/usr/bin/py to env py

FaST:
	txMgr - fixed close()...added self
	BssFactory - now gets fid via kahDatabaseInfo in database

PyGUI
	change so that something or another


-- ---------------------------------------------------------------
drop   table KahDatabaseInfo;
create table KahDatabaseInfo (
--
-- Just record some config information for this database instance.
-- ---------------------------------------------------------------
--
	foundryType   	varchar2(128)	NOT NULL,
	foundryUrl   	varchar2(128)	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