forked from TYPO3-svn-archive/operations
-
Notifications
You must be signed in to change notification settings - Fork 2
/
ext_tables.sql
75 lines (61 loc) · 1.91 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
#
# Table structure for table 'tx_operations_domain_model_operation'
#
CREATE TABLE tx_operations_domain_model_operation (
number varchar(255) DEFAULT '' NOT NULL,
onlyEld tinyint(4) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
path_segment varchar(2048),
location text,
begin int(11) DEFAULT '0' NOT NULL,
end int(11) DEFAULT '0' NOT NULL,
teaser text,
report text,
longitude varchar(255) DEFAULT '' NOT NULL,
latitude varchar(255) DEFAULT '' NOT NULL,
zoom int(11) DEFAULT '0' NOT NULL,
media varchar(255) DEFAULT '' NOT NULL,
type int(11) unsigned DEFAULT '0' NOT NULL,
assistance int(11) unsigned DEFAULT '0' NOT NULL,
vehicles int(11) unsigned DEFAULT '0' NOT NULL,
resources int(11) unsigned DEFAULT '0' NOT NULL,
category int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_operations_domain_model_assistance'
#
CREATE TABLE tx_operations_domain_model_assistance (
title varchar(255) DEFAULT '' NOT NULL,
description text,
link varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_operations_domain_model_vehicle'
#
CREATE TABLE tx_operations_domain_model_vehicle (
title varchar(255) DEFAULT '' NOT NULL,
path_segment varchar(2048),
short varchar(255) DEFAULT '' NOT NULL,
description text,
media varchar(255) DEFAULT '' NOT NULL,
link varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_operations_domain_model_resource'
#
CREATE TABLE tx_operations_domain_model_resource (
title varchar(255) DEFAULT '' NOT NULL,
path_segment varchar(2048),
short varchar(255) DEFAULT '' NOT NULL,
description text,
media varchar(255) DEFAULT '' NOT NULL,
link varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_operations_domain_model_type'
#
CREATE TABLE tx_operations_domain_model_type (
title varchar(255) DEFAULT '' NOT NULL,
image varchar(255) DEFAULT '' NOT NULL,
color varchar(25) DEFAULT '' NOT NULL
);