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