-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
87 lines (76 loc) · 2.31 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
#
# Table structure for table 'tx_booking_domain_model_room'
#
CREATE TABLE tx_booking_domain_model_room (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
opening_times_storage varchar(255),
booking_storage int(11),
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_booking_domain_model_booking'
#
CREATE TABLE tx_booking_domain_model_booking (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
room int(11) DEFAULT '0' NOT NULL,
time int(11) DEFAULT '0' NOT NULL,
fe_user int(11) DEFAULT '0' NOT NULL,
comment varchar(255) DEFAULT '',
PRIMARY KEY (uid),
KEY parent (pid),
KEY room (room),
KEY time (time),
KEY fe_user (fe_user),
UNIQUE one_booking_per_room_and_time (room, time),
);
#
# Table structure for table 'tx_booking_domain_model_closingday'
#
CREATE TABLE tx_booking_domain_model_closingday (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
name VARCHAR(255) DEFAULT '',
date int(11) not null,
description TEXT DEFAULT '',
PRIMARY KEY (uid),
KEY parent (pid),
KEY date (date),
);
#
# Table structure for table 'tx_booking_domain_model_openinghours'
#
CREATE TABLE tx_booking_domain_model_openinghours (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
hours VARCHAR(255) DEFAULT '',
week_day tinyint(4) not null,
PRIMARY KEY (uid),
KEY parent (pid),
UNIQUE weekday (pid, week_day)
);