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