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