2
# Copyright (C) 1997-2003 MySQL AB
3
# For a more info consult the file COPYRIGHT distributed with this file
5
# This script writes on stdout SQL commands to generate all not
6
# existing MySQL system tables. It also replaces the help tables with
7
# new context from the manual (from fill_help_tables.sql).
9
# $1 - "test" or "real" or "verbose" variant of database
10
# $2 - path to mysql-database directory
17
This script writes on stdout SQL commands to generate all not
18
existing MySQL system tables. It also replaces the help tables with
19
new context from the manual (from fill_help_tables.sql).
22
mysql_create_system_tables [test|verbose|real] <path to mysql-database directory> <hostname> <windows option>
31
# Initialize variables
42
c_tzn="" c_tz="" c_tzt="" c_tztt="" c_tzls="" c_pl=""
43
i_tzn="" i_tz="" i_tzt="" i_tztt="" i_tzls="" i_pl=""
48
# Check for old tables
49
if test ! -f $mdata/db.frm
51
if test "$1" = "verbose" ; then
52
echo "Preparing db table" 1>&2;
55
# mysqld --bootstrap wants one command/line
56
c_d="$c_d CREATE TABLE db ("
57
c_d="$c_d Host char(60) binary DEFAULT '' NOT NULL,"
58
c_d="$c_d Db char(64) binary DEFAULT '' NOT NULL,"
59
c_d="$c_d User char(16) binary DEFAULT '' NOT NULL,"
60
c_d="$c_d Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
61
c_d="$c_d Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
62
c_d="$c_d Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
63
c_d="$c_d Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
64
c_d="$c_d Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
65
c_d="$c_d Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
66
c_d="$c_d Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
67
c_d="$c_d References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
68
c_d="$c_d Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
69
c_d="$c_d Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
70
c_d="$c_d Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
71
c_d="$c_d Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
72
c_d="$c_d Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
73
c_d="$c_d Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
74
c_d="$c_d Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
75
c_d="$c_d Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
76
c_d="$c_d Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
77
c_d="$c_d Event_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
78
c_d="$c_d Trigger_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
79
c_d="$c_d PRIMARY KEY Host (Host,Db,User),"
80
c_d="$c_d KEY User (User)"
81
c_d="$c_d ) engine=MyISAM"
82
c_d="$c_d CHARACTER SET utf8 COLLATE utf8_bin"
83
c_d="$c_d comment='Database privileges';"
85
i_d="INSERT INTO db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','N','N','Y','Y');
86
INSERT INTO db VALUES ('%','test\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','N','N','Y','Y');"
89
if test ! -f $mdata/host.frm
91
if test "$1" = "verbose" ; then
92
echo "Preparing host table" 1>&2;
95
c_h="$c_h CREATE TABLE host ("
96
c_h="$c_h Host char(60) binary DEFAULT '' NOT NULL,"
97
c_h="$c_h Db char(64) binary DEFAULT '' NOT NULL,"
98
c_h="$c_h Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
99
c_h="$c_h Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
100
c_h="$c_h Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
101
c_h="$c_h Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
102
c_h="$c_h Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
103
c_h="$c_h Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
104
c_h="$c_h Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
105
c_h="$c_h References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
106
c_h="$c_h Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
107
c_h="$c_h Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
108
c_h="$c_h Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
109
c_h="$c_h Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
110
c_h="$c_h Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
111
c_h="$c_h Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
112
c_h="$c_h Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
113
c_h="$c_h Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
114
c_h="$c_h Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
115
c_h="$c_h Trigger_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
116
c_h="$c_h PRIMARY KEY Host (Host,Db)"
117
c_h="$c_h ) engine=MyISAM"
118
c_h="$c_h CHARACTER SET utf8 COLLATE utf8_bin"
119
c_h="$c_h comment='Host privileges; Merged with database privileges';"
122
if test ! -f $mdata/user.frm
124
if test "$1" = "verbose" ; then
125
echo "Preparing user table" 1>&2;
128
c_u="$c_u CREATE TABLE user ("
129
c_u="$c_u Host char(60) binary DEFAULT '' NOT NULL,"
130
c_u="$c_u User char(16) binary DEFAULT '' NOT NULL,"
131
c_u="$c_u Password char(41) character set latin1 collate latin1_bin DEFAULT '' NOT NULL,"
132
c_u="$c_u Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
133
c_u="$c_u Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
134
c_u="$c_u Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
135
c_u="$c_u Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
136
c_u="$c_u Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
137
c_u="$c_u Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
138
c_u="$c_u Reload_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
139
c_u="$c_u Shutdown_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
140
c_u="$c_u Process_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
141
c_u="$c_u File_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
142
c_u="$c_u Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
143
c_u="$c_u References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
144
c_u="$c_u Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
145
c_u="$c_u Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
146
c_u="$c_u Show_db_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
147
c_u="$c_u Super_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
148
c_u="$c_u Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
149
c_u="$c_u Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
150
c_u="$c_u Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
151
c_u="$c_u Repl_slave_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
152
c_u="$c_u Repl_client_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
153
c_u="$c_u Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
154
c_u="$c_u Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
155
c_u="$c_u Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
156
c_u="$c_u Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
157
c_u="$c_u Create_user_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
158
c_u="$c_u Event_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
159
c_u="$c_u Trigger_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
160
c_u="$c_u ssl_type enum('','ANY','X509', 'SPECIFIED') COLLATE utf8_general_ci DEFAULT '' NOT NULL,"
161
c_u="$c_u ssl_cipher BLOB NOT NULL,"
162
c_u="$c_u x509_issuer BLOB NOT NULL,"
163
c_u="$c_u x509_subject BLOB NOT NULL,"
164
c_u="$c_u max_questions int(11) unsigned DEFAULT 0 NOT NULL,"
165
c_u="$c_u max_updates int(11) unsigned DEFAULT 0 NOT NULL,"
166
c_u="$c_u max_connections int(11) unsigned DEFAULT 0 NOT NULL,"
167
c_u="$c_u max_user_connections int(11) unsigned DEFAULT 0 NOT NULL,"
168
c_u="$c_u PRIMARY KEY Host (Host,User)"
169
c_u="$c_u ) engine=MyISAM"
170
c_u="$c_u CHARACTER SET utf8 COLLATE utf8_bin"
171
c_u="$c_u comment='Users and global privileges';"
173
if test "$1" = "test"
175
i_u="INSERT INTO user VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
176
INSERT INTO user VALUES ('$hostname','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
177
REPLACE INTO user VALUES ('127.0.0.1','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
178
INSERT INTO user (host,user) values ('localhost','');
179
INSERT INTO user (host,user) values ('$hostname','');"
181
i_u="INSERT INTO user VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);"
182
if test "$windows" = "0"
185
INSERT INTO user VALUES ('$hostname','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
186
INSERT INTO user (host,user) values ('$hostname','');
187
INSERT INTO user (host,user) values ('localhost','');"
190
INSERT INTO user VALUES ('localhost','','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);"
195
if test ! -f $mdata/func.frm
197
if test "$1" = "verbose" ; then
198
echo "Preparing func table" 1>&2;
201
c_f="$c_f CREATE TABLE func ("
202
c_f="$c_f name char(64) binary DEFAULT '' NOT NULL,"
203
c_f="$c_f ret tinyint(1) DEFAULT '0' NOT NULL,"
204
c_f="$c_f dl char(128) DEFAULT '' NOT NULL,"
205
c_f="$c_f type enum ('function','aggregate') COLLATE utf8_general_ci NOT NULL,"
206
c_f="$c_f PRIMARY KEY (name)"
207
c_f="$c_f ) engine=MyISAM"
208
c_f="$c_f CHARACTER SET utf8 COLLATE utf8_bin"
209
c_f="$c_f comment='User defined functions';"
212
if test ! -f $mdata/plugin.frm
214
if test "$1" = "verbose" ; then
215
echo "Preparing plugin table" 1>&2;
218
c_pl="$c_pl CREATE TABLE plugin ("
219
c_pl="$c_pl name char(64) binary DEFAULT '' NOT NULL,"
220
c_pl="$c_pl dl char(128) DEFAULT '' NOT NULL,"
221
c_pl="$c_pl PRIMARY KEY (name)"
222
c_pl="$c_pl ) engine=MyISAM"
223
c_pl="$c_pl CHARACTER SET utf8 COLLATE utf8_bin"
224
c_pl="$c_pl comment='MySQL plugins';"
226
i_pl="INSERT INTO plugin VALUES ('pbxt', 'libpbxt.so');"
229
if test ! -f $mdata/tables_priv.frm
231
if test "$1" = "verbose" ; then
232
echo "Preparing tables_priv table" 1>&2;
235
c_t="$c_t CREATE TABLE tables_priv ("
236
c_t="$c_t Host char(60) binary DEFAULT '' NOT NULL,"
237
c_t="$c_t Db char(64) binary DEFAULT '' NOT NULL,"
238
c_t="$c_t User char(16) binary DEFAULT '' NOT NULL,"
239
c_t="$c_t Table_name char(64) binary DEFAULT '' NOT NULL,"
240
c_t="$c_t Grantor char(77) DEFAULT '' NOT NULL,"
241
c_t="$c_t Timestamp timestamp,"
242
c_t="$c_t Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') COLLATE utf8_general_ci DEFAULT '' NOT NULL,"
243
c_t="$c_t Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL,"
244
c_t="$c_t PRIMARY KEY (Host,Db,User,Table_name),"
245
c_t="$c_t KEY Grantor (Grantor)"
246
c_t="$c_t ) engine=MyISAM"
247
c_t="$c_t CHARACTER SET utf8 COLLATE utf8_bin"
248
c_t="$c_t comment='Table privileges';"
251
if test ! -f $mdata/columns_priv.frm
253
if test "$1" = "verbose" ; then
254
echo "Preparing columns_priv table" 1>&2;
257
c_c="$c_c CREATE TABLE columns_priv ("
258
c_c="$c_c Host char(60) binary DEFAULT '' NOT NULL,"
259
c_c="$c_c Db char(64) binary DEFAULT '' NOT NULL,"
260
c_c="$c_c User char(16) binary DEFAULT '' NOT NULL,"
261
c_c="$c_c Table_name char(64) binary DEFAULT '' NOT NULL,"
262
c_c="$c_c Column_name char(64) binary DEFAULT '' NOT NULL,"
263
c_c="$c_c Timestamp timestamp,"
264
c_c="$c_c Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL,"
265
c_c="$c_c PRIMARY KEY (Host,Db,User,Table_name,Column_name)"
266
c_c="$c_c ) engine=MyISAM"
267
c_c="$c_c CHARACTER SET utf8 COLLATE utf8_bin"
268
c_c="$c_c comment='Column privileges';"
271
if test ! -f $mdata/procs_priv.frm
273
if test "$1" = "verbose" ; then
274
echo "Preparing procs_priv table" 1>&2;
277
c_pp="$c_pp CREATE TABLE procs_priv ("
278
c_pp="$c_pp Host char(60) binary DEFAULT '' NOT NULL,"
279
c_pp="$c_pp Db char(64) binary DEFAULT '' NOT NULL,"
280
c_pp="$c_pp User char(16) binary DEFAULT '' NOT NULL,"
281
c_pp="$c_pp Routine_name char(64) binary DEFAULT '' NOT NULL,"
282
c_pp="$c_pp Routine_type enum('FUNCTION','PROCEDURE') NOT NULL,"
283
c_pp="$c_pp Grantor char(77) DEFAULT '' NOT NULL,"
284
c_pp="$c_pp Proc_priv set('Execute','Alter Routine','Grant') COLLATE utf8_general_ci DEFAULT '' NOT NULL,"
285
c_pp="$c_pp Timestamp timestamp,"
286
c_pp="$c_pp PRIMARY KEY (Host,Db,User,Routine_name,Routine_type),"
287
c_pp="$c_pp KEY Grantor (Grantor)"
288
c_pp="$c_pp ) engine=MyISAM"
289
c_pp="$c_pp CHARACTER SET utf8 COLLATE utf8_bin"
290
c_pp="$c_pp comment='Procedure privileges';"
293
if test ! -f $mdata/help_topic.frm
295
if test "$1" = "verbose" ; then
296
echo "Preparing help_topic table" 1>&2;
299
c_ht="$c_ht CREATE TABLE help_topic ("
300
c_ht="$c_ht help_topic_id int unsigned not null,"
301
c_ht="$c_ht name char(64) not null,"
302
c_ht="$c_ht help_category_id smallint unsigned not null,"
303
c_ht="$c_ht description text not null,"
304
c_ht="$c_ht example text not null,"
305
c_ht="$c_ht url char(128) not null,"
306
c_ht="$c_ht primary key (help_topic_id),"
307
c_ht="$c_ht unique index (name)"
308
c_ht="$c_ht ) engine=MyISAM"
309
c_ht="$c_ht CHARACTER SET utf8"
310
c_ht="$c_ht comment='help topics';"
315
if test ! -f $mdata/help_category.frm
317
if test "$1" = "verbose" ; then
318
echo "Preparing help_category table" 1>&2;
321
c_hc="$c_hc CREATE TABLE help_category ("
322
c_hc="$c_hc help_category_id smallint unsigned not null,"
323
c_hc="$c_hc name char(64) not null,"
324
c_hc="$c_hc parent_category_id smallint unsigned null,"
325
c_hc="$c_hc url char(128) not null,"
326
c_hc="$c_hc primary key (help_category_id),"
327
c_hc="$c_hc unique index (name)"
328
c_hc="$c_hc ) engine=MyISAM"
329
c_hc="$c_hc CHARACTER SET utf8"
330
c_hc="$c_hc comment='help categories';"
333
if test ! -f $mdata/help_keyword.frm
335
if test "$1" = "verbose" ; then
336
echo "Preparing help_keyword table" 1>&2;
339
c_hk="$c_hk CREATE TABLE help_keyword ("
340
c_hk="$c_hk help_keyword_id int unsigned not null,"
341
c_hk="$c_hk name char(64) not null,"
342
c_hk="$c_hk primary key (help_keyword_id),"
343
c_hk="$c_hk unique index (name)"
344
c_hk="$c_hk ) engine=MyISAM"
345
c_hk="$c_hk CHARACTER SET utf8"
346
c_hk="$c_hk comment='help keywords';"
349
if test ! -f $mdata/help_relation.frm
351
if test "$1" = "verbose" ; then
352
echo "Preparing help_relation table" 1>&2;
355
c_hr="$c_hr CREATE TABLE help_relation ("
356
c_hr="$c_hr help_topic_id int unsigned not null references help_topic,"
357
c_hr="$c_hr help_keyword_id int unsigned not null references help_keyword,"
358
c_hr="$c_hr primary key (help_keyword_id, help_topic_id)"
359
c_hr="$c_hr ) engine=MyISAM"
360
c_hr="$c_hr CHARACTER SET utf8"
361
c_hr="$c_hr comment='keyword-topic relation';"
365
if test ! -f $mdata/time_zone_name.frm
367
if test "$1" = "verbose" ; then
368
echo "Preparing time_zone_name table" 1>&2;
371
c_tzn="$c_tzn CREATE TABLE time_zone_name ("
372
c_tzn="$c_tzn Name char(64) NOT NULL,"
373
c_tzn="$c_tzn Time_zone_id int unsigned NOT NULL,"
374
c_tzn="$c_tzn PRIMARY KEY Name (Name)"
375
c_tzn="$c_tzn ) engine=MyISAM CHARACTER SET utf8"
376
c_tzn="$c_tzn comment='Time zone names';"
378
if test "$1" = "test"
380
i_tzn="$i_tzn INSERT INTO time_zone_name (Name, Time_Zone_id) VALUES"
381
i_tzn="$i_tzn ('MET', 1), ('UTC', 2), ('Universal', 2), "
382
i_tzn="$i_tzn ('Europe/Moscow',3), ('leap/Europe/Moscow',4), "
383
i_tzn="$i_tzn ('Japan', 5);"
387
if test ! -f $mdata/time_zone.frm
389
if test "$1" = "verbose" ; then
390
echo "Preparing time_zone table" 1>&2;
393
c_tz="$c_tz CREATE TABLE time_zone ("
394
c_tz="$c_tz Time_zone_id int unsigned NOT NULL auto_increment,"
395
c_tz="$c_tz Use_leap_seconds enum('Y','N') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
396
c_tz="$c_tz PRIMARY KEY TzId (Time_zone_id)"
397
c_tz="$c_tz ) engine=MyISAM CHARACTER SET utf8"
398
c_tz="$c_tz comment='Time zones';"
400
if test "$1" = "test"
402
i_tz="$i_tz INSERT INTO time_zone (Time_zone_id, Use_leap_seconds)"
403
i_tz="$i_tz VALUES (1,'N'), (2,'N'), (3,'N'), (4,'Y'), (5,'N');"
407
if test ! -f $mdata/time_zone_transition.frm
409
if test "$1" = "verbose" ; then
410
echo "Preparing time_zone_transition table" 1>&2;
413
c_tzt="$c_tzt CREATE TABLE time_zone_transition ("
414
c_tzt="$c_tzt Time_zone_id int unsigned NOT NULL,"
415
c_tzt="$c_tzt Transition_time bigint signed NOT NULL,"
416
c_tzt="$c_tzt Transition_type_id int unsigned NOT NULL,"
417
c_tzt="$c_tzt PRIMARY KEY TzIdTranTime (Time_zone_id, Transition_time)"
418
c_tzt="$c_tzt ) engine=MyISAM CHARACTER SET utf8"
419
c_tzt="$c_tzt comment='Time zone transitions';"
421
if test "$1" = "test"
423
i_tzt="$i_tzt INSERT INTO time_zone_transition"
424
i_tzt="$i_tzt (Time_zone_id, Transition_time, Transition_type_id)"
425
i_tzt="$i_tzt VALUES"
426
i_tzt="$i_tzt (1, -1693706400, 0) ,(1, -1680483600, 1)"
427
i_tzt="$i_tzt ,(1, -1663455600, 2) ,(1, -1650150000, 3)"
428
i_tzt="$i_tzt ,(1, -1632006000, 2) ,(1, -1618700400, 3)"
429
i_tzt="$i_tzt ,(1, -938905200, 2) ,(1, -857257200, 3)"
430
i_tzt="$i_tzt ,(1, -844556400, 2) ,(1, -828226800, 3)"
431
i_tzt="$i_tzt ,(1, -812502000, 2) ,(1, -796777200, 3)"
432
i_tzt="$i_tzt ,(1, 228877200, 2) ,(1, 243997200, 3)"
433
i_tzt="$i_tzt ,(1, 260326800, 2) ,(1, 276051600, 3)"
434
i_tzt="$i_tzt ,(1, 291776400, 2) ,(1, 307501200, 3)"
435
i_tzt="$i_tzt ,(1, 323830800, 2) ,(1, 338950800, 3)"
436
i_tzt="$i_tzt ,(1, 354675600, 2) ,(1, 370400400, 3)"
437
i_tzt="$i_tzt ,(1, 386125200, 2) ,(1, 401850000, 3)"
438
i_tzt="$i_tzt ,(1, 417574800, 2) ,(1, 433299600, 3)"
439
i_tzt="$i_tzt ,(1, 449024400, 2) ,(1, 465354000, 3)"
440
i_tzt="$i_tzt ,(1, 481078800, 2) ,(1, 496803600, 3)"
441
i_tzt="$i_tzt ,(1, 512528400, 2) ,(1, 528253200, 3)"
442
i_tzt="$i_tzt ,(1, 543978000, 2) ,(1, 559702800, 3)"
443
i_tzt="$i_tzt ,(1, 575427600, 2) ,(1, 591152400, 3)"
444
i_tzt="$i_tzt ,(1, 606877200, 2) ,(1, 622602000, 3)"
445
i_tzt="$i_tzt ,(1, 638326800, 2) ,(1, 654656400, 3)"
446
i_tzt="$i_tzt ,(1, 670381200, 2) ,(1, 686106000, 3)"
447
i_tzt="$i_tzt ,(1, 701830800, 2) ,(1, 717555600, 3)"
448
i_tzt="$i_tzt ,(1, 733280400, 2) ,(1, 749005200, 3)"
449
i_tzt="$i_tzt ,(1, 764730000, 2) ,(1, 780454800, 3)"
450
i_tzt="$i_tzt ,(1, 796179600, 2) ,(1, 811904400, 3)"
451
i_tzt="$i_tzt ,(1, 828234000, 2) ,(1, 846378000, 3)"
452
i_tzt="$i_tzt ,(1, 859683600, 2) ,(1, 877827600, 3)"
453
i_tzt="$i_tzt ,(1, 891133200, 2) ,(1, 909277200, 3)"
454
i_tzt="$i_tzt ,(1, 922582800, 2) ,(1, 941331600, 3)"
455
i_tzt="$i_tzt ,(1, 954032400, 2) ,(1, 972781200, 3)"
456
i_tzt="$i_tzt ,(1, 985482000, 2) ,(1, 1004230800, 3)"
457
i_tzt="$i_tzt ,(1, 1017536400, 2) ,(1, 1035680400, 3)"
458
i_tzt="$i_tzt ,(1, 1048986000, 2) ,(1, 1067130000, 3)"
459
i_tzt="$i_tzt ,(1, 1080435600, 2) ,(1, 1099184400, 3)"
460
i_tzt="$i_tzt ,(1, 1111885200, 2) ,(1, 1130634000, 3)"
461
i_tzt="$i_tzt ,(1, 1143334800, 2) ,(1, 1162083600, 3)"
462
i_tzt="$i_tzt ,(1, 1174784400, 2) ,(1, 1193533200, 3)"
463
i_tzt="$i_tzt ,(1, 1206838800, 2) ,(1, 1224982800, 3)"
464
i_tzt="$i_tzt ,(1, 1238288400, 2) ,(1, 1256432400, 3)"
465
i_tzt="$i_tzt ,(1, 1269738000, 2) ,(1, 1288486800, 3)"
466
i_tzt="$i_tzt ,(1, 1301187600, 2) ,(1, 1319936400, 3)"
467
i_tzt="$i_tzt ,(1, 1332637200, 2) ,(1, 1351386000, 3)"
468
i_tzt="$i_tzt ,(1, 1364691600, 2) ,(1, 1382835600, 3)"
469
i_tzt="$i_tzt ,(1, 1396141200, 2) ,(1, 1414285200, 3)"
470
i_tzt="$i_tzt ,(1, 1427590800, 2) ,(1, 1445734800, 3)"
471
i_tzt="$i_tzt ,(1, 1459040400, 2) ,(1, 1477789200, 3)"
472
i_tzt="$i_tzt ,(1, 1490490000, 2) ,(1, 1509238800, 3)"
473
i_tzt="$i_tzt ,(1, 1521939600, 2) ,(1, 1540688400, 3)"
474
i_tzt="$i_tzt ,(1, 1553994000, 2) ,(1, 1572138000, 3)"
475
i_tzt="$i_tzt ,(1, 1585443600, 2) ,(1, 1603587600, 3)"
476
i_tzt="$i_tzt ,(1, 1616893200, 2) ,(1, 1635642000, 3)"
477
i_tzt="$i_tzt ,(1, 1648342800, 2) ,(1, 1667091600, 3)"
478
i_tzt="$i_tzt ,(1, 1679792400, 2) ,(1, 1698541200, 3)"
479
i_tzt="$i_tzt ,(1, 1711846800, 2) ,(1, 1729990800, 3)"
480
i_tzt="$i_tzt ,(1, 1743296400, 2) ,(1, 1761440400, 3)"
481
i_tzt="$i_tzt ,(1, 1774746000, 2) ,(1, 1792890000, 3)"
482
i_tzt="$i_tzt ,(1, 1806195600, 2) ,(1, 1824944400, 3)"
483
i_tzt="$i_tzt ,(1, 1837645200, 2) ,(1, 1856394000, 3)"
484
i_tzt="$i_tzt ,(1, 1869094800, 2) ,(1, 1887843600, 3)"
485
i_tzt="$i_tzt ,(1, 1901149200, 2) ,(1, 1919293200, 3)"
486
i_tzt="$i_tzt ,(1, 1932598800, 2) ,(1, 1950742800, 3)"
487
i_tzt="$i_tzt ,(1, 1964048400, 2) ,(1, 1982797200, 3)"
488
i_tzt="$i_tzt ,(1, 1995498000, 2) ,(1, 2014246800, 3)"
489
i_tzt="$i_tzt ,(1, 2026947600, 2) ,(1, 2045696400, 3)"
490
i_tzt="$i_tzt ,(1, 2058397200, 2) ,(1, 2077146000, 3)"
491
i_tzt="$i_tzt ,(1, 2090451600, 2) ,(1, 2108595600, 3)"
492
i_tzt="$i_tzt ,(1, 2121901200, 2) ,(1, 2140045200, 3)"
493
i_tzt="$i_tzt ,(3, -1688265000, 2) ,(3, -1656819048, 1)"
494
i_tzt="$i_tzt ,(3, -1641353448, 2) ,(3, -1627965048, 3)"
495
i_tzt="$i_tzt ,(3, -1618716648, 1) ,(3, -1596429048, 3)"
496
i_tzt="$i_tzt ,(3, -1593829848, 5) ,(3, -1589860800, 4)"
497
i_tzt="$i_tzt ,(3, -1542427200, 5) ,(3, -1539493200, 6)"
498
i_tzt="$i_tzt ,(3, -1525323600, 5) ,(3, -1522728000, 4)"
499
i_tzt="$i_tzt ,(3, -1491188400, 7) ,(3, -1247536800, 4)"
500
i_tzt="$i_tzt ,(3, 354920400, 5) ,(3, 370728000, 4)"
501
i_tzt="$i_tzt ,(3, 386456400, 5) ,(3, 402264000, 4)"
502
i_tzt="$i_tzt ,(3, 417992400, 5) ,(3, 433800000, 4)"
503
i_tzt="$i_tzt ,(3, 449614800, 5) ,(3, 465346800, 8)"
504
i_tzt="$i_tzt ,(3, 481071600, 9) ,(3, 496796400, 8)"
505
i_tzt="$i_tzt ,(3, 512521200, 9) ,(3, 528246000, 8)"
506
i_tzt="$i_tzt ,(3, 543970800, 9) ,(3, 559695600, 8)"
507
i_tzt="$i_tzt ,(3, 575420400, 9) ,(3, 591145200, 8)"
508
i_tzt="$i_tzt ,(3, 606870000, 9) ,(3, 622594800, 8)"
509
i_tzt="$i_tzt ,(3, 638319600, 9) ,(3, 654649200, 8)"
510
i_tzt="$i_tzt ,(3, 670374000, 10) ,(3, 686102400, 11)"
511
i_tzt="$i_tzt ,(3, 695779200, 8) ,(3, 701812800, 5)"
512
i_tzt="$i_tzt ,(3, 717534000, 4) ,(3, 733273200, 9)"
513
i_tzt="$i_tzt ,(3, 748998000, 8) ,(3, 764722800, 9)"
514
i_tzt="$i_tzt ,(3, 780447600, 8) ,(3, 796172400, 9)"
515
i_tzt="$i_tzt ,(3, 811897200, 8) ,(3, 828226800, 9)"
516
i_tzt="$i_tzt ,(3, 846370800, 8) ,(3, 859676400, 9)"
517
i_tzt="$i_tzt ,(3, 877820400, 8) ,(3, 891126000, 9)"
518
i_tzt="$i_tzt ,(3, 909270000, 8) ,(3, 922575600, 9)"
519
i_tzt="$i_tzt ,(3, 941324400, 8) ,(3, 954025200, 9)"
520
i_tzt="$i_tzt ,(3, 972774000, 8) ,(3, 985474800, 9)"
521
i_tzt="$i_tzt ,(3, 1004223600, 8) ,(3, 1017529200, 9)"
522
i_tzt="$i_tzt ,(3, 1035673200, 8) ,(3, 1048978800, 9)"
523
i_tzt="$i_tzt ,(3, 1067122800, 8) ,(3, 1080428400, 9)"
524
i_tzt="$i_tzt ,(3, 1099177200, 8) ,(3, 1111878000, 9)"
525
i_tzt="$i_tzt ,(3, 1130626800, 8) ,(3, 1143327600, 9)"
526
i_tzt="$i_tzt ,(3, 1162076400, 8) ,(3, 1174777200, 9)"
527
i_tzt="$i_tzt ,(3, 1193526000, 8) ,(3, 1206831600, 9)"
528
i_tzt="$i_tzt ,(3, 1224975600, 8) ,(3, 1238281200, 9)"
529
i_tzt="$i_tzt ,(3, 1256425200, 8) ,(3, 1269730800, 9)"
530
i_tzt="$i_tzt ,(3, 1288479600, 8) ,(3, 1301180400, 9)"
531
i_tzt="$i_tzt ,(3, 1319929200, 8) ,(3, 1332630000, 9)"
532
i_tzt="$i_tzt ,(3, 1351378800, 8) ,(3, 1364684400, 9)"
533
i_tzt="$i_tzt ,(3, 1382828400, 8) ,(3, 1396134000, 9)"
534
i_tzt="$i_tzt ,(3, 1414278000, 8) ,(3, 1427583600, 9)"
535
i_tzt="$i_tzt ,(3, 1445727600, 8) ,(3, 1459033200, 9)"
536
i_tzt="$i_tzt ,(3, 1477782000, 8) ,(3, 1490482800, 9)"
537
i_tzt="$i_tzt ,(3, 1509231600, 8) ,(3, 1521932400, 9)"
538
i_tzt="$i_tzt ,(3, 1540681200, 8) ,(3, 1553986800, 9)"
539
i_tzt="$i_tzt ,(3, 1572130800, 8) ,(3, 1585436400, 9)"
540
i_tzt="$i_tzt ,(3, 1603580400, 8) ,(3, 1616886000, 9)"
541
i_tzt="$i_tzt ,(3, 1635634800, 8) ,(3, 1648335600, 9)"
542
i_tzt="$i_tzt ,(3, 1667084400, 8) ,(3, 1679785200, 9)"
543
i_tzt="$i_tzt ,(3, 1698534000, 8) ,(3, 1711839600, 9)"
544
i_tzt="$i_tzt ,(3, 1729983600, 8) ,(3, 1743289200, 9)"
545
i_tzt="$i_tzt ,(3, 1761433200, 8) ,(3, 1774738800, 9)"
546
i_tzt="$i_tzt ,(3, 1792882800, 8) ,(3, 1806188400, 9)"
547
i_tzt="$i_tzt ,(3, 1824937200, 8) ,(3, 1837638000, 9)"
548
i_tzt="$i_tzt ,(3, 1856386800, 8) ,(3, 1869087600, 9)"
549
i_tzt="$i_tzt ,(3, 1887836400, 8) ,(3, 1901142000, 9)"
550
i_tzt="$i_tzt ,(3, 1919286000, 8) ,(3, 1932591600, 9)"
551
i_tzt="$i_tzt ,(3, 1950735600, 8) ,(3, 1964041200, 9)"
552
i_tzt="$i_tzt ,(3, 1982790000, 8) ,(3, 1995490800, 9)"
553
i_tzt="$i_tzt ,(3, 2014239600, 8) ,(3, 2026940400, 9)"
554
i_tzt="$i_tzt ,(3, 2045689200, 8) ,(3, 2058390000, 9)"
555
i_tzt="$i_tzt ,(3, 2077138800, 8) ,(3, 2090444400, 9)"
556
i_tzt="$i_tzt ,(3, 2108588400, 8) ,(3, 2121894000, 9)"
557
i_tzt="$i_tzt ,(3, 2140038000, 8)"
558
i_tzt="$i_tzt ,(4, -1688265000, 2) ,(4, -1656819048, 1)"
559
i_tzt="$i_tzt ,(4, -1641353448, 2) ,(4, -1627965048, 3)"
560
i_tzt="$i_tzt ,(4, -1618716648, 1) ,(4, -1596429048, 3)"
561
i_tzt="$i_tzt ,(4, -1593829848, 5) ,(4, -1589860800, 4)"
562
i_tzt="$i_tzt ,(4, -1542427200, 5) ,(4, -1539493200, 6)"
563
i_tzt="$i_tzt ,(4, -1525323600, 5) ,(4, -1522728000, 4)"
564
i_tzt="$i_tzt ,(4, -1491188400, 7) ,(4, -1247536800, 4)"
565
i_tzt="$i_tzt ,(4, 354920409, 5) ,(4, 370728010, 4)"
566
i_tzt="$i_tzt ,(4, 386456410, 5) ,(4, 402264011, 4)"
567
i_tzt="$i_tzt ,(4, 417992411, 5) ,(4, 433800012, 4)"
568
i_tzt="$i_tzt ,(4, 449614812, 5) ,(4, 465346812, 8)"
569
i_tzt="$i_tzt ,(4, 481071612, 9) ,(4, 496796413, 8)"
570
i_tzt="$i_tzt ,(4, 512521213, 9) ,(4, 528246013, 8)"
571
i_tzt="$i_tzt ,(4, 543970813, 9) ,(4, 559695613, 8)"
572
i_tzt="$i_tzt ,(4, 575420414, 9) ,(4, 591145214, 8)"
573
i_tzt="$i_tzt ,(4, 606870014, 9) ,(4, 622594814, 8)"
574
i_tzt="$i_tzt ,(4, 638319615, 9) ,(4, 654649215, 8)"
575
i_tzt="$i_tzt ,(4, 670374016, 10) ,(4, 686102416, 11)"
576
i_tzt="$i_tzt ,(4, 695779216, 8) ,(4, 701812816, 5)"
577
i_tzt="$i_tzt ,(4, 717534017, 4) ,(4, 733273217, 9)"
578
i_tzt="$i_tzt ,(4, 748998018, 8) ,(4, 764722818, 9)"
579
i_tzt="$i_tzt ,(4, 780447619, 8) ,(4, 796172419, 9)"
580
i_tzt="$i_tzt ,(4, 811897219, 8) ,(4, 828226820, 9)"
581
i_tzt="$i_tzt ,(4, 846370820, 8) ,(4, 859676420, 9)"
582
i_tzt="$i_tzt ,(4, 877820421, 8) ,(4, 891126021, 9)"
583
i_tzt="$i_tzt ,(4, 909270021, 8) ,(4, 922575622, 9)"
584
i_tzt="$i_tzt ,(4, 941324422, 8) ,(4, 954025222, 9)"
585
i_tzt="$i_tzt ,(4, 972774022, 8) ,(4, 985474822, 9)"
586
i_tzt="$i_tzt ,(4, 1004223622, 8) ,(4, 1017529222, 9)"
587
i_tzt="$i_tzt ,(4, 1035673222, 8) ,(4, 1048978822, 9)"
588
i_tzt="$i_tzt ,(4, 1067122822, 8) ,(4, 1080428422, 9)"
589
i_tzt="$i_tzt ,(4, 1099177222, 8) ,(4, 1111878022, 9)"
590
i_tzt="$i_tzt ,(4, 1130626822, 8) ,(4, 1143327622, 9)"
591
i_tzt="$i_tzt ,(4, 1162076422, 8) ,(4, 1174777222, 9)"
592
i_tzt="$i_tzt ,(4, 1193526022, 8) ,(4, 1206831622, 9)"
593
i_tzt="$i_tzt ,(4, 1224975622, 8) ,(4, 1238281222, 9)"
594
i_tzt="$i_tzt ,(4, 1256425222, 8) ,(4, 1269730822, 9)"
595
i_tzt="$i_tzt ,(4, 1288479622, 8) ,(4, 1301180422, 9)"
596
i_tzt="$i_tzt ,(4, 1319929222, 8) ,(4, 1332630022, 9)"
597
i_tzt="$i_tzt ,(4, 1351378822, 8) ,(4, 1364684422, 9)"
598
i_tzt="$i_tzt ,(4, 1382828422, 8) ,(4, 1396134022, 9)"
599
i_tzt="$i_tzt ,(4, 1414278022, 8) ,(4, 1427583622, 9)"
600
i_tzt="$i_tzt ,(4, 1445727622, 8) ,(4, 1459033222, 9)"
601
i_tzt="$i_tzt ,(4, 1477782022, 8) ,(4, 1490482822, 9)"
602
i_tzt="$i_tzt ,(4, 1509231622, 8) ,(4, 1521932422, 9)"
603
i_tzt="$i_tzt ,(4, 1540681222, 8) ,(4, 1553986822, 9)"
604
i_tzt="$i_tzt ,(4, 1572130822, 8) ,(4, 1585436422, 9)"
605
i_tzt="$i_tzt ,(4, 1603580422, 8) ,(4, 1616886022, 9)"
606
i_tzt="$i_tzt ,(4, 1635634822, 8) ,(4, 1648335622, 9)"
607
i_tzt="$i_tzt ,(4, 1667084422, 8) ,(4, 1679785222, 9)"
608
i_tzt="$i_tzt ,(4, 1698534022, 8) ,(4, 1711839622, 9)"
609
i_tzt="$i_tzt ,(4, 1729983622, 8) ,(4, 1743289222, 9)"
610
i_tzt="$i_tzt ,(4, 1761433222, 8) ,(4, 1774738822, 9)"
611
i_tzt="$i_tzt ,(4, 1792882822, 8) ,(4, 1806188422, 9)"
612
i_tzt="$i_tzt ,(4, 1824937222, 8) ,(4, 1837638022, 9)"
613
i_tzt="$i_tzt ,(4, 1856386822, 8) ,(4, 1869087622, 9)"
614
i_tzt="$i_tzt ,(4, 1887836422, 8) ,(4, 1901142022, 9)"
615
i_tzt="$i_tzt ,(4, 1919286022, 8) ,(4, 1932591622, 9)"
616
i_tzt="$i_tzt ,(4, 1950735622, 8) ,(4, 1964041222, 9)"
617
i_tzt="$i_tzt ,(4, 1982790022, 8) ,(4, 1995490822, 9)"
618
i_tzt="$i_tzt ,(4, 2014239622, 8) ,(4, 2026940422, 9)"
619
i_tzt="$i_tzt ,(4, 2045689222, 8) ,(4, 2058390022, 9)"
620
i_tzt="$i_tzt ,(4, 2077138822, 8) ,(4, 2090444422, 9)"
621
i_tzt="$i_tzt ,(4, 2108588422, 8) ,(4, 2121894022, 9)"
622
i_tzt="$i_tzt ,(4, 2140038022, 8)"
623
i_tzt="$i_tzt ,(5, -1009875600, 1);"
627
if test ! -f $mdata/time_zone_transition_type.frm
629
if test "$1" = "verbose" ; then
630
echo "Preparing time_zone_transition_type table" 1>&2;
633
c_tztt="$c_tztt CREATE TABLE time_zone_transition_type ("
634
c_tztt="$c_tztt Time_zone_id int unsigned NOT NULL,"
635
c_tztt="$c_tztt Transition_type_id int unsigned NOT NULL,"
636
c_tztt="$c_tztt Offset int signed DEFAULT 0 NOT NULL,"
637
c_tztt="$c_tztt Is_DST tinyint unsigned DEFAULT 0 NOT NULL,"
638
c_tztt="$c_tztt Abbreviation char(8) DEFAULT '' NOT NULL,"
639
c_tztt="$c_tztt PRIMARY KEY TzIdTrTId (Time_zone_id, Transition_type_id)"
640
c_tztt="$c_tztt ) engine=MyISAM CHARACTER SET utf8"
641
c_tztt="$c_tztt comment='Time zone transition types';"
643
if test "$1" = "test"
645
i_tztt="$i_tztt INSERT INTO time_zone_transition_type (Time_zone_id,"
646
i_tztt="$i_tztt Transition_type_id, Offset, Is_DST, Abbreviation) VALUES"
647
i_tztt="$i_tztt (1, 0, 7200, 1, 'MEST') ,(1, 1, 3600, 0, 'MET')"
648
i_tztt="$i_tztt ,(1, 2, 7200, 1, 'MEST') ,(1, 3, 3600, 0, 'MET')"
649
i_tztt="$i_tztt ,(2, 0, 0, 0, 'UTC')"
650
i_tztt="$i_tztt ,(3, 0, 9000, 0, 'MMT') ,(3, 1, 12648, 1, 'MST')"
651
i_tztt="$i_tztt ,(3, 2, 9048, 0, 'MMT') ,(3, 3, 16248, 1, 'MDST')"
652
i_tztt="$i_tztt ,(3, 4, 10800, 0, 'MSK') ,(3, 5, 14400, 1, 'MSD')"
653
i_tztt="$i_tztt ,(3, 6, 18000, 1, 'MSD') ,(3, 7, 7200, 0, 'EET')"
654
i_tztt="$i_tztt ,(3, 8, 10800, 0, 'MSK') ,(3, 9, 14400, 1, 'MSD')"
655
i_tztt="$i_tztt ,(3, 10, 10800, 1, 'EEST') ,(3, 11, 7200, 0, 'EET')"
656
i_tztt="$i_tztt ,(4, 0, 9000, 0, 'MMT') ,(4, 1, 12648, 1, 'MST')"
657
i_tztt="$i_tztt ,(4, 2, 9048, 0, 'MMT') ,(4, 3, 16248, 1, 'MDST')"
658
i_tztt="$i_tztt ,(4, 4, 10800, 0, 'MSK') ,(4, 5, 14400, 1, 'MSD')"
659
i_tztt="$i_tztt ,(4, 6, 18000, 1, 'MSD') ,(4, 7, 7200, 0, 'EET')"
660
i_tztt="$i_tztt ,(4, 8, 10800, 0, 'MSK') ,(4, 9, 14400, 1, 'MSD')"
661
i_tztt="$i_tztt ,(4, 10, 10800, 1, 'EEST') ,(4, 11, 7200, 0, 'EET')"
662
i_tztt="$i_tztt ,(5, 0, 32400, 0, 'CJT') ,(5, 1, 32400, 0, 'JST');"
666
if test ! -f $mdata/time_zone_leap_second.frm
668
if test "$1" = "verbose" ; then
669
echo "Preparing time_zone_leap_second table" 1>&2;
672
c_tzls="$c_tzls CREATE TABLE time_zone_leap_second ("
673
c_tzls="$c_tzls Transition_time bigint signed NOT NULL,"
674
c_tzls="$c_tzls Correction int signed NOT NULL,"
675
c_tzls="$c_tzls PRIMARY KEY TranTime (Transition_time)"
676
c_tzls="$c_tzls ) engine=MyISAM CHARACTER SET utf8"
677
c_tzls="$c_tzls comment='Leap seconds information for time zones';"
679
if test "$1" = "test"
681
i_tzls="$i_tzls INSERT INTO time_zone_leap_second "
682
i_tzls="$i_tzls (Transition_time, Correction) VALUES "
683
i_tzls="$i_tzls (78796800, 1) ,(94694401, 2) ,(126230402, 3)"
684
i_tzls="$i_tzls ,(157766403, 4) ,(189302404, 5) ,(220924805, 6)"
685
i_tzls="$i_tzls ,(252460806, 7) ,(283996807, 8) ,(315532808, 9)"
686
i_tzls="$i_tzls ,(362793609, 10) ,(394329610, 11) ,(425865611, 12)"
687
i_tzls="$i_tzls ,(489024012, 13) ,(567993613, 14) ,(631152014, 15)"
688
i_tzls="$i_tzls ,(662688015, 16) ,(709948816, 17) ,(741484817, 18)"
689
i_tzls="$i_tzls ,(773020818, 19) ,(820454419, 20) ,(867715220, 21)"
690
i_tzls="$i_tzls ,(915148821, 22);"
694
if test ! -f $mdata/proc.frm
696
c_p="$c_p CREATE TABLE proc ("
697
c_p="$c_p db char(64) collate utf8_bin DEFAULT '' NOT NULL,"
698
c_p="$c_p name char(64) DEFAULT '' NOT NULL,"
699
c_p="$c_p type enum('FUNCTION','PROCEDURE') NOT NULL,"
700
c_p="$c_p specific_name char(64) DEFAULT '' NOT NULL,"
701
c_p="$c_p language enum('SQL') DEFAULT 'SQL' NOT NULL,"
702
c_p="$c_p sql_data_access enum('CONTAINS_SQL',"
704
c_p="$c_p 'READS_SQL_DATA',"
705
c_p="$c_p 'MODIFIES_SQL_DATA'"
706
c_p="$c_p ) DEFAULT 'CONTAINS_SQL' NOT NULL,"
707
c_p="$c_p is_deterministic enum('YES','NO') DEFAULT 'NO' NOT NULL,"
708
c_p="$c_p security_type enum('INVOKER','DEFINER') DEFAULT 'DEFINER' NOT NULL,"
709
c_p="$c_p param_list blob DEFAULT '' NOT NULL,"
710
c_p="$c_p returns char(64) DEFAULT '' NOT NULL,"
711
c_p="$c_p body longblob DEFAULT '' NOT NULL,"
712
c_p="$c_p definer char(77) collate utf8_bin DEFAULT '' NOT NULL,"
713
c_p="$c_p created timestamp,"
714
c_p="$c_p modified timestamp,"
715
c_p="$c_p sql_mode set("
716
c_p="$c_p 'REAL_AS_FLOAT',"
717
c_p="$c_p 'PIPES_AS_CONCAT',"
718
c_p="$c_p 'ANSI_QUOTES',"
719
c_p="$c_p 'IGNORE_SPACE',"
720
c_p="$c_p 'NOT_USED',"
721
c_p="$c_p 'ONLY_FULL_GROUP_BY',"
722
c_p="$c_p 'NO_UNSIGNED_SUBTRACTION',"
723
c_p="$c_p 'NO_DIR_IN_CREATE',"
724
c_p="$c_p 'POSTGRESQL',"
729
c_p="$c_p 'NO_KEY_OPTIONS',"
730
c_p="$c_p 'NO_TABLE_OPTIONS',"
731
c_p="$c_p 'NO_FIELD_OPTIONS',"
732
c_p="$c_p 'MYSQL323',"
733
c_p="$c_p 'MYSQL40',"
735
c_p="$c_p 'NO_AUTO_VALUE_ON_ZERO',"
736
c_p="$c_p 'NO_BACKSLASH_ESCAPES',"
737
c_p="$c_p 'STRICT_TRANS_TABLES',"
738
c_p="$c_p 'STRICT_ALL_TABLES',"
739
c_p="$c_p 'NO_ZERO_IN_DATE',"
740
c_p="$c_p 'NO_ZERO_DATE',"
741
c_p="$c_p 'INVALID_DATES',"
742
c_p="$c_p 'ERROR_FOR_DIVISION_BY_ZERO',"
743
c_p="$c_p 'TRADITIONAL',"
744
c_p="$c_p 'NO_AUTO_CREATE_USER',"
745
c_p="$c_p 'HIGH_NOT_PRECEDENCE'"
746
c_p="$c_p ) DEFAULT '' NOT NULL,"
747
c_p="$c_p comment char(64) collate utf8_bin DEFAULT '' NOT NULL,"
748
c_p="$c_p PRIMARY KEY (db,name,type)"
749
c_p="$c_p ) engine=MyISAM"
750
c_p="$c_p character set utf8"
751
c_p="$c_p comment='Stored Procedures';"
755
if test ! -f $mdata/general_log.frm
757
if test "$1" = "verbose" ; then
758
echo "Preparing general_log table" 1>&2;
760
c_gl="$c_gl CREATE PROCEDURE create_general_log_table() BEGIN DECLARE is_csv_enabled int DEFAULT 0; SELECT @@have_csv = 'YES' INTO is_csv_enabled; IF (is_csv_enabled) THEN CREATE TABLE general_log (event_time TIMESTAMP NOT NULL, user_host MEDIUMTEXT, thread_id INTEGER, server_id INTEGER, command_type VARCHAR(64), argument MEDIUMTEXT) engine=CSV CHARACTER SET utf8 comment='General log'; END IF; END;
761
CALL create_general_log_table();
762
DROP PROCEDURE create_general_log_table;"
766
if test ! -f $mdata/slow_log.frm
768
if test "$1" = "verbose" ; then
769
echo "Preparing slow_log table" 1>&2;
771
c_sl="$c_sl CREATE PROCEDURE create_slow_log_table() BEGIN DECLARE is_csv_enabled int DEFAULT 0; SELECT @@have_csv = 'YES' INTO is_csv_enabled; IF (is_csv_enabled) THEN CREATE TABLE slow_log (start_time TIMESTAMP NOT NULL, user_host MEDIUMTEXT NOT NULL, query_time TIME NOT NULL, lock_time TIME NOT NULL, rows_sent INTEGER NOT NULL, rows_examined INTEGER NOT NULL, db VARCHAR(512), last_insert_id INTEGER, insert_id INTEGER, server_id INTEGER, sql_text MEDIUMTEXT NOT NULL) engine=CSV CHARACTER SET utf8 comment='Slow log'; END IF; END;
772
CALL create_slow_log_table();
773
DROP PROCEDURE create_slow_log_table;"
776
if test ! -f $mdata/event.frm
778
c_ev="$c_ev CREATE TABLE event ("
779
c_ev="$c_ev db char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',"
780
c_ev="$c_ev name char(64) CHARACTER SET utf8 NOT NULL default '',"
781
c_ev="$c_ev body longblob NOT NULL,"
782
c_ev="$c_ev definer char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',"
783
c_ev="$c_ev execute_at DATETIME default NULL,"
784
c_ev="$c_ev interval_value int(11) default NULL,"
785
c_ev="$c_ev interval_field ENUM('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK',"
786
c_ev="$c_ev 'SECOND','MICROSECOND', 'YEAR_MONTH','DAY_HOUR',"
787
c_ev="$c_ev 'DAY_MINUTE','DAY_SECOND',"
788
c_ev="$c_ev 'HOUR_MINUTE','HOUR_SECOND',"
789
c_ev="$c_ev 'MINUTE_SECOND','DAY_MICROSECOND',"
790
c_ev="$c_ev 'HOUR_MICROSECOND','MINUTE_MICROSECOND',"
791
c_ev="$c_ev 'SECOND_MICROSECOND') default NULL,"
792
c_ev="$c_ev created TIMESTAMP NOT NULL,"
793
c_ev="$c_ev modified TIMESTAMP NOT NULL,"
794
c_ev="$c_ev last_executed DATETIME default NULL,"
795
c_ev="$c_ev starts DATETIME default NULL,"
796
c_ev="$c_ev ends DATETIME default NULL,"
797
c_ev="$c_ev status ENUM('ENABLED','DISABLED') NOT NULL default 'ENABLED',"
798
c_ev="$c_ev on_completion ENUM('DROP','PRESERVE') NOT NULL default 'DROP',"
799
c_ev="$c_ev sql_mode set("
800
c_ev="$c_ev 'REAL_AS_FLOAT',"
801
c_ev="$c_ev 'PIPES_AS_CONCAT',"
802
c_ev="$c_ev 'ANSI_QUOTES',"
803
c_ev="$c_ev 'IGNORE_SPACE',"
804
c_ev="$c_ev 'NOT_USED',"
805
c_ev="$c_ev 'ONLY_FULL_GROUP_BY',"
806
c_ev="$c_ev 'NO_UNSIGNED_SUBTRACTION',"
807
c_ev="$c_ev 'NO_DIR_IN_CREATE',"
808
c_ev="$c_ev 'POSTGRESQL',"
809
c_ev="$c_ev 'ORACLE',"
810
c_ev="$c_ev 'MSSQL',"
812
c_ev="$c_ev 'MAXDB',"
813
c_ev="$c_ev 'NO_KEY_OPTIONS',"
814
c_ev="$c_ev 'NO_TABLE_OPTIONS',"
815
c_ev="$c_ev 'NO_FIELD_OPTIONS',"
816
c_ev="$c_ev 'MYSQL323',"
817
c_ev="$c_ev 'MYSQL40',"
819
c_ev="$c_ev 'NO_AUTO_VALUE_ON_ZERO',"
820
c_ev="$c_ev 'NO_BACKSLASH_ESCAPES',"
821
c_ev="$c_ev 'STRICT_TRANS_TABLES',"
822
c_ev="$c_ev 'STRICT_ALL_TABLES',"
823
c_ev="$c_ev 'NO_ZERO_IN_DATE',"
824
c_ev="$c_ev 'NO_ZERO_DATE',"
825
c_ev="$c_ev 'INVALID_DATES',"
826
c_ev="$c_ev 'ERROR_FOR_DIVISION_BY_ZERO',"
827
c_ev="$c_ev 'TRADITIONAL',"
828
c_ev="$c_ev 'NO_AUTO_CREATE_USER',"
829
c_ev="$c_ev 'HIGH_NOT_PRECEDENCE'"
830
c_ev="$c_ev ) DEFAULT '' NOT NULL,"
831
c_ev="$c_ev comment char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',"
832
c_ev="$c_ev PRIMARY KEY (db, name)"
833
c_ev="$c_ev ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT 'Events';"
838
set storage_engine=myisam;
879
CREATE DATABASE IF NOT EXISTS cluster;
880
CREATE TABLE IF NOT EXISTS cluster.binlog_index (Position BIGINT UNSIGNED NOT NULL, File VARCHAR(255) NOT NULL, epoch BIGINT UNSIGNED NOT NULL, inserts BIGINT UNSIGNED NOT NULL, updates BIGINT UNSIGNED NOT NULL, deletes BIGINT UNSIGNED NOT NULL, schemaops BIGINT UNSIGNED NOT NULL, PRIMARY KEY(epoch)) ENGINE=MYISAM;