typo3/sysext/frontend/ext_tables.sql

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