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 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 text,
  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 text,
  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 text,
  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,deleted)
 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         # update timestamp of the database record, not the file!
 284         tstamp int(11) DEFAULT '0' NOT NULL,
 285         crdate int(11) DEFAULT '0' NOT NULL,
 286         cruser_id int(11) DEFAULT '0' NOT NULL,
 287         deleted tinyint(4) DEFAULT '0' NOT NULL,
 288         missing tinyint(4) DEFAULT '0' NOT NULL,
 289
 290         # Versioning fields
 291         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 292         t3ver_id int(11) DEFAULT '0' NOT NULL,
 293         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 294         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 295         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 296         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 297         t3ver_count int(11) DEFAULT '0' NOT NULL,
 298         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 299         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 300         t3_origuid int(11) DEFAULT '0' NOT NULL,
 301
 302         type varchar(10) DEFAULT '' NOT NULL,
 303         storage int(11) DEFAULT '0' NOT NULL,
 304         identifier varchar(200) DEFAULT '' NOT NULL,
 305         extension varchar(255) DEFAULT '' NOT NULL,
 306         mime_type varchar(255) DEFAULT '' NOT NULL,
 307         name tinytext,
 308         title tinytext,
 309         sha1 tinytext,
 310         size int(11) DEFAULT '0' NOT NULL,
 311         # creation/modification date of the file (not the record!)
 312         creation_date int(11) DEFAULT '0' NOT NULL,
 313         modification_date int(11) DEFAULT '0' NOT NULL,
 314         width int(11) DEFAULT '0' NOT NULL,
 315         height int(11) DEFAULT '0' NOT NULL,
 316         description text,
 317         alternative text,
 318
 319         PRIMARY KEY (uid),
 320         KEY parent (pid,deleted),
 321         KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 322         KEY sel01 (storage,identifier(20)),
 323         KEY sha1 (sha1(40))
 324 );
 325
 326 #
 327 # Table structure for table 'sys_file_processedfile'.
 328 # which is a "temporary" file, like an image preview
 329 # This table does not have a TCA representation, as it is only written
 330 # to using direct SQL queries in the code
 331 #
 332 CREATE TABLE sys_file_processedfile (
 333         uid int(11) NOT NULL auto_increment,
 334         tstamp int(11) DEFAULT '0' NOT NULL,
 335         crdate int(11) DEFAULT '0' NOT NULL,
 336
 337         storage int(11) DEFAULT '0' NOT NULL,
 338         original int(11) DEFAULT '0' NOT NULL,
 339         identifier varchar(200) DEFAULT '' NOT NULL,
 340         name tinytext,
 341         configuration text,
 342         originalfilesha1 varchar(40) DEFAULT '' NOT NULL,
 343         task_type varchar(200) DEFAULT '' NOT NULL,
 344         checksum varchar(255) DEFAULT '' NOT NULL,
 345         width int(11) DEFAULT '0',
 346         height int(11) DEFAULT '0',
 347
 348         PRIMARY KEY (uid)
 349 );
 350
 351 #
 352 # Table structure for table 'sys_file_reference'
 353 # which is one usage of a file with overloaded metadata
 354 #
 355 CREATE TABLE sys_file_reference (
 356         uid int(11) NOT NULL auto_increment,
 357         pid int(11) DEFAULT '0' NOT NULL,
 358         tstamp int(11) DEFAULT '0' NOT NULL,
 359         crdate int(11) DEFAULT '0' NOT NULL,
 360         cruser_id int(11) DEFAULT '0' NOT NULL,
 361         sorting int(10) DEFAULT '0' NOT NULL,
 362         deleted tinyint(4) DEFAULT '0' NOT NULL,
 363         hidden tinyint(4) DEFAULT '0' NOT NULL,
 364
 365         # Versioning fields
 366         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 367         t3ver_id int(11) DEFAULT '0' NOT NULL,
 368         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 369         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 370         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 371         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 372         t3ver_count int(11) DEFAULT '0' NOT NULL,
 373         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 374         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 375         t3_origuid int(11) DEFAULT '0' NOT NULL,
 376
 377         # Language fields
 378         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 379         l10n_parent int(11) DEFAULT '0' NOT NULL,
 380         l10n_diffsource mediumblob NOT NULL,
 381
 382         # Reference fields (basically same as MM table)
 383         uid_local int(11) DEFAULT '0' NOT NULL,
 384         uid_foreign int(11) DEFAULT '0' NOT NULL,
 385         tablenames varchar(255) DEFAULT '' NOT NULL,
 386         fieldname tinytext,
 387         sorting_foreign int(11) DEFAULT '0' NOT NULL,
 388         table_local varchar(255) DEFAULT '' NOT NULL,
 389
 390         # Local usage overlay fields
 391         title tinytext,
 392         description text,
 393         alternative tinytext,
 394         link tinytext,
 395         downloadname tinytext,
 396
 397         PRIMARY KEY (uid),
 398         KEY parent (pid,deleted)
 399 );
 400
 401
 402 #
 403 # Table structure for table 'sys_file_collection'
 404 #
 405 CREATE TABLE sys_file_collection (
 406         uid int(11) NOT NULL auto_increment,
 407         pid int(11) DEFAULT '0' NOT NULL,
 408         tstamp int(11) DEFAULT '0' NOT NULL,
 409         crdate int(11) DEFAULT '0' NOT NULL,
 410         cruser_id int(11) DEFAULT '0' NOT NULL,
 411         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 412         t3ver_id int(11) DEFAULT '0' NOT NULL,
 413         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 414         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 415         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 416         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 417         t3ver_count int(11) DEFAULT '0' NOT NULL,
 418         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 419         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 420         t3_origuid int(11) DEFAULT '0' NOT NULL,
 421         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 422         l10n_parent int(11) DEFAULT '0' NOT NULL,
 423         l10n_diffsource mediumtext,
 424         deleted tinyint(4) DEFAULT '0' NOT NULL,
 425         hidden tinyint(4) DEFAULT '0' NOT NULL,
 426         starttime int(11) DEFAULT '0' NOT NULL,
 427         endtime int(11) DEFAULT '0' NOT NULL,
 428
 429         # Actual fields
 430         title tinytext,
 431         description text,
 432         type varchar(6) DEFAULT 'static' NOT NULL,
 433
 434         # for type=static
 435         files int(11) DEFAULT '0' NOT NULL,
 436
 437         # for type=folder:
 438         storage int(11) DEFAULT '0' NOT NULL,
 439         folder text NOT NULL,
 440
 441         PRIMARY KEY (uid),
 442         KEY parent (pid,deleted),
 443         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 444 );
 445
 446 #
 447 # Table structure for table 'sys_collection'
 448 #
 449 CREATE TABLE sys_collection (
 450         uid int(11) NOT NULL auto_increment,
 451         pid int(11) DEFAULT '0' NOT NULL,
 452         tstamp int(11) DEFAULT '0' NOT NULL,
 453         crdate int(11) DEFAULT '0' NOT NULL,
 454         cruser_id int(11) DEFAULT '0' NOT NULL,
 455         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 456         t3ver_id int(11) DEFAULT '0' NOT NULL,
 457         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 458         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 459         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 460         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 461         t3ver_count int(11) DEFAULT '0' NOT NULL,
 462         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 463         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 464         t3_origuid int(11) DEFAULT '0' NOT NULL,
 465         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 466         l10n_parent int(11) DEFAULT '0' NOT NULL,
 467         l10n_diffsource mediumtext,
 468         deleted tinyint(4) DEFAULT '0' NOT NULL,
 469         hidden tinyint(4) DEFAULT '0' NOT NULL,
 470         starttime int(11) DEFAULT '0' NOT NULL,
 471         endtime int(11) DEFAULT '0' NOT NULL,
 472         fe_group int(11) DEFAULT '0' NOT NULL,
 473
 474         title tinytext,
 475         description text,
 476         type varchar(32) DEFAULT 'static' NOT NULL,
 477         table_name tinytext,
 478         items 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_entries'
 487 #
 488 CREATE TABLE sys_collection_entries (
 489         uid int(11) NOT NULL auto_increment,
 490         uid_local int(11) DEFAULT '0' NOT NULL,
 491         uid_foreign int(11) DEFAULT '0' NOT NULL,
 492         tablenames varchar(30) DEFAULT '' NOT NULL,
 493         sorting int(11) DEFAULT '0' NOT NULL,
 494
 495         KEY uid_local (uid_local),
 496         KEY uid_foreign (uid_foreign),
 497         PRIMARY KEY (uid)
 498 );
 499
 500 #
 501 # Table structure for table 'sys_history'
 502 #
 503 CREATE TABLE sys_history (
 504   uid int(11) unsigned NOT NULL auto_increment,
 505   pid int(11) unsigned DEFAULT '0' NOT NULL,
 506   sys_log_uid int(11) DEFAULT '0' NOT NULL,
 507   history_data mediumtext,
 508   fieldlist text,
 509   recuid int(11) DEFAULT '0' NOT NULL,
 510   tablename varchar(255) DEFAULT '' NOT NULL,
 511   tstamp int(11) DEFAULT '0' NOT NULL,
 512   history_files mediumtext,
 513   snapshot int(11) DEFAULT '0' NOT NULL,
 514   PRIMARY KEY (uid),
 515   KEY parent (pid),
 516   KEY recordident_1 (tablename,recuid),
 517   KEY recordident_2 (tablename,tstamp),
 518   KEY sys_log_uid (sys_log_uid)
 519 ) ENGINE=InnoDB;
 520
 521 #
 522 # Table structure for table 'sys_lockedrecords'
 523 #
 524 CREATE TABLE sys_lockedrecords (
 525   uid int(11) unsigned NOT NULL auto_increment,
 526   userid int(11) unsigned DEFAULT '0' NOT NULL,
 527   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 528   record_table varchar(255) DEFAULT '' NOT NULL,
 529   record_uid int(11) DEFAULT '0' NOT NULL,
 530   record_pid int(11) DEFAULT '0' NOT NULL,
 531   username varchar(50) DEFAULT '' NOT NULL,
 532   feuserid int(11) unsigned DEFAULT '0' NOT NULL,
 533   PRIMARY KEY (uid),
 534   KEY event (userid,tstamp)
 535 );
 536
 537 #
 538 # Table structure for table 'sys_refindex'
 539 #
 540 CREATE TABLE sys_refindex (
 541   hash varchar(32) DEFAULT '' NOT NULL,
 542   tablename varchar(255) DEFAULT '' NOT NULL,
 543   recuid int(11) DEFAULT '0' NOT NULL,
 544   field varchar(40) DEFAULT '' NOT NULL,
 545   flexpointer varchar(255) DEFAULT '' NOT NULL,
 546   softref_key varchar(30) DEFAULT '' NOT NULL,
 547   softref_id varchar(40) DEFAULT '' NOT NULL,
 548   sorting int(11) DEFAULT '0' NOT NULL,
 549   deleted tinyint(1) DEFAULT '0' NOT NULL,
 550   ref_table varchar(255) DEFAULT '' NOT NULL,
 551   ref_uid int(11) DEFAULT '0' NOT NULL,
 552   ref_string varchar(200) DEFAULT '' NOT NULL,
 553
 554   PRIMARY KEY (hash),
 555   KEY lookup_rec (tablename,recuid),
 556   KEY lookup_uid (ref_table,ref_uid),
 557   KEY lookup_string (ref_string)
 558 );
 559
 560 #
 561 # Table structure for table 'sys_log'
 562 #
 563 CREATE TABLE sys_log (
 564   uid int(11) unsigned NOT NULL auto_increment,
 565   pid int(11) unsigned DEFAULT '0' NOT NULL,
 566   userid int(11) unsigned DEFAULT '0' NOT NULL,
 567   action tinyint(4) unsigned DEFAULT '0' NOT NULL,
 568   recuid int(11) unsigned DEFAULT '0' NOT NULL,
 569   tablename varchar(255) DEFAULT '' NOT NULL,
 570   recpid int(11) DEFAULT '0' NOT NULL,
 571   error tinyint(4) unsigned DEFAULT '0' NOT NULL,
 572   details text NOT NULL,
 573   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 574   type tinyint(3) unsigned DEFAULT '0' NOT NULL,
 575   details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
 576   IP varchar(39) DEFAULT '' NOT NULL,
 577   log_data text,
 578   event_pid int(11) DEFAULT '-1' NOT NULL,
 579   workspace int(11) DEFAULT '0' NOT NULL,
 580   NEWid varchar(20) DEFAULT '' NOT NULL,
 581   request_id varchar(13) DEFAULT '' NOT NULL,
 582   time_micro float DEFAULT '0' NOT NULL,
 583   component varchar(255) DEFAULT '' NOT NULL,
 584   level tinyint(1) unsigned DEFAULT '0' NOT NULL,
 585   message text,
 586   data text,
 587   PRIMARY KEY (uid),
 588   KEY parent (pid),
 589   KEY event (userid,event_pid),
 590   KEY recuidIdx (recuid,uid),
 591   KEY user_auth (type,action,tstamp),
 592   KEY request (request_id)
 593 ) ENGINE=InnoDB;
 594
 595 #
 596 # Table structure for table 'sys_language'
 597 #
 598 CREATE TABLE sys_language (
 599   uid int(11) unsigned NOT NULL auto_increment,
 600   pid int(11) unsigned DEFAULT '0' NOT NULL,
 601   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 602   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 603   title varchar(80) DEFAULT '' NOT NULL,
 604   flag varchar(20) DEFAULT '' NOT NULL,
 605   static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
 606   PRIMARY KEY (uid),
 607   KEY parent (pid)
 608 );
 609
 610 #
 611 # Table structure for table 'sys_category'
 612 #
 613 CREATE TABLE sys_category (
 614         uid int(11) NOT NULL auto_increment,
 615         pid int(11) DEFAULT '0' NOT NULL,
 616         tstamp int(11) DEFAULT '0' NOT NULL,
 617         crdate int(11) DEFAULT '0' NOT NULL,
 618         cruser_id int(11) DEFAULT '0' NOT NULL,
 619         deleted tinyint(4) DEFAULT '0' NOT NULL,
 620         hidden tinyint(4) DEFAULT '0' NOT NULL,
 621         starttime int(11) unsigned DEFAULT '0' NOT NULL,
 622         endtime int(11) unsigned DEFAULT '0' NOT NULL,
 623
 624         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 625         t3ver_id int(11) DEFAULT '0' NOT NULL,
 626         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 627         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 628         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 629         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 630         t3ver_count int(11) DEFAULT '0' NOT NULL,
 631         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 632         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 633         t3_origuid int(11) DEFAULT '0' NOT NULL,
 634
 635         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 636         l10n_parent int(11) DEFAULT '0' NOT NULL,
 637         l10n_diffsource mediumblob NOT NULL,
 638
 639         title tinytext NOT NULL,
 640         description text NOT NULL,
 641         parent int(11) DEFAULT '0' NOT NULL,
 642         items int(11) DEFAULT '0' NOT NULL,
 643
 644         PRIMARY KEY (uid),
 645         KEY parent (pid),
 646         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 647 );
 648
 649 #
 650 # Table structure for table 'sys_category_record_mm'
 651 #
 652 CREATE TABLE sys_category_record_mm (
 653         uid_local int(11) DEFAULT '0' NOT NULL,
 654         uid_foreign int(11) DEFAULT '0' NOT NULL,
 655         tablenames varchar(255) DEFAULT '' NOT NULL,
 656         sorting int(11) DEFAULT '0' NOT NULL,
 657         sorting_foreign int(11) DEFAULT '0' NOT NULL,
 658
 659         KEY uid_local_foreign (uid_local,uid_foreign),
 660         KEY uid_foreign_tablenames (uid_foreign,tablenames)
 661 );