typo3/sysext/cms/ext_tables.sql

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