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