|
# MySQL dump 6.4
|
|
#
|
|
# Host: localhost Database: t3_testsite
|
|
#--------------------------------------------------------
|
|
# Server version 3.22.27
|
|
#
|
|
# TYPO3 CVS ID: $Id: tables.sql 1793 2006-11-16 21:18:38Z masi $
|
|
|
|
#
|
|
# Table structure for table 'be_groups'
|
|
#
|
|
CREATE TABLE be_groups (
|
|
uid int(11) unsigned NOT NULL auto_increment,
|
|
pid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
title varchar(20) DEFAULT '' NOT NULL,
|
|
non_exclude_fields blob,
|
|
explicit_allowdeny blob,
|
|
allowed_languages tinyblob,
|
|
custom_options blob,
|
|
db_mountpoints varchar(40) DEFAULT '' NOT NULL,
|
|
pagetypes_select tinyblob,
|
|
tables_select blob,
|
|
tables_modify blob,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
|
|
groupMods tinyblob,
|
|
file_mountpoints varchar(40) DEFAULT '' NOT NULL,
|
|
hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
|
|
inc_access_lists tinyint(3) unsigned DEFAULT '0' NOT NULL,
|
|
description text,
|
|
lockToDomain varchar(50) DEFAULT '' NOT NULL,
|
|
deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
|
|
TSconfig blob,
|
|
subgroup tinyblob,
|
|
hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
|
|
workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'be_sessions'
|
|
#
|
|
CREATE TABLE be_sessions (
|
|
ses_id varchar(32) DEFAULT '' NOT NULL,
|
|
ses_name varchar(32) DEFAULT '' NOT NULL,
|
|
ses_iplock varchar(39) DEFAULT '' NOT NULL,
|
|
ses_hashlock int(11) DEFAULT '0' NOT NULL,
|
|
ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
ses_data mediumblob,
|
|
ses_backuserid int(11) NOT NULL default '0',
|
|
PRIMARY KEY (ses_id,ses_name)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'be_users'
|
|
#
|
|
CREATE TABLE be_users (
|
|
uid int(11) unsigned NOT NULL auto_increment,
|
|
pid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
username varchar(20) DEFAULT '' NOT NULL,
|
|
password varchar(40) DEFAULT '' NOT NULL,
|
|
admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
usergroup tinyblob,
|
|
disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
starttime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
endtime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
lang varchar(2) DEFAULT '' NOT NULL,
|
|
email varchar(80) DEFAULT '' NOT NULL,
|
|
db_mountpoints varchar(40) DEFAULT '' NOT NULL,
|
|
options tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
|
|
realName varchar(80) DEFAULT '' NOT NULL,
|
|
userMods tinyblob,
|
|
allowed_languages tinyblob,
|
|
uc blob,
|
|
file_mountpoints varchar(40) DEFAULT '' NOT NULL,
|
|
fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
|
|
workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
|
|
lockToDomain varchar(50) DEFAULT '' NOT NULL,
|
|
disableIPlock tinyint(3) unsigned DEFAULT '0' NOT NULL,
|
|
deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
|
|
TSconfig blob,
|
|
lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
|
|
createdByAction int(11) DEFAULT '0' NOT NULL,
|
|
usergroup_cached_list tinytext,
|
|
workspace_id int(11) DEFAULT '0' NOT NULL,
|
|
workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid),
|
|
KEY username (username)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'cache_hash'
|
|
#
|
|
CREATE TABLE cache_hash (
|
|
hash varchar(32) DEFAULT '' NOT NULL,
|
|
content mediumblob,
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
ident varchar(20) DEFAULT '' NOT NULL,
|
|
PRIMARY KEY (hash)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'cache_imagesizes'
|
|
#
|
|
CREATE TABLE cache_imagesizes (
|
|
md5hash varchar(32) DEFAULT '' NOT NULL,
|
|
md5filename varchar(32) DEFAULT '' NOT NULL,
|
|
tstamp int(11) DEFAULT '0' NOT NULL,
|
|
filename tinytext,
|
|
imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
|
|
imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (md5filename)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'pages'
|
|
#
|
|
CREATE TABLE pages (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
t3ver_oid int(11) DEFAULT '0' NOT NULL,
|
|
t3ver_id int(11) DEFAULT '0' NOT NULL,
|
|
t3ver_wsid int(11) DEFAULT '0' NOT NULL,
|
|
t3ver_label varchar(30) DEFAULT '' NOT NULL,
|
|
t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
|
|
t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
|
|
t3ver_count int(11) DEFAULT '0' NOT NULL,
|
|
t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
|
|
t3ver_swapmode tinyint(4) DEFAULT '0' NOT NULL,
|
|
t3_origuid int(11) DEFAULT '0' NOT NULL,
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
sorting int(11) unsigned DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
|
|
title tinytext,
|
|
doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
|
|
TSconfig blob,
|
|
storage_pid int(11) DEFAULT '0' NOT NULL,
|
|
is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
|
|
php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
|
|
tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (uid),
|
|
KEY t3ver_oid (t3ver_oid,t3ver_wsid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'sys_be_shortcuts'
|
|
#
|
|
CREATE TABLE sys_be_shortcuts (
|
|
uid int(11) unsigned NOT NULL auto_increment,
|
|
userid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
module_name tinytext,
|
|
url text,
|
|
description tinytext,
|
|
sorting int(11) DEFAULT '0' NOT NULL,
|
|
sc_group tinyint(4) DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (uid),
|
|
KEY event (userid)
|
|
);
|
|
|
|
|
|
#
|
|
# Table structure for table 'sys_preview'
|
|
#
|
|
CREATE TABLE sys_preview (
|
|
keyword varchar(32) DEFAULT '' NOT NULL,
|
|
tstamp int(11) DEFAULT '0' NOT NULL,
|
|
endtime int(11) DEFAULT '0' NOT NULL,
|
|
config text,
|
|
PRIMARY KEY (keyword)
|
|
);
|
|
|
|
|
|
#
|
|
# Table structure for table 'sys_filemounts'
|
|
#
|
|
CREATE TABLE sys_filemounts (
|
|
uid int(11) unsigned NOT NULL auto_increment,
|
|
pid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
title varchar(30) DEFAULT '' NOT NULL,
|
|
path varchar(120) DEFAULT '' NOT NULL,
|
|
base tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
|
|
deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'sys_workspace'
|
|
#
|
|
CREATE TABLE sys_workspace (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
tstamp int(11) DEFAULT '0' NOT NULL,
|
|
deleted tinyint(3) DEFAULT '0' NOT NULL,
|
|
title varchar(30) DEFAULT '' NOT NULL,
|
|
description tinytext,
|
|
adminusers tinytext,
|
|
members text,
|
|
reviewers text,
|
|
db_mountpoints tinytext,
|
|
file_mountpoints tinytext,
|
|
publish_time int(11) DEFAULT '0' NOT NULL,
|
|
unpublish_time int(11) DEFAULT '0' NOT NULL,
|
|
freeze tinyint(3) DEFAULT '0' NOT NULL,
|
|
live_edit tinyint(3) DEFAULT '0' NOT NULL,
|
|
vtypes tinyint(3) DEFAULT '0' NOT NULL,
|
|
disable_autocreate tinyint(3) DEFAULT '0' NOT NULL,
|
|
swap_modes tinyint(3) DEFAULT '0' NOT NULL,
|
|
publish_access tinyint(3) DEFAULT '0' NOT NULL,
|
|
stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'sys_history'
|
|
#
|
|
CREATE TABLE sys_history (
|
|
uid int(11) unsigned NOT NULL auto_increment,
|
|
sys_log_uid int(11) DEFAULT '0' NOT NULL,
|
|
history_data mediumblob,
|
|
fieldlist blob,
|
|
recuid int(11) DEFAULT '0' NOT NULL,
|
|
tablename varchar(40) DEFAULT '' NOT NULL,
|
|
tstamp int(11) DEFAULT '0' NOT NULL,
|
|
history_files mediumblob,
|
|
snapshot tinyint(4) DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (uid),
|
|
KEY recordident (tablename,recuid),
|
|
KEY sys_log_uid (sys_log_uid)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'sys_lockedrecords'
|
|
#
|
|
CREATE TABLE sys_lockedrecords (
|
|
uid int(11) unsigned NOT NULL auto_increment,
|
|
userid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
record_table varchar(40) DEFAULT '' NOT NULL,
|
|
record_uid int(11) DEFAULT '0' NOT NULL,
|
|
record_pid int(11) DEFAULT '0' NOT NULL,
|
|
username varchar(20) DEFAULT '' NOT NULL,
|
|
PRIMARY KEY (uid),
|
|
KEY event (userid,tstamp)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'sys_refindex'
|
|
#
|
|
CREATE TABLE sys_refindex (
|
|
hash varchar(32) DEFAULT '' NOT NULL,
|
|
tablename varchar(40) DEFAULT '' NOT NULL,
|
|
recuid int(11) DEFAULT '0' NOT NULL,
|
|
field varchar(40) DEFAULT '' NOT NULL,
|
|
flexpointer tinytext,
|
|
softref_key varchar(30) DEFAULT '' NOT NULL,
|
|
softref_id varchar(40) DEFAULT '' NOT NULL,
|
|
sorting int(11) DEFAULT '0' NOT NULL,
|
|
deleted int(11) DEFAULT '0' NOT NULL,
|
|
ref_table varchar(40) DEFAULT '' NOT NULL,
|
|
ref_uid int(11) DEFAULT '0' NOT NULL,
|
|
ref_string varchar(200) DEFAULT '' NOT NULL,
|
|
|
|
PRIMARY KEY (hash),
|
|
KEY lookup_rec (tablename,recuid),
|
|
KEY lookup_uid (ref_table,ref_uid),
|
|
KEY lookup_string (ref_table,ref_string)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'sys_log'
|
|
#
|
|
CREATE TABLE sys_log (
|
|
uid int(11) unsigned NOT NULL auto_increment,
|
|
userid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
action tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
recuid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
tablename varchar(40) DEFAULT '' NOT NULL,
|
|
recpid int(11) DEFAULT '0' NOT NULL,
|
|
error tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
details tinytext,
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
type tinyint(3) unsigned DEFAULT '0' NOT NULL,
|
|
details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
|
|
IP varchar(39) DEFAULT '' NOT NULL,
|
|
log_data tinyblob,
|
|
event_pid int(11) DEFAULT '-1' NOT NULL,
|
|
workspace int(11) DEFAULT '0' NOT NULL,
|
|
NEWid varchar(20) DEFAULT '' NOT NULL,
|
|
PRIMARY KEY (uid),
|
|
KEY event (userid,event_pid)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'sys_language'
|
|
#
|
|
CREATE TABLE sys_language (
|
|
uid int(11) unsigned NOT NULL auto_increment,
|
|
pid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
title varchar(80) DEFAULT '' NOT NULL,
|
|
flag varchar(20) DEFAULT '' NOT NULL,
|
|
static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|