[Bio] / IGSBPortal / schema.sql Repository:
ViewVC logotype

View of /IGSBPortal/schema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (download) (annotate)
Tue Jul 6 17:05:45 2010 UTC (9 years, 3 months ago) by wilke
Branch: MAIN
CVS Tags: HEAD
*** empty log message ***

CREATE TABLE _metainfo ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, info_name VARCHAR(255), info_value VARCHAR(255) )
INSERT INTO _metainfo (info_name,info_value) VALUES ('module_name','IGSB_DB')
CREATE TABLE _references ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, _database VARCHAR(512), _backend_type VARCHAR(255), _backend_data VARCHAR(1024) )
CREATE TABLE _objects ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, object VARCHAR(255) )
INSERT INTO _objects (object) VALUES ('Customer')
CREATE TABLE Customer ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, country VARCHAR(255), Street VARCHAR(255), phone VARCHAR(255), state VARCHAR(255), last_name VARCHAR(255), email VARCHAR(255), city VARCHAR(255), postal_code VARCHAR(255), fax VARCHAR(255), first_name VARCHAR(255), institution VARCHAR(255) )
INSERT INTO _objects (object) VALUES ('RequestData')
CREATE TABLE RequestData ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, request INTEGER, _request_db INTEGER, value TEXT, tag VARCHAR(255) )
CREATE INDEX RequestData_0 ON RequestData ( request, _request_db )
INSERT INTO _objects (object) VALUES ('SampleHistory')
CREATE TABLE SampleHistory ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, status VARCHAR(255), date TIMESTAMP, sample INTEGER, _sample_db INTEGER )
INSERT INTO _objects (object) VALUES ('Request')
CREATE TABLE Request ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, ID VARCHAR(255), current_status VARCHAR(255), ltime TIMESTAMP, Date INTEGER )
CREATE UNIQUE INDEX Request_unique_0 ON Request ( ID )
INSERT INTO _objects (object) VALUES ('Sample')
CREATE TABLE Sample ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, request INTEGER, _request_db INTEGER, received_date VARCHAR(255), ID VARCHAR(255), storage_location VARCHAR(255), status VARCHAR(255), name VARCHAR(255), hgac_id VARCHAR(255) )
CREATE UNIQUE INDEX Sample_unique_0 ON Sample ( ID )
CREATE UNIQUE INDEX Sample_unique_1 ON Sample ( hgac_id )
CREATE INDEX Sample_0 ON Sample ( request, _request_db )
CREATE TABLE Request_status_history ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, _array_index INTEGER, _source_id INTEGER, _value TEXT )
CREATE TABLE _metainfo ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, info_name VARCHAR(255), info_value VARCHAR(255) )
INSERT INTO _metainfo (info_name,info_value) VALUES ('module_name','IGSB_DB')
CREATE TABLE _references ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, _database VARCHAR(512), _backend_type VARCHAR(255), _backend_data VARCHAR(1024) )
CREATE TABLE _objects ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, object VARCHAR(255) )
INSERT INTO _objects (object) VALUES ('Customer')
CREATE TABLE Customer ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, country VARCHAR(255), Street VARCHAR(255), phone VARCHAR(255), state VARCHAR(255), last_name VARCHAR(255), email VARCHAR(255), city VARCHAR(255), postal_code VARCHAR(255), fax VARCHAR(255), first_name VARCHAR(255), institution VARCHAR(255) )
INSERT INTO _objects (object) VALUES ('RequestData')
CREATE TABLE RequestData ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, request INTEGER, _request_db INTEGER, value TEXT, tag VARCHAR(255) )
CREATE INDEX RequestData_0 ON RequestData ( request, _request_db )
INSERT INTO _objects (object) VALUES ('SampleHistory')
CREATE TABLE SampleHistory ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, status VARCHAR(255), date TIMESTAMP, sample INTEGER, _sample_db INTEGER )
INSERT INTO _objects (object) VALUES ('Request')
CREATE TABLE Request ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, ID VARCHAR(255), current_status VARCHAR(255), ltime TIMESTAMP, Date INTEGER )
CREATE UNIQUE INDEX Request_unique_0 ON Request ( ID )
INSERT INTO _objects (object) VALUES ('Sample')
CREATE TABLE Sample ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, request INTEGER, _request_db INTEGER, received_date VARCHAR(255), ID VARCHAR(255), storage_location VARCHAR(255), status VARCHAR(255), name VARCHAR(255), hgac_id VARCHAR(255) )
CREATE UNIQUE INDEX Sample_unique_0 ON Sample ( ID )
CREATE UNIQUE INDEX Sample_unique_1 ON Sample ( hgac_id )
CREATE INDEX Sample_0 ON Sample ( request, _request_db )
CREATE TABLE Request_status_history ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, _array_index INTEGER, _source_id INTEGER, _value TEXT )
CREATE TABLE _metainfo ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, info_name VARCHAR(255), info_value VARCHAR(255) )
INSERT INTO _metainfo (info_name,info_value) VALUES ('module_name','IGSB_DB')
CREATE TABLE _references ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, _database VARCHAR(512), _backend_type VARCHAR(255), _backend_data VARCHAR(1024) )
CREATE TABLE _objects ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, object VARCHAR(255) )
INSERT INTO _objects (object) VALUES ('Customer')
CREATE TABLE Customer ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, country VARCHAR(255), Street VARCHAR(255), phone VARCHAR(255), state VARCHAR(255), last_name VARCHAR(255), email VARCHAR(255), city VARCHAR(255), postal_code VARCHAR(255), fax VARCHAR(255), first_name VARCHAR(255), institution VARCHAR(255) )
INSERT INTO _objects (object) VALUES ('RequestData')
CREATE TABLE RequestData ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, request INTEGER, _request_db INTEGER, value TEXT, tag VARCHAR(255) )
CREATE INDEX RequestData_0 ON RequestData ( request, _request_db )
INSERT INTO _objects (object) VALUES ('SampleHistory')
CREATE TABLE SampleHistory ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, status VARCHAR(255), date TIMESTAMP, sample INTEGER, _sample_db INTEGER )
INSERT INTO _objects (object) VALUES ('Request')
CREATE TABLE Request ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, ID VARCHAR(255), current_status VARCHAR(255), ltime TIMESTAMP, Date INTEGER )
CREATE UNIQUE INDEX Request_unique_0 ON Request ( ID )
INSERT INTO _objects (object) VALUES ('Sample')
CREATE TABLE Sample ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, request INTEGER, _request_db INTEGER, received_date VARCHAR(255), ID VARCHAR(255), storage_location VARCHAR(255), status VARCHAR(255), name VARCHAR(255), hgac_id VARCHAR(255) )
CREATE UNIQUE INDEX Sample_unique_0 ON Sample ( ID )
CREATE UNIQUE INDEX Sample_unique_1 ON Sample ( hgac_id )
CREATE INDEX Sample_0 ON Sample ( request, _request_db )
CREATE TABLE Request_status_history ( _id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, _array_index INTEGER, _source_id INTEGER, _value TEXT )

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3