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_extensions'
  97 #
  98 CREATE TABLE cache_extensions (
  99   extkey varchar(60) NOT NULL default '',
 100   version varchar(10) NOT NULL default '',
 101   alldownloadcounter int(11) unsigned NOT NULL default '0',
 102   downloadcounter int(11) unsigned NOT NULL default '0',
 103   title varchar(150) NOT NULL default '',
 104   description mediumtext,
 105   state int(4) NOT NULL default '0',
 106   reviewstate int(4) NOT NULL default '0',
 107   category int(4) NOT NULL default '0',
 108   lastuploaddate int(11) unsigned NOT NULL default '0',
 109   dependencies mediumtext,
 110   authorname varchar(100) NOT NULL default '',
 111   authoremail varchar(100) NOT NULL default '',
 112   ownerusername varchar(50) NOT NULL default '',
 113   t3xfilemd5 varchar(35) NOT NULL default '',
 114   uploadcomment mediumtext,
 115   authorcompany varchar(100) NOT NULL default '',
 116   intversion int(11) NOT NULL default '0',
 117   lastversion int(3) NOT NULL default '0',
 118   lastreviewedversion int(3) NOT NULL default '0',
 119   PRIMARY KEY (extkey,version)
 120 );
 121
 122 #
 123 # Table structure for table 'cache_hash'
 124 #
 125 CREATE TABLE cache_hash (
 126   id int(11) unsigned NOT NULL auto_increment,
 127   hash varchar(32) DEFAULT '' NOT NULL,
 128   content mediumblob,
 129   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 130   ident varchar(32) DEFAULT '' NOT NULL,
 131   PRIMARY KEY (id),
 132   KEY hash (hash)
 133 ) ENGINE=InnoDB;
 134
 135
 136 #
 137 # Table structure for table 'cachingframework_cache_hash'
 138 #
 139 CREATE TABLE cachingframework_cache_hash (
 140   id int(11) unsigned NOT NULL auto_increment,
 141   identifier varchar(128) DEFAULT '' NOT NULL,
 142   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 143   content mediumblob,
 144   lifetime int(11) unsigned DEFAULT '0' NOT NULL,
 145   PRIMARY KEY (id),
 146   KEY cache_id (identifier)
 147 ) ENGINE=InnoDB;
 148
 149
 150 #
 151 # Table structure for table 'cachingframework_cache_hash_tags'
 152 #
 153 CREATE TABLE cachingframework_cache_hash_tags (
 154   id int(11) unsigned NOT NULL auto_increment,
 155   identifier varchar(128) DEFAULT '' NOT NULL,
 156   tag varchar(128) DEFAULT '' NOT NULL,
 157   PRIMARY KEY (id),
 158   KEY cache_id (identifier),
 159   KEY cache_tag (tag)
 160 ) ENGINE=InnoDB;
 161
 162
 163 #
 164 # Table structure for table 'cache_imagesizes'
 165 #
 166 CREATE TABLE cache_imagesizes (
 167   md5hash varchar(32) DEFAULT '' NOT NULL,
 168   md5filename varchar(32) DEFAULT '' NOT NULL,
 169   tstamp int(11) DEFAULT '0' NOT NULL,
 170   filename varchar(255) DEFAULT '' NOT NULL,
 171   imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
 172   imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
 173   PRIMARY KEY (md5filename)
 174 ) ENGINE=InnoDB;
 175
 176 #
 177 # Table structure for table 'pages'
 178 #
 179 CREATE TABLE pages (
 180   uid int(11) NOT NULL auto_increment,
 181   pid int(11) DEFAULT '0' NOT NULL,
 182   t3ver_oid int(11) DEFAULT '0' NOT NULL,
 183   t3ver_id int(11) DEFAULT '0' NOT NULL,
 184   t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 185   t3ver_label varchar(255) DEFAULT '' NOT NULL,
 186   t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 187   t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
 188   t3ver_count int(11) DEFAULT '0' NOT NULL,
 189   t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 190   t3ver_swapmode tinyint(4) DEFAULT '0' NOT NULL,
 191   t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 192   t3_origuid int(11) DEFAULT '0' NOT NULL,
 193   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 194   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 195   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 196   perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
 197   perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
 198   perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
 199   perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
 200   perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
 201   editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
 202   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 203   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 204   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 205   title varchar(255) DEFAULT '' NOT NULL,
 206   doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
 207   TSconfig text,
 208   storage_pid int(11) DEFAULT '0' NOT NULL,
 209   is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
 210   php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
 211   tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 212   PRIMARY KEY (uid),
 213   KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 214   KEY parent (pid,sorting,deleted,hidden)
 215 );
 216
 217 #
 218 # Table structure for table 'sys_registry'
 219 #
 220 CREATE TABLE sys_registry (
 221   uid int(11) unsigned NOT NULL auto_increment,
 222   entry_namespace varchar(128) DEFAULT '' NOT NULL,
 223   entry_key varchar(128) DEFAULT '' NOT NULL,
 224   entry_value blob,
 225   PRIMARY KEY (uid),
 226   UNIQUE KEY entry_identifier (entry_namespace,entry_key)
 227 );
 228
 229 #
 230 # Table structure for table 'sys_be_shortcuts'
 231 #
 232 CREATE TABLE sys_be_shortcuts (
 233   uid int(11) unsigned NOT NULL auto_increment,
 234   userid int(11) unsigned DEFAULT '0' NOT NULL,
 235   module_name varchar(255) DEFAULT '' NOT NULL,
 236   url text,
 237   description varchar(255) DEFAULT '' NOT NULL,
 238   sorting int(11) DEFAULT '0' NOT NULL,
 239   sc_group tinyint(4) DEFAULT '0' NOT NULL,
 240   PRIMARY KEY (uid),
 241   KEY event (userid)
 242 );
 243
 244
 245 #
 246 # Table structure for table 'sys_preview'
 247 #
 248 CREATE TABLE sys_preview (
 249   keyword varchar(32) DEFAULT '' NOT NULL,
 250   tstamp int(11) DEFAULT '0' NOT NULL,
 251   endtime int(11) DEFAULT '0' NOT NULL,
 252   config text,
 253   PRIMARY KEY (keyword)
 254 );
 255
 256
 257 #
 258 # Table structure for table 'sys_filemounts'
 259 #
 260 CREATE TABLE sys_filemounts (
 261   uid int(11) unsigned NOT NULL auto_increment,
 262   pid int(11) unsigned DEFAULT '0' NOT NULL,
 263   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 264   title varchar(30) DEFAULT '' NOT NULL,
 265   path varchar(120) DEFAULT '' NOT NULL,
 266   base tinyint(4) unsigned DEFAULT '0' NOT NULL,
 267   hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
 268   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 269   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 270   PRIMARY KEY (uid),
 271   KEY parent (pid)
 272 );
 273
 274 #
 275 # Table structure for table 'sys_workspace'
 276 #
 277 CREATE TABLE sys_workspace (
 278   uid int(11) NOT NULL auto_increment,
 279   pid int(11) DEFAULT '0' NOT NULL,
 280   tstamp int(11) DEFAULT '0' NOT NULL,
 281   deleted tinyint(1) DEFAULT '0' NOT NULL,
 282   title varchar(30) DEFAULT '' NOT NULL,
 283   description varchar(255) DEFAULT '' NOT NULL,
 284   adminusers varchar(255) DEFAULT '' NOT NULL,
 285   members text,
 286   reviewers text,
 287   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
 288   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
 289   publish_time int(11) DEFAULT '0' NOT NULL,
 290   unpublish_time int(11) DEFAULT '0' NOT NULL,
 291   freeze tinyint(3) DEFAULT '0' NOT NULL,
 292   live_edit tinyint(3) DEFAULT '0' NOT NULL,
 293   review_stage_edit tinyint(3) DEFAULT '0' NOT NULL,
 294   vtypes tinyint(3) DEFAULT '0' NOT NULL,
 295   disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
 296   swap_modes tinyint(3) DEFAULT '0' NOT NULL,
 297   publish_access tinyint(3) DEFAULT '0' NOT NULL,
 298   stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
 299
 300   PRIMARY KEY (uid),
 301   KEY parent (pid)
 302 );
 303
 304 #
 305 # Table structure for table 'sys_history'
 306 #
 307 CREATE TABLE sys_history (
 308   uid int(11) unsigned NOT NULL auto_increment,
 309   sys_log_uid int(11) DEFAULT '0' NOT NULL,
 310   history_data mediumtext,
 311   fieldlist text,
 312   recuid int(11) DEFAULT '0' NOT NULL,
 313   tablename varchar(255) DEFAULT '' NOT NULL,
 314   tstamp int(11) DEFAULT '0' NOT NULL,
 315   history_files mediumtext,
 316   snapshot tinyint(4) DEFAULT '0' NOT NULL,
 317   PRIMARY KEY (uid),
 318   KEY recordident (tablename,recuid,tstamp),
 319   KEY sys_log_uid (sys_log_uid)
 320 );
 321
 322 #
 323 # Table structure for table 'sys_lockedrecords'
 324 #
 325 CREATE TABLE sys_lockedrecords (
 326   uid int(11) unsigned NOT NULL auto_increment,
 327   userid int(11) unsigned DEFAULT '0' NOT NULL,
 328   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 329   record_table varchar(255) DEFAULT '' NOT NULL,
 330   record_uid int(11) DEFAULT '0' NOT NULL,
 331   record_pid int(11) DEFAULT '0' NOT NULL,
 332   username varchar(50) DEFAULT '' NOT NULL,
 333   feuserid int(11) unsigned DEFAULT '0' NOT NULL,
 334   PRIMARY KEY (uid),
 335   KEY event (userid,tstamp)
 336 );
 337
 338 #
 339 # Table structure for table 'sys_refindex'
 340 #
 341 CREATE TABLE sys_refindex (
 342   hash varchar(32) DEFAULT '' NOT NULL,
 343   tablename varchar(255) DEFAULT '' NOT NULL,
 344   recuid int(11) DEFAULT '0' NOT NULL,
 345   field varchar(40) DEFAULT '' NOT NULL,
 346   flexpointer varchar(255) DEFAULT '' NOT NULL,
 347   softref_key varchar(30) DEFAULT '' NOT NULL,
 348   softref_id varchar(40) DEFAULT '' NOT NULL,
 349   sorting int(11) DEFAULT '0' NOT NULL,
 350   deleted tinyint(1) DEFAULT '0' NOT NULL,
 351   ref_table varchar(255) DEFAULT '' NOT NULL,
 352   ref_uid int(11) DEFAULT '0' NOT NULL,
 353   ref_string varchar(200) DEFAULT '' NOT NULL,
 354
 355   PRIMARY KEY (hash),
 356   KEY lookup_rec (tablename,recuid),
 357   KEY lookup_uid (ref_table,ref_uid),
 358   KEY lookup_string (ref_string)
 359 );
 360
 361 #
 362 # Table structure for table 'sys_refindex_words'
 363 #
 364 CREATE TABLE sys_refindex_words (
 365   wid int(11) DEFAULT '0' NOT NULL,
 366   baseword varchar(60) DEFAULT '' NOT NULL,
 367   PRIMARY KEY (wid)
 368 );
 369
 370 #
 371 # Table structure for table 'sys_refindex_rel'
 372 #
 373 CREATE TABLE sys_refindex_rel (
 374   rid int(11) DEFAULT '0' NOT NULL,
 375   wid int(11) DEFAULT '0' NOT NULL,
 376   PRIMARY KEY (rid,wid)
 377 );
 378
 379
 380 #
 381 # Table structure for table 'sys_refindex_res'
 382 #
 383 CREATE TABLE sys_refindex_res (
 384   rid int(11) DEFAULT '0' NOT NULL,
 385   tablename varchar(255) DEFAULT '' NOT NULL,
 386   recuid int(11) DEFAULT '0' NOT NULL,
 387   PRIMARY KEY (rid)
 388 );
 389
 390 #
 391 # Table structure for table 'sys_log'
 392 #
 393 CREATE TABLE sys_log (
 394   uid int(11) unsigned NOT NULL auto_increment,
 395   userid int(11) unsigned DEFAULT '0' NOT NULL,
 396   action tinyint(4) unsigned DEFAULT '0' NOT NULL,
 397   recuid int(11) unsigned DEFAULT '0' NOT NULL,
 398   tablename varchar(255) DEFAULT '' NOT NULL,
 399   recpid int(11) DEFAULT '0' NOT NULL,
 400   error tinyint(4) unsigned DEFAULT '0' NOT NULL,
 401   details text NOT NULL,
 402   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 403   type tinyint(3) unsigned DEFAULT '0' NOT NULL,
 404   details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
 405   IP varchar(39) DEFAULT '' NOT NULL,
 406   log_data varchar(255) DEFAULT '' NOT NULL,
 407   event_pid int(11) DEFAULT '-1' NOT NULL,
 408   workspace int(11) DEFAULT '0' NOT NULL,
 409   NEWid varchar(20) DEFAULT '' NOT NULL,
 410   PRIMARY KEY (uid),
 411   KEY event (userid,event_pid),
 412   KEY recuidIdx (recuid,uid)
 413 ) ENGINE=InnoDB;
 414
 415 #
 416 # Table structure for table 'sys_language'
 417 #
 418 CREATE TABLE sys_language (
 419   uid int(11) unsigned NOT NULL auto_increment,
 420   pid int(11) unsigned DEFAULT '0' NOT NULL,
 421   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 422   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 423   title varchar(80) DEFAULT '' NOT NULL,
 424   flag varchar(20) DEFAULT '' NOT NULL,
 425   static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
 426   PRIMARY KEY (uid),
 427   KEY parent (pid)
 428 );