-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathext_tables.sql
122 lines (103 loc) · 3.64 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
---
-- Sponsors
---
CREATE TABLE tx_t3sponsors_companies (
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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource text NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
name1 varchar(150) DEFAULT '' NOT NULL,
name2 varchar(150) DEFAULT '' NOT NULL,
description text NOT NULL,
comment text NOT NULL,
damlogo int(11) DEFAULT '0' NOT NULL,
dampictures int(11) DEFAULT '0' NOT NULL,
logo text NOT NULL,
pictures text NOT NULL,
hasreport tinyint(4) DEFAULT '0' NOT NULL,
address varchar(150) DEFAULT '' NOT NULL,
zip varchar(150) DEFAULT '' NOT NULL,
city varchar(150) DEFAULT '' NOT NULL,
country int(11) DEFAULT '0' NOT NULL,
countrycode varchar(20) DEFAULT '' NOT NULL,
www varchar(150) DEFAULT '' NOT NULL,
email varchar(150) DEFAULT '' NOT NULL,
phone varchar(150) DEFAULT '' NOT NULL,
fax varchar(150) DEFAULT '' NOT NULL,
mobile varchar(150) DEFAULT '' NOT NULL,
contactfirstname varchar(150) DEFAULT '' NOT NULL,
contactlastname varchar(150) DEFAULT '' NOT NULL,
lng tinytext,
lat tinytext,
tags text NOT NULL,
openingtime text NOT NULL,
categories int(11) DEFAULT '0' NOT NULL,
trades int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_t3sponsors_categories (
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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource text NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
name varchar(150) DEFAULT '' NOT NULL,
description text NOT NULL,
damlogo int(11) DEFAULT '0' NOT NULL,
logo text NOT NULL,
sponsors int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_t3sponsors_categories_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,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
CREATE TABLE tx_t3sponsors_trades (
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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource text NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
name varchar(150) DEFAULT '' NOT NULL,
description text NOT NULL,
logo int(11) DEFAULT '0' NOT NULL,
t3logo text NOT NULL,
sponsors int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_t3sponsors_trades_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,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);