File: MySQL template.txt

package info (click to toggle)
gentle 1.9+cvs20100605+dfsg-2
  • links: PTS, VCS
  • area: contrib
  • in suites: squeeze
  • size: 12,264 kB
  • ctags: 5,235
  • sloc: cpp: 41,571; ansic: 3,978; sh: 1,420; makefile: 291
file content (134 lines) | stat: -rw-r--r-- 3,403 bytes parent folder | download | duplicates (6)
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 f�r 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 f�r 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 f�r 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 f�r Tabelle `enzyme_group`
#

DROP TABLE IF EXISTS enzyme_group;
CREATE TABLE enzyme_group (
  eg_name tinytext
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f�r 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 f�r Tabelle `project`
#

DROP TABLE IF EXISTS project;
CREATE TABLE project (
  pr_name tinytext,
  pr_desc mediumtext
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur f�r 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 f�r 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;