-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
executable file
·31 lines (30 loc) · 1.42 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
#
# Table structure for table 'tx_pfprojects_domain_model_project'
#
CREATE TABLE tx_pfprojects_domain_model_project
(
title varchar(255) DEFAULT '' NOT NULL,
path_segment varchar(2048) DEFAULT '' NOT NULL,
start_date date DEFAULT '1000-01-01',
status varchar(10) DEFAULT '' NOT NULL,
contact_person varchar(255) DEFAULT '' NOT NULL,
telephone varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
office_type tinyint(1) unsigned DEFAULT '0' NOT NULL,
organisationseinheit int(11) unsigned DEFAULT '0' NOT NULL,
office_manuell varchar(255) DEFAULT '' NOT NULL,
images int(11) unsigned DEFAULT '0' NOT NULL,
description text NOT NULL,
files int(11) unsigned DEFAULT '0' NOT NULL,
links int(11) unsigned DEFAULT '0' NOT NULL,
area_of_activity int(11) DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_pfprojects_domain_model_link'
#
CREATE TABLE tx_pfprojects_domain_model_link
(
title varchar(255) DEFAULT '' NOT NULL,
link varchar(255) DEFAULT '' NOT NULL,
project int(11) DEFAULT '0' NOT NULL
);