47ee22bbc642e8b7aa0fa3bb8fdaea7467f50e03
[TYPO3CMS/Extensions/static_info_tables.git] / ext_tables.sql
1 #
2 # Table structure for table "static_territories"
3 #
4 CREATE TABLE static_territories (
5 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
6 pid int(11) unsigned DEFAULT '0' NOT NULL,
7 tr_iso_nr int(11) unsigned DEFAULT '0' NOT NULL,
8 tr_parent_iso_nr int(11) unsigned DEFAULT '0' NOT NULL,
9 tr_name_en varchar(50) DEFAULT '' NOT NULL,
10 PRIMARY KEY (uid),
11 UNIQUE uid (uid)
12 );
13
14 #
15 # Table structure for table "static_countries"
16 #
17 CREATE TABLE static_countries (
18 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
19 pid int(11) unsigned DEFAULT '0' NOT NULL,
20 cn_iso_2 char(2) DEFAULT '' NOT NULL,
21 cn_iso_3 char(3) DEFAULT '' NOT NULL,
22 cn_iso_nr int(11) unsigned DEFAULT '0' NOT NULL,
23 cn_parent_tr_iso_nr int(11) unsigned DEFAULT '0' NOT NULL,
24 cn_official_name_local varchar(128) DEFAULT '' NOT NULL,
25 cn_official_name_en varchar(128) DEFAULT '' NOT NULL,
26 cn_capital varchar(45) DEFAULT '' NOT NULL,
27 cn_tldomain char(2) DEFAULT '' NOT NULL,
28 cn_currency_iso_3 char(3) DEFAULT '' NOT NULL,
29 cn_currency_iso_nr int(10) unsigned DEFAULT '0' NOT NULL,
30 cn_phone int(10) unsigned DEFAULT '0' NOT NULL,
31 cn_eu_member tinyint(3) unsigned DEFAULT '0' NOT NULL,
32 cn_uno_member tinyint(3) unsigned DEFAULT '0' NOT NULL,
33 cn_address_format tinyint(3) unsigned DEFAULT '0' NOT NULL,
34 cn_zone_flag tinyint(4) DEFAULT '0' NOT NULL,
35 cn_short_local varchar(70) DEFAULT '' NOT NULL,
36 cn_short_en varchar(50) DEFAULT '' NOT NULL,
37 PRIMARY KEY (uid),
38 UNIQUE uid (uid)
39 );
40
41
42 #
43 # Table structure for table "static_country_zones"
44 #
45 CREATE TABLE static_country_zones (
46 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
47 pid int(11) unsigned DEFAULT '0' NOT NULL,
48 zn_country_iso_2 char(2) DEFAULT '' NOT NULL,
49 zn_country_iso_3 char(3) DEFAULT '' NOT NULL,
50 zn_country_iso_nr int(11) unsigned DEFAULT '0' NOT NULL,
51 zn_code varchar(45) DEFAULT '' NOT NULL,
52 zn_name_local varchar(128) DEFAULT '' NOT NULL,
53 zn_name_en varchar(50) DEFAULT '' NOT NULL,
54 PRIMARY KEY (uid),
55 UNIQUE uid (uid)
56 );
57
58
59 #
60 # Table structure for table "static_currencies"
61 #
62 CREATE TABLE static_currencies (
63 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
64 pid int(11) unsigned DEFAULT '0' NOT NULL,
65 cu_iso_3 char(3) DEFAULT '' NOT NULL,
66 cu_iso_nr int(11) unsigned DEFAULT '0' NOT NULL,
67 cu_name_en varchar(50) DEFAULT '' NOT NULL,
68 cu_symbol_left varchar(12) DEFAULT '' NOT NULL,
69 cu_symbol_right varchar(12) DEFAULT '' NOT NULL,
70 cu_thousands_point char(1) DEFAULT '' NOT NULL,
71 cu_decimal_point char(1) DEFAULT '' NOT NULL,
72 cu_decimal_digits tinyint(3) unsigned DEFAULT '0' NOT NULL,
73 cu_sub_name_en varchar(20) DEFAULT '' NOT NULL,
74 cu_sub_divisor int(11) DEFAULT '1' NOT NULL,
75 cu_sub_symbol_left varchar(12) DEFAULT '' NOT NULL,
76 cu_sub_symbol_right varchar(12) DEFAULT '' NOT NULL,
77 PRIMARY KEY (uid),
78 UNIQUE uid (uid),
79 KEY parent (pid)
80 );
81
82
83 #
84 # Table structure for table "static_languages"
85 #
86 CREATE TABLE static_languages (
87 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
88 pid int(11) unsigned DEFAULT '0' NOT NULL,
89 lg_iso_2 char(2) DEFAULT '' NOT NULL,
90 lg_name_local varchar(99) DEFAULT '' NOT NULL,
91 lg_name_en varchar(50) DEFAULT '' NOT NULL,
92 lg_typo3 char(2) DEFAULT '' NOT NULL,
93 lg_country_iso_2 char(2) DEFAULT '' NOT NULL,
94 lg_collate_locale varchar(5) DEFAULT '' NOT NULL,
95 lg_sacred tinyint(3) unsigned DEFAULT '0' NOT NULL,
96 lg_constructed tinyint(3) unsigned DEFAULT '0' NOT NULL,
97 PRIMARY KEY (uid),
98 UNIQUE uid (uid),
99 KEY parent (pid)
100 );
101
102
103 #
104 # Table structure for table "static_markets"
105 #
106 CREATE TABLE static_markets (
107 uid int(11) auto_increment,
108 pid int(11) default '0',
109 country int(11) default '0',
110 mic varchar(4) default '',
111 institution_description varchar(90) default '',
112 acronym varchar(30) default '',
113 city varchar(30) default '',
114 url varchar(90) default '',
115 PRIMARY KEY (uid),
116 KEY parent (pid)
117 );
118
119
120 #
121 # Table structure for table "tx_staticinfotables_hotlist"
122 #
123 CREATE TABLE tx_staticinfotables_hotlist (
124 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
125 tablenames varchar(30) DEFAULT '' NOT NULL,
126 application varchar(20) DEFAULT '' NOT NULL,
127 sorting bigint(20) unsigned DEFAULT '0' NOT NULL,
128 KEY uid_local (uid_local),
129 );