This repository has been archived by the owner on Jan 26, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
ext_tables.sql
122 lines (115 loc) · 4.38 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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
#
# Table structure for table 'tx_calendar_cat'
#
CREATE TABLE tx_calendar_cat (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
image blob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_calendar_targetgroup'
#
CREATE TABLE tx_calendar_targetgroup (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
image blob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_calendar_organizer'
#
CREATE TABLE tx_calendar_organizer (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
image blob NOT NULL,
url tinytext NOT NULL,
url_text tinytext NOT NULL,
email tinytext NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_calendar_item'
#
CREATE TABLE tx_calendar_item (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
eventtype int(5) unsigned DEFAULT '0' NOT NULL,
start_date int(11) DEFAULT '0' NOT NULL,
start_time int(11) DEFAULT '0' NOT NULL,
end_date int(11) DEFAULT '0' NOT NULL,
end_time int(11) DEFAULT '0' NOT NULL,
organizer_mm int(11) unsigned DEFAULT '0' NOT NULL,
organizer tinytext NOT NULL,
organizer_email tinytext NOT NULL,
organizer_url tinytext NOT NULL,
organizer_url_text tinytext NOT NULL,
teaser tinytext NOT NULL,
descr text NOT NULL,
category int(11) unsigned DEFAULT '0' NOT NULL,
targetgroup int(11) unsigned DEFAULT '0' NOT NULL,
place tinytext NOT NULL,
address text NOT NULL,
moreinfo text NOT NULL,
url tinytext NOT NULL,
url_text tinytext NOT NULL,
image blob NOT NULL,
rec_end_date int(11) DEFAULT '0' NOT NULL,
rec_end_times int(11) unsigned DEFAULT '0' NOT NULL,
rec_daily_type int(11) unsigned DEFAULT '0' NOT NULL,
repeat_days int(11) unsigned DEFAULT '0' NOT NULL,
repeat_weeks int(11) unsigned DEFAULT '0' NOT NULL,
repeat_week_monday tinyint(4) unsigned DEFAULT '0' NOT NULL,
repeat_week_tuesday tinyint(4) unsigned DEFAULT '0' NOT NULL,
repeat_week_wednesday tinyint(4) unsigned DEFAULT '0' NOT NULL,
repeat_week_thursday tinyint(4) unsigned DEFAULT '0' NOT NULL,
repeat_week_friday tinyint(4) unsigned DEFAULT '0' NOT NULL,
repeat_week_saturday tinyint(4) unsigned DEFAULT '0' NOT NULL,
repeat_week_sunday tinyint(4) unsigned DEFAULT '0' NOT NULL,
rec_monthly_type int(11) unsigned DEFAULT '0' NOT NULL,
repeat_months int(11) unsigned DEFAULT '0' NOT NULL,
rec_monthly_weekday int(11) unsigned DEFAULT '0' NOT NULL,
rec_monthly_weekday_no int(11) unsigned DEFAULT '0' NOT NULL,
rec_monthly_notfound int(11) unsigned DEFAULT '0' NOT NULL,
rec_yearly_type int(11) unsigned DEFAULT '0' NOT NULL,
repeat_years int(11) unsigned DEFAULT '0' NOT NULL,
repeat_year_month int(11) unsigned DEFAULT '0' NOT NULL,
repeat_year_day int(11) unsigned DEFAULT '0' NOT NULL,
exception_mm int(11) unsigned DEFAULT '0' NOT NULL,
exception_skip tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);