Servus miteinander,
kann mir jemand sagen wo ich Informationen zu der
Typo3 Basic Datenbankstruktur bekomme.
d.h. welche Tabellen sind notwendig damit Typo3 läuft und wie sind die Beziehungen zwischen den Tabellen.
Gibt es da eine Doku über dieses Thema. Habe selber noch keins gefunden.
Gruß
Tofu
Das sind ein ppar zu viele weil da extensions dabei sind aber sonst:
#
# Table structure for table `be_groups`
#
CREATE TABLE be_groups (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
title varchar(20) NOT NULL default '',
non_exclude_fields blob NOT NULL,
db_mountpoints varchar(40) NOT NULL default '',
pagetypes_select tinyblob NOT NULL,
tables_select blob NOT NULL,
tables_modify blob NOT NULL,
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
groupMods tinyblob NOT NULL,
file_mountpoints varchar(40) NOT NULL default '',
hidden tinyint(3) unsigned NOT NULL default '0',
inc_access_lists tinyint(3) unsigned NOT NULL default '0',
description text NOT NULL,
lockToDomain varchar(50) NOT NULL default '',
deleted tinyint(3) unsigned NOT NULL default '0',
TSconfig blob NOT NULL,
subgroup tinyblob NOT NULL,
hide_in_lists tinyint(4) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `be_sessions`
#
CREATE TABLE be_sessions (
ses_id varchar(32) NOT NULL default '',
ses_name varchar(32) NOT NULL default '',
ses_userid int(11) unsigned NOT NULL default '0',
ses_tstamp int(11) unsigned NOT NULL default '0',
ses_data blob NOT NULL,
PRIMARY KEY (ses_id,ses_name)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `be_users`
#
CREATE TABLE be_users (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
username varchar(20) NOT NULL default '',
password varchar(40) NOT NULL default '',
admin tinyint(4) unsigned NOT NULL default '0',
usergroup tinyblob NOT NULL,
disable tinyint(4) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
lang char(2) NOT NULL default '',
email varchar(80) NOT NULL default '',
db_mountpoints varchar(40) NOT NULL default '',
options tinyint(4) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
realName varchar(80) NOT NULL default '',
userMods tinyblob NOT NULL,
uc blob NOT NULL,
file_mountpoints varchar(40) NOT NULL default '',
fileoper_perms tinyint(4) NOT NULL default '0',
lockToDomain varchar(50) NOT NULL default '',
deleted tinyint(3) unsigned NOT NULL default '0',
TSconfig blob NOT NULL,
lastlogin int(10) unsigned NOT NULL default '0',
createdByAction int(11) NOT NULL default '0',
usergroup_cached_list tinytext NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY username (username)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `cache_hash`
#
CREATE TABLE cache_hash (
hash varchar(32) NOT NULL default '',
content mediumblob NOT NULL,
tstamp int(11) unsigned NOT NULL default '0',
ident varchar(20) NOT NULL default '',
PRIMARY KEY (hash)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `cache_md5params`
#
CREATE TABLE cache_md5params (
md5hash varchar(20) NOT NULL default '',
tstamp int(11) NOT NULL default '0',
type tinyint(3) NOT NULL default '0',
params text NOT NULL,
PRIMARY KEY (md5hash)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `cache_pages`
#
CREATE TABLE cache_pages (
id int(11) unsigned NOT NULL auto_increment,
hash varchar(32) NOT NULL default '',
page_id int(11) unsigned NOT NULL default '0',
reg1 int(11) unsigned NOT NULL default '0',
HTML mediumblob NOT NULL,
tstamp int(11) unsigned NOT NULL default '0',
expires int(10) unsigned NOT NULL default '0',
cache_data mediumblob NOT NULL,
KEY page_id (page_id),
KEY sel (hash,page_id),
PRIMARY KEY (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `cache_pagesection`
#
CREATE TABLE cache_pagesection (
page_id int(11) unsigned NOT NULL default '0',
content blob NOT NULL,
tstamp int(11) unsigned NOT NULL default '0',
PRIMARY KEY (page_id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `cache_sys_dmail_stat`
#
CREATE TABLE cache_sys_dmail_stat (
mid int(11) NOT NULL default '0',
rid int(11) NOT NULL default '0',
rtbl char(1) NOT NULL default '',
pings tinyint(3) unsigned NOT NULL default '0',
plain_links tinyint(3) unsigned NOT NULL default '0',
html_links tinyint(3) unsigned NOT NULL default '0',
links tinyint(3) unsigned NOT NULL default '0',
recieved_html tinyint(3) unsigned NOT NULL default '0',
recieved_plain tinyint(3) unsigned NOT NULL default '0',
size int(11) NOT NULL default '0',
tstamp int(11) NOT NULL default '0',
pings_first int(11) NOT NULL default '0',
pings_last int(11) NOT NULL default '0',
html_links_first int(11) NOT NULL default '0',
html_links_last int(11) NOT NULL default '0',
plain_links_first int(11) NOT NULL default '0',
plain_links_last int(11) NOT NULL default '0',
links_first int(11) NOT NULL default '0',
links_last int(11) NOT NULL default '0',
response_first int(11) NOT NULL default '0',
response_last int(11) NOT NULL default '0',
response tinyint(3) unsigned NOT NULL default '0',
time_firstping int(11) NOT NULL default '0',
time_lastping int(11) NOT NULL default '0',
time_first_link int(11) NOT NULL default '0',
time_last_link int(11) NOT NULL default '0',
firstlink tinyint(4) NOT NULL default '0',
firstlink_time int(11) NOT NULL default '0',
secondlink tinyint(4) NOT NULL default '0',
secondlink_time int(11) NOT NULL default '0',
thirdlink tinyint(4) NOT NULL default '0',
thirdlink_time int(11) NOT NULL default '0',
KEY mid (mid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `cache_typo3temp_log`
#
CREATE TABLE cache_typo3temp_log (
md5hash varchar(32) NOT NULL default '',
tstamp int(11) NOT NULL default '0',
filename tinytext NOT NULL,
orig_filename tinytext NOT NULL,
PRIMARY KEY (md5hash)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `fe_groups`
#
CREATE TABLE fe_groups (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
title varchar(20) NOT NULL default '',
hidden tinyint(3) unsigned NOT NULL default '0',
lockToDomain varchar(50) NOT NULL default '',
deleted tinyint(3) unsigned NOT NULL default '0',
description text NOT NULL,
TSconfig blob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `fe_session_data`
#
CREATE TABLE fe_session_data (
hash varchar(32) NOT NULL default '',
content blob NOT NULL,
tstamp int(11) unsigned NOT NULL default '0',
PRIMARY KEY (hash)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `fe_sessions`
#
CREATE TABLE fe_sessions (
ses_id varchar(32) NOT NULL default '',
ses_name varchar(32) NOT NULL default '',
ses_userid int(11) unsigned NOT NULL default '0',
ses_tstamp int(11) unsigned NOT NULL default '0',
ses_data blob NOT NULL,
PRIMARY KEY (ses_id,ses_name)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `fe_users`
#
CREATE TABLE fe_users (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
username varchar(50) NOT NULL default '',
password varchar(40) NOT NULL default '',
usergroup tinyblob NOT NULL,
disable tinyint(4) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
name varchar(80) NOT NULL default '',
address tinytext NOT NULL,
telephone varchar(20) NOT NULL default '',
fax varchar(20) NOT NULL default '',
email varchar(80) NOT NULL default '',
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
lockToDomain varchar(50) NOT NULL default '',
deleted tinyint(3) unsigned NOT NULL default '0',
uc blob NOT NULL,
title varchar(40) NOT NULL default '',
zip varchar(10) NOT NULL default '',
city varchar(50) NOT NULL default '',
country varchar(40) NOT NULL default '',
www varchar(80) NOT NULL default '',
company varchar(80) NOT NULL default '',
image tinyblob NOT NULL,
TSconfig blob NOT NULL,
module_sys_dmail_category int(10) unsigned NOT NULL default '0',
module_sys_dmail_html tinyint(3) unsigned NOT NULL default '0',
fe_cruser_id int(10) unsigned NOT NULL default '0',
lastlogin int(10) unsigned NOT NULL default '0',
is_online int(10) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid),
KEY username (username),
KEY is_online (is_online),
KEY pid (pid,username)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `index_fulltext`
#
CREATE TABLE index_fulltext (
phash int(11) NOT NULL default '0',
fulltextdata mediumtext NOT NULL,
PRIMARY KEY (phash)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `index_grlist`
#
CREATE TABLE index_grlist (
phash int(11) NOT NULL default '0',
phash_x int(11) NOT NULL default '0',
hash_gr_list int(11) NOT NULL default '0',
gr_list tinytext NOT NULL,
uniqid int(11) NOT NULL auto_increment,
PRIMARY KEY (uniqid),
KEY joinkey (phash,hash_gr_list),
KEY phash_grouping (phash_x,hash_gr_list)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `index_phash`
#
CREATE TABLE index_phash (
phash int(11) NOT NULL default '0',
phash_grouping int(11) NOT NULL default '0',
cHashParams tinyblob NOT NULL,
data_filename tinytext NOT NULL,
data_page_id int(11) unsigned NOT NULL default '0',
data_page_reg1 int(11) unsigned NOT NULL default '0',
data_page_type tinyint(3) unsigned NOT NULL default '0',
data_page_mp tinytext NOT NULL,
gr_list tinytext NOT NULL,
item_type tinyint(4) NOT NULL default '0',
item_title tinytext NOT NULL,
item_description tinytext NOT NULL,
item_mtime int(11) NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
item_size int(11) NOT NULL default '0',
contentHash int(11) NOT NULL default '0',
crdate int(11) NOT NULL default '0',
parsetime int(11) NOT NULL default '0',
sys_language_uid int(11) NOT NULL default '0',
item_crdate int(11) NOT NULL default '0',
PRIMARY KEY (phash),
KEY phash_grouping (phash_grouping)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `index_rel`
#
CREATE TABLE index_rel (
phash int(11) NOT NULL default '0',
wid int(11) NOT NULL default '0',
count tinyint(3) unsigned NOT NULL default '0',
first tinyint(3) unsigned NOT NULL default '0',
freq smallint(5) unsigned NOT NULL default '0',
flags tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (phash,wid),
KEY wid (wid,phash)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `index_section`
#
CREATE TABLE index_section (
phash int(11) NOT NULL default '0',
phash_t3 int(11) NOT NULL default '0',
rl0 int(11) unsigned NOT NULL default '0',
rl1 int(11) unsigned NOT NULL default '0',
rl2 int(11) unsigned NOT NULL default '0',
page_id int(11) NOT NULL default '0',
uniqid int(11) NOT NULL auto_increment,
PRIMARY KEY (uniqid),
KEY joinkey (phash,rl0),
KEY page_id (page_id),
KEY rl0 (rl0,rl1,phash),
KEY rl0_2 (rl0,phash)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `index_stat_search`
#
CREATE TABLE index_stat_search (
uid int(11) NOT NULL auto_increment,
searchstring tinytext NOT NULL,
searchoptions blob NOT NULL,
tstamp int(11) NOT NULL default '0',
feuser_id int(11) unsigned NOT NULL default '0',
cookie varchar(10) NOT NULL default '',
IP tinytext NOT NULL,
hits int(11) NOT NULL default '0',
PRIMARY KEY (uid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `index_stat_word`
#
CREATE TABLE index_stat_word (
uid int(11) NOT NULL auto_increment,
word varchar(30) NOT NULL default '',
index_stat_search_id int(11) NOT NULL default '0',
tstamp int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY tstamp (tstamp,word)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `index_words`
#
CREATE TABLE index_words (
wid int(11) NOT NULL default '0',
baseword varchar(30) NOT NULL default '',
metaphone int(11) NOT NULL default '0',
PRIMARY KEY (wid),
KEY baseword (baseword,wid),
KEY metaphone (metaphone,wid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `pages`
#
CREATE TABLE pages (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
sorting int(11) unsigned NOT NULL default '0',
deleted tinyint(4) unsigned NOT NULL default '0',
perms_userid int(11) unsigned NOT NULL default '0',
perms_groupid int(11) unsigned NOT NULL default '0',
perms_user tinyint(4) unsigned NOT NULL default '0',
perms_group tinyint(4) unsigned NOT NULL default '0',
perms_everybody tinyint(4) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
alias varchar(20) NOT NULL default '',
doktype tinyint(3) unsigned NOT NULL default '0',
url tinytext NOT NULL,
hidden tinyint(4) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
urltype tinyint(4) unsigned NOT NULL default '0',
shortcut int(10) unsigned NOT NULL default '0',
no_cache int(10) unsigned NOT NULL default '0',
fe_group int(11) NOT NULL default '0',
subtitle tinytext NOT NULL,
layout tinyint(3) unsigned NOT NULL default '0',
target varchar(20) NOT NULL default '',
media blob NOT NULL,
lastUpdated int(10) unsigned NOT NULL default '0',
keywords text NOT NULL,
cache_timeout int(10) unsigned NOT NULL default '0',
newUntil int(10) unsigned NOT NULL default '0',
description text NOT NULL,
no_search tinyint(3) unsigned NOT NULL default '0',
SYS_LASTCHANGED int(10) unsigned NOT NULL default '0',
abstract text NOT NULL,
module varchar(10) NOT NULL default '',
extendToSubpages tinyint(3) unsigned NOT NULL default '0',
TSconfig blob NOT NULL,
author tinytext NOT NULL,
author_email varchar(80) NOT NULL default '',
treeStop tinyint(4) NOT NULL default '0',
nav_title tinytext NOT NULL,
storage_pid int(11) NOT NULL default '0',
is_siteroot tinyint(4) NOT NULL default '0',
php_tree_stop tinyint(4) NOT NULL default '0',
shortcut_mode int(10) unsigned NOT NULL default '0',
content_from_pid int(10) unsigned NOT NULL default '0',
mount_pid int(10) unsigned NOT NULL default '0',
tx_impexp_origuid int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid),
KEY alias (alias)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `pages_language_overlay`
#
CREATE TABLE pages_language_overlay (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
sys_language_uid int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
hidden tinyint(4) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
subtitle tinytext NOT NULL,
media tinyblob NOT NULL,
keywords text NOT NULL,
description text NOT NULL,
abstract text NOT NULL,
author tinytext NOT NULL,
author_email varchar(80) NOT NULL default '',
tx_impexp_origuid int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `static_template`
#
CREATE TABLE static_template (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
include_static tinyblob NOT NULL,
constants blob NOT NULL,
config blob NOT NULL,
description text NOT NULL,
editorcfg blob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `static_tsconfig_help`
#
CREATE TABLE static_tsconfig_help (
uid int(11) NOT NULL auto_increment,
guide int(11) NOT NULL default '0',
md5hash varchar(32) NOT NULL default '',
description text NOT NULL,
obj_string tinytext NOT NULL,
appdata blob NOT NULL,
title tinytext NOT NULL,
PRIMARY KEY (uid),
KEY guide (guide,md5hash)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_action`
#
CREATE TABLE sys_action (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
description text NOT NULL,
type tinyint(3) unsigned NOT NULL default '0',
t1_userprefix varchar(20) NOT NULL default '',
t1_copy_of_user int(11) NOT NULL default '0',
t1_allowed_groups tinyblob NOT NULL,
t2_data blob NOT NULL,
assign_to_groups int(11) NOT NULL default '0',
hidden tinyint(4) NOT NULL default '0',
t1_create_user_dir tinyint(4) NOT NULL default '0',
t3_listPid int(11) NOT NULL default '0',
t3_tables varchar(40) NOT NULL default '',
t4_recordsToEdit text NOT NULL,
PRIMARY KEY (uid),
KEY cruser_id (cruser_id),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_action_asgr_mm`
#
CREATE TABLE sys_action_asgr_mm (
uid_local int(11) unsigned NOT NULL default '0',
uid_foreign int(11) unsigned NOT NULL default '0',
sorting int(11) unsigned NOT NULL default '0',
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_be_shortcuts`
#
CREATE TABLE sys_be_shortcuts (
uid int(11) unsigned NOT NULL auto_increment,
userid int(11) unsigned NOT NULL default '0',
module_name tinytext NOT NULL,
url text NOT NULL,
description tinytext NOT NULL,
sorting int(11) NOT NULL default '0',
sc_group tinyint(4) NOT NULL default '0',
PRIMARY KEY (uid),
KEY event (userid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_dmail`
#
CREATE TABLE sys_dmail (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
type tinyint(4) unsigned NOT NULL default '0',
page int(11) unsigned NOT NULL default '0',
attachment tinyblob NOT NULL,
subject varchar(120) NOT NULL default '',
from_email varchar(80) NOT NULL default '',
from_name varchar(80) NOT NULL default '',
replyto_email varchar(80) NOT NULL default '',
replyto_name varchar(80) NOT NULL default '',
organisation varchar(80) NOT NULL default '',
priority tinyint(4) unsigned NOT NULL default '0',
sendOptions tinyint(4) unsigned NOT NULL default '0',
HTMLParams varchar(80) NOT NULL default '',
plainParams varchar(80) NOT NULL default '',
issent tinyint(4) unsigned NOT NULL default '0',
renderedsize int(11) unsigned NOT NULL default '0',
mailContent mediumblob NOT NULL,
scheduled int(10) unsigned NOT NULL default '0',
query_info mediumblob NOT NULL,
scheduled_begin int(10) unsigned NOT NULL default '0',
scheduled_end int(10) unsigned NOT NULL default '0',
return_path varchar(80) NOT NULL default '',
long_link_rdct_url varchar(80) NOT NULL default '',
long_link_mode tinyint(4) unsigned NOT NULL default '0',
PRIMARY KEY (uid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_dmail_group`
#
CREATE TABLE sys_dmail_group (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
deleted tinyint(4) unsigned NOT NULL default '0',
type tinyint(4) unsigned NOT NULL default '0',
title tinytext NOT NULL,
description text NOT NULL,
query blob NOT NULL,
static_list int(11) NOT NULL default '0',
list mediumblob NOT NULL,
csv tinyint(4) NOT NULL default '0',
pages tinyblob NOT NULL,
whichtables tinyint(4) NOT NULL default '0',
recursive tinyint(4) NOT NULL default '0',
mail_groups tinyblob NOT NULL,
select_categories int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_dmail_group_mm`
#
CREATE TABLE sys_dmail_group_mm (
uid_local int(11) unsigned NOT NULL default '0',
uid_foreign int(11) unsigned NOT NULL default '0',
tablenames varchar(30) NOT NULL default '',
sorting int(11) unsigned NOT NULL default '0',
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_dmail_maillog`
#
CREATE TABLE sys_dmail_maillog (
uid int(11) unsigned NOT NULL auto_increment,
mid int(11) unsigned NOT NULL default '0',
rid int(11) unsigned NOT NULL default '0',
rtbl char(1) NOT NULL default '',
tstamp int(11) unsigned NOT NULL default '0',
url tinyblob NOT NULL,
size int(11) unsigned NOT NULL default '0',
parsetime int(11) unsigned NOT NULL default '0',
response_type tinyint(4) NOT NULL default '0',
html_sent tinyint(4) NOT NULL default '0',
url_id tinyint(4) NOT NULL default '0',
return_content mediumblob NOT NULL,
return_code smallint(6) NOT NULL default '0',
PRIMARY KEY (uid),
KEY rid (rid,rtbl,mid,response_type,uid),
KEY mid (mid,response_type,rtbl,rid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_domain`
#
CREATE TABLE sys_domain (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
domainName varchar(80) NOT NULL default '',
redirectTo varchar(120) NOT NULL default '',
sorting int(10) unsigned NOT NULL default '0',
prepend_params int(10) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_filemounts`
#
CREATE TABLE sys_filemounts (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
title varchar(30) NOT NULL default '',
path varchar(120) NOT NULL default '',
base tinyint(4) unsigned NOT NULL default '0',
hidden tinyint(3) unsigned NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_history`
#
CREATE TABLE sys_history (
uid int(11) unsigned NOT NULL auto_increment,
sys_log_uid int(11) NOT NULL default '0',
history_data mediumblob NOT NULL,
fieldlist blob NOT NULL,
recuid int(11) NOT NULL default '0',
tablename varchar(40) NOT NULL default '',
tstamp int(11) NOT NULL default '0',
history_files mediumblob NOT NULL,
snapshot tinyint(4) NOT NULL default '0',
PRIMARY KEY (uid),
KEY recordident (tablename,recuid),
KEY sys_log_uid (sys_log_uid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_language`
#
CREATE TABLE sys_language (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
title varchar(80) NOT NULL default '',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_lockedrecords`
#
CREATE TABLE sys_lockedrecords (
uid int(11) unsigned NOT NULL auto_increment,
userid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
record_table varchar(40) NOT NULL default '',
record_uid int(11) NOT NULL default '0',
record_pid int(11) NOT NULL default '0',
username varchar(20) NOT NULL default '',
PRIMARY KEY (uid),
KEY event (userid,tstamp)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_log`
#
CREATE TABLE sys_log (
uid int(11) unsigned NOT NULL auto_increment,
userid int(11) unsigned NOT NULL default '0',
action tinyint(4) unsigned NOT NULL default '0',
recuid int(11) unsigned NOT NULL default '0',
tablename varchar(40) NOT NULL default '',
recpid int(11) NOT NULL default '0',
error tinyint(4) unsigned NOT NULL default '0',
details tinytext NOT NULL,
tstamp int(11) unsigned NOT NULL default '0',
type tinyint(3) unsigned NOT NULL default '0',
details_nr tinyint(3) unsigned NOT NULL default '0',
IP varchar(15) NOT NULL default '',
log_data tinyblob NOT NULL,
event_pid int(11) NOT NULL default '-1',
NEWid varchar(20) NOT NULL default '',
PRIMARY KEY (uid),
KEY event (userid,event_pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_note`
#
CREATE TABLE sys_note (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser int(11) unsigned NOT NULL default '0',
author varchar(80) NOT NULL default '',
email varchar(80) NOT NULL default '',
subject tinytext NOT NULL,
message text NOT NULL,
personal tinyint(3) unsigned NOT NULL default '0',
category tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_notepad`
#
CREATE TABLE sys_notepad (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
note text NOT NULL,
crdate int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY cruser_id (cruser_id),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_products_orders`
#
CREATE TABLE sys_products_orders (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
deleted tinyint(4) unsigned NOT NULL default '0',
note text NOT NULL,
name varchar(80) NOT NULL default '',
telephone varchar(20) NOT NULL default '',
email varchar(80) NOT NULL default '',
payment varchar(80) NOT NULL default '',
shipping varchar(80) NOT NULL default '',
amount varchar(20) NOT NULL default '',
email_notify tinyint(4) unsigned NOT NULL default '0',
tracking_code varchar(20) NOT NULL default '',
status tinyint(4) unsigned NOT NULL default '0',
status_log blob NOT NULL,
orderData mediumblob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY tracking (tracking_code),
KEY status (status),
KEY uid (uid,amount)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_products_orders_mm_tt_products`
#
CREATE TABLE sys_products_orders_mm_tt_products (
sys_products_orders_uid int(11) unsigned NOT NULL default '0',
sys_products_orders_qty int(11) unsigned NOT NULL default '0',
tt_products_uid int(11) unsigned NOT NULL default '0',
KEY tt_products_uid (tt_products_uid),
KEY sys_products_orders_uid (sys_products_orders_uid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_stat`
#
CREATE TABLE sys_stat (
uid int(11) unsigned NOT NULL auto_increment,
page_id int(11) unsigned NOT NULL default '0',
jumpurl tinytext NOT NULL,
feuser_id int(11) unsigned NOT NULL default '0',
cookie varchar(10) NOT NULL default '',
IP tinytext NOT NULL,
host tinytext NOT NULL,
referer tinytext NOT NULL,
browser tinytext NOT NULL,
tstamp int(11) unsigned NOT NULL default '0',
page_type tinyint(4) unsigned NOT NULL default '0',
parsetime mediumint(11) unsigned NOT NULL default '0',
flags tinyint(3) unsigned NOT NULL default '0',
rl0 int(11) NOT NULL default '0',
rl1 int(11) NOT NULL default '0',
sureCookie int(11) NOT NULL default '0',
client_browser varchar(5) NOT NULL default '',
client_version double(16,4) NOT NULL default '0.0000',
client_os varchar(4) NOT NULL default '',
PRIMARY KEY (uid),
KEY page_id (page_id,tstamp,sureCookie),
KEY rl0 (rl0,tstamp,sureCookie),
KEY rl1 (rl1,tstamp,sureCookie)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_staticfile_edit`
#
CREATE TABLE sys_staticfile_edit (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser int(11) unsigned NOT NULL default '0',
edit_content mediumtext NOT NULL,
edit_file tinyblob NOT NULL,
edit_subpart_marker varchar(40) NOT NULL default '',
always_reload tinyint(4) NOT NULL default '0',
update_status tinytext NOT NULL,
rte_enabled tinyint(4) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_tabledescr`
#
CREATE TABLE sys_tabledescr (
tablename varchar(40) NOT NULL default '',
fieldname varchar(40) NOT NULL default '',
description tinytext NOT NULL,
details text NOT NULL,
syntax text NOT NULL,
image tinytext NOT NULL,
image_descr tinytext NOT NULL,
seeAlso text NOT NULL,
serial int(11) NOT NULL default '0',
tstamp int(11) NOT NULL default '0',
PRIMARY KEY (tablename,fieldname)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_tabledescr_dk`
#
CREATE TABLE sys_tabledescr_dk (
tablename varchar(40) NOT NULL default '',
fieldname varchar(40) NOT NULL default '',
description_dk tinytext NOT NULL,
details_dk text NOT NULL,
syntax_dk text NOT NULL,
image_descr_dk tinytext NOT NULL,
serial_dk int(11) NOT NULL default '0',
tstamp_dk int(11) NOT NULL default '0',
PRIMARY KEY (tablename,fieldname)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_tabledescr_local`
#
CREATE TABLE sys_tabledescr_local (
tablename varchar(40) NOT NULL default '',
fieldname varchar(40) NOT NULL default '',
description tinytext NOT NULL,
details text NOT NULL,
syntax text NOT NULL,
image_descr tinytext NOT NULL,
serial int(11) NOT NULL default '0',
tstamp int(11) NOT NULL default '0',
image tinytext NOT NULL,
seeAlso text NOT NULL,
mode tinyint(4) NOT NULL default '0',
PRIMARY KEY (tablename,fieldname)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_template`
#
CREATE TABLE sys_template (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
sorting int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
sitetitle tinytext NOT NULL,
hidden tinyint(4) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
root tinyint(4) unsigned NOT NULL default '0',
clear tinyint(4) unsigned NOT NULL default '0',
include_static tinyblob NOT NULL,
constants blob NOT NULL,
config blob NOT NULL,
resources blob NOT NULL,
nextLevel varchar(5) NOT NULL default '',
description text NOT NULL,
basedOn tinyblob NOT NULL,
deleted tinyint(3) unsigned NOT NULL default '0',
includeStaticAfterBasedOn tinyint(4) unsigned NOT NULL default '0',
static_file_mode tinyint(4) unsigned NOT NULL default '0',
editorcfg blob NOT NULL,
include_static_file blob NOT NULL,
tx_impexp_origuid int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_todos`
#
CREATE TABLE sys_todos (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
deleted tinyint(4) unsigned NOT NULL default '0',
type varchar(11) NOT NULL default '',
deadline int(11) unsigned NOT NULL default '0',
finished tinyint(3) unsigned NOT NULL default '0',
title tinytext NOT NULL,
description text NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY cruser_id (cruser_id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_todos_users_mm`
#
CREATE TABLE sys_todos_users_mm (
uid_local int(11) unsigned NOT NULL default '0',
uid_foreign int(11) NOT NULL default '0',
status tinyint(4) NOT NULL default '0',
status_log mediumblob NOT NULL,
is_read tinyint(4) NOT NULL default '0',
tstamp int(11) NOT NULL default '0',
mm_uid int(11) NOT NULL auto_increment,
deleted tinyint(4) NOT NULL default '0',
rec_reference varchar(50) NOT NULL default '',
finalized tinyint(4) NOT NULL default '0',
finished_instance tinyint(4) NOT NULL default '0',
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign),
PRIMARY KEY (mm_uid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_workflows`
#
CREATE TABLE sys_workflows (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
description text NOT NULL,
tablename varchar(60) NOT NULL default '',
working_area int(11) NOT NULL default '0',
allowed_groups int(11) NOT NULL default '0',
review_users int(11) NOT NULL default '0',
final_target int(11) NOT NULL default '0',
final_unhide tinyint(4) NOT NULL default '0',
final_perms_userid int(11) NOT NULL default '0',
final_perms_groupid int(11) NOT NULL default '0',
final_perms_user tinyint(11) NOT NULL default '0',
final_perms_group tinyint(11) NOT NULL default '0',
final_perms_everybody tinyint(11) NOT NULL default '0',
hidden tinyint(4) NOT NULL default '0',
final_set_perms tinyint(4) NOT NULL default '0',
target_groups tinyblob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_workflows_algr_mm`
#
CREATE TABLE sys_workflows_algr_mm (
uid_local int(11) unsigned NOT NULL default '0',
uid_foreign int(11) unsigned NOT NULL default '0',
sorting int(11) unsigned NOT NULL default '0',
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `sys_workflows_rvuser_mm`
#
CREATE TABLE sys_workflows_rvuser_mm (
uid_local int(11) unsigned NOT NULL default '0',
uid_foreign int(11) unsigned NOT NULL default '0',
sorting int(11) unsigned NOT NULL default '0',
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_address`
#
CREATE TABLE tt_address (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
name tinytext NOT NULL,
title varchar(40) NOT NULL default '',
email varchar(80) NOT NULL default '',
phone varchar(30) NOT NULL default '',
mobile varchar(30) NOT NULL default '',
www varchar(80) NOT NULL default '',
address tinytext NOT NULL,
company varchar(80) NOT NULL default '',
city varchar(80) NOT NULL default '',
zip varchar(20) NOT NULL default '',
country varchar(30) NOT NULL default '',
image tinyblob NOT NULL,
fax varchar(30) NOT NULL default '',
deleted tinyint(3) unsigned NOT NULL default '0',
description text NOT NULL,
module_sys_dmail_category int(10) unsigned NOT NULL default '0',
module_sys_dmail_html tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid),
KEY pid (pid,email)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_board`
#
CREATE TABLE tt_board (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
author varchar(80) NOT NULL default '',
email varchar(80) NOT NULL default '',
subject tinytext NOT NULL,
message text NOT NULL,
hidden tinyint(4) unsigned NOT NULL default '0',
parent int(10) unsigned NOT NULL default '0',
notify_me tinyint(3) unsigned NOT NULL default '0',
doublePostCheck int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid),
KEY parent_select (pid,parent)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_calender`
#
CREATE TABLE tt_calender (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
type tinyint(4) unsigned NOT NULL default '0',
title tinytext NOT NULL,
note text NOT NULL,
date int(11) unsigned NOT NULL default '0',
datetext varchar(80) NOT NULL default '',
week tinyint(4) unsigned NOT NULL default '0',
complete tinyint(4) unsigned NOT NULL default '0',
workgroup varchar(80) NOT NULL default '',
responsible varchar(20) NOT NULL default '',
category int(11) unsigned NOT NULL default '0',
priority tinyint(4) unsigned NOT NULL default '0',
link tinytext NOT NULL,
deleted tinyint(3) unsigned NOT NULL default '0',
time int(10) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_calender_cat`
#
CREATE TABLE tt_calender_cat (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
deleted tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_content`
#
CREATE TABLE tt_content (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
sorting int(11) unsigned NOT NULL default '0',
CType varchar(30) NOT NULL default '',
header tinytext NOT NULL,
header_position varchar(6) NOT NULL default '',
bodytext mediumtext NOT NULL,
image blob NOT NULL,
imagewidth mediumint(11) unsigned NOT NULL default '0',
imageorient tinyint(4) unsigned NOT NULL default '0',
imagecaption text NOT NULL,
imagecols tinyint(4) unsigned NOT NULL default '0',
imageborder tinyint(4) unsigned NOT NULL default '0',
media blob NOT NULL,
layout tinyint(3) unsigned NOT NULL default '0',
deleted tinyint(4) unsigned NOT NULL default '0',
cols tinyint(3) unsigned NOT NULL default '0',
records blob NOT NULL,
pages tinyblob NOT NULL,
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
colPos tinyint(3) unsigned NOT NULL default '0',
subheader tinytext NOT NULL,
spaceBefore tinyint(4) unsigned NOT NULL default '0',
spaceAfter tinyint(4) unsigned NOT NULL default '0',
fe_group int(11) NOT NULL default '0',
header_link tinytext NOT NULL,
imagecaption_position varchar(6) NOT NULL default '',
image_link tinytext NOT NULL,
image_zoom tinyint(3) unsigned NOT NULL default '0',
image_noRows tinyint(3) unsigned NOT NULL default '0',
image_effects tinyint(3) unsigned NOT NULL default '0',
image_compression tinyint(3) unsigned NOT NULL default '0',
header_layout varchar(30) NOT NULL default '0',
text_align varchar(6) NOT NULL default '',
text_face tinyint(3) unsigned NOT NULL default '0',
text_size tinyint(3) unsigned NOT NULL default '0',
text_color tinyint(3) unsigned NOT NULL default '0',
text_properties tinyint(3) unsigned NOT NULL default '0',
menu_type varchar(30) NOT NULL default '0',
list_type varchar(30) NOT NULL default '0',
table_border tinyint(3) unsigned NOT NULL default '0',
table_cellspacing tinyint(3) unsigned NOT NULL default '0',
table_cellpadding tinyint(3) unsigned NOT NULL default '0',
table_bgColor tinyint(3) unsigned NOT NULL default '0',
select_key varchar(80) NOT NULL default '',
sectionIndex tinyint(3) unsigned NOT NULL default '0',
linkToTop tinyint(3) unsigned NOT NULL default '0',
filelink_size tinyint(3) unsigned NOT NULL default '0',
section_frame tinyint(3) unsigned NOT NULL default '0',
date int(10) unsigned NOT NULL default '0',
splash_layout varchar(30) NOT NULL default '0',
multimedia tinyblob NOT NULL,
image_frames tinyint(3) unsigned NOT NULL default '0',
recursive tinyint(3) unsigned NOT NULL default '0',
imageheight mediumint(8-) unsigned NOT NULL default '0',
module_sys_dmail_category int(10) unsigned NOT NULL default '0',
rte_enabled tinyint(4) NOT NULL default '0',
sys_language_uid int(11) NOT NULL default '0',
tx_mininews_frontpage_list int(11) unsigned NOT NULL default '0',
tx_impexp_origuid int(11) NOT NULL default '0',
tx_thexttable_table_source text NOT NULL,
tx_thexttable_table_cellpadding tinytext NOT NULL,
tx_thexttable_table_cellspacing tinytext NOT NULL,
tx_thexttable_table_border tinytext NOT NULL,
tx_thexttable_table_align varchar(6) NOT NULL default '',
tx_thexttable_table_class varchar(255) NOT NULL default '',
tx_thexttable_table_style text NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_guest`
#
CREATE TABLE tt_guest (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
note text NOT NULL,
cr_name varchar(80) NOT NULL default '',
cr_email varchar(80) NOT NULL default '',
hidden tinyint(4) unsigned NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
www tinytext NOT NULL,
doublePostCheck int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_news`
#
CREATE TABLE tt_news (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
fe_group int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
datetime int(11) unsigned NOT NULL default '0',
image tinyblob NOT NULL,
imagecaption text NOT NULL,
related int(11) NOT NULL default '0',
short text NOT NULL,
bodytext mediumtext NOT NULL,
author tinytext NOT NULL,
author_email tinytext NOT NULL,
category int(11) NOT NULL default '0',
links text NOT NULL,
type tinyint(4) NOT NULL default '0',
page int(11) NOT NULL default '0',
keywords text NOT NULL,
archivedate int(11) NOT NULL default '0',
ext_url tinytext NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_news_cat`
#
CREATE TABLE tt_news_cat (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
deleted tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_news_related_mm`
#
CREATE TABLE tt_news_related_mm (
uid_local int(11) unsigned NOT NULL default '0',
uid_foreign int(11) unsigned NOT NULL default '0',
sorting int(11) unsigned NOT NULL default '0',
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_poll`
#
CREATE TABLE tt_poll (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
question text NOT NULL,
answers text NOT NULL,
votes int(11) NOT NULL default '0',
recordlink tinyblob NOT NULL,
hidden tinyint(4) unsigned NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_products`
#
CREATE TABLE tt_products (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
note text NOT NULL,
price varchar(20) NOT NULL default '',
price2 varchar(20) NOT NULL default '',
image tinyblob NOT NULL,
www varchar(80) NOT NULL default '',
itemnumber varchar(40) NOT NULL default '',
category int(10) unsigned NOT NULL default '0',
inStock int(11) NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
ordered int(10) unsigned NOT NULL default '0',
fe_group int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_products_cat`
#
CREATE TABLE tt_products_cat (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
deleted tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tt_rating`
#
CREATE TABLE tt_rating (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
title tinytext NOT NULL,
description text NOT NULL,
rating varchar(20) NOT NULL default '0',
votes int(11) NOT NULL default '0',
ratingstat tinytext NOT NULL,
hidden tinyint(4) unsigned NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
recordlink tinyblob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tx_extrepwizard_static_presets`
#
CREATE TABLE tx_extrepwizard_static_presets (
fieldname varchar(40) NOT NULL default '',
title tinytext NOT NULL,
type varchar(40) NOT NULL default '',
appdata blob NOT NULL,
tstamp int(11) NOT NULL default '0',
PRIMARY KEY (fieldname)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `tx_mininews_news`
#
CREATE TABLE tx_mininews_news (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
deleted tinyint(4) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
fe_group int(11) NOT NULL default '0',
datetime int(11) NOT NULL default '0',
title tinytext NOT NULL,
teaser text NOT NULL,
full_text text NOT NULL,
front_page tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `user_photomarathon`
#
CREATE TABLE user_photomarathon (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
fe_cruser_id int(11) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
title tinytext NOT NULL,
description text NOT NULL,
images tinyblob NOT NULL,
photodate int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
MFG
Dander
Habe in dem offiziellen Typo3 Buch von Altmann,Fritz,Hinderik eine Abbildung gefunden, wie die Tabellen miteinander verknüpft sind!
na dann
ich dachte schon es kommt nie eine antwort
Tofu schriebHabe in dem offiziellen Typo3 Buch von Altmann,Fritz,Hinderik eine Abbildung gefunden, wie die Tabellen miteinander verknüpft sind!
Hast Du die Möglichkeit diese Seiten mal einzuscannen und hier zu posten?