[BUGFIX] Use correct Extbase-ActionController
[TYPO3CMS/Extensions/questionrating.git] / ext_tables.sql
1 #
2 # Table structure for table 'tx_questionrating_domain_model_question'
3 #
4 CREATE TABLE tx_questionrating_domain_model_question (
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 deleted tinyint(4) DEFAULT '0' NOT NULL,
11 hidden tinyint(4) DEFAULT '0' NOT NULL,
12 xml_id varchar(255) DEFAULT '' NOT NULL,
13 status varchar(7) DEFAULT '' NOT NULL,
14 active tinyint(3) DEFAULT '0' NOT NULL,
15 questiontext text,
16 answer1text text,
17 answer2text text,
18 answer3text text,
19 answer4text text,
20 answer5text text,
21 answer6text text,
22 answer7text text,
23 answer8text text,
24 answer9text text,
25 answer10text text,
26 correctanswer varchar(255) DEFAULT '' NOT NULL,
27 ratings int(11) unsigned DEFAULT '0' NOT NULL,
28
29 discussions int(11) unsigned DEFAULT '0' NOT NULL,
30
31 PRIMARY KEY (uid),
32 KEY parent (pid)
33 );
34
35 #
36 # Table structure for table 'tx_questionrating_domain_model_rating'
37 #
38 CREATE TABLE tx_questionrating_domain_model_rating (
39 uid int(11) NOT NULL auto_increment,
40 pid int(11) DEFAULT '0' NOT NULL,
41 tstamp int(11) DEFAULT '0' NOT NULL,
42 crdate int(11) DEFAULT '0' NOT NULL,
43 cruser_id int(11) DEFAULT '0' NOT NULL,
44 deleted tinyint(4) DEFAULT '0' NOT NULL,
45 hidden tinyint(4) DEFAULT '0' NOT NULL,
46 user int(255) DEFAULT '0' NOT NULL,
47 question int(255) DEFAULT '0' NOT NULL,
48 rating_value int(11) DEFAULT '0' NOT NULL,
49 final_rating tinyint(3) DEFAULT '0' NOT NULL,
50 final_rating_value int(11) DEFAULT '0' NOT NULL,
51
52 PRIMARY KEY (uid),
53 KEY parent (pid)
54 );
55
56 #
57 # Table structure for table 'tx_questionrating_domain_model_discussion'
58 #
59 CREATE TABLE tx_questionrating_domain_model_discussion (
60 uid int(11) NOT NULL auto_increment,
61 pid int(11) DEFAULT '0' NOT NULL,
62 tstamp int(11) DEFAULT '0' NOT NULL,
63 crdate int(11) DEFAULT '0' NOT NULL,
64 cruser_id int(11) DEFAULT '0' NOT NULL,
65 deleted tinyint(4) DEFAULT '0' NOT NULL,
66 hidden tinyint(4) DEFAULT '0' NOT NULL,
67 from_user int(255) DEFAULT '0' NOT NULL,
68 from_leader tinyint(3) DEFAULT '0' NOT NULL,
69 to_user int(255) DEFAULT '0' NOT NULL,
70 to_leader tinyint(3) DEFAULT '0' NOT NULL,
71 question int(255) DEFAULT '0' NOT NULL,
72 message text,
73
74 PRIMARY KEY (uid),
75 KEY parent (pid)
76 );
77
78
79 #
80 # Table structure for table 'tx_questionrating_domain_model_review'
81 #
82 CREATE TABLE tx_questionrating_domain_model_review (
83 uid int(11) NOT NULL auto_increment,
84 pid int(11) DEFAULT '0' NOT NULL,
85 tstamp int(11) DEFAULT '0' NOT NULL,
86 crdate int(11) DEFAULT '0' NOT NULL,
87 cruser_id int(11) DEFAULT '0' NOT NULL,
88 deleted tinyint(4) DEFAULT '0' NOT NULL,
89 hidden tinyint(4) DEFAULT '0' NOT NULL,
90 xml_id tinytext,
91 headline text,
92 status tinytext,
93 votes int(11) DEFAULT '0' NOT NULL,
94 reviewcomments int(11) DEFAULT '0' NOT NULL,
95
96 PRIMARY KEY (uid),
97 KEY parent (pid)
98 );
99
100
101
102 #
103 # Table structure for table 'tx_questionrating_domain_model_reviewcomment'
104 #
105 CREATE TABLE tx_questionrating_domain_model_reviewcomment (
106 uid int(11) NOT NULL auto_increment,
107 pid int(11) DEFAULT '0' NOT NULL,
108 tstamp int(11) DEFAULT '0' NOT NULL,
109 crdate int(11) DEFAULT '0' NOT NULL,
110 cruser_id int(11) DEFAULT '0' NOT NULL,
111 deleted tinyint(4) DEFAULT '0' NOT NULL,
112 hidden tinyint(4) DEFAULT '0' NOT NULL,
113 message text,
114 review int(11) DEFAULT '0' NOT NULL,
115 user int(11) DEFAULT '0' NOT NULL,
116
117 PRIMARY KEY (uid),
118 KEY parent (pid)
119 );
120