-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathext_tables.sql
81 lines (63 loc) · 2.65 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
73
74
75
76
77
78
79
80
81
#
# Table structure for table 'tx_t3oodle_domain_model_poll'
#
CREATE TABLE tx_t3oodle_domain_model_poll (
type varchar(255) DEFAULT '' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
description text,
link text,
slug varchar(255) DEFAULT '' NOT NULL,
visibility varchar(255) DEFAULT 'public' NOT NULL,
author varchar(255) DEFAULT '' NOT NULL,
author_name varchar(255) DEFAULT '' NOT NULL,
author_mail varchar(255) DEFAULT '' NOT NULL,
author_ident varchar(128) DEFAULT '' NOT NULL,
options int(11) unsigned DEFAULT '0' NOT NULL,
suggest_mode_enabled smallint(5) unsigned DEFAULT '0' NOT NULL,
is_suggest_mode_finished smallint(5) unsigned DEFAULT '0' NOT NULL,
is_published smallint(5) unsigned DEFAULT '0' NOT NULL,
publish_date int(10) unsigned DEFAULT '0',
votes int(11) unsigned DEFAULT '0' NOT NULL,
is_finished smallint(5) unsigned DEFAULT '0' NOT NULL,
finish_date int(10) unsigned DEFAULT '0',
final_option int(11) unsigned DEFAULT '0',
setting_tristate_checkbox smallint(5) unsigned DEFAULT '0' NOT NULL,
setting_max_votes_per_option int(11) unsigned DEFAULT '0',
setting_min_votes_per_participant int(11) unsigned DEFAULT '0',
setting_max_votes_per_participant int(11) unsigned DEFAULT '0',
setting_secret_participants smallint(5) unsigned DEFAULT '0' NOT NULL,
setting_secret_votings smallint(5) unsigned DEFAULT '0' NOT NULL,
setting_super_secret_mode smallint(5) unsigned DEFAULT '0' NOT NULL,
setting_voting_expires_date int(10) DEFAULT '0',
setting_voting_expires_time int(10) DEFAULT '0'
);
#
# Table structure for table 'tx_t3oodle_domain_model_option'
#
CREATE TABLE tx_t3oodle_domain_model_option (
poll int(11) unsigned DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
creator varchar(255) DEFAULT '' NOT NULL,
creator_name varchar(255) DEFAULT '' NOT NULL,
creator_mail varchar(255) DEFAULT '' NOT NULL,
creator_ident varchar(128) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_t3oodle_domain_model_vote'
#
CREATE TABLE tx_t3oodle_domain_model_vote (
participant varchar(255) DEFAULT '' NOT NULL,
participant_name varchar(255) DEFAULT '' NOT NULL,
participant_mail varchar(255) DEFAULT '' NOT NULL,
participant_ident varchar(128) DEFAULT '' NOT NULL,
option_values int(11) unsigned DEFAULT '0' NOT NULL,
poll int(11) unsigned DEFAULT '0'
);
#
# Table structure for table 'tx_t3oodle_domain_model_optionvalue'
#
CREATE TABLE tx_t3oodle_domain_model_optionvalue (
option int(11) unsigned DEFAULT '0',
value varchar(255) DEFAULT '' NOT NULL,
vote int(11) unsigned DEFAULT '0'
);