[Bio] / DomReg / DomReg.sql Repository:
ViewVC logotype

View of /DomReg/DomReg.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.3 - (download) (annotate)
Fri Feb 2 16:31:05 2007 UTC (12 years, 9 months ago) by bartels
Branch: MAIN
CVS Tags: HEAD
Changes since 1.2: +29 -7 lines
*** empty log message ***

CREATE DATABASE DomReg;
USE DomReg;
CREATE TABLE _metainfo (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id), info_name CHAR(255), info_value CHAR(255));
CREATE TABLE _references (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id), _database CHAR(255));
INSERT INTO _metainfo (info_name, info_value) VALUES('module_name', 'DomReg');
CREATE TABLE _objects (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id), object CHAR(255));
INSERT INTO _objects (object) VALUES ('RiboType');
CREATE TABLE RiboType (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	name CHAR(250)
	);
INSERT INTO _objects (object) VALUES ('BSMotif');
CREATE TABLE BSMotif (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	graphix BLOB,
	Regulator int,
	_Regulator_db int,
	structure CHAR(250),
	name CHAR(250),
	consensus TEXT
	);
CREATE TABLE Regulon_BindingSites (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	_array_index int,
	_target_id int,
	_source_id int,
	_target_db int
	);
INSERT INTO _objects (object) VALUES ('Riboswitch');
CREATE TABLE Riboswitch (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	RiboType int,
	_RiboType_db int,
	organismGI CHAR(250),
	sequence TEXT,
	stop INT,
	distance INT,
	downstreamGI CHAR(250),
	organism CHAR(250),
	start INT,
	contig CHAR(250)
	);
INSERT INTO _objects (object) VALUES ('Regulon');
CREATE TABLE Regulon (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	RegulatorInstance int,
	_RegulatorInstance_db int
	);
INSERT INTO _objects (object) VALUES ('Domain');
CREATE TABLE Domain (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	stop INT,
	score FLOAT,
	DomainType int,
	_DomainType_db int,
	start INT,
	figid CHAR(125)
	);
INSERT INTO _objects (object) VALUES ('DomainType');
CREATE TABLE DomainType (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	db CHAR(250),
	url CHAR(250),
	vs CHAR(250),
	name CHAR(250),
	type CHAR(250)
	);
CREATE UNIQUE INDEX DomainType_name_vs_key ON DomainType (name, vs);
INSERT INTO _objects (object) VALUES ('BindingSite');
CREATE TABLE BindingSite (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	BSMotif int,
	_BSMotif_db int,
	sequence CHAR(250),
	stop INT,
	name CHAR(125),
	organism CHAR(250),
	RegulatorInstance int,
	_RegulatorInstance_db int,
	start INT,
	contig CHAR(250)
	);
CREATE TABLE Regulon_FigidsRegulated (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	_array_index int,
	_source_id int,
	_value CHAR(125)
	);
INSERT INTO _objects (object) VALUES ('Regulator');
CREATE TABLE Regulator (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	RegFam int,
	_RegFam_db int,
	name CHAR(250)
	);
INSERT INTO _objects (object) VALUES ('RegFam');
CREATE TABLE RegFam (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	name CHAR(250)
	);
INSERT INTO _objects (object) VALUES ('RegulatorInstance');
CREATE TABLE RegulatorInstance (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	Regulator int,
	_Regulator_db int,
	action CHAR(8),
	name CHAR(250),
	figid CHAR(125)
	);
CREATE TABLE Riboswitch_FigidsRegulated (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	_array_index int,
	_source_id int,
	_value CHAR(125)
	);
CREATE TABLE RegulatorInstance_effector (_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (_id),
	_array_index int,
	_source_id int,
	_value CHAR(250)
	);

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3