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

Annotation of /BioSimScratch/BssSchema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.5 - (view) (download)

1 : efrank 1.1
2 : efrank 1.5
3 :     -- ---------------------------------------------------------------
4 :     drop table KahDatabaseInfo;
5 :     create table KahDatabaseInfo (
6 :     --
7 :     -- Just record some config information for this database instance.
8 :     -- ---------------------------------------------------------------
9 :     --
10 :     foundryType varchar2(128) NOT NULL,
11 :     foundryUrl varchar2(128) NOT NULL
12 :     -- "url" is a misnomer
13 :     --
14 :     );
15 :    
16 :    
17 : efrank 1.1 -- ----------------------------------------------------------------------
18 :     drop sequence RxIdSequence;
19 :     create sequence RxIdSequence increment by 1 start with 50000;
20 :     --
21 :     --
22 :     -- A sequence for inserting reactions
23 :    
24 :    
25 :     -- ----------------------------------------------------------------------
26 :     drop sequence RecoIdSequence;
27 :     create sequence RecoIdSequence increment by 1 start with 100;
28 :     --
29 :     --
30 :     -- A sequence for inserting reactions
31 :    
32 :     -- ----------------------------------------------------------------------
33 :     drop sequence ProcIdSequence;
34 :     create sequence ProcIdSequence increment by 1 start with 50000;
35 :     --
36 :     --
37 :     -- A sequence for inserting reactions
38 :    
39 :    
40 :     -- ----------------------------------------------------------------------
41 :     drop sequence EnzymeRoleIdSequence;
42 :     create sequence EnzymeRoleIdSequence increment by 1 start with 50000;
43 :     --
44 :     -- A sequence for inserting enzymeRoles (an (ec,chem-name) bound to a rx)
45 :     --
46 :    
47 : park 1.2 -- ----------------------------------------------------------------------
48 :     drop sequence CompoundIdSequence;
49 :     create sequence CompoundIdSequence increment by 1 start with 50000;
50 :     --
51 :     -- A sequence for inserting compounds into the database
52 :     --
53 :    
54 : efrank 1.5
55 : efrank 1.1 @FnlChartTab
56 :     @ExcelBasedECTables
57 : efrank 1.3 @CreateCatalog
58 : efrank 1.4 --@TriggerCatalog

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3