-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathext_tables.sql
113 lines (108 loc) · 3.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
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
#
# Table structure for table "static_countries"
#
CREATE TABLE static_countries (
uid int(11) UNSIGNED NOT NULL auto_increment,
pid int(11) UNSIGNED DEFAULT '0' NOT NULL,
deleted smallint(6) UNSIGNED DEFAULT '0' NOT NULL,
cn_iso_2 varchar(2) DEFAULT '' NOT NULL,
cn_iso_3 varchar(3) DEFAULT '' NOT NULL,
cn_iso_nr int(11) DEFAULT '0' NOT NULL,
cn_parent_territory_uid int(11) DEFAULT '0' NOT NULL,
cn_parent_tr_iso_nr int(11) DEFAULT '0' NOT NULL,
cn_official_name_local varchar(128) DEFAULT '' NOT NULL,
cn_official_name_en varchar(128) DEFAULT '' NOT NULL,
cn_capital varchar(45) DEFAULT '' NOT NULL,
cn_tldomain varchar(2) DEFAULT '' NOT NULL,
cn_currency_uid int(11) DEFAULT '0' NOT NULL,
cn_currency_iso_3 varchar(3) DEFAULT '' NOT NULL,
cn_currency_iso_nr int(11) DEFAULT '0' NOT NULL,
cn_phone int(11) DEFAULT '0' NOT NULL,
cn_eu_member smallint(6) DEFAULT '0' NOT NULL,
cn_uno_member smallint(6) DEFAULT '0' NOT NULL,
cn_address_format smallint(6) DEFAULT '0' NOT NULL,
cn_zone_flag smallint(6) DEFAULT '0' NOT NULL,
cn_short_local varchar(70) DEFAULT '' NOT NULL,
cn_short_en varchar(50) DEFAULT '' NOT NULL,
cn_country_zones int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid,deleted)
);
#
# Table structure for table "static_country_zones"
#
CREATE TABLE static_country_zones (
uid int(11) UNSIGNED NOT NULL auto_increment,
pid int(11) UNSIGNED DEFAULT '0' NOT NULL,
deleted smallint(6) UNSIGNED DEFAULT '0' NOT NULL,
zn_country_iso_2 varchar(2) DEFAULT '' NOT NULL,
zn_country_iso_3 varchar(3) DEFAULT '' NOT NULL,
zn_country_iso_nr int(11) DEFAULT '0' NOT NULL,
zn_code varchar(45) DEFAULT '' NOT NULL,
zn_name_local varchar(128) DEFAULT '' NOT NULL,
zn_name_en varchar(50) DEFAULT '' NOT NULL,
zn_country_uid int(11) DEFAULT '0' NOT NULL,
zn_country_table tinytext,
PRIMARY KEY (uid),
KEY parent (pid,deleted)
);
#
# Table structure for table "static_currencies"
#
CREATE TABLE static_currencies (
uid int(11) UNSIGNED NOT NULL auto_increment,
pid int(11) UNSIGNED DEFAULT '0' NOT NULL,
deleted smallint(6) UNSIGNED DEFAULT '0' NOT NULL,
cu_iso_3 varchar(3) DEFAULT '' NOT NULL,
cu_iso_nr int(11) DEFAULT '0' NOT NULL,
cu_name_en varchar(50) DEFAULT '' NOT NULL,
cu_symbol_left varchar(12) DEFAULT '' NOT NULL,
cu_symbol_right varchar(12) DEFAULT '' NOT NULL,
cu_thousands_point varchar(1) DEFAULT '' NOT NULL,
cu_decimal_point varchar(1) DEFAULT '' NOT NULL,
cu_decimal_digits smallint(6) DEFAULT '0' NOT NULL,
cu_sub_name_en varchar(20) DEFAULT '' NOT NULL,
cu_sub_divisor int(11) DEFAULT '1' NOT NULL,
cu_sub_symbol_left varchar(12) DEFAULT '' NOT NULL,
cu_sub_symbol_right varchar(12) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid,deleted)
);
#
# Table structure for table "static_languages"
#
CREATE TABLE static_languages (
uid int(11) UNSIGNED NOT NULL auto_increment,
pid int(11) UNSIGNED DEFAULT '0' NOT NULL,
deleted smallint(6) UNSIGNED DEFAULT '0' NOT NULL,
lg_iso_2 varchar(2) DEFAULT '' NOT NULL,
lg_name_local varchar(99) DEFAULT '' NOT NULL,
lg_name_en varchar(50) DEFAULT '' NOT NULL,
lg_typo3 varchar(2) DEFAULT '' NOT NULL,
lg_country_iso_2 varchar(2) DEFAULT '' NOT NULL,
lg_collate_locale varchar(5) DEFAULT '' NOT NULL,
lg_sacred smallint(6) DEFAULT '0' NOT NULL,
lg_constructed smallint(6) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid,deleted)
);
#
# Table structure for table "static_territories"
#
CREATE TABLE static_territories (
uid int(11) UNSIGNED NOT NULL auto_increment,
pid int(11) UNSIGNED DEFAULT '0' NOT NULL,
deleted smallint(6) UNSIGNED DEFAULT '0' NOT NULL,
tr_iso_nr int(11) DEFAULT '0' NOT NULL,
tr_parent_territory_uid int(11) DEFAULT '0' NOT NULL,
tr_parent_iso_nr int(11) DEFAULT '0' NOT NULL,
tr_name_en varchar(50) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid,deleted)
);
#
# Table structure for table "sys_language"
#
CREATE TABLE sys_language (
static_lang_isocode int(10) UNSIGNED NOT NULL DEFAULT 0
);