[TASK] Migrate extension update script to TYPO3 LTS 9
[TYPO3CMS/Extensions/static_info_tables.git] / ext_tables.sql
1 #
2 # Table structure for table "static_countries"
3 #
4 CREATE TABLE static_countries (
5 uid int(11) NOT NULL auto_increment,
6 pid int(11) DEFAULT '0' NOT NULL,
7 deleted smallint(6) DEFAULT '0' NOT NULL,
8 cn_iso_2 varchar(2) DEFAULT '' NOT NULL,
9 cn_iso_3 varchar(3) DEFAULT '' NOT NULL,
10 cn_iso_nr int(11) DEFAULT '0' NOT NULL,
11 cn_parent_territory_uid int(11) DEFAULT '0' NOT NULL,
12 cn_parent_tr_iso_nr int(11) DEFAULT '0' NOT NULL,
13 cn_official_name_local varchar(128) DEFAULT '' NOT NULL,
14 cn_official_name_en varchar(128) DEFAULT '' NOT NULL,
15 cn_capital varchar(45) DEFAULT '' NOT NULL,
16 cn_tldomain varchar(2) DEFAULT '' NOT NULL,
17 cn_currency_uid int(11) DEFAULT '0' NOT NULL,
18 cn_currency_iso_3 varchar(3) DEFAULT '' NOT NULL,
19 cn_currency_iso_nr int(11) DEFAULT '0' NOT NULL,
20 cn_phone int(11) DEFAULT '0' NOT NULL,
21 cn_eu_member smallint(6) DEFAULT '0' NOT NULL,
22 cn_uno_member smallint(6) DEFAULT '0' NOT NULL,
23 cn_address_format smallint(6) DEFAULT '0' NOT NULL,
24 cn_zone_flag smallint(6) DEFAULT '0' NOT NULL,
25 cn_short_local varchar(70) DEFAULT '' NOT NULL,
26 cn_short_en varchar(50) DEFAULT '' NOT NULL,
27 cn_country_zones int(11) DEFAULT '0' NOT NULL,
28 PRIMARY KEY (uid)
29 );
30
31 #
32 # Table structure for table "static_country_zones"
33 #
34 CREATE TABLE static_country_zones (
35 uid int(11) NOT NULL auto_increment,
36 pid int(11) DEFAULT '0' NOT NULL,
37 deleted smallint(6) DEFAULT '0' NOT NULL,
38 zn_country_iso_2 varchar(2) DEFAULT '' NOT NULL,
39 zn_country_iso_3 varchar(3) DEFAULT '' NOT NULL,
40 zn_country_iso_nr int(11) DEFAULT '0' NOT NULL,
41 zn_code varchar(45) DEFAULT '' NOT NULL,
42 zn_name_local varchar(128) DEFAULT '' NOT NULL,
43 zn_name_en varchar(50) DEFAULT '' NOT NULL,
44 zn_country_uid int(11) DEFAULT '0' NOT NULL,
45 zn_country_table tinytext,
46 PRIMARY KEY (uid)
47 );
48
49 #
50 # Table structure for table "static_currencies"
51 #
52 CREATE TABLE static_currencies (
53 uid int(11) NOT NULL auto_increment,
54 pid int(11) DEFAULT '0' NOT NULL,
55 deleted smallint(6) DEFAULT '0' NOT NULL,
56 cu_iso_3 varchar(3) DEFAULT '' NOT NULL,
57 cu_iso_nr int(11) DEFAULT '0' NOT NULL,
58 cu_name_en varchar(50) DEFAULT '' NOT NULL,
59 cu_symbol_left varchar(12) DEFAULT '' NOT NULL,
60 cu_symbol_right varchar(12) DEFAULT '' NOT NULL,
61 cu_thousands_point varchar(1) DEFAULT '' NOT NULL,
62 cu_decimal_point varchar(1) DEFAULT '' NOT NULL,
63 cu_decimal_digits smallint(6) DEFAULT '0' NOT NULL,
64 cu_sub_name_en varchar(20) DEFAULT '' NOT NULL,
65 cu_sub_divisor int(11) DEFAULT '1' NOT NULL,
66 cu_sub_symbol_left varchar(12) DEFAULT '' NOT NULL,
67 cu_sub_symbol_right varchar(12) DEFAULT '' NOT NULL,
68 PRIMARY KEY (uid),
69 KEY parent (pid)
70 );
71
72 #
73 # Table structure for table "static_languages"
74 #
75 CREATE TABLE static_languages (
76 uid int(11) NOT NULL auto_increment,
77 pid int(11) DEFAULT '0' NOT NULL,
78 deleted smallint(6) DEFAULT '0' NOT NULL,
79 lg_iso_2 varchar(2) DEFAULT '' NOT NULL,
80 lg_name_local varchar(99) DEFAULT '' NOT NULL,
81 lg_name_en varchar(50) DEFAULT '' NOT NULL,
82 lg_typo3 varchar(2) DEFAULT '' NOT NULL,
83 lg_country_iso_2 varchar(2) DEFAULT '' NOT NULL,
84 lg_collate_locale varchar(5) DEFAULT '' NOT NULL,
85 lg_sacred smallint(6) DEFAULT '0' NOT NULL,
86 lg_constructed smallint(6) DEFAULT '0' NOT NULL,
87 PRIMARY KEY (uid),
88 KEY parent (pid)
89 );
90
91 #
92 # Table structure for table "static_territories"
93 #
94 CREATE TABLE static_territories (
95 uid int(11) NOT NULL auto_increment,
96 pid int(11) DEFAULT '0' NOT NULL,
97 deleted smallint(6) DEFAULT '0' NOT NULL,
98 tr_iso_nr int(11) DEFAULT '0' NOT NULL,
99 tr_parent_territory_uid int(11) DEFAULT '0' NOT NULL,
100 tr_parent_iso_nr int(11) DEFAULT '0' NOT NULL,
101 tr_name_en varchar(50) DEFAULT '' NOT NULL,
102 PRIMARY KEY (uid)
103 );