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(40) 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 tinytext NOT NULL,
  28   file_mountpoints varchar(40) 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 mediumtext 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 varchar(2) DEFAULT '' NOT NULL,
  72   email varchar(80) DEFAULT '' NOT NULL,
  73   db_mountpoints varchar(40) 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(40) 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_hash'
 100 #
 101 CREATE TABLE cache_hash (
 102   hash varchar(32) DEFAULT '' NOT NULL,
 103   content mediumtext NOT NULL,
 104   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 105   ident varchar(20) DEFAULT '' NOT NULL,
 106   PRIMARY KEY (hash)
 107 );
 108
 109 #
 110 # Table structure for table 'cache_imagesizes'
 111 #
 112 CREATE TABLE cache_imagesizes (
 113   md5hash varchar(32) DEFAULT '' NOT NULL,
 114   md5filename varchar(32) DEFAULT '' NOT NULL,
 115   tstamp int(11) DEFAULT '0' NOT NULL,
 116   filename tinytext NOT NULL,
 117   imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
 118   imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
 119   PRIMARY KEY (md5filename)
 120 );
 121
 122 #
 123 # Table structure for table 'pages'
 124 #
 125 CREATE TABLE pages (
 126   uid int(11) NOT NULL auto_increment,
 127   pid int(11) DEFAULT '0' NOT NULL,
 128   t3ver_oid int(11) DEFAULT '0' NOT NULL,
 129   t3ver_id int(11) DEFAULT '0' NOT NULL,
 130   t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 131   t3ver_label varchar(30) DEFAULT '' NOT NULL,
 132   t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 133   t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
 134   t3ver_count int(11) DEFAULT '0' NOT NULL,
 135   t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 136   t3ver_swapmode tinyint(4) DEFAULT '0' NOT NULL,
 137   t3_origuid int(11) DEFAULT '0' NOT NULL,
 138   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 139   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 140   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 141   perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
 142   perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
 143   perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
 144   perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
 145   perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
 146   editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
 147   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 148   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 149   title tinytext NOT NULL,
 150   doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
 151   TSconfig text NOT NULL,
 152   storage_pid int(11) DEFAULT '0' NOT NULL,
 153   is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
 154   php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
 155   tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 156   PRIMARY KEY (uid),
 157   KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 158   KEY parent (pid)
 159 );
 160
 161 #
 162 # Table structure for table 'sys_be_shortcuts'
 163 #
 164 CREATE TABLE sys_be_shortcuts (
 165   uid int(11) unsigned NOT NULL auto_increment,
 166   userid int(11) unsigned DEFAULT '0' NOT NULL,
 167   module_name tinytext NOT NULL,
 168   url text NOT NULL,
 169   description tinytext NOT NULL,
 170   sorting int(11) DEFAULT '0' NOT NULL,
 171   sc_group tinyint(4) DEFAULT '0' NOT NULL,
 172   PRIMARY KEY (uid),
 173   KEY event (userid)
 174 );
 175
 176
 177 #
 178 # Table structure for table 'sys_preview'
 179 #
 180 CREATE TABLE sys_preview (
 181   keyword varchar(32) DEFAULT '' NOT NULL,
 182   tstamp int(11) DEFAULT '0' NOT NULL,
 183   endtime int(11) DEFAULT '0' NOT NULL,
 184   config text NOT NULL,
 185   PRIMARY KEY (keyword)
 186 );
 187
 188
 189 #
 190 # Table structure for table 'sys_filemounts'
 191 #
 192 CREATE TABLE sys_filemounts (
 193   uid int(11) unsigned NOT NULL auto_increment,
 194   pid int(11) unsigned DEFAULT '0' NOT NULL,
 195   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 196   title varchar(30) DEFAULT '' NOT NULL,
 197   path varchar(120) DEFAULT '' NOT NULL,
 198   base tinyint(4) unsigned DEFAULT '0' NOT NULL,
 199   hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
 200   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 201   PRIMARY KEY (uid),
 202   KEY parent (pid)
 203 );
 204
 205 #
 206 # Table structure for table 'sys_workspace'
 207 #
 208 CREATE TABLE sys_workspace (
 209   uid int(11) NOT NULL auto_increment,
 210   pid int(11) DEFAULT '0' NOT NULL,
 211   tstamp int(11) DEFAULT '0' NOT NULL,
 212   deleted tinyint(1) DEFAULT '0' NOT NULL,
 213   title varchar(30) DEFAULT '' NOT NULL,
 214   description tinytext NOT NULL,
 215   adminusers tinytext NOT NULL,
 216   members text NOT NULL,
 217   reviewers text NOT NULL,
 218   db_mountpoints tinytext NOT NULL,
 219   file_mountpoints tinytext NOT NULL,
 220   publish_time int(11) DEFAULT '0' NOT NULL,
 221   unpublish_time int(11) DEFAULT '0' NOT NULL,
 222   freeze tinyint(3) DEFAULT '0' NOT NULL,
 223   live_edit tinyint(3) DEFAULT '0' NOT NULL,
 224   review_stage_edit tinyint(3) DEFAULT '0' NOT NULL,
 225   vtypes tinyint(3) DEFAULT '0' NOT NULL,
 226   disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
 227   swap_modes tinyint(3) DEFAULT '0' NOT NULL,
 228   publish_access tinyint(3) DEFAULT '0' NOT NULL,
 229   stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
 230
 231   PRIMARY KEY (uid),
 232   KEY parent (pid)
 233 );
 234
 235 #
 236 # Table structure for table 'sys_history'
 237 #
 238 CREATE TABLE sys_history (
 239   uid int(11) unsigned NOT NULL auto_increment,
 240   sys_log_uid int(11) DEFAULT '0' NOT NULL,
 241   history_data mediumtext NOT NULL,
 242   fieldlist text NOT NULL,
 243   recuid int(11) DEFAULT '0' NOT NULL,
 244   tablename varchar(40) DEFAULT '' NOT NULL,
 245   tstamp int(11) DEFAULT '0' NOT NULL,
 246   history_files mediumtext NOT NULL,
 247   snapshot tinyint(4) DEFAULT '0' NOT NULL,
 248   PRIMARY KEY (uid),
 249   KEY recordident (tablename,recuid),
 250   KEY sys_log_uid (sys_log_uid)
 251 );
 252
 253 #
 254 # Table structure for table 'sys_lockedrecords'
 255 #
 256 CREATE TABLE sys_lockedrecords (
 257   uid int(11) unsigned NOT NULL auto_increment,
 258   userid int(11) unsigned DEFAULT '0' NOT NULL,
 259   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 260   record_table varchar(40) DEFAULT '' NOT NULL,
 261   record_uid int(11) DEFAULT '0' NOT NULL,
 262   record_pid int(11) DEFAULT '0' NOT NULL,
 263   username varchar(20) DEFAULT '' NOT NULL,
 264   PRIMARY KEY (uid),
 265   KEY event (userid,tstamp)
 266 );
 267
 268 #
 269 # Table structure for table 'sys_refindex'
 270 #
 271 CREATE TABLE sys_refindex (
 272   hash varchar(32) DEFAULT '' NOT NULL,
 273   tablename varchar(40) DEFAULT '' NOT NULL,
 274   recuid int(11) DEFAULT '0' NOT NULL,
 275   field varchar(40) DEFAULT '' NOT NULL,
 276   flexpointer tinytext NOT NULL,
 277   softref_key varchar(30) DEFAULT '' NOT NULL,
 278   softref_id varchar(40) DEFAULT '' NOT NULL,
 279   sorting int(11) DEFAULT '0' NOT NULL,
 280   deleted tinyint(1) DEFAULT '0' NOT NULL,
 281   ref_table varchar(40) DEFAULT '' NOT NULL,
 282   ref_uid int(11) DEFAULT '0' NOT NULL,
 283   ref_string varchar(200) DEFAULT '' NOT NULL,
 284
 285   PRIMARY KEY (hash),
 286   KEY lookup_rec (tablename,recuid),
 287   KEY lookup_uid (ref_table,ref_uid),
 288   KEY lookup_string (ref_table,ref_string)
 289 );
 290
 291 #
 292 # Table structure for table ''
 293 #
 294 CREATE TABLE sys_refindex_words (
 295   wid int(11) DEFAULT '0' NOT NULL,
 296   baseword varchar(60) DEFAULT '' NOT NULL,
 297   PRIMARY KEY (wid)
 298 );
 299
 300 #
 301 # Table structure for table ''
 302 #
 303 CREATE TABLE sys_refindex_rel (
 304   rid int(11) DEFAULT '0' NOT NULL,
 305   wid int(11) DEFAULT '0' NOT NULL,
 306   PRIMARY KEY (rid,wid)
 307 );
 308
 309
 310 #
 311 # Table structure for table ''
 312 #
 313 CREATE TABLE sys_refindex_res (
 314   rid int(11) DEFAULT '0' NOT NULL,
 315   tablename varchar(100) DEFAULT '' NOT NULL,
 316   recuid int(11) DEFAULT '0' NOT NULL,
 317   PRIMARY KEY (rid)
 318 );
 319
 320 #
 321 # Table structure for table 'sys_log'
 322 #
 323 CREATE TABLE sys_log (
 324   uid int(11) unsigned NOT NULL auto_increment,
 325   userid int(11) unsigned DEFAULT '0' NOT NULL,
 326   action tinyint(4) unsigned DEFAULT '0' NOT NULL,
 327   recuid int(11) unsigned DEFAULT '0' NOT NULL,
 328   tablename varchar(40) DEFAULT '' NOT NULL,
 329   recpid int(11) DEFAULT '0' NOT NULL,
 330   error tinyint(4) unsigned DEFAULT '0' NOT NULL,
 331   details tinytext NOT NULL,
 332   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 333   type tinyint(3) unsigned DEFAULT '0' NOT NULL,
 334   details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
 335   IP varchar(39) DEFAULT '' NOT NULL,
 336   log_data tinytext NOT NULL,
 337   event_pid int(11) DEFAULT '-1' NOT NULL,
 338   workspace int(11) DEFAULT '0' NOT NULL,
 339   NEWid varchar(20) DEFAULT '' NOT NULL,
 340   PRIMARY KEY (uid),
 341   KEY event (userid,event_pid)
 342 );
 343
 344 #
 345 # Table structure for table 'sys_language'
 346 #
 347 CREATE TABLE sys_language (
 348   uid int(11) unsigned NOT NULL auto_increment,
 349   pid int(11) unsigned DEFAULT '0' NOT NULL,
 350   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 351   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 352   title varchar(80) DEFAULT '' NOT NULL,
 353   flag varchar(20) DEFAULT '' NOT NULL,
 354   static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
 355   PRIMARY KEY (uid),
 356   KEY parent (pid)
 357 );
 358