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(20) 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(20) 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   vtypes tinyint(3) DEFAULT '0' NOT NULL,
 225   disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
 226   swap_modes tinyint(3) DEFAULT '0' NOT NULL,
 227   publish_access tinyint(3) DEFAULT '0' NOT NULL,
 228   stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
 229
 230   PRIMARY KEY (uid),
 231   KEY parent (pid)
 232 );
 233
 234 #
 235 # Table structure for table 'sys_history'
 236 #
 237 CREATE TABLE sys_history (
 238   uid int(11) unsigned NOT NULL auto_increment,
 239   sys_log_uid int(11) DEFAULT '0' NOT NULL,
 240   history_data mediumtext NOT NULL,
 241   fieldlist text NOT NULL,
 242   recuid int(11) DEFAULT '0' NOT NULL,
 243   tablename varchar(40) DEFAULT '' NOT NULL,
 244   tstamp int(11) DEFAULT '0' NOT NULL,
 245   history_files mediumtext NOT NULL,
 246   snapshot tinyint(4) DEFAULT '0' NOT NULL,
 247   PRIMARY KEY (uid),
 248   KEY recordident (tablename,recuid),
 249   KEY sys_log_uid (sys_log_uid)
 250 );
 251
 252 #
 253 # Table structure for table 'sys_lockedrecords'
 254 #
 255 CREATE TABLE sys_lockedrecords (
 256   uid int(11) unsigned NOT NULL auto_increment,
 257   userid int(11) unsigned DEFAULT '0' NOT NULL,
 258   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 259   record_table varchar(40) DEFAULT '' NOT NULL,
 260   record_uid int(11) DEFAULT '0' NOT NULL,
 261   record_pid int(11) DEFAULT '0' NOT NULL,
 262   username varchar(20) DEFAULT '' NOT NULL,
 263   PRIMARY KEY (uid),
 264   KEY event (userid,tstamp)
 265 );
 266
 267 #
 268 # Table structure for table 'sys_refindex'
 269 #
 270 CREATE TABLE sys_refindex (
 271   hash varchar(32) DEFAULT '' NOT NULL,
 272   tablename varchar(40) DEFAULT '' NOT NULL,
 273   recuid int(11) DEFAULT '0' NOT NULL,
 274   field varchar(40) DEFAULT '' NOT NULL,
 275   flexpointer tinytext NOT NULL,
 276   softref_key varchar(30) DEFAULT '' NOT NULL,
 277   softref_id varchar(40) DEFAULT '' NOT NULL,
 278   sorting int(11) DEFAULT '0' NOT NULL,
 279   deleted tinyint(1) DEFAULT '0' NOT NULL,
 280   ref_table varchar(40) DEFAULT '' NOT NULL,
 281   ref_uid int(11) DEFAULT '0' NOT NULL,
 282   ref_string varchar(200) DEFAULT '' NOT NULL,
 283
 284   PRIMARY KEY (hash),
 285   KEY lookup_rec (tablename,recuid),
 286   KEY lookup_uid (ref_table,ref_uid),
 287   KEY lookup_string (ref_table,ref_string(199))
 288 );
 289
 290 #
 291 # Table structure for table 'sys_log'
 292 #
 293 CREATE TABLE sys_log (
 294   uid int(11) unsigned NOT NULL auto_increment,
 295   userid int(11) unsigned DEFAULT '0' NOT NULL,
 296   action tinyint(4) unsigned DEFAULT '0' NOT NULL,
 297   recuid int(11) unsigned DEFAULT '0' NOT NULL,
 298   tablename varchar(40) DEFAULT '' NOT NULL,
 299   recpid int(11) DEFAULT '0' NOT NULL,
 300   error tinyint(4) unsigned DEFAULT '0' NOT NULL,
 301   details tinytext NOT NULL,
 302   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 303   type tinyint(3) unsigned DEFAULT '0' NOT NULL,
 304   details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
 305   IP varchar(39) DEFAULT '' NOT NULL,
 306   log_data tinytext NOT NULL,
 307   event_pid int(11) DEFAULT '-1' NOT NULL,
 308   workspace int(11) DEFAULT '0' NOT NULL,
 309   NEWid varchar(20) DEFAULT '' NOT NULL,
 310   PRIMARY KEY (uid),
 311   KEY event (userid,event_pid)
 312 );
 313
 314 #
 315 # Table structure for table 'sys_language'
 316 #
 317 CREATE TABLE sys_language (
 318   uid int(11) unsigned NOT NULL auto_increment,
 319   pid int(11) unsigned DEFAULT '0' NOT NULL,
 320   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 321   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 322   title varchar(80) DEFAULT '' NOT NULL,
 323   flag varchar(20) DEFAULT '' NOT NULL,
 324   static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
 325   PRIMARY KEY (uid),
 326   KEY parent (pid)
 327 );
 328