1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134
|
# phpMyAdmin MySQL-Dump
# version 2.3.0
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Erstellungszeit: 04. Februar 2004 um 12:13
# Server Version: 3.23.52
# PHP-Version: 4.3.2
# Datenbank: `GENtle`
# --------------------------------------------------------
#
# Tabellenstruktur fr Tabelle `dna`
#
DROP TABLE IF EXISTS dna;
CREATE TABLE dna (
dna_name varchar(255) NOT NULL default '',
dna_description text,
dna_type int(11) default NULL,
dna_sequence mediumtext,
dna_sticky_ul varchar(32) default NULL,
dna_sticky_ur varchar(32) default NULL,
dna_sticky_ll varchar(32) default NULL,
dna_sticky_lr varchar(32) default NULL,
dna_restriction_enzymes mediumtext,
dna_circular tinyint(1) default NULL,
dna_params mediumtext,
PRIMARY KEY (dna_name),
UNIQUE KEY dna_name (dna_name),
KEY dna_name_2 (dna_name)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur fr Tabelle `dna_item`
#
DROP TABLE IF EXISTS dna_item;
CREATE TABLE dna_item (
di_name varchar(255) NOT NULL default '',
di_dna varchar(255) NOT NULL default '',
di_description tinytext,
di_type varchar(32) default NULL,
di_from int(11) default NULL,
di_to int(11) default NULL,
di_direction int(11) default NULL,
di_params mediumtext,
KEY di_name (di_name),
KEY di_dna (di_dna),
FULLTEXT KEY di_name_2 (di_name),
FULLTEXT KEY di_dna_2 (di_dna),
KEY di_type (di_type)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur fr Tabelle `enzyme`
#
DROP TABLE IF EXISTS enzyme;
CREATE TABLE enzyme (
e_id bigint(20) NOT NULL default '0',
e_name varchar(100) NOT NULL default '',
e_sequence varchar(100) NOT NULL default '',
e_note varchar(255) NOT NULL default '',
e_location varchar(255) NOT NULL default '',
e_cut int(11) NOT NULL default '0',
e_overlap int(11) NOT NULL default '0',
PRIMARY KEY (e_id,e_name),
UNIQUE KEY e_name (e_name),
KEY e_name_2 (e_name)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur fr Tabelle `enzyme_group`
#
DROP TABLE IF EXISTS enzyme_group;
CREATE TABLE enzyme_group (
eg_name tinytext
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur fr Tabelle `link_enzyme_group`
#
DROP TABLE IF EXISTS link_enzyme_group;
CREATE TABLE link_enzyme_group (
leg_enzyme varchar(100) NOT NULL default '',
leg_group varchar(100) NOT NULL default '',
KEY leg_enzyme (leg_enzyme),
KEY leg_group (leg_group)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur fr Tabelle `project`
#
DROP TABLE IF EXISTS project;
CREATE TABLE project (
pr_name tinytext,
pr_desc mediumtext
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur fr Tabelle `project_dna`
#
DROP TABLE IF EXISTS project_dna;
CREATE TABLE project_dna (
pd_project tinytext,
pd_dna tinytext,
pd_database tinytext
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Tabellenstruktur fr Tabelle `stuff`
#
DROP TABLE IF EXISTS stuff;
CREATE TABLE stuff (
s_type varchar(255) NOT NULL default '',
s_name varchar(255) NOT NULL default '',
s_value mediumtext,
KEY s_type (s_type),
KEY s_name (s_name)
) TYPE=MyISAM;
|