Merge branch 'release/3.1.0'
[TYPO3CMS/Extensions/powermailCond.git] / ext_tables.sql
1 #
2 # Table structure for table 'tx_powermailcond_domain_model_conditioncontainer'
3 #
4 CREATE TABLE tx_powermailcond_domain_model_conditioncontainer (
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 conditions int(11) DEFAULT '0' NOT NULL,
20
21 title tinytext NOT NULL,
22 form int(11) DEFAULT '0' NOT NULL,
23
24 PRIMARY KEY (uid),
25 KEY parent (pid)
26 );
27
28 #
29 # Table structure for table 'tx_powermailcond_domain_model_condition'
30 #
31 CREATE TABLE tx_powermailcond_domain_model_condition (
32 uid int(11) NOT NULL auto_increment,
33 pid int(11) DEFAULT '0' NOT NULL,
34 tstamp int(11) DEFAULT '0' NOT NULL,
35 crdate int(11) DEFAULT '0' NOT NULL,
36 cruser_id int(11) DEFAULT '0' NOT NULL,
37 sys_language_uid int(11) DEFAULT '0' NOT NULL,
38 l18n_parent int(11) DEFAULT '0' NOT NULL,
39 l18n_diffsource mediumblob 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 starttime int(11) DEFAULT '0' NOT NULL,
44 endtime int(11) DEFAULT '0' NOT NULL,
45
46 rules int(11) DEFAULT '0' NOT NULL,
47 conditioncontainer int(11) DEFAULT '0' NOT NULL,
48
49 title tinytext NOT NULL,
50 target_field tinytext NOT NULL,
51 actions tinytext NOT NULL,
52 conjunction tinytext NOT NULL,
53
54 PRIMARY KEY (uid),
55 KEY parent (pid)
56 );
57
58
59 #
60 # Table structure for table 'tx_powermailcond_domain_model_rule'
61 #
62 CREATE TABLE tx_powermailcond_domain_model_rule (
63 uid int(11) NOT NULL auto_increment,
64 pid int(11) DEFAULT '0' NOT NULL,
65 tstamp int(11) DEFAULT '0' NOT NULL,
66 crdate int(11) DEFAULT '0' NOT NULL,
67 cruser_id int(11) DEFAULT '0' NOT NULL,
68 sorting int(10) DEFAULT '0' NOT NULL,
69 deleted tinyint(4) DEFAULT '0' NOT NULL,
70 hidden tinyint(4) DEFAULT '0' NOT NULL,
71
72 conditions int(11) DEFAULT '0' NOT NULL,
73
74 title tinytext NOT NULL,
75 start_field int(11) DEFAULT '0' NOT NULL,
76 ops int(11) DEFAULT '0' NOT NULL,
77 cond_string text NOT NULL,
78 equal_field int(11) DEFAULT '0' NOT NULL,
79
80 PRIMARY KEY (uid),
81 KEY parent (pid)
82 );