[TASK] Document variables assigned to mail templates
[Packages/TYPO3.CMS.git] / typo3 / sysext / frontend / ext_tables.sql
1 #
2 # Table structure for table 'cache_treelist'
3 #
4 CREATE TABLE cache_treelist (
5 md5hash char(32) DEFAULT '' NOT NULL,
6 pid int(11) DEFAULT '0' NOT NULL,
7 treelist mediumtext,
8 tstamp int(11) DEFAULT '0' NOT NULL,
9 expires int(11) unsigned DEFAULT '0' NOT NULL,
10
11 PRIMARY KEY (md5hash)
12 ) ENGINE=InnoDB;
13
14 #
15 # Table structure for table 'fe_groups'
16 #
17 CREATE TABLE fe_groups (
18 title varchar(50) DEFAULT '' NOT NULL,
19 lockToDomain varchar(50) DEFAULT '' NOT NULL,
20 subgroup tinytext,
21 TSconfig text
22 );
23
24
25 #
26 # Table structure for table 'fe_sessions'
27 #
28 CREATE TABLE fe_sessions (
29 ses_id varchar(32) DEFAULT '' NOT NULL,
30 ses_iplock varchar(39) DEFAULT '' NOT NULL,
31 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
32 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
33 ses_data mediumblob,
34 ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
35 ses_anonymous tinyint(1) unsigned DEFAULT '0' NOT NULL,
36
37 PRIMARY KEY (ses_id),
38 KEY ses_tstamp (ses_tstamp)
39 ) ENGINE=InnoDB;
40
41 #
42 # Table structure for table 'fe_users'
43 #
44 CREATE TABLE fe_users (
45 username varchar(255) DEFAULT '' NOT NULL,
46 password varchar(100) DEFAULT '' NOT NULL,
47 usergroup tinytext,
48 name varchar(160) DEFAULT '' NOT NULL,
49 first_name varchar(50) DEFAULT '' NOT NULL,
50 middle_name varchar(50) DEFAULT '' NOT NULL,
51 last_name varchar(50) DEFAULT '' NOT NULL,
52 address varchar(255) DEFAULT '' NOT NULL,
53 telephone varchar(30) DEFAULT '' NOT NULL,
54 fax varchar(30) DEFAULT '' NOT NULL,
55 email varchar(255) DEFAULT '' NOT NULL,
56 lockToDomain varchar(50) DEFAULT '' NOT NULL,
57 uc blob,
58 title varchar(40) DEFAULT '' NOT NULL,
59 zip varchar(10) DEFAULT '' NOT NULL,
60 city varchar(50) DEFAULT '' NOT NULL,
61 country varchar(40) DEFAULT '' NOT NULL,
62 www varchar(80) DEFAULT '' NOT NULL,
63 company varchar(80) DEFAULT '' NOT NULL,
64 image tinytext,
65 TSconfig text,
66 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
67 is_online int(10) unsigned DEFAULT '0' NOT NULL,
68
69 KEY parent (pid,username(100)),
70 KEY username (username(100)),
71 KEY is_online (is_online)
72 );
73
74 #
75 # Table structure for table 'sys_template'
76 #
77 CREATE TABLE sys_template (
78 title varchar(255) DEFAULT '' NOT NULL,
79 sitetitle varchar(255) DEFAULT '' NOT NULL,
80 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
81 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
82 include_static_file text,
83 constants text,
84 config text,
85 basedOn tinytext,
86 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
87 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
88
89 KEY roottemplate (deleted,hidden,root)
90 );
91
92 #
93 # Table structure for table 'tt_content'
94 #
95 CREATE TABLE tt_content (
96 CType varchar(255) DEFAULT '' NOT NULL,
97 header varchar(255) DEFAULT '' NOT NULL,
98 header_position varchar(255) DEFAULT '' NOT NULL,
99 rowDescription text,
100 bodytext mediumtext,
101 bullets_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
102 uploads_description tinyint(1) unsigned DEFAULT '0' NOT NULL,
103 uploads_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
104 assets int(11) unsigned DEFAULT '0' NOT NULL,
105 image int(11) unsigned DEFAULT '0' NOT NULL,
106 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
107 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
108 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
109 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
110 media int(11) unsigned DEFAULT '0' NOT NULL,
111 layout int(11) unsigned DEFAULT '0' NOT NULL,
112 frame_class varchar(60) DEFAULT 'default' NOT NULL,
113 cols int(11) unsigned DEFAULT '0' NOT NULL,
114 space_before_class varchar(60) DEFAULT '' NOT NULL,
115 space_after_class varchar(60) DEFAULT '' NOT NULL,
116 records text,
117 pages text,
118 colPos int(11) unsigned DEFAULT '0' NOT NULL,
119 subheader varchar(255) DEFAULT '' NOT NULL,
120 header_link varchar(1024) DEFAULT '' NOT NULL,
121 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
122 header_layout varchar(30) DEFAULT '0' NOT NULL,
123 list_type varchar(255) DEFAULT '' NOT NULL,
124 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
125 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
126 file_collections text,
127 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
128 filelink_sorting varchar(17) DEFAULT '' NOT NULL,
129 filelink_sorting_direction varchar(4) DEFAULT '' NOT NULL,
130 target varchar(30) DEFAULT '' NOT NULL,
131 date int(10) unsigned DEFAULT '0' NOT NULL,
132 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
133 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
134 pi_flexform mediumtext,
135 accessibility_title varchar(30) DEFAULT '' NOT NULL,
136 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
137 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
138 selected_categories text,
139 category_field varchar(64) DEFAULT '' NOT NULL,
140 table_class varchar(60) DEFAULT '' NOT NULL,
141 table_caption varchar(255) DEFAULT NULL,
142 table_delimiter smallint(6) unsigned DEFAULT '0' NOT NULL,
143 table_enclosure smallint(6) unsigned DEFAULT '0' NOT NULL,
144 table_header_position tinyint(3) unsigned DEFAULT '0' NOT NULL,
145 table_tfoot tinyint(1) unsigned DEFAULT '0' NOT NULL,
146
147 KEY parent (pid,sorting),
148 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
149 KEY language (l18n_parent,sys_language_uid)
150 );
151
152 #
153 # Table structure for table 'backend_layout'
154 #
155 CREATE TABLE backend_layout (
156 title varchar(255) DEFAULT '' NOT NULL,
157 config text NOT NULL,
158 icon text
159 );