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