Maintenance - Mise à jour mensuelle Lundi 6 Avril 2020 entre 7h00 et 9h00

ext_tables.sql 5.51 KB
Newer Older
1 2 3 4 5 6 7 8

/*
 * Table structure for table 'fe_rights_levels'
*/
CREATE TABLE fe_rights_levels (
    right_level_id int(11) NOT NULL,
    right_level_label varchar(20) NOT NULL,
    PRIMARY KEY (right_level_id),
9
) CHARSET=utf8 ;
10 11 12 13 14 15 16 17 18 19


/*
 * Table structure for table 'fe_rights'
*/
CREATE TABLE fe_rights (
    fe_user_id int(11) NOT NULL,
    project_id int(11) NOT NULL,
    right_id int(11) NOT NULL,
    PRIMARY KEY (fe_user_id, project_id, right_id)
20
) CHARSET=utf8 ;
21 22 23 24 25


/*
 * Table structure for table 'tx_nG6_project'
*/
Jerome Mariette's avatar
Jerome Mariette committed
26
CREATE TABLE tx_nG6_project (
27 28 29 30 31 32 33 34 35 36 37 38 39
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    public tinyint(4) DEFAULT '1' NOT NULL,
    name varchar(255) DEFAULT '' NOT NULL,
    description varchar(255) DEFAULT '' NOT NULL,
    
    PRIMARY KEY (uid),
    KEY parent (pid)
40
) CHARSET=utf8 ;
Jerome Mariette's avatar
Jerome Mariette committed
41 42 43



44 45 46
/*
 * Table structure for table 'tx_nG6_run'
*/
Jerome Mariette's avatar
Jerome Mariette committed
47
CREATE TABLE tx_nG6_run (
48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    name varchar(255) DEFAULT '' NOT NULL,
    date int(11) DEFAULT '0' NOT NULL,
    directory varchar(255) DEFAULT '' NOT NULL,
    species varchar(255) DEFAULT '' NOT NULL,
    data_nature varchar(255) DEFAULT '' NOT NULL,
    type varchar(255) DEFAULT '' NOT NULL,
    nb_sequences varchar(255) DEFAULT '0' NOT NULL,
    full_seq_size varchar(255) DEFAULT '0' NOT NULL,
    description varchar(255) DEFAULT '' NOT NULL,
    sequencer varchar(255) DEFAULT '' NOT NULL,
    
    PRIMARY KEY (uid),
    KEY parent (pid)
68
) CHARSET=utf8 ;
Jerome Mariette's avatar
Jerome Mariette committed
69 70


71 72 73
/*
 * Table structure for table 'tx_nG6_analyze'
*/
Jerome Mariette's avatar
Jerome Mariette committed
74 75

CREATE TABLE tx_nG6_analyze (
76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    parent_uid int(11) DEFAULT '0' NOT NULL,
    class varchar(255) DEFAULT '' NOT NULL,
    name varchar(255) DEFAULT '' NOT NULL,
    description varchar(255) DEFAULT '' NOT NULL,
    date int(11) DEFAULT '0' NOT NULL,
    directory varchar(255) DEFAULT '' NOT NULL,
    software varchar(255) DEFAULT '' NOT NULL,
    version varchar(255) DEFAULT '' NOT NULL,
    params text NOT NULL,
    
    PRIMARY KEY (uid),
    KEY parent (pid)
95
) CHARSET=utf8 ;
96 97 98



99 100 101 102
/*
 * Table structure for table 'tx_nG6_sample'
*/

103
CREATE TABLE tx_nG6_sample (
104 105 106 107 108 109 110 111 112 113 114 115 116
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    run_id int(11) DEFAULT '0' NOT NULL,
    mid varchar(255) DEFAULT '' NOT NULL,
    description varchar(255) DEFAULT '' NOT NULL,
    
    PRIMARY KEY (uid),
    KEY parent (pid)
117
) CHARSET=utf8 ;
118 119


120 121 122
/*
 * Table structure for table 'tx_nG6_result'
*/
123 124

CREATE TABLE tx_nG6_result (
125 126 127 128 129 130 131 132 133 134 135 136 137 138 139
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    analyze_id int(11) DEFAULT '0' NOT NULL,
    file varchar(255) DEFAULT '' NOT NULL,
    rkey varchar(255) DEFAULT '' NOT NULL,
    rvalue text DEFAULT '' NOT NULL,
    rgroup varchar(255) DEFAULT '' NOT NULL,
    
    PRIMARY KEY (uid),
    KEY parent (pid)
140
) CHARSET=utf8 ;
Jerome Mariette's avatar
Jerome Mariette committed
141 142


143 144 145
/*
 * Table structure for table 'tx_nG6_project_run'
*/
Jerome Mariette's avatar
Jerome Mariette committed
146 147

CREATE TABLE tx_nG6_project_run (
148 149 150 151 152 153 154 155 156 157 158 159
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    project_id int(11) DEFAULT '0' NOT NULL,
    run_id int(11) DEFAULT '0' NOT NULL,
    
    PRIMARY KEY (uid),
    KEY parent (pid)
160
) CHARSET=utf8 ;
Jerome Mariette's avatar
Jerome Mariette committed
161 162


163 164 165
/*
 * Table structure for table 'tx_nG6_project_analyze'
*/
Jerome Mariette's avatar
Jerome Mariette committed
166 167

CREATE TABLE tx_nG6_project_analyze (
168 169 170 171 172 173 174 175 176 177 178 179
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    project_id int(11) DEFAULT '0' NOT NULL,
    analyze_id int(11) DEFAULT '0' NOT NULL,
    
    PRIMARY KEY (uid),
    KEY parent (pid)
180
) CHARSET=utf8 ;
Jerome Mariette's avatar
Jerome Mariette committed
181 182


183 184 185
/*
 * Table structure for table 'tx_nG6_run_analyze'
*/
Jerome Mariette's avatar
Jerome Mariette committed
186 187

CREATE TABLE tx_nG6_run_analyze (
188 189 190 191 192 193 194 195 196 197 198 199
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    run_id int(11) DEFAULT '0' NOT NULL,
    analyze_id int(11) DEFAULT '0' NOT NULL,
    
    PRIMARY KEY (uid),
    KEY parent (pid)
200
) CHARSET=utf8 ;