[FEATURE] Expand db function searchQuery to handle AND and OR constraints
[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 description text NOT NULL,
14 PRIMARY KEY (uid),
15 KEY parent (pid)
16 );
17
18 #
19 # Add field for static_templates in table 'sys_template'
20 #
21 CREATE TABLE sys_template (
22 include_static tinyblob NOT NULL
23 );