t3lib/stddb/tables.sql

   1 #
   2
   3 #
   4 # Table structure for table 'be_groups'
   5 #
   6 CREATE TABLE be_groups (
   7   uid int(11) unsigned NOT NULL auto_increment,
   8   pid int(11) unsigned DEFAULT '0' NOT NULL,
   9   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  10   title varchar(50) DEFAULT '' NOT NULL,
  11   non_exclude_fields text,
  12   explicit_allowdeny text,
  13   allowed_languages varchar(255) DEFAULT '' NOT NULL,
  14   custom_options text,
  15   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  16   pagetypes_select varchar(255) DEFAULT '' NOT NULL,
  17   tables_select text,
  18   tables_modify text,
  19   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  20   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  21   groupMods text,
  22   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  23   fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
  24   hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
  25   inc_access_lists tinyint(3) unsigned DEFAULT '0' NOT NULL,
  26   description text,
  27   lockToDomain varchar(50) DEFAULT '' NOT NULL,
  28   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
  29   TSconfig text,
  30   subgroup varchar(255) DEFAULT '' NOT NULL,
  31   hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
  32   workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
  33   PRIMARY KEY (uid),
  34   KEY parent (pid)
  35 );
  36
  37 #
  38 # Table structure for table 'be_sessions'
  39 #
  40 CREATE TABLE be_sessions (
  41   ses_id varchar(32) DEFAULT '' NOT NULL,
  42   ses_name varchar(32) DEFAULT '' NOT NULL,
  43   ses_iplock varchar(39) DEFAULT '' NOT NULL,
  44   ses_hashlock int(11) DEFAULT '0' NOT NULL,
  45   ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
  46   ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  47   ses_data longtext,
  48   ses_backuserid int(11) NOT NULL default '0',
  49   PRIMARY KEY (ses_id,ses_name),
  50   KEY ses_tstamp (ses_tstamp)
  51 );
  52
  53 #
  54 # Table structure for table 'be_users'
  55 #
  56 CREATE TABLE be_users (
  57   uid int(11) unsigned NOT NULL auto_increment,
  58   pid int(11) unsigned DEFAULT '0' NOT NULL,
  59   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  60   username varchar(50) DEFAULT '' NOT NULL,
  61   password varchar(100) DEFAULT '' NOT NULL,
  62   admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
  63   usergroup varchar(255) DEFAULT '' NOT NULL,
  64   disable tinyint(1) unsigned DEFAULT '0' NOT NULL,
  65   starttime int(11) unsigned DEFAULT '0' NOT NULL,
  66   endtime int(11) unsigned DEFAULT '0' NOT NULL,
  67   lang char(2) DEFAULT '' NOT NULL,
  68   email varchar(80) DEFAULT '' NOT NULL,
  69   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  70   options tinyint(4) unsigned DEFAULT '0' NOT NULL,
  71   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  72   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  73   realName varchar(80) DEFAULT '' NOT NULL,
  74   userMods varchar(255) DEFAULT '' NOT NULL,
  75   allowed_languages varchar(255) DEFAULT '' NOT NULL,
  76   uc mediumtext,
  77   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  78   fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
  79   workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
  80   lockToDomain varchar(50) DEFAULT '' NOT NULL,
  81   disableIPlock tinyint(1) unsigned DEFAULT '0' NOT NULL,
  82   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
  83   TSconfig text,
  84   lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
  85   createdByAction int(11) DEFAULT '0' NOT NULL,
  86   usergroup_cached_list varchar(255) DEFAULT '' NOT NULL,
  87   workspace_id int(11) DEFAULT '0' NOT NULL,
  88   workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
  89   PRIMARY KEY (uid),
  90   KEY parent (pid),
  91   KEY username (username)
  92 );
  93
  94 #
  95 # Table structure for table 'cache_imagesizes'
  96 #
  97 CREATE TABLE cache_imagesizes (
  98   md5hash varchar(32) DEFAULT '' NOT NULL,
  99   md5filename varchar(32) DEFAULT '' NOT NULL,
 100   tstamp int(11) DEFAULT '0' NOT NULL,
 101   filename varchar(255) DEFAULT '' NOT NULL,
 102   imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
 103   imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
 104   PRIMARY KEY (md5filename)
 105 ) ENGINE=InnoDB;
 106
 107 #
 108 # Table structure for table 'pages'
 109 #
 110 CREATE TABLE pages (
 111   uid int(11) NOT NULL auto_increment,
 112   pid int(11) DEFAULT '0' NOT NULL,
 113   t3ver_oid int(11) DEFAULT '0' NOT NULL,
 114   t3ver_id int(11) DEFAULT '0' NOT NULL,
 115   t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 116   t3ver_label varchar(255) DEFAULT '' NOT NULL,
 117   t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 118   t3ver_stage int(11) DEFAULT '0' NOT NULL,
 119   t3ver_count int(11) DEFAULT '0' NOT NULL,
 120   t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 121   t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 122   t3_origuid int(11) DEFAULT '0' NOT NULL,
 123   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 124   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 125   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 126   perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
 127   perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
 128   perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
 129   perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
 130   perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
 131   editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
 132   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 133   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 134   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 135   title varchar(255) DEFAULT '' NOT NULL,
 136   doktype int(11) unsigned DEFAULT '0' NOT NULL,
 137   TSconfig text,
 138   storage_pid int(11) DEFAULT '0' NOT NULL,
 139   is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
 140   php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
 141   tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 142   url varchar(255) DEFAULT '' NOT NULL,
 143   starttime int(11) unsigned DEFAULT '0' NOT NULL,
 144   endtime int(11) unsigned DEFAULT '0' NOT NULL,
 145   urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
 146   shortcut int(10) unsigned DEFAULT '0' NOT NULL,
 147   shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
 148   no_cache int(10) unsigned DEFAULT '0' NOT NULL,
 149   fe_group varchar(100) DEFAULT '0' NOT NULL,
 150   subtitle varchar(255) DEFAULT '' NOT NULL,
 151   layout int(11) unsigned DEFAULT '0' NOT NULL,
 152   url_scheme tinyint(3) unsigned DEFAULT '0' NOT NULL,
 153   target varchar(80) DEFAULT '' NOT NULL,
 154   media text,
 155   lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
 156   keywords text,
 157   cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
 158   cache_tags varchar(255) DEFAULT '' NOT NULL,
 159   newUntil int(10) unsigned DEFAULT '0' NOT NULL,
 160   description text,
 161   no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
 162   SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
 163   abstract text,
 164   module varchar(10) DEFAULT '' NOT NULL,
 165   extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
 166   author varchar(255) DEFAULT '' NOT NULL,
 167   author_email varchar(80) DEFAULT '' NOT NULL,
 168   nav_title varchar(255) DEFAULT '' NOT NULL,
 169   nav_hide tinyint(4) DEFAULT '0' NOT NULL,
 170   content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
 171   mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
 172   mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
 173   alias varchar(32) DEFAULT '' NOT NULL,
 174   l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
 175   fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
 176   backend_layout int(10) DEFAULT '0' NOT NULL,
 177   backend_layout_next_level int(10) DEFAULT '0' NOT NULL,
 178   PRIMARY KEY (uid),
 179   KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 180   KEY parent (pid,deleted,sorting),
 181   KEY alias (alias)
 182 );
 183
 184 #
 185 # Table structure for table 'sys_registry'
 186 #
 187 CREATE TABLE sys_registry (
 188   uid int(11) unsigned NOT NULL auto_increment,
 189   entry_namespace varchar(128) DEFAULT '' NOT NULL,
 190   entry_key varchar(128) DEFAULT '' NOT NULL,
 191   entry_value blob,
 192   PRIMARY KEY (uid),
 193   UNIQUE KEY entry_identifier (entry_namespace,entry_key)
 194 );
 195
 196 #
 197 # Table structure for table 'sys_be_shortcuts'
 198 #
 199 CREATE TABLE sys_be_shortcuts (
 200   uid int(11) unsigned NOT NULL auto_increment,
 201   userid int(11) unsigned DEFAULT '0' NOT NULL,
 202   module_name varchar(255) DEFAULT '' NOT NULL,
 203   url text,
 204   description varchar(255) DEFAULT '' NOT NULL,
 205   sorting int(11) DEFAULT '0' NOT NULL,
 206   sc_group tinyint(4) DEFAULT '0' NOT NULL,
 207   PRIMARY KEY (uid),
 208   KEY event (userid)
 209 );
 210
 211
 212 #
 213 # Table structure for table 'sys_news'
 214 #
 215 CREATE TABLE sys_news (
 216   uid int(11) unsigned NOT NULL auto_increment,
 217   pid int(11) unsigned DEFAULT '0' NOT NULL,
 218   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 219   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 220   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 221   deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
 222   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 223   starttime int(11) unsigned DEFAULT '0' NOT NULL,
 224   endtime int(11) unsigned DEFAULT '0' NOT NULL,
 225   title varchar(255) DEFAULT '' NOT NULL,
 226   content mediumtext,
 227
 228   PRIMARY KEY (uid),
 229   KEY parent (pid)
 230 );
 231
 232
 233 #
 234 # Table structure for table 'sys_filemounts'
 235 #
 236 CREATE TABLE sys_filemounts (
 237   uid int(11) unsigned NOT NULL auto_increment,
 238   pid int(11) unsigned DEFAULT '0' NOT NULL,
 239   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 240   title varchar(30) DEFAULT '' NOT NULL,
 241   path varchar(120) DEFAULT '' NOT NULL,
 242   base tinyint(4) unsigned DEFAULT '0' NOT NULL,
 243   hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
 244   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 245   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 246   PRIMARY KEY (uid),
 247   KEY parent (pid)
 248 );
 249
 250
 251 #
 252 # Table structure for table 'sys_file_storage'
 253 #
 254 CREATE TABLE sys_file_storage (
 255         uid int(11) NOT NULL auto_increment,
 256         pid int(11) DEFAULT '0' NOT NULL,
 257         tstamp int(11) DEFAULT '0' NOT NULL,
 258         crdate int(11) DEFAULT '0' NOT NULL,
 259         cruser_id int(11) DEFAULT '0' NOT NULL,
 260         deleted tinyint(4) DEFAULT '0' NOT NULL,
 261         hidden tinyint(4) DEFAULT '0' NOT NULL,
 262
 263         name tinytext,
 264         description text,
 265         driver tinytext,
 266         configuration text,
 267         is_browsable tinyint(4) DEFAULT '0' NOT NULL,
 268         is_public tinyint(4) DEFAULT '0' NOT NULL,
 269         is_writable tinyint(4) DEFAULT '0' NOT NULL,
 270         is_online tinyint(4) DEFAULT '1' NOT NULL,
 271         processingfolder tinytext,
 272
 273         PRIMARY KEY (uid),
 274         KEY parent (pid)
 275 );
 276
 277 #
 278 # Table structure for table 'sys_file'
 279 #
 280 CREATE TABLE sys_file (
 281         uid int(11) NOT NULL auto_increment,
 282         pid int(11) DEFAULT '0' NOT NULL,
 283         tstamp int(11) DEFAULT '0' NOT NULL,
 284         crdate int(11) DEFAULT '0' NOT NULL,
 285         cruser_id int(11) DEFAULT '0' NOT NULL,
 286         deleted tinyint(4) DEFAULT '0' NOT NULL,
 287
 288         # Versioning fields
 289         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 290         t3ver_id int(11) DEFAULT '0' NOT NULL,
 291         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 292         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 293         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 294         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 295         t3ver_count int(11) DEFAULT '0' NOT NULL,
 296         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 297         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 298         t3_origuid int(11) DEFAULT '0' NOT NULL,
 299
 300         type varchar(10) DEFAULT '' NOT NULL,
 301         storage int(11) DEFAULT '0' NOT NULL,
 302         identifier varchar(200) DEFAULT '' NOT NULL,
 303         extension varchar(255) DEFAULT '' NOT NULL,
 304         mime_type varchar(255) DEFAULT '' NOT NULL,
 305         name tinytext,
 306         title tinytext,
 307         sha1 tinytext,
 308         size int(11) DEFAULT '0' NOT NULL,
 309         creation_date int(11) DEFAULT '0' NOT NULL,
 310         modification_date int(11) DEFAULT '0' NOT NULL,
 311         width int(11) DEFAULT '0' NOT NULL,
 312         height int(11) DEFAULT '0' NOT NULL,
 313         description text,
 314         alternative text,
 315
 316         PRIMARY KEY (uid),
 317         KEY parent (pid),
 318         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 319 );
 320
 321 #
 322 # Table structure for table 'sys_file_processedfile'.
 323 # which is a "temporary" file, like an image preview
 324 # This table does not have a TCA representation, as it's only written do using direct SQL queries in the code
 325 #
 326 CREATE TABLE sys_file_processedfile (
 327         uid int(11) NOT NULL auto_increment,
 328         pid int(11) DEFAULT '0' NOT NULL,
 329         tstamp int(11) DEFAULT '0' NOT NULL,
 330         crdate int(11) DEFAULT '0' NOT NULL,
 331         cruser_id int(11) DEFAULT '0' NOT NULL,
 332         deleted tinyint(4) DEFAULT '0' NOT NULL,
 333
 334         storage int(11) DEFAULT '0' NOT NULL,
 335         original int(11) DEFAULT '0' NOT NULL,
 336         identifier varchar(200) DEFAULT '' NOT NULL,
 337         name tinytext,
 338         configuration text,
 339         context varchar(200) DEFAULT '' NOT NULL,
 340         checksum varchar(255) DEFAULT '' NOT NULL,
 341         is_processed varchar(200) DEFAULT '' NOT NULL,
 342         extension varchar(255) DEFAULT '' NOT NULL,
 343         mime_type varchar(255) DEFAULT '' NOT NULL,
 344         sha1 tinytext,
 345         size int(11) DEFAULT '0' NOT NULL,
 346         width int(11) DEFAULT '0' NOT NULL,
 347         height int(11) DEFAULT '0' NOT NULL,
 348
 349         PRIMARY KEY (uid),
 350         KEY parent (pid)
 351 );
 352
 353 #
 354 # Table structure for table 'sys_file_reference'
 355 # which is one usage of a file with overloaded metadata
 356 #
 357 CREATE TABLE sys_file_reference (
 358         uid int(11) NOT NULL auto_increment,
 359         pid int(11) DEFAULT '0' NOT NULL,
 360         tstamp int(11) DEFAULT '0' NOT NULL,
 361         crdate int(11) DEFAULT '0' NOT NULL,
 362         cruser_id int(11) DEFAULT '0' NOT NULL,
 363         sorting int(10) DEFAULT '0' NOT NULL,
 364         deleted tinyint(4) DEFAULT '0' NOT NULL,
 365         hidden tinyint(4) DEFAULT '0' NOT NULL,
 366
 367         # Versioning fields
 368         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 369         t3ver_id int(11) DEFAULT '0' NOT NULL,
 370         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 371         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 372         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 373         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 374         t3ver_count int(11) DEFAULT '0' NOT NULL,
 375         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 376         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 377         t3_origuid int(11) DEFAULT '0' NOT NULL,
 378
 379         # Language fields
 380         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 381         l10n_parent int(11) DEFAULT '0' NOT NULL,
 382         l10n_diffsource mediumblob NOT NULL,
 383
 384         # Reference fields (basically same as MM table)
 385         uid_local int(11) DEFAULT '0' NOT NULL,
 386         uid_foreign int(11) DEFAULT '0' NOT NULL,
 387         tablenames varchar(255) DEFAULT '' NOT NULL,
 388         fieldname tinytext,
 389         sorting_foreign int(11) DEFAULT '0' NOT NULL,
 390         table_local varchar(255) DEFAULT '' NOT NULL,
 391
 392         # Local usage overlay fields
 393         title tinytext,
 394         description text,
 395         alternative tinytext,
 396         link tinytext,
 397         downloadname tinytext,
 398
 399         PRIMARY KEY (uid),
 400         KEY uid_local (uid_local),
 401         KEY uid_foreign (uid_foreign),
 402         KEY parent (pid)
 403 );
 404
 405
 406 #
 407 # Table structure for table 'sys_file_collection'
 408 #
 409 CREATE TABLE sys_file_collection (
 410         uid int(11) NOT NULL auto_increment,
 411         pid int(11) DEFAULT '0' NOT NULL,
 412         tstamp int(11) DEFAULT '0' NOT NULL,
 413         crdate int(11) DEFAULT '0' NOT NULL,
 414         cruser_id int(11) DEFAULT '0' NOT NULL,
 415         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 416         t3ver_id int(11) DEFAULT '0' NOT NULL,
 417         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 418         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 419         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 420         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 421         t3ver_count int(11) DEFAULT '0' NOT NULL,
 422         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 423         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 424         t3_origuid int(11) DEFAULT '0' NOT NULL,
 425         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 426         l10n_parent int(11) DEFAULT '0' NOT NULL,
 427         l10n_diffsource mediumtext,
 428         deleted tinyint(4) DEFAULT '0' NOT NULL,
 429         hidden tinyint(4) DEFAULT '0' NOT NULL,
 430         starttime int(11) DEFAULT '0' NOT NULL,
 431         endtime int(11) DEFAULT '0' NOT NULL,
 432
 433         # Actual fields
 434         title tinytext,
 435         description text,
 436         type varchar(6) DEFAULT 'static' NOT NULL,
 437
 438         # for type=static
 439         files int(11) DEFAULT '0' NOT NULL,
 440
 441         # for type=folder:
 442         storage int(11) DEFAULT '0' NOT NULL,
 443         folder text NOT NULL,
 444
 445         PRIMARY KEY (uid),
 446         KEY parent (pid),
 447         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 448 );
 449
 450 #
 451 # Table structure for table 'sys_collection'
 452 #
 453 CREATE TABLE sys_collection (
 454         uid int(11) NOT NULL auto_increment,
 455         pid int(11) DEFAULT '0' NOT NULL,
 456         tstamp int(11) DEFAULT '0' NOT NULL,
 457         crdate int(11) DEFAULT '0' NOT NULL,
 458         cruser_id int(11) DEFAULT '0' NOT NULL,
 459         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 460         t3ver_id int(11) DEFAULT '0' NOT NULL,
 461         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 462         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 463         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 464         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 465         t3ver_count int(11) DEFAULT '0' NOT NULL,
 466         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 467         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 468         t3_origuid int(11) DEFAULT '0' NOT NULL,
 469         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 470         l10n_parent int(11) DEFAULT '0' NOT NULL,
 471         l10n_diffsource mediumtext,
 472         deleted tinyint(4) DEFAULT '0' NOT NULL,
 473         hidden tinyint(4) DEFAULT '0' NOT NULL,
 474         starttime int(11) DEFAULT '0' NOT NULL,
 475         endtime int(11) DEFAULT '0' NOT NULL,
 476         fe_group int(11) DEFAULT '0' NOT NULL,
 477
 478         title tinytext,
 479         description text,
 480         type varchar(32) DEFAULT 'static' NOT NULL,
 481         table_name tinytext,
 482         items int(11) DEFAULT '0' NOT NULL,
 483
 484         PRIMARY KEY (uid),
 485         KEY parent (pid),
 486         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 487 );
 488
 489 #
 490 # Table structure for table 'sys_collection_entries'
 491 #
 492 CREATE TABLE sys_collection_entries (
 493         uid int(11) NOT NULL auto_increment,
 494         uid_local int(11) DEFAULT '0' NOT NULL,
 495         uid_foreign int(11) DEFAULT '0' NOT NULL,
 496         tablenames varchar(30) DEFAULT '' NOT NULL,
 497         sorting int(11) DEFAULT '0' NOT NULL,
 498
 499         KEY uid_local (uid_local),
 500         KEY uid_foreign (uid_foreign),
 501         PRIMARY KEY (uid)
 502 );
 503
 504 #
 505 # Table structure for table 'sys_history'
 506 #
 507 CREATE TABLE sys_history (
 508   uid int(11) unsigned NOT NULL auto_increment,
 509   pid int(11) unsigned DEFAULT '0' NOT NULL,
 510   sys_log_uid int(11) DEFAULT '0' NOT NULL,
 511   history_data mediumtext,
 512   fieldlist text,
 513   recuid int(11) DEFAULT '0' NOT NULL,
 514   tablename varchar(255) DEFAULT '' NOT NULL,
 515   tstamp int(11) DEFAULT '0' NOT NULL,
 516   history_files mediumtext,
 517   snapshot int(11) DEFAULT '0' NOT NULL,
 518   PRIMARY KEY (uid),
 519   KEY parent (pid),
 520   KEY recordident_1 (tablename,recuid),
 521   KEY recordident_2 (tablename,tstamp),
 522   KEY sys_log_uid (sys_log_uid)
 523 ) ENGINE=InnoDB;
 524
 525 #
 526 # Table structure for table 'sys_lockedrecords'
 527 #
 528 CREATE TABLE sys_lockedrecords (
 529   uid int(11) unsigned NOT NULL auto_increment,
 530   userid int(11) unsigned DEFAULT '0' NOT NULL,
 531   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 532   record_table varchar(255) DEFAULT '' NOT NULL,
 533   record_uid int(11) DEFAULT '0' NOT NULL,
 534   record_pid int(11) DEFAULT '0' NOT NULL,
 535   username varchar(50) DEFAULT '' NOT NULL,
 536   feuserid int(11) unsigned DEFAULT '0' NOT NULL,
 537   PRIMARY KEY (uid),
 538   KEY event (userid,tstamp)
 539 );
 540
 541 #
 542 # Table structure for table 'sys_refindex'
 543 #
 544 CREATE TABLE sys_refindex (
 545   hash varchar(32) DEFAULT '' NOT NULL,
 546   tablename varchar(255) DEFAULT '' NOT NULL,
 547   recuid int(11) DEFAULT '0' NOT NULL,
 548   field varchar(40) DEFAULT '' NOT NULL,
 549   flexpointer varchar(255) DEFAULT '' NOT NULL,
 550   softref_key varchar(30) DEFAULT '' NOT NULL,
 551   softref_id varchar(40) DEFAULT '' NOT NULL,
 552   sorting int(11) DEFAULT '0' NOT NULL,
 553   deleted tinyint(1) DEFAULT '0' NOT NULL,
 554   ref_table varchar(255) DEFAULT '' NOT NULL,
 555   ref_uid int(11) DEFAULT '0' NOT NULL,
 556   ref_string varchar(200) DEFAULT '' NOT NULL,
 557
 558   PRIMARY KEY (hash),
 559   KEY lookup_rec (tablename,recuid),
 560   KEY lookup_uid (ref_table,ref_uid),
 561   KEY lookup_string (ref_string)
 562 );
 563
 564 #
 565 # Table structure for table 'sys_log'
 566 #
 567 CREATE TABLE sys_log (
 568   uid int(11) unsigned NOT NULL auto_increment,
 569   pid int(11) unsigned DEFAULT '0' NOT NULL,
 570   userid int(11) unsigned DEFAULT '0' NOT NULL,
 571   action tinyint(4) unsigned DEFAULT '0' NOT NULL,
 572   recuid int(11) unsigned DEFAULT '0' NOT NULL,
 573   tablename varchar(255) DEFAULT '' NOT NULL,
 574   recpid int(11) DEFAULT '0' NOT NULL,
 575   error tinyint(4) unsigned DEFAULT '0' NOT NULL,
 576   details text NOT NULL,
 577   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 578   type tinyint(3) unsigned DEFAULT '0' NOT NULL,
 579   details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
 580   IP varchar(39) DEFAULT '' NOT NULL,
 581   log_data text,
 582   event_pid int(11) DEFAULT '-1' NOT NULL,
 583   workspace int(11) DEFAULT '0' NOT NULL,
 584   NEWid varchar(20) DEFAULT '' NOT NULL,
 585   request_id varchar(13) DEFAULT '' NOT NULL,
 586   time_micro float DEFAULT '0' NOT NULL,
 587   component varchar(255) DEFAULT '' NOT NULL,
 588   level tinyint(1) unsigned DEFAULT '0' NOT NULL,
 589   message text,
 590   data text,
 591   PRIMARY KEY (uid),
 592   KEY parent (pid),
 593   KEY event (userid,event_pid),
 594   KEY recuidIdx (recuid,uid),
 595   KEY user_auth (type,action,tstamp),
 596   KEY request (request_id)
 597 ) ENGINE=InnoDB;
 598
 599 #
 600 # Table structure for table 'sys_language'
 601 #
 602 CREATE TABLE sys_language (
 603   uid int(11) unsigned NOT NULL auto_increment,
 604   pid int(11) unsigned DEFAULT '0' NOT NULL,
 605   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 606   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 607   title varchar(80) DEFAULT '' NOT NULL,
 608   flag varchar(20) DEFAULT '' NOT NULL,
 609   static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
 610   PRIMARY KEY (uid),
 611   KEY parent (pid)
 612 );
 613
 614 #
 615 # Table structure for table 'sys_category'
 616 #
 617 CREATE TABLE sys_category (
 618         uid int(11) NOT NULL auto_increment,
 619         pid int(11) DEFAULT '0' NOT NULL,
 620         tstamp int(11) DEFAULT '0' NOT NULL,
 621         crdate int(11) DEFAULT '0' NOT NULL,
 622         cruser_id int(11) DEFAULT '0' NOT NULL,
 623         deleted tinyint(4) DEFAULT '0' NOT NULL,
 624         hidden tinyint(4) DEFAULT '0' NOT NULL,
 625         starttime int(11) unsigned DEFAULT '0' NOT NULL,
 626         endtime int(11) unsigned DEFAULT '0' NOT NULL,
 627
 628         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 629         t3ver_id int(11) DEFAULT '0' NOT NULL,
 630         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 631         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 632         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 633         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 634         t3ver_count int(11) DEFAULT '0' NOT NULL,
 635         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 636         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 637         t3_origuid int(11) DEFAULT '0' NOT NULL,
 638
 639         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 640         l10n_parent int(11) DEFAULT '0' NOT NULL,
 641         l10n_diffsource mediumblob NOT NULL,
 642
 643         title tinytext NOT NULL,
 644         description text NOT NULL,
 645         parent int(11) DEFAULT '0' NOT NULL,
 646         items int(11) DEFAULT '0' NOT NULL,
 647
 648         PRIMARY KEY (uid),
 649         KEY parent (pid),
 650         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 651 );
 652
 653 #
 654 # Table structure for table 'sys_category_record_mm'
 655 #
 656 CREATE TABLE sys_category_record_mm (
 657         uid_local int(11) DEFAULT '0' NOT NULL,
 658         uid_foreign int(11) DEFAULT '0' NOT NULL,
 659         tablenames varchar(255) DEFAULT '' NOT NULL,
 660         sorting int(11) DEFAULT '0' NOT NULL,
 661         sorting_foreign int(11) DEFAULT '0' NOT NULL,
 662
 663         KEY uid_local_foreign (uid_local,uid_foreign)
 664         KEY uid_foreign_tablenames (uid_foreign,tablenames)
 665 );