typo3/sysext/cms/ext_tables.sql

   1 #
   2 # TYPO3 SVN ID: $Id$
   3 #
   4
   5
   6 #
   7 # Table structure for table 'cache_pages'
   8 #
   9 CREATE TABLE cache_pages (
  10   id int(11) unsigned NOT NULL auto_increment,
  11   identifier varchar(250) DEFAULT '' NOT NULL,
  12   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  13   content mediumtext,
  14   tags mediumtext,
  15   lifetime int(11) unsigned DEFAULT '0' NOT NULL,
  16   PRIMARY KEY (id),
  17   KEY cache_id (identifier)
  18 ) ENGINE=InnoDB;
  19
  20
  21 #
  22 # Table structure for table 'cache_pagesection'
  23 #
  24 CREATE TABLE cache_pagesection (
  25   id int(11) unsigned NOT NULL auto_increment,
  26   identifier varchar(250) DEFAULT '' NOT NULL,
  27   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  28   content mediumtext,
  29   tags mediumtext,
  30   lifetime int(11) unsigned DEFAULT '0' NOT NULL,
  31   PRIMARY KEY (id),
  32   KEY cache_id (identifier)
  33 ) ENGINE=InnoDB;
  34
  35
  36 #
  37 # Table structure for table 'cache_typo3temp_log'
  38 #
  39 CREATE TABLE cache_typo3temp_log (
  40   md5hash varchar(32) DEFAULT '' NOT NULL,
  41   tstamp int(11) DEFAULT '0' NOT NULL,
  42   filename varchar(255) DEFAULT '' NOT NULL,
  43   orig_filename varchar(255) DEFAULT '' NOT NULL,
  44   PRIMARY KEY (md5hash)
  45 ) ENGINE=InnoDB;
  46
  47
  48 #
  49 # Table structure for table 'cache_md5params'
  50 #
  51 CREATE TABLE cache_md5params (
  52   md5hash varchar(20) DEFAULT '' NOT NULL,
  53   tstamp int(11) DEFAULT '0' NOT NULL,
  54   type tinyint(3) DEFAULT '0' NOT NULL,
  55   params text,
  56   PRIMARY KEY (md5hash)
  57 ) ENGINE=InnoDB;
  58
  59
  60 #
  61 # Table structure for table 'cache_imagesizes'
  62 #
  63 CREATE TABLE cache_imagesizes (
  64   md5hash varchar(32) DEFAULT '' NOT NULL,
  65   md5filename varchar(32) DEFAULT '' NOT NULL,
  66   tstamp int(11) DEFAULT '0' NOT NULL,
  67   filename varchar(255) DEFAULT '' NOT NULL,
  68   imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
  69   imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
  70   PRIMARY KEY (md5filename)
  71 ) ENGINE=InnoDB;
  72
  73
  74 #
  75 # Table structure for table 'cache_treelist'
  76 #
  77 CREATE TABLE cache_treelist (
  78   md5hash char(32) DEFAULT '' NOT NULL,
  79   pid int(11) DEFAULT '0' NOT NULL,
  80   treelist text,
  81   tstamp int(11) DEFAULT '0' NOT NULL,
  82   expires int(11) unsigned  DEFAULT '0' NOT NULL,
  83   PRIMARY KEY (md5hash)
  84 ) ENGINE=InnoDB;
  85
  86
  87 #
  88 # Table structure for table 'fe_groups'
  89 #
  90 CREATE TABLE fe_groups (
  91   uid int(11) unsigned NOT NULL auto_increment,
  92   pid int(11) unsigned DEFAULT '0' NOT NULL,
  93   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  94   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  95   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  96   title varchar(50) DEFAULT '' NOT NULL,
  97   hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
  98   lockToDomain varchar(50) DEFAULT '' NOT NULL,
  99   deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
 100   description text,
 101   subgroup tinytext,
 102   TSconfig text,
 103   PRIMARY KEY (uid),
 104   KEY parent (pid)
 105 );
 106
 107
 108 #
 109 # Table structure for table 'fe_session_data'
 110 #
 111 CREATE TABLE fe_session_data (
 112   hash varchar(32) DEFAULT '' NOT NULL,
 113   content mediumblob,
 114   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 115   PRIMARY KEY (hash)
 116 ) ENGINE=InnoDB;
 117
 118
 119 #
 120 # Table structure for table 'fe_sessions'
 121 #
 122 CREATE TABLE fe_sessions (
 123   ses_id varchar(32) DEFAULT '' NOT NULL,
 124   ses_name varchar(32) DEFAULT '' NOT NULL,
 125   ses_iplock varchar(39) DEFAULT '' NOT NULL,
 126   ses_hashlock int(11) DEFAULT '0' NOT NULL,
 127   ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
 128   ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 129   ses_data blob,
 130   ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
 131   PRIMARY KEY (ses_id,ses_name)
 132 ) ENGINE=InnoDB;
 133
 134
 135 #
 136 # Table structure for table 'fe_users'
 137 #
 138 CREATE TABLE fe_users (
 139   uid int(11) unsigned NOT NULL auto_increment,
 140   pid int(11) unsigned DEFAULT '0' NOT NULL,
 141   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 142   username varchar(50) DEFAULT '' NOT NULL,
 143   password varchar(40) DEFAULT '' NOT NULL,
 144   usergroup tinytext,
 145   disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
 146   starttime int(11) unsigned DEFAULT '0' NOT NULL,
 147   endtime int(11) unsigned DEFAULT '0' NOT NULL,
 148   name varchar(80) DEFAULT '' NOT NULL,
 149   address varchar(255) DEFAULT '' NOT NULL,
 150   telephone varchar(20) DEFAULT '' NOT NULL,
 151   fax varchar(20) DEFAULT '' NOT NULL,
 152   email varchar(80) DEFAULT '' NOT NULL,
 153   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 154   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 155   lockToDomain varchar(50) DEFAULT '' NOT NULL,
 156   deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
 157   uc blob,
 158   title varchar(40) DEFAULT '' NOT NULL,
 159   zip varchar(10) DEFAULT '' NOT NULL,
 160   city varchar(50) DEFAULT '' NOT NULL,
 161   country varchar(40) DEFAULT '' NOT NULL,
 162   www varchar(80) DEFAULT '' NOT NULL,
 163   company varchar(80) DEFAULT '' NOT NULL,
 164   image tinytext,
 165   TSconfig text,
 166   fe_cruser_id int(10) unsigned DEFAULT '0' NOT NULL,
 167   lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
 168   is_online int(10) unsigned DEFAULT '0' NOT NULL,
 169   PRIMARY KEY (uid),
 170   KEY parent (pid,username),
 171   KEY username (username),
 172   KEY is_online (is_online)
 173 );
 174
 175
 176 #
 177 # Table structure for table 'pages_language_overlay'
 178 #
 179 CREATE TABLE pages_language_overlay (
 180   uid int(11) NOT NULL auto_increment,
 181   pid int(11) DEFAULT '0' NOT NULL,
 182   doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
 183   t3ver_oid int(11) DEFAULT '0' NOT NULL,
 184   t3ver_id int(11) DEFAULT '0' NOT NULL,
 185   t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 186   t3ver_label varchar(30) DEFAULT '' NOT NULL,
 187   t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 188   t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
 189   t3ver_count int(11) DEFAULT '0' NOT NULL,
 190   t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 191   t3_origuid int(11) DEFAULT '0' NOT NULL,
 192   tstamp 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   sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
 196   title 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   deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
 201   subtitle varchar(255) DEFAULT '' NOT NULL,
 202   nav_title varchar(255) DEFAULT '' NOT NULL,
 203   media tinytext,
 204   keywords text,
 205   description text,
 206   abstract text,
 207   author varchar(255) DEFAULT '' NOT NULL,
 208   author_email varchar(80) DEFAULT '' NOT NULL,
 209   tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 210   l18n_diffsource mediumblob,
 211   url varchar(255) DEFAULT '' NOT NULL,
 212   urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
 213   shortcut int(10) unsigned DEFAULT '0' NOT NULL,
 214   shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
 215
 216   PRIMARY KEY (uid),
 217   KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 218   KEY parent (pid,sys_language_uid)
 219 );
 220
 221
 222 #
 223 # Table structure for table 'static_template'
 224 #
 225 CREATE TABLE static_template (
 226   uid int(11) unsigned NOT NULL auto_increment,
 227   pid int(11) unsigned DEFAULT '0' NOT NULL,
 228   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 229   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 230   title varchar(255) DEFAULT '' NOT NULL,
 231   include_static tinytext,
 232   constants text,
 233   config text,
 234   editorcfg text,
 235   description text,
 236   PRIMARY KEY (uid),
 237   KEY parent (pid)
 238 );
 239
 240
 241 #
 242 # Table structure for table 'sys_domain'
 243 #
 244 CREATE TABLE sys_domain (
 245   uid int(11) unsigned NOT NULL auto_increment,
 246   pid int(11) unsigned DEFAULT '0' NOT NULL,
 247   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 248   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 249   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 250   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 251   domainName varchar(80) DEFAULT '' NOT NULL,
 252   redirectTo varchar(120) DEFAULT '' NOT NULL,
 253   redirectHttpStatusCode int(4) unsigned DEFAULT '301' NOT NULL,
 254   sorting int(10) unsigned DEFAULT '0' NOT NULL,
 255   prepend_params int(10) DEFAULT '0' NOT NULL,
 256
 257   PRIMARY KEY (uid),
 258   KEY parent (pid)
 259 );
 260
 261
 262
 263 #
 264 # Table structure for table 'sys_template'
 265 #
 266 CREATE TABLE sys_template (
 267   uid int(11) NOT NULL auto_increment,
 268   pid int(11) DEFAULT '0' NOT NULL,
 269   t3ver_oid int(11) DEFAULT '0' NOT NULL,
 270   t3ver_id int(11) DEFAULT '0' NOT NULL,
 271   t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 272   t3ver_label varchar(30) DEFAULT '' NOT NULL,
 273   t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 274   t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
 275   t3ver_count int(11) DEFAULT '0' NOT NULL,
 276   t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 277   t3_origuid int(11) DEFAULT '0' NOT NULL,
 278   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 279   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 280   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 281   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 282   title varchar(255) DEFAULT '' NOT NULL,
 283   sitetitle varchar(255) DEFAULT '' NOT NULL,
 284   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 285   starttime int(11) unsigned DEFAULT '0' NOT NULL,
 286   endtime int(11) unsigned DEFAULT '0' NOT NULL,
 287   root tinyint(4) unsigned DEFAULT '0' NOT NULL,
 288   clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
 289   include_static tinytext,
 290   include_static_file text,
 291   constants text,
 292   config text,
 293   editorcfg text,
 294   resources text,
 295   nextLevel varchar(5) DEFAULT '' NOT NULL,
 296   description text,
 297   basedOn tinytext,
 298   deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
 299   includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
 300   static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
 301   tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 302   PRIMARY KEY (uid),
 303   KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 304   KEY parent (pid,sorting,deleted,hidden)
 305 );
 306
 307
 308 #
 309 # Table structure for table 'tt_content'
 310 #
 311 CREATE TABLE tt_content (
 312   uid int(11) NOT NULL auto_increment,
 313   pid int(11) DEFAULT '0' NOT NULL,
 314   t3ver_oid int(11) DEFAULT '0' NOT NULL,
 315   t3ver_id int(11) DEFAULT '0' NOT NULL,
 316   t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 317   t3ver_label varchar(30) DEFAULT '' NOT NULL,
 318   t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 319   t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
 320   t3ver_count int(11) DEFAULT '0' NOT NULL,
 321   t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 322   t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 323   t3_origuid int(11) DEFAULT '0' NOT NULL,
 324   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 325   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 326   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 327   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 328   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 329   CType varchar(30) DEFAULT '' NOT NULL,
 330   header varchar(255) DEFAULT '' NOT NULL,
 331   header_position varchar(6) DEFAULT '' NOT NULL,
 332   bodytext mediumtext,
 333   image text,
 334   imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
 335   imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
 336   imagecaption text,
 337   imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
 338   imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
 339   media text,
 340   layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
 341   deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
 342   cols tinyint(3) unsigned DEFAULT '0' NOT NULL,
 343   records text,
 344   pages tinytext,
 345   starttime int(11) unsigned DEFAULT '0' NOT NULL,
 346   endtime int(11) unsigned DEFAULT '0' NOT NULL,
 347   colPos tinyint(3) unsigned DEFAULT '0' NOT NULL,
 348   subheader varchar(255) DEFAULT '' NOT NULL,
 349   spaceBefore tinyint(4) unsigned DEFAULT '0' NOT NULL,
 350   spaceAfter tinyint(4) unsigned DEFAULT '0' NOT NULL,
 351   fe_group varchar(100) DEFAULT '0' NOT NULL,
 352   header_link varchar(255) DEFAULT '' NOT NULL,
 353   imagecaption_position varchar(6) DEFAULT '' NOT NULL,
 354   image_link varchar(255) DEFAULT '' NOT NULL,
 355   image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
 356   image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
 357   image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
 358   image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
 359   altText text,
 360   titleText text,
 361   longdescURL text,
 362   header_layout varchar(30) DEFAULT '0' NOT NULL,
 363   text_align varchar(6) DEFAULT '' NOT NULL,
 364   text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
 365   text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
 366   text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
 367   text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
 368   menu_type varchar(30) DEFAULT '0' NOT NULL,
 369   list_type varchar(36) DEFAULT '0' NOT NULL,
 370   table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
 371   table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
 372   table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
 373   table_bgColor tinyint(3) unsigned DEFAULT '0' NOT NULL,
 374   select_key varchar(80) DEFAULT '' NOT NULL,
 375   sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
 376   linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
 377   filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
 378   section_frame tinyint(3) unsigned DEFAULT '0' NOT NULL,
 379   date int(10) unsigned DEFAULT '0' NOT NULL,
 380   splash_layout varchar(30) DEFAULT '0' NOT NULL,
 381   multimedia tinytext,
 382   image_frames tinyint(3) unsigned DEFAULT '0' NOT NULL,
 383   recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
 384   imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
 385   rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
 386   sys_language_uid int(11) DEFAULT '0' NOT NULL,
 387   tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 388   pi_flexform mediumtext,
 389   l18n_parent int(11) DEFAULT '0' NOT NULL,
 390   l18n_diffsource mediumblob,
 391
 392   PRIMARY KEY (uid),
 393   KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 394   KEY parent (pid,sorting)
 395 );
 396
 397
 398 #
 399 # Table structure for table 'pages'
 400 #
 401 CREATE TABLE pages (
 402   url varchar(255) DEFAULT '' NOT NULL,
 403   starttime int(11) unsigned DEFAULT '0' NOT NULL,
 404   endtime int(11) unsigned DEFAULT '0' NOT NULL,
 405   urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
 406   shortcut int(10) unsigned DEFAULT '0' NOT NULL,
 407   shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
 408   no_cache int(10) unsigned DEFAULT '0' NOT NULL,
 409   fe_group varchar(100) DEFAULT '0' NOT NULL,
 410   subtitle varchar(255) DEFAULT '' NOT NULL,
 411   layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
 412   target varchar(20) DEFAULT '' NOT NULL,
 413   media text,
 414   lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
 415   keywords text,
 416   cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
 417   newUntil int(10) unsigned DEFAULT '0' NOT NULL,
 418   description text,
 419   no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
 420   SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
 421   abstract text,
 422   module varchar(10) DEFAULT '' NOT NULL,
 423   extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
 424   author varchar(255) DEFAULT '' NOT NULL,
 425   author_email varchar(80) DEFAULT '' NOT NULL,
 426   nav_title varchar(255) DEFAULT '' NOT NULL,
 427   nav_hide tinyint(4) DEFAULT '0' NOT NULL,
 428   content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
 429   mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
 430   mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
 431   alias varchar(32) DEFAULT '' NOT NULL,
 432   l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
 433   fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
 434   KEY alias (alias)
 435 );