t3lib/stddb/tables.sql

   1 #
   2 # TYPO3 SVN ID: $Id$
   3 #
   4
   5 #
   6 # Table structure for table 'be_groups'
   7 #
   8 CREATE TABLE be_groups (
   9   uid int(11) unsigned NOT NULL auto_increment,
  10   pid int(11) unsigned DEFAULT '0' NOT NULL,
  11   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  12   title varchar(50) DEFAULT '' NOT NULL,
  13   non_exclude_fields text,
  14   explicit_allowdeny text,
  15   allowed_languages varchar(255) DEFAULT '' NOT NULL,
  16   custom_options text,
  17   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  18   pagetypes_select varchar(255) DEFAULT '' NOT NULL,
  19   tables_select text,
  20   tables_modify text,
  21   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  22   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  23   groupMods text,
  24   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  25   fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
  26   hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
  27   inc_access_lists tinyint(3) unsigned DEFAULT '0' NOT NULL,
  28   description text,
  29   lockToDomain varchar(50) DEFAULT '' NOT NULL,
  30   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
  31   TSconfig text,
  32   subgroup varchar(255) DEFAULT '' NOT NULL,
  33   hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
  34   workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
  35   PRIMARY KEY (uid),
  36   KEY parent (pid)
  37 );
  38
  39 #
  40 # Table structure for table 'be_sessions'
  41 #
  42 CREATE TABLE be_sessions (
  43   ses_id varchar(32) DEFAULT '' NOT NULL,
  44   ses_name varchar(32) DEFAULT '' NOT NULL,
  45   ses_iplock varchar(39) DEFAULT '' NOT NULL,
  46   ses_hashlock int(11) DEFAULT '0' NOT NULL,
  47   ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
  48   ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  49   ses_data longtext,
  50   ses_backuserid int(11) NOT NULL default '0',
  51   PRIMARY KEY (ses_id,ses_name)
  52 );
  53
  54 #
  55 # Table structure for table 'be_users'
  56 #
  57 CREATE TABLE be_users (
  58   uid int(11) unsigned NOT NULL auto_increment,
  59   pid int(11) unsigned DEFAULT '0' NOT NULL,
  60   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  61   username varchar(50) DEFAULT '' NOT NULL,
  62   password varchar(40) DEFAULT '' NOT NULL,
  63   admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
  64   usergroup varchar(255) DEFAULT '' NOT NULL,
  65   disable tinyint(1) unsigned DEFAULT '0' NOT NULL,
  66   starttime int(11) unsigned DEFAULT '0' NOT NULL,
  67   endtime int(11) unsigned DEFAULT '0' NOT NULL,
  68   lang char(2) DEFAULT '' NOT NULL,
  69   email varchar(80) DEFAULT '' NOT NULL,
  70   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  71   options tinyint(4) unsigned DEFAULT '0' NOT NULL,
  72   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  73   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  74   realName varchar(80) DEFAULT '' NOT NULL,
  75   userMods varchar(255) DEFAULT '' NOT NULL,
  76   allowed_languages varchar(255) DEFAULT '' NOT NULL,
  77   uc text,
  78   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  79   fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
  80   workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
  81   lockToDomain varchar(50) DEFAULT '' NOT NULL,
  82   disableIPlock tinyint(1) unsigned DEFAULT '0' NOT NULL,
  83   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
  84   TSconfig text,
  85   lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
  86   createdByAction int(11) DEFAULT '0' NOT NULL,
  87   usergroup_cached_list varchar(255) DEFAULT '' NOT NULL,
  88   workspace_id int(11) DEFAULT '0' NOT NULL,
  89   workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
  90   PRIMARY KEY (uid),
  91   KEY parent (pid),
  92   KEY username (username)
  93 );
  94
  95 #
  96 # Table structure for table 'cache_hash'
  97 #
  98 CREATE TABLE cache_hash (
  99   id int(11) unsigned NOT NULL auto_increment,
 100   hash varchar(32) DEFAULT '' NOT NULL,
 101   content mediumblob,
 102   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 103   ident varchar(32) DEFAULT '' NOT NULL,
 104   PRIMARY KEY (id),
 105   KEY hash (hash)
 106 ) ENGINE=InnoDB;
 107
 108
 109 #
 110 # Table structure for table 'cachingframework_cache_hash'
 111 #
 112 CREATE TABLE cachingframework_cache_hash (
 113   id int(11) unsigned NOT NULL auto_increment,
 114   identifier varchar(128) DEFAULT '' NOT NULL,
 115   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 116   content mediumblob,
 117   lifetime int(11) unsigned DEFAULT '0' NOT NULL,
 118   PRIMARY KEY (id),
 119   KEY cache_id (identifier)
 120 ) ENGINE=InnoDB;
 121
 122
 123 #
 124 # Table structure for table 'cachingframework_cache_hash_tags'
 125 #
 126 CREATE TABLE cachingframework_cache_hash_tags (
 127   id int(11) unsigned NOT NULL auto_increment,
 128   identifier varchar(128) DEFAULT '' NOT NULL,
 129   tag varchar(128) DEFAULT '' NOT NULL,
 130   PRIMARY KEY (id),
 131   KEY cache_id (identifier),
 132   KEY cache_tag (tag)
 133 ) ENGINE=InnoDB;
 134
 135
 136 #
 137 # Table structure for table 'cache_imagesizes'
 138 #
 139 CREATE TABLE cache_imagesizes (
 140   md5hash varchar(32) DEFAULT '' NOT NULL,
 141   md5filename varchar(32) DEFAULT '' NOT NULL,
 142   tstamp int(11) DEFAULT '0' NOT NULL,
 143   filename varchar(255) DEFAULT '' NOT NULL,
 144   imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
 145   imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
 146   PRIMARY KEY (md5filename)
 147 ) ENGINE=InnoDB;
 148
 149 #
 150 # Table structure for table 'pages'
 151 #
 152 CREATE TABLE pages (
 153   uid int(11) NOT NULL auto_increment,
 154   pid int(11) DEFAULT '0' NOT NULL,
 155   t3ver_oid int(11) DEFAULT '0' NOT NULL,
 156   t3ver_id int(11) DEFAULT '0' NOT NULL,
 157   t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 158   t3ver_label varchar(255) DEFAULT '' NOT NULL,
 159   t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 160   t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
 161   t3ver_count int(11) DEFAULT '0' NOT NULL,
 162   t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 163   t3ver_swapmode tinyint(4) DEFAULT '0' NOT NULL,
 164   t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 165   t3_origuid int(11) DEFAULT '0' NOT NULL,
 166   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 167   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 168   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 169   perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
 170   perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
 171   perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
 172   perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
 173   perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
 174   editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
 175   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 176   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 177   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 178   title varchar(255) DEFAULT '' NOT NULL,
 179   doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
 180   TSconfig text,
 181   storage_pid int(11) DEFAULT '0' NOT NULL,
 182   is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
 183   php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
 184   tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 185   url varchar(255) DEFAULT '' NOT NULL,
 186   starttime int(11) unsigned DEFAULT '0' NOT NULL,
 187   endtime int(11) unsigned DEFAULT '0' NOT NULL,
 188   urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
 189   shortcut int(10) unsigned DEFAULT '0' NOT NULL,
 190   shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
 191   no_cache int(10) unsigned DEFAULT '0' NOT NULL,
 192   fe_group varchar(100) DEFAULT '0' NOT NULL,
 193   subtitle varchar(255) DEFAULT '' NOT NULL,
 194   layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
 195   url_scheme tinyint(3) unsigned DEFAULT '0' NOT NULL,
 196   target varchar(80) DEFAULT '' NOT NULL,
 197   media text,
 198   lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
 199   keywords text,
 200   cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
 201   newUntil int(10) unsigned DEFAULT '0' NOT NULL,
 202   description text,
 203   no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
 204   SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
 205   abstract text,
 206   module varchar(10) DEFAULT '' NOT NULL,
 207   extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
 208   author varchar(255) DEFAULT '' NOT NULL,
 209   author_email varchar(80) DEFAULT '' NOT NULL,
 210   nav_title varchar(255) DEFAULT '' NOT NULL,
 211   nav_hide tinyint(4) DEFAULT '0' NOT NULL,
 212   content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
 213   mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
 214   mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
 215   alias varchar(32) DEFAULT '' NOT NULL,
 216   l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
 217   fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
 218   PRIMARY KEY (uid),
 219   KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 220   KEY parent (pid,sorting,deleted,hidden),
 221   KEY alias (alias)
 222 );
 223
 224 #
 225 # Table structure for table 'sys_registry'
 226 #
 227 CREATE TABLE sys_registry (
 228   uid int(11) unsigned NOT NULL auto_increment,
 229   entry_namespace varchar(128) DEFAULT '' NOT NULL,
 230   entry_key varchar(128) DEFAULT '' NOT NULL,
 231   entry_value blob,
 232   PRIMARY KEY (uid),
 233   UNIQUE KEY entry_identifier (entry_namespace,entry_key)
 234 );
 235
 236 #
 237 # Table structure for table 'sys_be_shortcuts'
 238 #
 239 CREATE TABLE sys_be_shortcuts (
 240   uid int(11) unsigned NOT NULL auto_increment,
 241   userid int(11) unsigned DEFAULT '0' NOT NULL,
 242   module_name varchar(255) DEFAULT '' NOT NULL,
 243   url text,
 244   description varchar(255) DEFAULT '' NOT NULL,
 245   sorting int(11) DEFAULT '0' NOT NULL,
 246   sc_group tinyint(4) DEFAULT '0' NOT NULL,
 247   PRIMARY KEY (uid),
 248   KEY event (userid)
 249 );
 250
 251
 252 #
 253 # Table structure for table 'sys_news'
 254 #
 255 CREATE TABLE sys_news (
 256   uid int(11) unsigned NOT NULL auto_increment,
 257   pid int(11) unsigned DEFAULT '0' NOT NULL,
 258   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 259   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 260   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 261   deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
 262   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 263   starttime int(11) unsigned DEFAULT '0' NOT NULL,
 264   endtime int(11) unsigned DEFAULT '0' NOT NULL,
 265   title varchar(255) DEFAULT '' NOT NULL,
 266   content mediumtext,
 267
 268   PRIMARY KEY (uid),
 269   KEY parent (pid)
 270 );
 271
 272
 273 #
 274 # Table structure for table 'sys_preview'
 275 #
 276 CREATE TABLE sys_preview (
 277   keyword varchar(32) DEFAULT '' NOT NULL,
 278   tstamp int(11) DEFAULT '0' NOT NULL,
 279   endtime int(11) DEFAULT '0' NOT NULL,
 280   config text,
 281   PRIMARY KEY (keyword)
 282 );
 283
 284
 285 #
 286 # Table structure for table 'sys_filemounts'
 287 #
 288 CREATE TABLE sys_filemounts (
 289   uid int(11) unsigned NOT NULL auto_increment,
 290   pid int(11) unsigned DEFAULT '0' NOT NULL,
 291   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 292   title varchar(30) DEFAULT '' NOT NULL,
 293   path varchar(120) DEFAULT '' NOT NULL,
 294   base tinyint(4) unsigned DEFAULT '0' NOT NULL,
 295   hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
 296   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 297   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 298   PRIMARY KEY (uid),
 299   KEY parent (pid)
 300 );
 301
 302 #
 303 # Table structure for table 'sys_workspace'
 304 #
 305 CREATE TABLE sys_workspace (
 306   uid int(11) NOT NULL auto_increment,
 307   pid int(11) DEFAULT '0' NOT NULL,
 308   tstamp int(11) DEFAULT '0' NOT NULL,
 309   deleted tinyint(1) DEFAULT '0' NOT NULL,
 310   title varchar(30) DEFAULT '' NOT NULL,
 311   description varchar(255) DEFAULT '' NOT NULL,
 312   adminusers varchar(255) DEFAULT '' NOT NULL,
 313   members text,
 314   reviewers text,
 315   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
 316   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
 317   publish_time int(11) DEFAULT '0' NOT NULL,
 318   unpublish_time int(11) DEFAULT '0' NOT NULL,
 319   freeze tinyint(3) DEFAULT '0' NOT NULL,
 320   live_edit tinyint(3) DEFAULT '0' NOT NULL,
 321   review_stage_edit tinyint(3) DEFAULT '0' NOT NULL,
 322   vtypes tinyint(3) DEFAULT '0' NOT NULL,
 323   disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
 324   swap_modes tinyint(3) DEFAULT '0' NOT NULL,
 325   publish_access tinyint(3) DEFAULT '0' NOT NULL,
 326   stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
 327
 328   PRIMARY KEY (uid),
 329   KEY parent (pid)
 330 );
 331
 332 #
 333 # Table structure for table 'sys_history'
 334 #
 335 CREATE TABLE sys_history (
 336   uid int(11) unsigned NOT NULL auto_increment,
 337   sys_log_uid int(11) DEFAULT '0' NOT NULL,
 338   history_data mediumtext,
 339   fieldlist text,
 340   recuid int(11) DEFAULT '0' NOT NULL,
 341   tablename varchar(255) DEFAULT '' NOT NULL,
 342   tstamp int(11) DEFAULT '0' NOT NULL,
 343   history_files mediumtext,
 344   snapshot tinyint(4) DEFAULT '0' NOT NULL,
 345   PRIMARY KEY (uid),
 346   KEY recordident (tablename,recuid,tstamp),
 347   KEY sys_log_uid (sys_log_uid)
 348 );
 349
 350 #
 351 # Table structure for table 'sys_lockedrecords'
 352 #
 353 CREATE TABLE sys_lockedrecords (
 354   uid int(11) unsigned NOT NULL auto_increment,
 355   userid int(11) unsigned DEFAULT '0' NOT NULL,
 356   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 357   record_table varchar(255) DEFAULT '' NOT NULL,
 358   record_uid int(11) DEFAULT '0' NOT NULL,
 359   record_pid int(11) DEFAULT '0' NOT NULL,
 360   username varchar(50) DEFAULT '' NOT NULL,
 361   feuserid int(11) unsigned DEFAULT '0' NOT NULL,
 362   PRIMARY KEY (uid),
 363   KEY event (userid,tstamp)
 364 );
 365
 366 #
 367 # Table structure for table 'sys_refindex'
 368 #
 369 CREATE TABLE sys_refindex (
 370   hash varchar(32) DEFAULT '' NOT NULL,
 371   tablename varchar(255) DEFAULT '' NOT NULL,
 372   recuid int(11) DEFAULT '0' NOT NULL,
 373   field varchar(40) DEFAULT '' NOT NULL,
 374   flexpointer varchar(255) DEFAULT '' NOT NULL,
 375   softref_key varchar(30) DEFAULT '' NOT NULL,
 376   softref_id varchar(40) DEFAULT '' NOT NULL,
 377   sorting int(11) DEFAULT '0' NOT NULL,
 378   deleted tinyint(1) DEFAULT '0' NOT NULL,
 379   ref_table varchar(255) DEFAULT '' NOT NULL,
 380   ref_uid int(11) DEFAULT '0' NOT NULL,
 381   ref_string varchar(200) DEFAULT '' NOT NULL,
 382
 383   PRIMARY KEY (hash),
 384   KEY lookup_rec (tablename,recuid),
 385   KEY lookup_uid (ref_table,ref_uid),
 386   KEY lookup_string (ref_string)
 387 );
 388
 389 #
 390 # Table structure for table 'sys_refindex_words'
 391 #
 392 CREATE TABLE sys_refindex_words (
 393   wid int(11) DEFAULT '0' NOT NULL,
 394   baseword varchar(60) DEFAULT '' NOT NULL,
 395   PRIMARY KEY (wid)
 396 );
 397
 398 #
 399 # Table structure for table 'sys_refindex_rel'
 400 #
 401 CREATE TABLE sys_refindex_rel (
 402   rid int(11) DEFAULT '0' NOT NULL,
 403   wid int(11) DEFAULT '0' NOT NULL,
 404   PRIMARY KEY (rid,wid)
 405 );
 406
 407
 408 #
 409 # Table structure for table 'sys_refindex_res'
 410 #
 411 CREATE TABLE sys_refindex_res (
 412   rid int(11) DEFAULT '0' NOT NULL,
 413   tablename varchar(255) DEFAULT '' NOT NULL,
 414   recuid int(11) DEFAULT '0' NOT NULL,
 415   PRIMARY KEY (rid)
 416 );
 417
 418 #
 419 # Table structure for table 'sys_log'
 420 #
 421 CREATE TABLE sys_log (
 422   uid int(11) unsigned NOT NULL auto_increment,
 423   userid int(11) unsigned DEFAULT '0' NOT NULL,
 424   action tinyint(4) unsigned DEFAULT '0' NOT NULL,
 425   recuid int(11) unsigned DEFAULT '0' NOT NULL,
 426   tablename varchar(255) DEFAULT '' NOT NULL,
 427   recpid int(11) DEFAULT '0' NOT NULL,
 428   error tinyint(4) unsigned DEFAULT '0' NOT NULL,
 429   details text NOT NULL,
 430   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 431   type tinyint(3) unsigned DEFAULT '0' NOT NULL,
 432   details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
 433   IP varchar(39) DEFAULT '' NOT NULL,
 434   log_data varchar(255) DEFAULT '' NOT NULL,
 435   event_pid int(11) DEFAULT '-1' NOT NULL,
 436   workspace int(11) DEFAULT '0' NOT NULL,
 437   NEWid varchar(20) DEFAULT '' NOT NULL,
 438   PRIMARY KEY (uid),
 439   KEY event (userid,event_pid),
 440   KEY recuidIdx (recuid,uid)
 441 ) ENGINE=InnoDB;
 442
 443 #
 444 # Table structure for table 'sys_language'
 445 #
 446 CREATE TABLE sys_language (
 447   uid int(11) unsigned NOT NULL auto_increment,
 448   pid int(11) unsigned DEFAULT '0' NOT NULL,
 449   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 450   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 451   title varchar(80) DEFAULT '' NOT NULL,
 452   flag varchar(20) DEFAULT '' NOT NULL,
 453   static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
 454   PRIMARY KEY (uid),
 455   KEY parent (pid)
 456 );