* Merging all changes from TYPO3_4-0 branch back into HEAD
[Packages/TYPO3.CMS.git] / typo3 / sysext / sys_note / ext_tables.sql
1 #
2 # Table structure for table 'sys_note'
3 #
4 CREATE TABLE sys_note (
5 uid int(11) unsigned NOT NULL auto_increment,
6 pid int(11) unsigned DEFAULT '0' NOT NULL,
7 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
8 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
9 crdate int(11) unsigned DEFAULT '0' NOT NULL,
10 cruser int(11) unsigned DEFAULT '0' NOT NULL,
11 author varchar(80) DEFAULT '' NOT NULL,
12 email varchar(80) DEFAULT '' NOT NULL,
13 subject tinytext NOT NULL,
14 message text NOT NULL,
15 personal tinyint(3) unsigned DEFAULT '0' NOT NULL,
16 category tinyint(3) unsigned DEFAULT '0' NOT NULL,
17 PRIMARY KEY (uid),
18 KEY parent (pid)
19 );