65bad995e5d8959617688b3b23849a1ba8f6dbb8
[Packages/TYPO3.CMS.git] / typo3 / sysext / statictemplates / ext_tables.sql
1 #
2 # Table structure for table 'static_template'
3 #
4 CREATE TABLE static_template (
5 uid int(11) unsigned NOT NULL auto_increment,
6 pid int(11) unsigned DEFAULT '0' NOT NULL,
7 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
8 crdate int(11) unsigned DEFAULT '0' NOT NULL,
9 title varchar(255) DEFAULT '' NOT NULL,
10 include_static tinyblob NOT NULL,
11 constants blob NOT NULL,
12 config blob NOT NULL,
13 editorcfg blob NOT NULL,
14 description text NOT NULL,
15 PRIMARY KEY (uid),
16 KEY parent (pid)
17 );
18
19 #
20 # Add field for static_templates in table 'sys_template'
21 #
22 CREATE TABLE sys_template (
23 include_static tinyblob NOT NULL
24 );