typo3/sysext/frontend/ext_tables.sql

   1 #
   2 # Table structure for table 'cache_md5params'
   3 #
   4 CREATE TABLE cache_md5params (
   5         md5hash varchar(20) DEFAULT '' NOT NULL,
   6         tstamp int(11) DEFAULT '0' NOT NULL,
   7         type tinyint(3) DEFAULT '0' NOT NULL,
   8         params text,
   9
  10         PRIMARY KEY (md5hash)
  11 ) ENGINE=InnoDB;
  12
  13 #
  14 # Table structure for table 'cache_treelist'
  15 #
  16 CREATE TABLE cache_treelist (
  17         md5hash char(32) DEFAULT '' NOT NULL,
  18         pid int(11) DEFAULT '0' NOT NULL,
  19         treelist mediumtext,
  20         tstamp int(11) DEFAULT '0' NOT NULL,
  21         expires int(11) unsigned  DEFAULT '0' NOT NULL,
  22
  23         PRIMARY KEY (md5hash)
  24 ) ENGINE=InnoDB;
  25
  26 #
  27 # Table structure for table 'fe_groups'
  28 #
  29 CREATE TABLE fe_groups (
  30         uid int(11) unsigned NOT NULL auto_increment,
  31         pid int(11) unsigned DEFAULT '0' NOT NULL,
  32         tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  33         crdate int(11) unsigned DEFAULT '0' NOT NULL,
  34         cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  35         title varchar(50) DEFAULT '' NOT NULL,
  36         hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
  37         lockToDomain varchar(50) DEFAULT '' NOT NULL,
  38         deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
  39         description text NOT NULL,
  40         subgroup tinytext NOT NULL,
  41         TSconfig text NOT NULL,
  42
  43         PRIMARY KEY (uid),
  44         KEY parent (pid)
  45 );
  46
  47 #
  48 # Table structure for table 'fe_session_data'
  49 #
  50 CREATE TABLE fe_session_data (
  51         hash varchar(32) DEFAULT '' NOT NULL,
  52         content mediumblob,
  53         tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  54
  55         PRIMARY KEY (hash),
  56         KEY tstamp (tstamp)
  57 ) ENGINE=InnoDB;
  58
  59 #
  60 # Table structure for table 'fe_sessions'
  61 #
  62 CREATE TABLE fe_sessions (
  63         ses_id varchar(32) DEFAULT '' NOT NULL,
  64         ses_name varchar(32) DEFAULT '' NOT NULL,
  65         ses_iplock varchar(39) DEFAULT '' NOT NULL,
  66         ses_hashlock int(11) DEFAULT '0' NOT NULL,
  67         ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
  68         ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  69         ses_data blob,
  70         ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
  71
  72         PRIMARY KEY (ses_id,ses_name),
  73         KEY ses_tstamp (ses_tstamp)
  74 ) ENGINE=InnoDB;
  75
  76 #
  77 # Table structure for table 'fe_users'
  78 #
  79 CREATE TABLE fe_users (
  80         uid int(11) unsigned NOT NULL auto_increment,
  81         pid int(11) unsigned DEFAULT '0' NOT NULL,
  82         tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  83         username varchar(255) DEFAULT '' NOT NULL,
  84         password varchar(100) DEFAULT '' NOT NULL,
  85         usergroup tinytext,
  86         disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
  87         starttime int(11) unsigned DEFAULT '0' NOT NULL,
  88         endtime int(11) unsigned DEFAULT '0' NOT NULL,
  89         name varchar(80) DEFAULT '' NOT NULL,
  90         first_name varchar(50) DEFAULT '' NOT NULL,
  91         middle_name varchar(50) DEFAULT '' NOT NULL,
  92         last_name varchar(50) DEFAULT '' NOT NULL,
  93         address varchar(255) DEFAULT '' NOT NULL,
  94         telephone varchar(20) DEFAULT '' NOT NULL,
  95         fax varchar(20) DEFAULT '' NOT NULL,
  96         email varchar(255) DEFAULT '' NOT NULL,
  97         crdate int(11) unsigned DEFAULT '0' NOT NULL,
  98         cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  99         lockToDomain varchar(50) DEFAULT '' NOT NULL,
 100         deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
 101         uc blob,
 102         title varchar(40) DEFAULT '' NOT NULL,
 103         zip varchar(10) DEFAULT '' NOT NULL,
 104         city varchar(50) DEFAULT '' NOT NULL,
 105         country varchar(40) DEFAULT '' NOT NULL,
 106         www varchar(80) DEFAULT '' NOT NULL,
 107         company varchar(80) DEFAULT '' NOT NULL,
 108         image tinytext,
 109         TSconfig text,
 110         fe_cruser_id int(10) unsigned DEFAULT '0' NOT NULL,
 111         lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
 112         is_online int(10) unsigned DEFAULT '0' NOT NULL,
 113
 114         PRIMARY KEY (uid),
 115         KEY parent (pid,username),
 116         KEY username (username),
 117         KEY is_online (is_online)
 118 );
 119
 120 #
 121 # Table structure for table 'pages_language_overlay'
 122 #
 123 CREATE TABLE pages_language_overlay (
 124         uid int(11) NOT NULL auto_increment,
 125         pid int(11) DEFAULT '0' NOT NULL,
 126         doktype int(11) unsigned DEFAULT '0' NOT NULL,
 127         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 128         t3ver_id int(11) DEFAULT '0' NOT NULL,
 129         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 130         t3ver_label varchar(255) DEFAULT '' NOT NULL,
 131         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 132         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 133         t3ver_count int(11) DEFAULT '0' NOT NULL,
 134         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 135         t3_origuid int(11) DEFAULT '0' NOT NULL,
 136         tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 137         crdate int(11) unsigned DEFAULT '0' NOT NULL,
 138         cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 139         sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
 140         title varchar(255) DEFAULT '' NOT NULL,
 141         hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 142         starttime int(11) unsigned DEFAULT '0' NOT NULL,
 143         endtime int(11) unsigned DEFAULT '0' NOT NULL,
 144         deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
 145         subtitle varchar(255) DEFAULT '' NOT NULL,
 146         nav_title varchar(255) DEFAULT '' NOT NULL,
 147         media text,
 148         keywords text,
 149         description text,
 150         abstract text,
 151         author varchar(255) DEFAULT '' NOT NULL,
 152         author_email varchar(80) DEFAULT '' NOT NULL,
 153         tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 154         l18n_diffsource mediumblob,
 155         url varchar(255) DEFAULT '' NOT NULL,
 156         urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
 157         shortcut int(10) unsigned DEFAULT '0' NOT NULL,
 158         shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
 159
 160         PRIMARY KEY (uid),
 161         KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 162         KEY parent (pid,sys_language_uid)
 163 );
 164
 165 #
 166 # Table structure for table 'sys_domain'
 167 #
 168 CREATE TABLE sys_domain (
 169         uid int(11) unsigned NOT NULL auto_increment,
 170         pid int(11) unsigned DEFAULT '0' NOT NULL,
 171         tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 172         crdate int(11) unsigned DEFAULT '0' NOT NULL,
 173         cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 174         hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 175         domainName varchar(80) DEFAULT '' NOT NULL,
 176         redirectTo varchar(255) DEFAULT '' NOT NULL,
 177         redirectHttpStatusCode int(4) unsigned DEFAULT '301' NOT NULL,
 178         sorting int(10) unsigned DEFAULT '0' NOT NULL,
 179         prepend_params int(10) DEFAULT '0' NOT NULL,
 180         forced tinyint(3) unsigned DEFAULT '0' NOT NULL,
 181
 182         PRIMARY KEY (uid),
 183         KEY parent (pid),
 184         KEY getSysDomain (redirectTo,hidden)
 185 );
 186
 187 #
 188 # Table structure for table 'sys_template'
 189 #
 190 CREATE TABLE sys_template (
 191         uid int(11) NOT NULL auto_increment,
 192         pid int(11) DEFAULT '0' NOT NULL,
 193         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 194         t3ver_id int(11) DEFAULT '0' NOT NULL,
 195         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 196         t3ver_label varchar(255) DEFAULT '' NOT NULL,
 197         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 198         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 199         t3ver_count int(11) DEFAULT '0' NOT NULL,
 200         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 201         t3_origuid int(11) DEFAULT '0' NOT NULL,
 202         tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 203         sorting int(11) unsigned DEFAULT '0' NOT NULL,
 204         crdate int(11) unsigned DEFAULT '0' NOT NULL,
 205         cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 206         title varchar(255) DEFAULT '' NOT NULL,
 207         sitetitle varchar(255) DEFAULT '' NOT NULL,
 208         hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 209         starttime int(11) unsigned DEFAULT '0' NOT NULL,
 210         endtime int(11) unsigned DEFAULT '0' NOT NULL,
 211         root tinyint(4) unsigned DEFAULT '0' NOT NULL,
 212         clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
 213         include_static_file text,
 214         constants text,
 215         config text,
 216         nextLevel varchar(5) DEFAULT '' NOT NULL,
 217         description text,
 218         basedOn tinytext,
 219         deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
 220         includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
 221         static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
 222         tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 223
 224         PRIMARY KEY (uid),
 225         KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 226         KEY parent (pid,deleted,hidden,sorting),
 227         KEY roottemplate (deleted,hidden,root)
 228 );
 229
 230 #
 231 # Table structure for table 'tt_content'
 232 #
 233 CREATE TABLE tt_content (
 234         uid int(11) NOT NULL auto_increment,
 235         pid int(11) DEFAULT '0' NOT NULL,
 236         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 237         t3ver_id int(11) DEFAULT '0' NOT NULL,
 238         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 239         t3ver_label varchar(255) DEFAULT '' NOT NULL,
 240         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 241         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 242         t3ver_count int(11) DEFAULT '0' NOT NULL,
 243         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 244         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 245         t3_origuid int(11) DEFAULT '0' NOT NULL,
 246         tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 247         crdate int(11) unsigned DEFAULT '0' NOT NULL,
 248         cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 249         editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
 250         hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 251         sorting int(11) unsigned DEFAULT '0' NOT NULL,
 252         CType varchar(255) DEFAULT '' NOT NULL,
 253         header varchar(255) DEFAULT '' NOT NULL,
 254         rowDescription text,
 255         bodytext mediumtext,
 256
 257         # Even though we're using FAL and an IRRE field for images
 258         # now, it needs to stay "text" for the migration to work
 259         image text,
 260
 261         imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
 262         imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
 263         imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
 264         imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
 265         media text,
 266         layout int(11) unsigned DEFAULT '0' NOT NULL,
 267         deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
 268         cols int(11) unsigned DEFAULT '0' NOT NULL,
 269         records text,
 270         pages text,
 271         starttime int(11) unsigned DEFAULT '0' NOT NULL,
 272         endtime int(11) unsigned DEFAULT '0' NOT NULL,
 273         colPos int(11) unsigned DEFAULT '0' NOT NULL,
 274         subheader varchar(255) DEFAULT '' NOT NULL,
 275         fe_group varchar(100) DEFAULT '0' NOT NULL,
 276         header_link varchar(1024) DEFAULT '' NOT NULL,
 277         image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
 278         header_layout varchar(30) DEFAULT '0' NOT NULL,
 279         menu_type varchar(30) DEFAULT '0' NOT NULL,
 280         list_type varchar(255) DEFAULT '0' NOT NULL,
 281         select_key varchar(80) DEFAULT '' NOT NULL,
 282         sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
 283         linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
 284         file_collections text,
 285         filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
 286         filelink_sorting varchar(10) DEFAULT '' NOT NULL,
 287         target varchar(30) DEFAULT '' NOT NULL,
 288         date int(10) unsigned DEFAULT '0' NOT NULL,
 289         recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
 290         imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
 291         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 292         tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 293         pi_flexform mediumtext,
 294         accessibility_title varchar(30) DEFAULT '' NOT NULL,
 295         accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
 296         accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
 297         l18n_parent int(11) DEFAULT '0' NOT NULL,
 298         l18n_diffsource mediumblob,
 299         selected_categories text,
 300         category_field varchar(64) DEFAULT '' NOT NULL,
 301         table_caption varchar(255) DEFAULT NULL,
 302         table_delimiter smallint(6) unsigned DEFAULT '0' NOT NULL,
 303         table_enclosure smallint(6) unsigned DEFAULT '0' NOT NULL,
 304         table_header_position tinyint(3) unsigned DEFAULT '0' NOT NULL,
 305         table_tfoot tinyint(1) unsigned DEFAULT '0' NOT NULL,
 306
 307         PRIMARY KEY (uid),
 308         KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 309         KEY parent (pid,sorting),
 310         KEY language (l18n_parent,sys_language_uid)
 311 );
 312
 313 #
 314 # Table structure for table 'backend_layout'
 315 #
 316 CREATE TABLE backend_layout (
 317         uid int(11) NOT NULL auto_increment,
 318         pid int(11) DEFAULT '0' NOT NULL,
 319         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 320         t3ver_id int(11) DEFAULT '0' NOT NULL,
 321         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 322         t3ver_label varchar(255) DEFAULT '' NOT NULL,
 323         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 324         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 325         t3ver_count int(11) DEFAULT '0' NOT NULL,
 326         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 327         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 328         t3_origuid int(11) DEFAULT '0' NOT NULL,
 329         tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 330         crdate int(11) unsigned DEFAULT '0' NOT NULL,
 331         cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 332         hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 333         deleted tinyint(4) DEFAULT '0' NOT NULL,
 334         sorting int(11) unsigned DEFAULT '0' NOT NULL,
 335         title varchar(255) DEFAULT '' NOT NULL,
 336         description text NOT NULL,
 337         config text NOT NULL,
 338         icon text NOT NULL,
 339
 340         PRIMARY KEY (uid),
 341         KEY parent (pid),
 342         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 343 );