· 8 years ago · Jul 18, 2018, 02:34 PM
1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2
3SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
4
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
6
7
8
9CREATE TABLE IF NOT EXISTS `rt`.`instrument` (
10
11 `instrument_id` INT(11) NOT NULL ,
12
13 `name` INT(11) NOT NULL ,
14
15 PRIMARY KEY (`instrument_id`) )
16
17ENGINE = InnoDB
18
19DEFAULT CHARACTER SET = latin1
20
21COLLATE = latin1_swedish_ci;
22
23
24
25CREATE TABLE IF NOT EXISTS `rt`.`lc_run` (
26
27 `lc_run_id` INT(11) NOT NULL ,
28
29 `l_project_id` INT(11) NOT NULL ,
30
31 `l_instrument_id` INT(11) NOT NULL ,
32
33 PRIMARY KEY (`lc_run_id`) ,
34
35 INDEX `l_project_id_1` (`l_project_id` ASC) ,
36
37 INDEX `l_instrument_id_1` (`l_instrument_id` ASC) ,
38
39
40ENGINE = InnoDB
41
42DEFAULT CHARACTER SET = latin1
43
44COLLATE = latin1_swedish_ci;
45
46
47
48CREATE TABLE IF NOT EXISTS `rt`.`modification_set_has_modification` (
49
50 `l_modification_set_id` INT(10) UNSIGNED NOT NULL ,
51
52 `l_modification_id` INT(10) UNSIGNED NOT NULL ,
53
54 PRIMARY KEY (`l_modification_set_id`, `l_modification_id`) ,
55
56 INDEX `l_modification_set_id_1` (`l_modification_set_id` ASC) ,
57
58 INDEX `l_modification_id_2` (`l_modification_id` ASC) ,
59
60
61ENGINE = InnoDB
62
63DEFAULT CHARACTER SET = latin1
64
65COLLATE = latin1_swedish_ci;
66
67
68
69CREATE TABLE IF NOT EXISTS `rt`.`modification_set` (
70
71 `modification_set_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
72
73 `tag` VARCHAR(5) NOT NULL ,
74
75 PRIMARY KEY (`modification_set_id`) )
76
77ENGINE = InnoDB
78
79DEFAULT CHARACTER SET = latin1
80
81COLLATE = latin1_swedish_ci;
82
83
84
85CREATE TABLE IF NOT EXISTS `rt`.`modification` (
86
87 `modification_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
88
89 `tag` VARCHAR(45) NOT NULL ,
90
91 `name` VARCHAR(45) NOT NULL ,
92
93 PRIMARY KEY (`modification_id`) )
94
95ENGINE = InnoDB
96
97DEFAULT CHARACTER SET = latin1
98
99COLLATE = latin1_swedish_ci;
100
101
102
103CREATE TABLE IF NOT EXISTS `rt`.`peptide_has_modification` (
104
105 `peptide_has_modification_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
106
107 `l_lc_run_id` INT(11) NOT NULL ,
108
109 `l_peptide_id` INT(11) NOT NULL ,
110
111 `l_modification_id` INT(11) NOT NULL ,
112
113 `retention_time` DECIMAL(8,4) NOT NULL ,
114
115 `score` DECIMAL(3,1) NOT NULL ,
116
117 `threshold` DECIMAL(3,1) NOT NULL ,
118
119 `homology` DECIMAL(3,1) NOT NULL ,
120
121 `positions` VARCHAR(30) NOT NULL ,
122
123 PRIMARY KEY (`peptide_has_modification_id`) ,
124
125 INDEX `l_peptide_id_` (`l_peptide_id` ASC) ,
126
127 INDEX `l_modification_id_1` (`l_modification_id` ASC) ,
128
129 INDEX `l_lc_run_id_1` (`l_lc_run_id` ASC) ,
130
131
132ENGINE = InnoDB
133
134DEFAULT CHARACTER SET = latin1
135
136COLLATE = latin1_swedish_ci;
137
138
139
140CREATE TABLE IF NOT EXISTS `rt`.`peptide` (
141
142 `peptide_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
143
144 `sequence` VARCHAR(45) NOT NULL ,
145
146 PRIMARY KEY (`peptide_id`) )
147
148ENGINE = InnoDB
149
150DEFAULT CHARACTER SET = latin1
151
152COLLATE = latin1_swedish_ci;
153
154
155
156CREATE TABLE IF NOT EXISTS `rt`.`project` (
157
158 `project_id` INT(11) NOT NULL ,
159
160 `protocol` INT(11) NOT NULL ,
161
162 PRIMARY KEY (`project_id`) )
163
164ENGINE = InnoDB
165
166DEFAULT CHARACTER SET = latin1
167
168COLLATE = latin1_swedish_ci;
169
170
171
172
173
174SET SQL_MODE=@OLD_SQL_MODE;
175
176SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
177
178SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;