Serverside Validation
[TYPO3CMS/Extensions/powermailCond.git] / ext_tables.sql
1 #
2 # Table structure for table 'tx_powermailcond_domain_model_condition'
3 #
4 CREATE TABLE tx_powermailcond_domain_model_condition (
5 uid int(11) NOT NULL auto_increment,
6 pid int(11) DEFAULT '0' NOT NULL,
7 tstamp int(11) DEFAULT '0' NOT NULL,
8 crdate int(11) DEFAULT '0' NOT NULL,
9 cruser_id int(11) DEFAULT '0' NOT NULL,
10 sys_language_uid int(11) DEFAULT '0' NOT NULL,
11 l18n_parent int(11) DEFAULT '0' NOT NULL,
12 l18n_diffsource mediumblob NOT NULL,
13 sorting int(10) DEFAULT '0' NOT NULL,
14 deleted tinyint(4) DEFAULT '0' NOT NULL,
15 hidden tinyint(4) DEFAULT '0' NOT NULL,
16 starttime int(11) DEFAULT '0' NOT NULL,
17 endtime int(11) DEFAULT '0' NOT NULL,
18
19 rules int(11) DEFAULT '0' NOT NULL,
20
21 title tinytext NOT NULL,
22 targetField tinytext NOT NULL,
23 actions tinytext NOT NULL,
24 filterSelectField tinytext NOT NULL,
25 conjunction tinytext NOT NULL,
26 form int(11) DEFAULT '0' NOT NULL,
27
28 PRIMARY KEY (uid),
29 KEY parent (pid)
30 );
31
32
33 #
34 # Table structure for table 'tx_powermailcond_domain_model_rule'
35 #
36 CREATE TABLE tx_powermailcond_domain_model_rule (
37 uid int(11) NOT NULL auto_increment,
38 pid int(11) DEFAULT '0' NOT NULL,
39 tstamp int(11) DEFAULT '0' NOT NULL,
40 crdate int(11) DEFAULT '0' NOT NULL,
41 cruser_id int(11) DEFAULT '0' NOT NULL,
42 sorting int(10) DEFAULT '0' NOT NULL,
43 deleted tinyint(4) DEFAULT '0' NOT NULL,
44 hidden tinyint(4) DEFAULT '0' NOT NULL,
45
46 conditions int(11) DEFAULT '0' NOT NULL,
47
48 title tinytext NOT NULL,
49 startField int(11) DEFAULT '0' NOT NULL,
50 ops int(11) DEFAULT '0' NOT NULL,
51 condstring text NOT NULL,
52 equalField int(11) DEFAULT '0' NOT NULL,
53
54 PRIMARY KEY (uid),
55 KEY parent (pid)
56 );