t3lib/stddb/tables.sql

   1 # MySQL dump 6.4
   2 #
   3 # Host: localhost    Database: t3_testsite
   4 #--------------------------------------------------------
   5 # Server version        3.22.27
   6 #
   7 # TYPO3 CVS ID: $Id$
   8
   9 #
  10 # Table structure for table 'be_groups'
  11 #
  12 CREATE TABLE be_groups (
  13   uid int(11) unsigned NOT NULL auto_increment,
  14   pid int(11) unsigned DEFAULT '0' NOT NULL,
  15   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  16   title varchar(50) DEFAULT '' NOT NULL,
  17   non_exclude_fields text NOT NULL,
  18   explicit_allowdeny text NOT NULL,
  19   allowed_languages tinytext NOT NULL,
  20   custom_options text NOT NULL,
  21   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  22   pagetypes_select tinytext NOT NULL,
  23   tables_select text NOT NULL,
  24   tables_modify text NOT NULL,
  25   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  26   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  27   groupMods text NOT NULL,
  28   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  29   hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
  30   inc_access_lists tinyint(3) unsigned DEFAULT '0' NOT NULL,
  31   description text NOT NULL,
  32   lockToDomain varchar(50) DEFAULT '' NOT NULL,
  33   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
  34   TSconfig text NOT NULL,
  35   subgroup tinytext NOT NULL,
  36   hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
  37   workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
  38   PRIMARY KEY (uid),
  39   KEY parent (pid)
  40 );
  41
  42 #
  43 # Table structure for table 'be_sessions'
  44 #
  45 CREATE TABLE be_sessions (
  46   ses_id varchar(32) DEFAULT '' NOT NULL,
  47   ses_name varchar(32) DEFAULT '' NOT NULL,
  48   ses_iplock varchar(39) DEFAULT '' NOT NULL,
  49   ses_hashlock int(11) DEFAULT '0' NOT NULL,
  50   ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
  51   ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  52   ses_data longtext NOT NULL,
  53   ses_backuserid int(11) NOT NULL default '0',
  54   PRIMARY KEY (ses_id,ses_name)
  55 );
  56
  57 #
  58 # Table structure for table 'be_users'
  59 #
  60 CREATE TABLE be_users (
  61   uid int(11) unsigned NOT NULL auto_increment,
  62   pid int(11) unsigned DEFAULT '0' NOT NULL,
  63   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  64   username varchar(50) DEFAULT '' NOT NULL,
  65   password varchar(40) DEFAULT '' NOT NULL,
  66   admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
  67   usergroup tinytext NOT NULL,
  68   disable tinyint(1) unsigned DEFAULT '0' NOT NULL,
  69   starttime int(11) unsigned DEFAULT '0' NOT NULL,
  70   endtime int(11) unsigned DEFAULT '0' NOT NULL,
  71   lang char(2) DEFAULT '' NOT NULL,
  72   email varchar(80) DEFAULT '' NOT NULL,
  73   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  74   options tinyint(4) unsigned DEFAULT '0' NOT NULL,
  75   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  76   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  77   realName varchar(80) DEFAULT '' NOT NULL,
  78   userMods tinytext NOT NULL,
  79   allowed_languages tinytext NOT NULL,
  80   uc text NOT NULL,
  81   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  82   fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
  83   workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
  84   lockToDomain varchar(50) DEFAULT '' NOT NULL,
  85   disableIPlock tinyint(1) unsigned DEFAULT '0' NOT NULL,
  86   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
  87   TSconfig text NOT NULL,
  88   lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
  89   createdByAction int(11) DEFAULT '0' NOT NULL,
  90   usergroup_cached_list tinytext NOT NULL,
  91   workspace_id int(11) DEFAULT '0' NOT NULL,
  92   workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
  93   PRIMARY KEY (uid),
  94   KEY parent (pid),
  95   KEY username (username)
  96 );
  97
  98 #
  99 # Table structure for table 'cache_extensions'
 100 #
 101 CREATE TABLE cache_extensions (
 102   extkey varchar(60) NOT NULL default '',
 103   version varchar(10) NOT NULL default '',
 104   alldownloadcounter int(11) unsigned NOT NULL default '0',
 105   downloadcounter int(11) unsigned NOT NULL default '0',
 106   title varchar(150) NOT NULL default '',
 107   description mediumtext NOT NULL,
 108   state int(4) NOT NULL default '0',
 109   reviewstate int(4) unsigned NOT NULL default '0',
 110   category int(4) NOT NULL default '0',
 111   lastuploaddate int(11) unsigned NOT NULL default '0',
 112   dependencies mediumtext NOT NULL,
 113   authorname varchar(100) NOT NULL default '',
 114   authoremail varchar(100) NOT NULL default '',
 115   ownerusername varchar(50) NOT NULL default '',
 116   t3xfilemd5 varchar(35) NOT NULL default '',
 117   uploadcomment mediumtext NOT NULL,
 118   authorcompany varchar(100) NOT NULL default '',
 119   intversion int(11) NOT NULL default '0',
 120   lastversion int(3) NOT NULL default '0',
 121   lastreviewedversion int(3) NOT NULL default '0',
 122   PRIMARY KEY (extkey,version)
 123 );
 124
 125 #
 126 # Table structure for table 'cache_hash'
 127 #
 128 CREATE TABLE cache_hash (
 129   hash varchar(32) DEFAULT '' NOT NULL,
 130   content mediumtext NOT NULL,
 131   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 132   ident varchar(20) DEFAULT '' NOT NULL,
 133   PRIMARY KEY (hash)
 134 ) ENGINE=InnoDB;
 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 tinytext 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(30) 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   t3_origuid int(11) DEFAULT '0' NOT NULL,
 165   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 166   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 167   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 168   perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
 169   perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
 170   perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
 171   perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
 172   perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
 173   editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
 174   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 175   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 176   title tinytext NOT NULL,
 177   doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
 178   TSconfig text NOT NULL,
 179   storage_pid int(11) DEFAULT '0' NOT NULL,
 180   is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
 181   php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
 182   tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 183   PRIMARY KEY (uid),
 184   KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 185   KEY parent (pid,sorting)
 186 );
 187
 188 #
 189 # Table structure for table 'sys_be_shortcuts'
 190 #
 191 CREATE TABLE sys_be_shortcuts (
 192   uid int(11) unsigned NOT NULL auto_increment,
 193   userid int(11) unsigned DEFAULT '0' NOT NULL,
 194   module_name tinytext NOT NULL,
 195   url text NOT NULL,
 196   description tinytext NOT NULL,
 197   sorting int(11) DEFAULT '0' NOT NULL,
 198   sc_group tinyint(4) DEFAULT '0' NOT NULL,
 199   PRIMARY KEY (uid),
 200   KEY event (userid)
 201 );
 202
 203
 204 #
 205 # Table structure for table 'sys_preview'
 206 #
 207 CREATE TABLE sys_preview (
 208   keyword varchar(32) DEFAULT '' NOT NULL,
 209   tstamp int(11) DEFAULT '0' NOT NULL,
 210   endtime int(11) DEFAULT '0' NOT NULL,
 211   config text NOT NULL,
 212   PRIMARY KEY (keyword)
 213 );
 214
 215
 216 #
 217 # Table structure for table 'sys_filemounts'
 218 #
 219 CREATE TABLE sys_filemounts (
 220   uid int(11) unsigned NOT NULL auto_increment,
 221   pid int(11) unsigned DEFAULT '0' NOT NULL,
 222   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 223   title varchar(30) DEFAULT '' NOT NULL,
 224   path varchar(120) DEFAULT '' NOT NULL,
 225   base tinyint(4) unsigned DEFAULT '0' NOT NULL,
 226   hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
 227   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 228   PRIMARY KEY (uid),
 229   KEY parent (pid)
 230 );
 231
 232 #
 233 # Table structure for table 'sys_workspace'
 234 #
 235 CREATE TABLE sys_workspace (
 236   uid int(11) NOT NULL auto_increment,
 237   pid int(11) DEFAULT '0' NOT NULL,
 238   tstamp int(11) DEFAULT '0' NOT NULL,
 239   deleted tinyint(1) DEFAULT '0' NOT NULL,
 240   title varchar(30) DEFAULT '' NOT NULL,
 241   description tinytext NOT NULL,
 242   adminusers tinytext NOT NULL,
 243   members text NOT NULL,
 244   reviewers text NOT NULL,
 245   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
 246   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
 247   publish_time int(11) DEFAULT '0' NOT NULL,
 248   unpublish_time int(11) DEFAULT '0' NOT NULL,
 249   freeze tinyint(3) DEFAULT '0' NOT NULL,
 250   live_edit tinyint(3) DEFAULT '0' NOT NULL,
 251   review_stage_edit tinyint(3) DEFAULT '0' NOT NULL,
 252   vtypes tinyint(3) DEFAULT '0' NOT NULL,
 253   disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
 254   swap_modes tinyint(3) DEFAULT '0' NOT NULL,
 255   publish_access tinyint(3) DEFAULT '0' NOT NULL,
 256   stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
 257
 258   PRIMARY KEY (uid),
 259   KEY parent (pid)
 260 );
 261
 262 #
 263 # Table structure for table 'sys_history'
 264 #
 265 CREATE TABLE sys_history (
 266   uid int(11) unsigned NOT NULL auto_increment,
 267   sys_log_uid int(11) DEFAULT '0' NOT NULL,
 268   history_data mediumtext NOT NULL,
 269   fieldlist text NOT NULL,
 270   recuid int(11) DEFAULT '0' NOT NULL,
 271   tablename varchar(40) DEFAULT '' NOT NULL,
 272   tstamp int(11) DEFAULT '0' NOT NULL,
 273   history_files mediumtext NOT NULL,
 274   snapshot tinyint(4) DEFAULT '0' NOT NULL,
 275   PRIMARY KEY (uid),
 276   KEY recordident (tablename,recuid,tstamp),
 277   KEY sys_log_uid (sys_log_uid),
 278 );
 279
 280 #
 281 # Table structure for table 'sys_lockedrecords'
 282 #
 283 CREATE TABLE sys_lockedrecords (
 284   uid int(11) unsigned NOT NULL auto_increment,
 285   userid int(11) unsigned DEFAULT '0' NOT NULL,
 286   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 287   record_table varchar(40) DEFAULT '' NOT NULL,
 288   record_uid int(11) DEFAULT '0' NOT NULL,
 289   record_pid int(11) DEFAULT '0' NOT NULL,
 290   username varchar(20) DEFAULT '' NOT NULL,
 291   PRIMARY KEY (uid),
 292   KEY event (userid,tstamp)
 293 );
 294
 295 #
 296 # Table structure for table 'sys_refindex'
 297 #
 298 CREATE TABLE sys_refindex (
 299   hash varchar(32) DEFAULT '' NOT NULL,
 300   tablename varchar(40) DEFAULT '' NOT NULL,
 301   recuid int(11) DEFAULT '0' NOT NULL,
 302   field varchar(40) DEFAULT '' NOT NULL,
 303   flexpointer tinytext NOT NULL,
 304   softref_key varchar(30) DEFAULT '' NOT NULL,
 305   softref_id varchar(40) DEFAULT '' NOT NULL,
 306   sorting int(11) DEFAULT '0' NOT NULL,
 307   deleted tinyint(1) DEFAULT '0' NOT NULL,
 308   ref_table varchar(40) DEFAULT '' NOT NULL,
 309   ref_uid int(11) DEFAULT '0' NOT NULL,
 310   ref_string varchar(200) DEFAULT '' NOT NULL,
 311
 312   PRIMARY KEY (hash),
 313   KEY lookup_rec (tablename,recuid),
 314   KEY lookup_uid (ref_table,ref_uid),
 315   KEY lookup_string (ref_table,ref_string)
 316 );
 317
 318 #
 319 # Table structure for table ''
 320 #
 321 CREATE TABLE sys_refindex_words (
 322   wid int(11) DEFAULT '0' NOT NULL,
 323   baseword varchar(60) DEFAULT '' NOT NULL,
 324   PRIMARY KEY (wid)
 325 );
 326
 327 #
 328 # Table structure for table ''
 329 #
 330 CREATE TABLE sys_refindex_rel (
 331   rid int(11) DEFAULT '0' NOT NULL,
 332   wid int(11) DEFAULT '0' NOT NULL,
 333   PRIMARY KEY (rid,wid)
 334 );
 335
 336
 337 #
 338 # Table structure for table ''
 339 #
 340 CREATE TABLE sys_refindex_res (
 341   rid int(11) DEFAULT '0' NOT NULL,
 342   tablename varchar(100) DEFAULT '' NOT NULL,
 343   recuid int(11) DEFAULT '0' NOT NULL,
 344   PRIMARY KEY (rid)
 345 );
 346
 347 #
 348 # Table structure for table 'sys_log'
 349 #
 350 CREATE TABLE sys_log (
 351   uid int(11) unsigned NOT NULL auto_increment,
 352   userid int(11) unsigned DEFAULT '0' NOT NULL,
 353   action tinyint(4) unsigned DEFAULT '0' NOT NULL,
 354   recuid int(11) unsigned DEFAULT '0' NOT NULL,
 355   tablename varchar(40) DEFAULT '' NOT NULL,
 356   recpid int(11) DEFAULT '0' NOT NULL,
 357   error tinyint(4) unsigned DEFAULT '0' NOT NULL,
 358   details tinytext NOT NULL,
 359   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 360   type tinyint(3) unsigned DEFAULT '0' NOT NULL,
 361   details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
 362   IP varchar(39) DEFAULT '' NOT NULL,
 363   log_data tinytext NOT NULL,
 364   event_pid int(11) DEFAULT '-1' NOT NULL,
 365   workspace int(11) DEFAULT '0' NOT NULL,
 366   NEWid varchar(20) DEFAULT '' NOT NULL,
 367   PRIMARY KEY (uid),
 368   KEY event (userid,event_pid),
 369   KEY recuidIdx (recuid,uid)
 370 ) ENGINE=InnoDB;
 371
 372 #
 373 # Table structure for table 'sys_language'
 374 #
 375 CREATE TABLE sys_language (
 376   uid int(11) unsigned NOT NULL auto_increment,
 377   pid int(11) unsigned DEFAULT '0' NOT NULL,
 378   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 379   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 380   title varchar(80) DEFAULT '' NOT NULL,
 381   flag varchar(20) DEFAULT '' NOT NULL,
 382   static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
 383   PRIMARY KEY (uid),
 384   KEY parent (pid)
 385 );
 386