-
Notifications
You must be signed in to change notification settings - Fork 1
/
ext_tables.sql
72 lines (65 loc) · 2.69 KB
/
ext_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
CREATE TABLE tx_minipoll_poll (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
fe_group varchar(100) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
description text,
use_captcha tinyint(1) unsigned DEFAULT '0' NOT NULL,
duplication_check varchar(100) DEFAULT '' NOT NULL,
status tinyint(4) unsigned DEFAULT '0' NOT NULL,
open_datetime int(11) unsigned DEFAULT '0' NOT NULL,
close_datetime int(11) unsigned DEFAULT '0' NOT NULL,
allow_multiple tinyint(1) unsigned DEFAULT '0' NOT NULL,
display_results tinyint(4) unsigned DEFAULT '0' NOT NULL,
options int(11) unsigned DEFAULT '0' NOT NULL,
participations int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_minipoll_poll_option (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
poll int(11) unsigned DEFAULT '0' NOT NULL,
answers int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY poll (poll)
);
CREATE TABLE tx_minipoll_participation (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
poll int(11) unsigned DEFAULT '0' NOT NULL,
ip varchar(15) DEFAULT '' NOT NULL,
frontend_user int(11) unsigned DEFAULT '0' NOT NULL,
answers int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY poll (poll)
);
CREATE TABLE tx_minipoll_answer (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
participation int(11) unsigned DEFAULT '0' NOT NULL,
poll_option int(11) unsigned DEFAULT '0' NOT NULL,
value mediumtext,
PRIMARY KEY (uid),
KEY parent (pid),
KEY participation (participation,poll_option),
);