Initial Upload of powermail_cond 2.0
[TYPO3CMS/Extensions/powermailCond.git] / ext_tables.sql
1 #
2 # Table structure for table 'tx_powermailcond_conditions'
3 #
4 CREATE TABLE tx_powermailcond_conditions (
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 title tinytext NOT NULL,
19 targetField tinytext NOT NULL,
20 actions tinytext NOT NULL,
21 filterSelectField tinytext NOT NULL,
22 conjunction tinytext NOT NULL,
23 rules int(11) DEFAULT '0' NOT NULL,
24
25 PRIMARY KEY (uid),
26 KEY parent (pid)
27 );
28
29
30
31 #
32 # Table structure for table 'tx_powermailcond_rules'
33 #
34 CREATE TABLE tx_powermailcond_rules (
35 uid int(11) NOT NULL auto_increment,
36 pid int(11) DEFAULT '0' NOT NULL,
37 tstamp int(11) DEFAULT '0' NOT NULL,
38 crdate int(11) DEFAULT '0' NOT NULL,
39 cruser_id int(11) DEFAULT '0' NOT NULL,
40 sorting int(10) DEFAULT '0' NOT NULL,
41 deleted tinyint(4) DEFAULT '0' NOT NULL,
42 hidden tinyint(4) DEFAULT '0' NOT NULL,
43 title tinytext NOT NULL,
44 startField int(11) DEFAULT '0' NOT NULL,
45 ops int(11) DEFAULT '0' NOT NULL,
46 condstring text NOT NULL,
47 conditions int(11) DEFAULT '0' NOT NULL,
48 equalField int(11) DEFAULT '0' NOT NULL,
49
50 PRIMARY KEY (uid),
51 KEY parent (pid)
52 );