Repository navigation
Expand file tree
/
Copy pathext_tables.sql
More file actions
executable file
·126 lines (113 loc) · 4.11 KB
/
Copy pathext_tables.sql
File metadata and controls
executable file
·126 lines (113 loc) · 4.11 KB
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
123
124
125
126
#
# Table structure for table 'tx_wecstaffdirectory_info'
#
CREATE TABLE tx_wecstaffdirectory_info (
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,
feuser_id int(11) DEFAULT '0' NOT NULL,
position_title tinytext NOT NULL,
position_description text NOT NULL,
department tinytext NOT NULL,
department_rec tinytext NOT NULL,
team tinytext NOT NULL,
start_date int(11) DEFAULT '0' NOT NULL,
biography text NOT NULL,
news text NOT NULL,
photo_main blob NOT NULL,
photos_etc blob NOT NULL,
cellphone tinytext NOT NULL,
social_contact1 varchar(50) DEFAULT '' NOT NULL,
social_contact2 varchar(50) DEFAULT '' NOT NULL,
social_contact3 varchar(50) DEFAULT '' NOT NULL,
misc tinytext NOT NULL,
display_order tinyint(10) DEFAULT '0' NOT NULL,
gender int(11) unsigned DEFAULT '0' NOT NULL,
full_name varchar(100) DEFAULT '' NOT NULL,
first_name varchar(50) DEFAULT '' NOT NULL,
last_name varchar(50) DEFAULT '' NOT NULL,
title varchar(40) DEFAULT '' NOT NULL,
address tinytext NOT NULL,
address2 tinytext NOT NULL,
city varchar(50) DEFAULT '' NOT NULL,
zone varchar(45) DEFAULT '' NOT NULL,
zip varchar(10) DEFAULT '' NOT NULL,
country varchar(40) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
telephone varchar(25) DEFAULT '' NOT NULL,
fax varchar(25) DEFAULT '' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_wsid int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(30) DEFAULT '' NOT NULL,
t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
t3ver_count int(11) DEFAULT '0' NOT NULL,
t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
t3_origuid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY t3ver_oid (t3ver_oid,t3ver_wsid)
);
CREATE TABLE tx_wecstaffdirectory_department (
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,
department_name varchar(50) DEFAULT '' NOT NULL,
description text NOT NULL,
parent_department int(11) DEFAULT '0' NOT NULL,
image tinytext NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_wsid int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(30) DEFAULT '' NOT NULL,
t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
t3ver_count int(11) DEFAULT '0' NOT NULL,
t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
t3_origuid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY t3ver_oid (t3ver_oid,t3ver_wsid)
);
CREATE TABLE tx_wecstaffdirectory_department_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
tx_wecstaffdirectory_in int(11) DEFAULT '0' NOT NULL,
gender int(11) unsigned DEFAULT '0' NOT NULL,
first_name varchar(50) DEFAULT '' NOT NULL,
last_name varchar(50) DEFAULT '' NOT NULL,
title varchar(40) DEFAULT '' NOT NULL,
name varchar(100) DEFAULT '' NOT NULL,
country varchar(60) DEFAULT '' NOT NULL,
zip varchar(20) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
telephone varchar(25) DEFAULT '' NOT NULL,
address2 tinytext NOT NULL,
zone varchar(45) DEFAULT '' NOT NULL,
);