Skip to content

M
MariaDB
Switch branch/tag
Find file Normal viewHistoryPermalink
mysql_create_system_tables.sh 41.3 KB
Newer Older
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
1 
#!/bin/sh
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
2 
# Copyright (C) 1997-2003 MySQL AB
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
3 4 5 6 7 8 9 10 11 12 13 
# For a more info consult the file COPYRIGHT distributed with this file

# This script writes on stdout SQL commands to generate all not
# existing MySQL system tables. It also replaces the help tables with
# new context from the manual (from fill_help_tables.sql).

# $1 - "test" or "real" or "verbose" variant of database
# $2 - path to mysql-database directory
# $3 - hostname  
# $4 - windows option
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
14 
if test "$1" = ""
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
15 16 17 18 19 20 21 
then
  echo "
This script writes on stdout SQL commands to generate all not
existing MySQL system tables. It also replaces the help tables with
new context from the manual (from fill_help_tables.sql).

Usage:
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
22 23 24 
  mysql_create_system_tables [test|verbose|real] <path to mysql-database directory> <hostname> <windows option>
"
  exit
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 
fi

mdata=$2
hostname=$3
windows=$4

# Initialize variables
c_d="" i_d=""
c_h="" i_h=""
c_u="" i_u=""
c_f="" i_f=""
c_t="" c_c=""
c_ht=""
c_hc=""
c_hr="" 
c_hk="" 
i_ht=""
svoj@poseidon.ndb.mysql.com's avatar
WL#2575 - Fulltext: Parser plugin for FTS  
svoj@poseidon.ndb.mysql.com committed
42 43 
c_tzn="" c_tz="" c_tzt="" c_tztt="" c_tzls="" c_pl=""
i_tzn="" i_tz="" i_tzt="" i_tztt="" i_tzls="" i_pl=""
acurtis@pcgem.rdg.cyberkinetica.com's avatar
WL#925 - Privileges for stored routines  
acurtis@pcgem.rdg.cyberkinetica.com committed
44 
c_p="" c_pp=""
cps@outpost.site's avatar
WL1019: complete patch. Reapplied patch to the clean  
cps@outpost.site committed
45 
c_gl="" c_sl=""
guilhem@mysql.com's avatar
excess space caused "../scripts/mysql_create_system_tables: line 46: : command not found"  
guilhem@mysql.com committed
46 
c_ev=""
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
47 48 49 50 

# Check for old tables
if test ! -f $mdata/db.frm
then
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
51 
  if test "$1" = "verbose" ; then
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
52 53 54 55 56 57 58 59 
    echo "Preparing db table" 1>&2; 
  fi

  # mysqld --bootstrap wants one command/line
  c_d="$c_d CREATE TABLE db ("
  c_d="$c_d   Host char(60) binary DEFAULT '' NOT NULL,"
  c_d="$c_d   Db char(64) binary DEFAULT '' NOT NULL,"
  c_d="$c_d   User char(16) binary DEFAULT '' NOT NULL,"
jimw@mysql.com's avatar
Fix all of the enum and set columns in privilege tables to be  
jimw@mysql.com committed
60 61 62 63 64 65 66 67 68 69 70 71 
  c_d="$c_d   Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
jimw@mysql.com's avatar
Merge  
jimw@mysql.com committed
72 73 74 75 76 
  c_d="$c_d   Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_d="$c_d   Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
andrey@lmy004's avatar
WL #1034 (Internal CRON) post-push fix  
andrey@lmy004 committed
77 
  c_d="$c_d   Event_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
anozdrin@mysql.com's avatar
Fix for BUG#9412: Triggers: should have trigger privilege.  
anozdrin@mysql.com committed
78 
  c_d="$c_d   Trigger_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
79 80 
  c_d="$c_d PRIMARY KEY Host (Host,Db,User),"
  c_d="$c_d KEY User (User)"
serg@serg.mylan's avatar
add engine=MyISAM to all create table statements in  
serg@serg.mylan committed
81 
  c_d="$c_d ) engine=MyISAM"
bar@mysql.com's avatar
Bug#4338 mysql-test-run fails if compiled with non-latin1 character set  
bar@mysql.com committed
82 
  c_d="$c_d CHARACTER SET utf8 COLLATE utf8_bin"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
83 84 
  c_d="$c_d comment='Database privileges';"
anozdrin@mysql.com's avatar
Fix for BUG#9412: Triggers: should have trigger privilege.  
anozdrin@mysql.com committed
85 86 
  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');
  INSERT INTO db VALUES ('%','test\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','N','N','Y','Y');"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
87 88 89 90 
fi

if test ! -f $mdata/host.frm
then
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
91 
  if test "$1" = "verbose" ; then
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
92 93 94 95 96 97 
    echo "Preparing host table" 1>&2;
  fi

  c_h="$c_h CREATE TABLE host ("
  c_h="$c_h  Host char(60) binary DEFAULT '' NOT NULL,"
  c_h="$c_h  Db char(64) binary DEFAULT '' NOT NULL,"
jimw@mysql.com's avatar
Fix all of the enum and set columns in privilege tables to be  
jimw@mysql.com committed
98 99 100 101 102 103 104 105 106 107 108 109 
  c_h="$c_h  Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
jimw@mysql.com's avatar
Merge  
jimw@mysql.com committed
110 111 
  c_h="$c_h  Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
jimw@mysql.com's avatar
Resolve merge of fix for #8166.  
jimw@mysql.com committed
112 113 114 
  c_h="$c_h  Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_h="$c_h  Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
anozdrin@mysql.com's avatar
Fix for BUG#9412: Triggers: should have trigger privilege.  
anozdrin@mysql.com committed
115 
  c_h="$c_h  Trigger_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
116 
  c_h="$c_h  PRIMARY KEY Host (Host,Db)"
serg@serg.mylan's avatar
add engine=MyISAM to all create table statements in  
serg@serg.mylan committed
117 
  c_h="$c_h ) engine=MyISAM"
bar@mysql.com's avatar
Bug#4338 mysql-test-run fails if compiled with non-latin1 character set  
bar@mysql.com committed
118 
  c_h="$c_h CHARACTER SET utf8 COLLATE utf8_bin"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
119 120 121 122 123 
  c_h="$c_h comment='Host privileges;  Merged with database privileges';"
fi

if test ! -f $mdata/user.frm
then
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
124 
  if test "$1" = "verbose" ; then
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
125 126 127 128 129 130 
    echo "Preparing user table" 1>&2;
  fi

  c_u="$c_u CREATE TABLE user ("
  c_u="$c_u   Host char(60) binary DEFAULT '' NOT NULL,"
  c_u="$c_u   User char(16) binary DEFAULT '' NOT NULL,"
bar@mysql.com's avatar
type_binary.result, type_binary.test:  
bar@mysql.com committed
131 
  c_u="$c_u   Password char(41) character set latin1 collate latin1_bin DEFAULT '' NOT NULL,"
jimw@mysql.com's avatar
Fix all of the enum and set columns in privilege tables to be  
jimw@mysql.com committed
132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 
  c_u="$c_u   Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Reload_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Shutdown_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Process_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   File_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Show_db_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Super_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Repl_slave_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Repl_client_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
jimw@mysql.com's avatar
Merge  
jimw@mysql.com committed
153 154 155 156 
  c_u="$c_u   Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
  c_u="$c_u   Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
mysqldev@mysql.com's avatar
sql_acl.cc, sql_acl.h, sql_parse.cc  
mysqldev@mysql.com committed
157 
  c_u="$c_u   Create_user_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
andrey@lmy004's avatar
WL #1034 (Internal CRON) post-push fix  
andrey@lmy004 committed
158 
  c_u="$c_u   Event_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
anozdrin@mysql.com's avatar
Fix for BUG#9412: Triggers: should have trigger privilege.  
anozdrin@mysql.com committed
159 
  c_u="$c_u   Trigger_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
jimw@mysql.com's avatar
Fix all of the enum and set columns in privilege tables to be  
jimw@mysql.com committed
160 
  c_u="$c_u   ssl_type enum('','ANY','X509', 'SPECIFIED') COLLATE utf8_general_ci DEFAULT '' NOT NULL,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
161 162 163 164 165 166 
  c_u="$c_u   ssl_cipher BLOB NOT NULL,"
  c_u="$c_u   x509_issuer BLOB NOT NULL,"
  c_u="$c_u   x509_subject BLOB NOT NULL,"
  c_u="$c_u   max_questions int(11) unsigned DEFAULT 0  NOT NULL,"
  c_u="$c_u   max_updates int(11) unsigned DEFAULT 0  NOT NULL,"
  c_u="$c_u   max_connections int(11) unsigned DEFAULT 0  NOT NULL,"
dlenev@brandersnatch.localdomain's avatar
WL#1339 "Add per account max_user_connections limit (maximum number  
dlenev@brandersnatch.localdomain committed
167 
  c_u="$c_u   max_user_connections int(11) unsigned DEFAULT 0  NOT NULL,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
168 
  c_u="$c_u   PRIMARY KEY Host (Host,User)"
serg@serg.mylan's avatar
add engine=MyISAM to all create table statements in  
serg@serg.mylan committed
169 
  c_u="$c_u ) engine=MyISAM"
bar@mysql.com's avatar
Bug#4338 mysql-test-run fails if compiled with non-latin1 character set  
bar@mysql.com committed
170 
  c_u="$c_u CHARACTER SET utf8 COLLATE utf8_bin"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
171 172 
  c_u="$c_u comment='Users and global privileges';"
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
173 
  if test "$1" = "test"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
174 
  then
anozdrin@mysql.com's avatar
Fix for BUG#9412: Triggers: should have trigger privilege.  
anozdrin@mysql.com committed
175 176 177 
    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);
    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);
    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);
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
178 179 180 
    INSERT INTO user (host,user) values ('localhost','');
    INSERT INTO user (host,user) values ('$hostname','');"
  else
anozdrin@mysql.com's avatar
Fix for BUG#9412: Triggers: should have trigger privilege.  
anozdrin@mysql.com committed
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);"
monty@mishka.mysql.fi's avatar
Move init_compiled_charsets to own file  
monty@mishka.mysql.fi committed
182 
    if test "$windows" = "0"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
183 
    then
monty@mysql.com's avatar
Added missing root user to mysql.user on windows. (Bug #4242)  
monty@mysql.com committed
184 
      i_u="$i_u
anozdrin@mysql.com's avatar
Fix for BUG#9412: Triggers: should have trigger privilege.  
anozdrin@mysql.com committed
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);
bar@bar.mysql.r18.ru's avatar
mysql_create_system_tables.sh:  
bar@bar.mysql.r18.ru committed
186 187 
           INSERT INTO user (host,user) values ('$hostname','');
           INSERT INTO user (host,user) values ('localhost','');"
monty@narttu.mysql.fi's avatar
Fixed some new memory leaks  
monty@narttu.mysql.fi committed
188 
    else
monty@mysql.com's avatar
Added missing root user to mysql.user on windows. (Bug #4242)  
monty@mysql.com committed
189 
      i_u="$i_u
anozdrin@mysql.com's avatar
Fix for BUG#9412: Triggers: should have trigger privilege.  
anozdrin@mysql.com committed
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);"
monty@narttu.mysql.fi's avatar
Fixed some new memory leaks  
monty@narttu.mysql.fi committed
191 
    fi
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
192 193 194 195 196 
  fi 
fi

if test ! -f $mdata/func.frm
then
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
197 
  if test "$1" = "verbose" ; then
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
198 199 200 201 202 203 204 
    echo "Preparing func table" 1>&2;
  fi

  c_f="$c_f CREATE TABLE func ("
  c_f="$c_f   name char(64) binary DEFAULT '' NOT NULL,"
  c_f="$c_f   ret tinyint(1) DEFAULT '0' NOT NULL,"
  c_f="$c_f   dl char(128) DEFAULT '' NOT NULL,"
jimw@mysql.com's avatar
Fix all of the enum and set columns in privilege tables to be  
jimw@mysql.com committed
205 
  c_f="$c_f   type enum ('function','aggregate') COLLATE utf8_general_ci NOT NULL,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
206 
  c_f="$c_f   PRIMARY KEY (name)"
serg@serg.mylan's avatar
add engine=MyISAM to all create table statements in  
serg@serg.mylan committed
207 
  c_f="$c_f ) engine=MyISAM"
bar@mysql.com's avatar
Bug#4338 mysql-test-run fails if compiled with non-latin1 character set  
bar@mysql.com committed
208 
  c_f="$c_f CHARACTER SET utf8 COLLATE utf8_bin"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
209 210 211 
  c_f="$c_f   comment='User defined functions';"
fi
svoj@poseidon.ndb.mysql.com's avatar
WL#2575 - Fulltext: Parser plugin for FTS  
svoj@poseidon.ndb.mysql.com committed
212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 
if test ! -f $mdata/plugin.frm
then
  if test "$1" = "verbose" ; then
    echo "Preparing plugin table" 1>&2;
  fi

  c_pl="$c_pl CREATE TABLE plugin ("
  c_pl="$c_pl   name char(64) binary DEFAULT '' NOT NULL,"
  c_pl="$c_pl   dl char(128) DEFAULT '' NOT NULL,"
  c_pl="$c_pl   PRIMARY KEY (name)"
  c_pl="$c_pl ) engine=MyISAM"
  c_pl="$c_pl CHARACTER SET utf8 COLLATE utf8_bin"
  c_pl="$c_pl   comment='MySQL plugins';"
fi
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
227 228 
if test ! -f $mdata/tables_priv.frm
then
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
229 
  if test "$1" = "verbose" ; then
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
230 231 232 233 234 235 236 
    echo "Preparing tables_priv table" 1>&2;
  fi

  c_t="$c_t CREATE TABLE tables_priv ("
  c_t="$c_t   Host char(60) binary DEFAULT '' NOT NULL,"
  c_t="$c_t   Db char(64) binary DEFAULT '' NOT NULL,"
  c_t="$c_t   User char(16) binary DEFAULT '' NOT NULL,"
monty@mysql.com's avatar
Added test to show bug in current union implementation  
monty@mysql.com committed
237 
  c_t="$c_t   Table_name char(64) binary DEFAULT '' NOT NULL,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
238 
  c_t="$c_t   Grantor char(77) DEFAULT '' NOT NULL,"
serg@serg.mylan's avatar
cleanup  
serg@serg.mylan committed
239 
  c_t="$c_t   Timestamp timestamp,"
anozdrin@mysql.com's avatar
Fix for BUG#9412: Triggers: should have trigger privilege.  
anozdrin@mysql.com committed
240 
  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,"
jimw@mysql.com's avatar
Fix all of the enum and set columns in privilege tables to be  
jimw@mysql.com committed
241 
  c_t="$c_t   Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
242 243 
  c_t="$c_t   PRIMARY KEY (Host,Db,User,Table_name),"
  c_t="$c_t   KEY Grantor (Grantor)"
serg@serg.mylan's avatar
add engine=MyISAM to all create table statements in  
serg@serg.mylan committed
244 
  c_t="$c_t ) engine=MyISAM"
bar@mysql.com's avatar
Bug#4338 mysql-test-run fails if compiled with non-latin1 character set  
bar@mysql.com committed
245 
  c_t="$c_t CHARACTER SET utf8 COLLATE utf8_bin"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
246 247 248 249 250 
  c_t="$c_t   comment='Table privileges';"
fi

if test ! -f $mdata/columns_priv.frm
then
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
251 
  if test "$1" = "verbose" ; then
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
252 253 254 255 256 257 258 259 260 
    echo "Preparing columns_priv table" 1>&2;
  fi

  c_c="$c_c CREATE TABLE columns_priv ("
  c_c="$c_c   Host char(60) binary DEFAULT '' NOT NULL,"
  c_c="$c_c   Db char(64) binary DEFAULT '' NOT NULL,"
  c_c="$c_c   User char(16) binary DEFAULT '' NOT NULL,"
  c_c="$c_c   Table_name char(64) binary DEFAULT '' NOT NULL,"
  c_c="$c_c   Column_name char(64) binary DEFAULT '' NOT NULL,"
serg@serg.mylan's avatar
cleanup  
serg@serg.mylan committed
261 
  c_c="$c_c   Timestamp timestamp,"
jimw@mysql.com's avatar
Fix all of the enum and set columns in privilege tables to be  
jimw@mysql.com committed
262 
  c_c="$c_c   Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
263 
  c_c="$c_c   PRIMARY KEY (Host,Db,User,Table_name,Column_name)"
serg@serg.mylan's avatar
add engine=MyISAM to all create table statements in  
serg@serg.mylan committed
264 
  c_c="$c_c ) engine=MyISAM"
bar@mysql.com's avatar
Bug#4338 mysql-test-run fails if compiled with non-latin1 character set  
bar@mysql.com committed
265 
  c_c="$c_c CHARACTER SET utf8 COLLATE utf8_bin"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
266 267 268 
  c_c="$c_c   comment='Column privileges';"
fi
acurtis@pcgem.rdg.cyberkinetica.com's avatar
WL#925 - Privileges for stored routines  
acurtis@pcgem.rdg.cyberkinetica.com committed
269 270 271 272 273 274 275 276 277 278 279 
if test ! -f $mdata/procs_priv.frm
then
  if test "$1" = "verbose" ; then
    echo "Preparing procs_priv table" 1>&2;
  fi

  c_pp="$c_pp CREATE TABLE procs_priv ("
  c_pp="$c_pp   Host char(60) binary DEFAULT '' NOT NULL,"
  c_pp="$c_pp   Db char(64) binary DEFAULT '' NOT NULL,"
  c_pp="$c_pp   User char(16) binary DEFAULT '' NOT NULL,"
  c_pp="$c_pp   Routine_name char(64) binary DEFAULT '' NOT NULL,"
acurtis@xiphis.org's avatar
Bug#10246 - Parser: bad syntax for GRANT EXECUTE  
acurtis@xiphis.org committed
280 
  c_pp="$c_pp   Routine_type enum('FUNCTION','PROCEDURE') NOT NULL,"
acurtis@pcgem.rdg.cyberkinetica.com's avatar
WL#925 - Privileges for stored routines  
acurtis@pcgem.rdg.cyberkinetica.com committed
281 
  c_pp="$c_pp   Grantor char(77) DEFAULT '' NOT NULL,"
jimw@mysql.com's avatar
Clean up merge from 4.1, including making several enum fields  
jimw@mysql.com committed
282 
  c_pp="$c_pp   Proc_priv set('Execute','Alter Routine','Grant') COLLATE utf8_general_ci DEFAULT '' NOT NULL,"
serg@serg.mylan's avatar
cleanup  
serg@serg.mylan committed
283 
  c_pp="$c_pp   Timestamp timestamp,"
acurtis@xiphis.org's avatar
Bug#10246 - Parser: bad syntax for GRANT EXECUTE  
acurtis@xiphis.org committed
284 
  c_pp="$c_pp   PRIMARY KEY (Host,Db,User,Routine_name,Routine_type),"
acurtis@pcgem.rdg.cyberkinetica.com's avatar
WL#925 - Privileges for stored routines  
acurtis@pcgem.rdg.cyberkinetica.com committed
285 286 287 288 289 290 
  c_pp="$c_pp   KEY Grantor (Grantor)"
  c_pp="$c_pp ) engine=MyISAM"
  c_pp="$c_pp CHARACTER SET utf8 COLLATE utf8_bin"
  c_pp="$c_pp   comment='Procedure privileges';"
fi
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
291 292 
if test ! -f $mdata/help_topic.frm
then
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
293 
  if test "$1" = "verbose" ; then
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
294 295 296 297 298 
    echo "Preparing help_topic table" 1>&2;
  fi

  c_ht="$c_ht CREATE TABLE help_topic ("
  c_ht="$c_ht   help_topic_id    int unsigned not null,"
jimw@mysql.com's avatar
Hack to ensure that CHAR's created in 5.0 are not converted to VARCHAR even if  
jimw@mysql.com committed
299 
  c_ht="$c_ht   name             char(64) not null,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
300 301 302 
  c_ht="$c_ht   help_category_id smallint unsigned not null,"
  c_ht="$c_ht   description      text not null,"
  c_ht="$c_ht   example          text not null,"
jimw@mysql.com's avatar
Hack to ensure that CHAR's created in 5.0 are not converted to VARCHAR even if  
jimw@mysql.com committed
303 
  c_ht="$c_ht   url              char(128) not null,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
304 305 
  c_ht="$c_ht   primary key      (help_topic_id),"
  c_ht="$c_ht   unique index     (name)"
serg@serg.mylan's avatar
add engine=MyISAM to all create table statements in  
serg@serg.mylan committed
306 
  c_ht="$c_ht ) engine=MyISAM"
bar@mysql.com's avatar
Bug#4338 mysql-test-run fails if compiled with non-latin1 character set  
bar@mysql.com committed
307 
  c_ht="$c_ht CHARACTER SET utf8"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
308 309 310 311 312 313 314 
  c_ht="$c_ht   comment='help topics';"
fi

old_categories="yes"
		    
if test ! -f $mdata/help_category.frm
then
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
315 
  if test "$1" = "verbose" ; then
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
316 317 318 319 320 
    echo "Preparing help_category table" 1>&2;
  fi
  
  c_hc="$c_hc CREATE TABLE help_category ("
  c_hc="$c_hc   help_category_id   smallint unsigned not null,"
jimw@mysql.com's avatar
Hack to ensure that CHAR's created in 5.0 are not converted to VARCHAR even if  
jimw@mysql.com committed
321 
  c_hc="$c_hc   name               char(64) not null,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
322 
  c_hc="$c_hc   parent_category_id smallint unsigned null,"
jimw@mysql.com's avatar
Hack to ensure that CHAR's created in 5.0 are not converted to VARCHAR even if  
jimw@mysql.com committed
323 
  c_hc="$c_hc   url                char(128) not null,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
324 325 
  c_hc="$c_hc   primary key        (help_category_id),"
  c_hc="$c_hc   unique index       (name)"
serg@serg.mylan's avatar
add engine=MyISAM to all create table statements in  
serg@serg.mylan committed
326 
  c_hc="$c_hc ) engine=MyISAM"
bar@mysql.com's avatar
Bug#4338 mysql-test-run fails if compiled with non-latin1 character set  
bar@mysql.com committed
327 
  c_hc="$c_hc CHARACTER SET utf8"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
328 329 330 331 332 
  c_hc="$c_hc   comment='help categories';"
fi

if test ! -f $mdata/help_keyword.frm
then
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
333 
  if test "$1" = "verbose" ; then
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
334 335 336 337 338 
    echo "Preparing help_keyword table" 1>&2;
  fi

  c_hk="$c_hk CREATE TABLE help_keyword ("
  c_hk="$c_hk   help_keyword_id  int unsigned not null,"
jimw@mysql.com's avatar
Hack to ensure that CHAR's created in 5.0 are not converted to VARCHAR even if  
jimw@mysql.com committed
339 
  c_hk="$c_hk   name             char(64) not null,"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
340 341 
  c_hk="$c_hk   primary key      (help_keyword_id),"
  c_hk="$c_hk   unique index     (name)"
serg@serg.mylan's avatar
add engine=MyISAM to all create table statements in  
serg@serg.mylan committed
342 
  c_hk="$c_hk ) engine=MyISAM"
bar@mysql.com's avatar
Bug#4338 mysql-test-run fails if compiled with non-latin1 character set  
bar@mysql.com committed
343 
  c_hk="$c_hk CHARACTER SET utf8"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
344 345 346 347 348 
  c_hk="$c_hk   comment='help keywords';"
fi
				    
if test ! -f $mdata/help_relation.frm
then
monty@narttu.mysql.fi's avatar
Fixes for make_win_src_distributions  
monty@narttu.mysql.fi committed
349 
  if test "$1" = "verbose" ; then
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
350 351 352 353 354 355 356 
   echo "Preparing help_relation table" 1>&2;
  fi

  c_hr="$c_hr CREATE TABLE help_relation ("
  c_hr="$c_hr   help_topic_id    int unsigned not null references help_topic,"
  c_hr="$c_hr   help_keyword_id  int unsigned not null references help_keyword,"
  c_hr="$c_hr   primary key      (help_keyword_id, help_topic_id)"
serg@serg.mylan's avatar
add engine=MyISAM to all create table statements in  
serg@serg.mylan committed
357 
  c_hr="$c_hr ) engine=MyISAM"
bar@mysql.com's avatar
Bug#4338 mysql-test-run fails if compiled with non-latin1 character set  
bar@mysql.com committed
358 
  c_hr="$c_hr CHARACTER SET utf8"
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
359 360 361 
  c_hr="$c_hr   comment='keyword-topic relation';"
fi
cps@outpost.site's avatar
WL1019: complete patch. Reapplied patch to the clean  
cps@outpost.site committed
362
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
363 364 365 366 367 368 369 370 371 372 
if test ! -f $mdata/time_zone_name.frm
then
  if test "$1" = "verbose" ; then
   echo "Preparing time_zone_name table" 1>&2;
  fi

  c_tzn="$c_tzn CREATE TABLE time_zone_name ("
  c_tzn="$c_tzn   Name char(64) NOT NULL,"
  c_tzn="$c_tzn   Time_zone_id int unsigned NOT NULL,"
  c_tzn="$c_tzn   PRIMARY KEY Name (Name)"
serg@serg.mylan's avatar
merged  
serg@serg.mylan committed
373 
  c_tzn="$c_tzn ) engine=MyISAM CHARACTER SET utf8"
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
374 375 376 377 378 379 
  c_tzn="$c_tzn   comment='Time zone names';"
  
  if test "$1" = "test" 
  then
    i_tzn="$i_tzn INSERT INTO time_zone_name (Name, Time_Zone_id) VALUES"
    i_tzn="$i_tzn   ('MET', 1), ('UTC', 2), ('Universal', 2), "
dlenev@brandersnatch.localdomain's avatar
Fix for bug #4508 "CONVERT_TZ() function with new time zone as param crashes server".  
dlenev@brandersnatch.localdomain committed
380 381 
    i_tzn="$i_tzn   ('Europe/Moscow',3), ('leap/Europe/Moscow',4), "
    i_tzn="$i_tzn   ('Japan', 5);"
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
382 383 384 385 386 387 388 389 390 391 392 
  fi
fi

if test ! -f $mdata/time_zone.frm
then
  if test "$1" = "verbose" ; then
   echo "Preparing time_zone table" 1>&2;
  fi

  c_tz="$c_tz CREATE TABLE time_zone ("
  c_tz="$c_tz   Time_zone_id int unsigned NOT NULL auto_increment,"
jimw@mysql.com's avatar
Fix all of the enum and set columns in privilege tables to be  
jimw@mysql.com committed
393 
  c_tz="$c_tz   Use_leap_seconds enum('Y','N') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,"
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
394 
  c_tz="$c_tz   PRIMARY KEY TzId (Time_zone_id)"
serg@serg.mylan's avatar
merged  
serg@serg.mylan committed
395 
  c_tz="$c_tz ) engine=MyISAM CHARACTER SET utf8"
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
396 397 398 399 400 
  c_tz="$c_tz   comment='Time zones';"
  
  if test "$1" = "test" 
  then
    i_tz="$i_tz INSERT INTO time_zone (Time_zone_id, Use_leap_seconds)"
dlenev@brandersnatch.localdomain's avatar
Fix for bug #4508 "CONVERT_TZ() function with new time zone as param crashes server".  
dlenev@brandersnatch.localdomain committed
401 
    i_tz="$i_tz   VALUES (1,'N'), (2,'N'), (3,'N'), (4,'Y'), (5,'N');"
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
402 403 404 405 406 407 408 409 410 411 412 413 414 415 
  fi
fi

if test ! -f $mdata/time_zone_transition.frm
then
  if test "$1" = "verbose" ; then
   echo "Preparing time_zone_transition table" 1>&2;
  fi

  c_tzt="$c_tzt CREATE TABLE time_zone_transition ("
  c_tzt="$c_tzt   Time_zone_id int unsigned NOT NULL,"
  c_tzt="$c_tzt   Transition_time bigint signed NOT NULL,"
  c_tzt="$c_tzt   Transition_type_id int unsigned NOT NULL,"
  c_tzt="$c_tzt   PRIMARY KEY TzIdTranTime (Time_zone_id, Transition_time)"
serg@serg.mylan's avatar
merged  
serg@serg.mylan committed
416 
  c_tzt="$c_tzt ) engine=MyISAM CHARACTER SET utf8"
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 
  c_tzt="$c_tzt   comment='Time zone transitions';"
  
  if test "$1" = "test" 
  then
    i_tzt="$i_tzt INSERT INTO time_zone_transition"
    i_tzt="$i_tzt   (Time_zone_id, Transition_time, Transition_type_id)"
    i_tzt="$i_tzt VALUES"
    i_tzt="$i_tzt   (1, -1693706400, 0) ,(1, -1680483600, 1)"
    i_tzt="$i_tzt  ,(1, -1663455600, 2) ,(1, -1650150000, 3)"
    i_tzt="$i_tzt  ,(1, -1632006000, 2) ,(1, -1618700400, 3)"
    i_tzt="$i_tzt  ,(1, -938905200, 2) ,(1, -857257200, 3)"
    i_tzt="$i_tzt  ,(1, -844556400, 2) ,(1, -828226800, 3)"
    i_tzt="$i_tzt  ,(1, -812502000, 2) ,(1, -796777200, 3)"
    i_tzt="$i_tzt  ,(1, 228877200, 2) ,(1, 243997200, 3)"
    i_tzt="$i_tzt  ,(1, 260326800, 2) ,(1, 276051600, 3)"
    i_tzt="$i_tzt  ,(1, 291776400, 2) ,(1, 307501200, 3)"
    i_tzt="$i_tzt  ,(1, 323830800, 2) ,(1, 338950800, 3)"
    i_tzt="$i_tzt  ,(1, 354675600, 2) ,(1, 370400400, 3)"
    i_tzt="$i_tzt  ,(1, 386125200, 2) ,(1, 401850000, 3)"
    i_tzt="$i_tzt  ,(1, 417574800, 2) ,(1, 433299600, 3)"
    i_tzt="$i_tzt  ,(1, 449024400, 2) ,(1, 465354000, 3)"
    i_tzt="$i_tzt  ,(1, 481078800, 2) ,(1, 496803600, 3)"
    i_tzt="$i_tzt  ,(1, 512528400, 2) ,(1, 528253200, 3)"
    i_tzt="$i_tzt  ,(1, 543978000, 2) ,(1, 559702800, 3)"
    i_tzt="$i_tzt  ,(1, 575427600, 2) ,(1, 591152400, 3)"
    i_tzt="$i_tzt  ,(1, 606877200, 2) ,(1, 622602000, 3)"
    i_tzt="$i_tzt  ,(1, 638326800, 2) ,(1, 654656400, 3)"
    i_tzt="$i_tzt  ,(1, 670381200, 2) ,(1, 686106000, 3)"
    i_tzt="$i_tzt  ,(1, 701830800, 2) ,(1, 717555600, 3)"
    i_tzt="$i_tzt  ,(1, 733280400, 2) ,(1, 749005200, 3)"
    i_tzt="$i_tzt  ,(1, 764730000, 2) ,(1, 780454800, 3)"
    i_tzt="$i_tzt  ,(1, 796179600, 2) ,(1, 811904400, 3)"
    i_tzt="$i_tzt  ,(1, 828234000, 2) ,(1, 846378000, 3)"
    i_tzt="$i_tzt  ,(1, 859683600, 2) ,(1, 877827600, 3)"
    i_tzt="$i_tzt  ,(1, 891133200, 2) ,(1, 909277200, 3)"
    i_tzt="$i_tzt  ,(1, 922582800, 2) ,(1, 941331600, 3)"
    i_tzt="$i_tzt  ,(1, 954032400, 2) ,(1, 972781200, 3)"
    i_tzt="$i_tzt  ,(1, 985482000, 2) ,(1, 1004230800, 3)"
    i_tzt="$i_tzt  ,(1, 1017536400, 2) ,(1, 1035680400, 3)"
    i_tzt="$i_tzt  ,(1, 1048986000, 2) ,(1, 1067130000, 3)"
    i_tzt="$i_tzt  ,(1, 1080435600, 2) ,(1, 1099184400, 3)"
    i_tzt="$i_tzt  ,(1, 1111885200, 2) ,(1, 1130634000, 3)"
    i_tzt="$i_tzt  ,(1, 1143334800, 2) ,(1, 1162083600, 3)"
    i_tzt="$i_tzt  ,(1, 1174784400, 2) ,(1, 1193533200, 3)"
    i_tzt="$i_tzt  ,(1, 1206838800, 2) ,(1, 1224982800, 3)"
    i_tzt="$i_tzt  ,(1, 1238288400, 2) ,(1, 1256432400, 3)"
    i_tzt="$i_tzt  ,(1, 1269738000, 2) ,(1, 1288486800, 3)"
    i_tzt="$i_tzt  ,(1, 1301187600, 2) ,(1, 1319936400, 3)"
    i_tzt="$i_tzt  ,(1, 1332637200, 2) ,(1, 1351386000, 3)"
    i_tzt="$i_tzt  ,(1, 1364691600, 2) ,(1, 1382835600, 3)"
    i_tzt="$i_tzt  ,(1, 1396141200, 2) ,(1, 1414285200, 3)"
    i_tzt="$i_tzt  ,(1, 1427590800, 2) ,(1, 1445734800, 3)"
    i_tzt="$i_tzt  ,(1, 1459040400, 2) ,(1, 1477789200, 3)"
    i_tzt="$i_tzt  ,(1, 1490490000, 2) ,(1, 1509238800, 3)"
    i_tzt="$i_tzt  ,(1, 1521939600, 2) ,(1, 1540688400, 3)"
    i_tzt="$i_tzt  ,(1, 1553994000, 2) ,(1, 1572138000, 3)"
    i_tzt="$i_tzt  ,(1, 1585443600, 2) ,(1, 1603587600, 3)"
    i_tzt="$i_tzt  ,(1, 1616893200, 2) ,(1, 1635642000, 3)"
    i_tzt="$i_tzt  ,(1, 1648342800, 2) ,(1, 1667091600, 3)"
    i_tzt="$i_tzt  ,(1, 1679792400, 2) ,(1, 1698541200, 3)"
    i_tzt="$i_tzt  ,(1, 1711846800, 2) ,(1, 1729990800, 3)"
    i_tzt="$i_tzt  ,(1, 1743296400, 2) ,(1, 1761440400, 3)"
    i_tzt="$i_tzt  ,(1, 1774746000, 2) ,(1, 1792890000, 3)"
    i_tzt="$i_tzt  ,(1, 1806195600, 2) ,(1, 1824944400, 3)"
    i_tzt="$i_tzt  ,(1, 1837645200, 2) ,(1, 1856394000, 3)"
    i_tzt="$i_tzt  ,(1, 1869094800, 2) ,(1, 1887843600, 3)"
    i_tzt="$i_tzt  ,(1, 1901149200, 2) ,(1, 1919293200, 3)"
    i_tzt="$i_tzt  ,(1, 1932598800, 2) ,(1, 1950742800, 3)"
    i_tzt="$i_tzt  ,(1, 1964048400, 2) ,(1, 1982797200, 3)"
    i_tzt="$i_tzt  ,(1, 1995498000, 2) ,(1, 2014246800, 3)"
    i_tzt="$i_tzt  ,(1, 2026947600, 2) ,(1, 2045696400, 3)"
    i_tzt="$i_tzt  ,(1, 2058397200, 2) ,(1, 2077146000, 3)"
    i_tzt="$i_tzt  ,(1, 2090451600, 2) ,(1, 2108595600, 3)"
    i_tzt="$i_tzt  ,(1, 2121901200, 2) ,(1, 2140045200, 3)"
    i_tzt="$i_tzt  ,(3, -1688265000, 2) ,(3, -1656819048, 1)"
    i_tzt="$i_tzt  ,(3, -1641353448, 2) ,(3, -1627965048, 3)"
    i_tzt="$i_tzt  ,(3, -1618716648, 1) ,(3, -1596429048, 3)"
    i_tzt="$i_tzt  ,(3, -1593829848, 5) ,(3, -1589860800, 4)"
    i_tzt="$i_tzt  ,(3, -1542427200, 5) ,(3, -1539493200, 6)"
    i_tzt="$i_tzt  ,(3, -1525323600, 5) ,(3, -1522728000, 4)"
    i_tzt="$i_tzt  ,(3, -1491188400, 7) ,(3, -1247536800, 4)"
    i_tzt="$i_tzt  ,(3, 354920400, 5) ,(3, 370728000, 4)"
    i_tzt="$i_tzt  ,(3, 386456400, 5) ,(3, 402264000, 4)"
    i_tzt="$i_tzt  ,(3, 417992400, 5) ,(3, 433800000, 4)"
    i_tzt="$i_tzt  ,(3, 449614800, 5) ,(3, 465346800, 8)"
    i_tzt="$i_tzt  ,(3, 481071600, 9) ,(3, 496796400, 8)"
    i_tzt="$i_tzt  ,(3, 512521200, 9) ,(3, 528246000, 8)"
    i_tzt="$i_tzt  ,(3, 543970800, 9) ,(3, 559695600, 8)"
    i_tzt="$i_tzt  ,(3, 575420400, 9) ,(3, 591145200, 8)"
    i_tzt="$i_tzt  ,(3, 606870000, 9) ,(3, 622594800, 8)"
    i_tzt="$i_tzt  ,(3, 638319600, 9) ,(3, 654649200, 8)"
    i_tzt="$i_tzt  ,(3, 670374000, 10) ,(3, 686102400, 11)"
    i_tzt="$i_tzt  ,(3, 695779200, 8) ,(3, 701812800, 5)"
    i_tzt="$i_tzt  ,(3, 717534000, 4) ,(3, 733273200, 9)"
    i_tzt="$i_tzt  ,(3, 748998000, 8) ,(3, 764722800, 9)"
    i_tzt="$i_tzt  ,(3, 780447600, 8) ,(3, 796172400, 9)"
    i_tzt="$i_tzt  ,(3, 811897200, 8) ,(3, 828226800, 9)"
    i_tzt="$i_tzt  ,(3, 846370800, 8) ,(3, 859676400, 9)"
    i_tzt="$i_tzt  ,(3, 877820400, 8) ,(3, 891126000, 9)"
    i_tzt="$i_tzt  ,(3, 909270000, 8) ,(3, 922575600, 9)"
    i_tzt="$i_tzt  ,(3, 941324400, 8) ,(3, 954025200, 9)"
    i_tzt="$i_tzt  ,(3, 972774000, 8) ,(3, 985474800, 9)"
    i_tzt="$i_tzt  ,(3, 1004223600, 8) ,(3, 1017529200, 9)"
    i_tzt="$i_tzt  ,(3, 1035673200, 8) ,(3, 1048978800, 9)"
    i_tzt="$i_tzt  ,(3, 1067122800, 8) ,(3, 1080428400, 9)"
    i_tzt="$i_tzt  ,(3, 1099177200, 8) ,(3, 1111878000, 9)"
    i_tzt="$i_tzt  ,(3, 1130626800, 8) ,(3, 1143327600, 9)"
    i_tzt="$i_tzt  ,(3, 1162076400, 8) ,(3, 1174777200, 9)"
    i_tzt="$i_tzt  ,(3, 1193526000, 8) ,(3, 1206831600, 9)"
    i_tzt="$i_tzt  ,(3, 1224975600, 8) ,(3, 1238281200, 9)"
    i_tzt="$i_tzt  ,(3, 1256425200, 8) ,(3, 1269730800, 9)"
    i_tzt="$i_tzt  ,(3, 1288479600, 8) ,(3, 1301180400, 9)"
    i_tzt="$i_tzt  ,(3, 1319929200, 8) ,(3, 1332630000, 9)"
    i_tzt="$i_tzt  ,(3, 1351378800, 8) ,(3, 1364684400, 9)"
    i_tzt="$i_tzt  ,(3, 1382828400, 8) ,(3, 1396134000, 9)"
    i_tzt="$i_tzt  ,(3, 1414278000, 8) ,(3, 1427583600, 9)"
    i_tzt="$i_tzt  ,(3, 1445727600, 8) ,(3, 1459033200, 9)"
    i_tzt="$i_tzt  ,(3, 1477782000, 8) ,(3, 1490482800, 9)"
    i_tzt="$i_tzt  ,(3, 1509231600, 8) ,(3, 1521932400, 9)"
    i_tzt="$i_tzt  ,(3, 1540681200, 8) ,(3, 1553986800, 9)"
    i_tzt="$i_tzt  ,(3, 1572130800, 8) ,(3, 1585436400, 9)"
    i_tzt="$i_tzt  ,(3, 1603580400, 8) ,(3, 1616886000, 9)"
    i_tzt="$i_tzt  ,(3, 1635634800, 8) ,(3, 1648335600, 9)"
    i_tzt="$i_tzt  ,(3, 1667084400, 8) ,(3, 1679785200, 9)"
    i_tzt="$i_tzt  ,(3, 1698534000, 8) ,(3, 1711839600, 9)"
    i_tzt="$i_tzt  ,(3, 1729983600, 8) ,(3, 1743289200, 9)"
    i_tzt="$i_tzt  ,(3, 1761433200, 8) ,(3, 1774738800, 9)"
    i_tzt="$i_tzt  ,(3, 1792882800, 8) ,(3, 1806188400, 9)"
    i_tzt="$i_tzt  ,(3, 1824937200, 8) ,(3, 1837638000, 9)"
    i_tzt="$i_tzt  ,(3, 1856386800, 8) ,(3, 1869087600, 9)"
    i_tzt="$i_tzt  ,(3, 1887836400, 8) ,(3, 1901142000, 9)"
    i_tzt="$i_tzt  ,(3, 1919286000, 8) ,(3, 1932591600, 9)"
    i_tzt="$i_tzt  ,(3, 1950735600, 8) ,(3, 1964041200, 9)"
    i_tzt="$i_tzt  ,(3, 1982790000, 8) ,(3, 1995490800, 9)"
    i_tzt="$i_tzt  ,(3, 2014239600, 8) ,(3, 2026940400, 9)"
    i_tzt="$i_tzt  ,(3, 2045689200, 8) ,(3, 2058390000, 9)"
    i_tzt="$i_tzt  ,(3, 2077138800, 8) ,(3, 2090444400, 9)"
    i_tzt="$i_tzt  ,(3, 2108588400, 8) ,(3, 2121894000, 9)"
    i_tzt="$i_tzt  ,(3, 2140038000, 8)"
    i_tzt="$i_tzt  ,(4, -1688265000, 2) ,(4, -1656819048, 1)"
    i_tzt="$i_tzt  ,(4, -1641353448, 2) ,(4, -1627965048, 3)"
    i_tzt="$i_tzt  ,(4, -1618716648, 1) ,(4, -1596429048, 3)"
    i_tzt="$i_tzt  ,(4, -1593829848, 5) ,(4, -1589860800, 4)"
    i_tzt="$i_tzt  ,(4, -1542427200, 5) ,(4, -1539493200, 6)"
    i_tzt="$i_tzt  ,(4, -1525323600, 5) ,(4, -1522728000, 4)"
    i_tzt="$i_tzt  ,(4, -1491188400, 7) ,(4, -1247536800, 4)"
    i_tzt="$i_tzt  ,(4, 354920409, 5) ,(4, 370728010, 4)"
    i_tzt="$i_tzt  ,(4, 386456410, 5) ,(4, 402264011, 4)"
    i_tzt="$i_tzt  ,(4, 417992411, 5) ,(4, 433800012, 4)"
    i_tzt="$i_tzt  ,(4, 449614812, 5) ,(4, 465346812, 8)"
    i_tzt="$i_tzt  ,(4, 481071612, 9) ,(4, 496796413, 8)"
    i_tzt="$i_tzt  ,(4, 512521213, 9) ,(4, 528246013, 8)"
    i_tzt="$i_tzt  ,(4, 543970813, 9) ,(4, 559695613, 8)"
    i_tzt="$i_tzt  ,(4, 575420414, 9) ,(4, 591145214, 8)"
    i_tzt="$i_tzt  ,(4, 606870014, 9) ,(4, 622594814, 8)"
    i_tzt="$i_tzt  ,(4, 638319615, 9) ,(4, 654649215, 8)"
    i_tzt="$i_tzt  ,(4, 670374016, 10) ,(4, 686102416, 11)"
    i_tzt="$i_tzt  ,(4, 695779216, 8) ,(4, 701812816, 5)"
    i_tzt="$i_tzt  ,(4, 717534017, 4) ,(4, 733273217, 9)"
    i_tzt="$i_tzt  ,(4, 748998018, 8) ,(4, 764722818, 9)"
    i_tzt="$i_tzt  ,(4, 780447619, 8) ,(4, 796172419, 9)"
    i_tzt="$i_tzt  ,(4, 811897219, 8) ,(4, 828226820, 9)"
    i_tzt="$i_tzt  ,(4, 846370820, 8) ,(4, 859676420, 9)"
    i_tzt="$i_tzt  ,(4, 877820421, 8) ,(4, 891126021, 9)"
    i_tzt="$i_tzt  ,(4, 909270021, 8) ,(4, 922575622, 9)"
    i_tzt="$i_tzt  ,(4, 941324422, 8) ,(4, 954025222, 9)"
    i_tzt="$i_tzt  ,(4, 972774022, 8) ,(4, 985474822, 9)"
    i_tzt="$i_tzt  ,(4, 1004223622, 8) ,(4, 1017529222, 9)"
    i_tzt="$i_tzt  ,(4, 1035673222, 8) ,(4, 1048978822, 9)"
    i_tzt="$i_tzt  ,(4, 1067122822, 8) ,(4, 1080428422, 9)"
    i_tzt="$i_tzt  ,(4, 1099177222, 8) ,(4, 1111878022, 9)"
    i_tzt="$i_tzt  ,(4, 1130626822, 8) ,(4, 1143327622, 9)"
    i_tzt="$i_tzt  ,(4, 1162076422, 8) ,(4, 1174777222, 9)"
    i_tzt="$i_tzt  ,(4, 1193526022, 8) ,(4, 1206831622, 9)"
    i_tzt="$i_tzt  ,(4, 1224975622, 8) ,(4, 1238281222, 9)"
    i_tzt="$i_tzt  ,(4, 1256425222, 8) ,(4, 1269730822, 9)"
    i_tzt="$i_tzt  ,(4, 1288479622, 8) ,(4, 1301180422, 9)"
    i_tzt="$i_tzt  ,(4, 1319929222, 8) ,(4, 1332630022, 9)"
    i_tzt="$i_tzt  ,(4, 1351378822, 8) ,(4, 1364684422, 9)"
    i_tzt="$i_tzt  ,(4, 1382828422, 8) ,(4, 1396134022, 9)"
    i_tzt="$i_tzt  ,(4, 1414278022, 8) ,(4, 1427583622, 9)"
    i_tzt="$i_tzt  ,(4, 1445727622, 8) ,(4, 1459033222, 9)"
    i_tzt="$i_tzt  ,(4, 1477782022, 8) ,(4, 1490482822, 9)"
    i_tzt="$i_tzt  ,(4, 1509231622, 8) ,(4, 1521932422, 9)"
    i_tzt="$i_tzt  ,(4, 1540681222, 8) ,(4, 1553986822, 9)"
    i_tzt="$i_tzt  ,(4, 1572130822, 8) ,(4, 1585436422, 9)"
    i_tzt="$i_tzt  ,(4, 1603580422, 8) ,(4, 1616886022, 9)"
    i_tzt="$i_tzt  ,(4, 1635634822, 8) ,(4, 1648335622, 9)"
    i_tzt="$i_tzt  ,(4, 1667084422, 8) ,(4, 1679785222, 9)"
    i_tzt="$i_tzt  ,(4, 1698534022, 8) ,(4, 1711839622, 9)"
    i_tzt="$i_tzt  ,(4, 1729983622, 8) ,(4, 1743289222, 9)"
    i_tzt="$i_tzt  ,(4, 1761433222, 8) ,(4, 1774738822, 9)"
    i_tzt="$i_tzt  ,(4, 1792882822, 8) ,(4, 1806188422, 9)"
    i_tzt="$i_tzt  ,(4, 1824937222, 8) ,(4, 1837638022, 9)"
    i_tzt="$i_tzt  ,(4, 1856386822, 8) ,(4, 1869087622, 9)"
    i_tzt="$i_tzt  ,(4, 1887836422, 8) ,(4, 1901142022, 9)"
    i_tzt="$i_tzt  ,(4, 1919286022, 8) ,(4, 1932591622, 9)"
    i_tzt="$i_tzt  ,(4, 1950735622, 8) ,(4, 1964041222, 9)"
    i_tzt="$i_tzt  ,(4, 1982790022, 8) ,(4, 1995490822, 9)"
    i_tzt="$i_tzt  ,(4, 2014239622, 8) ,(4, 2026940422, 9)"
    i_tzt="$i_tzt  ,(4, 2045689222, 8) ,(4, 2058390022, 9)"
    i_tzt="$i_tzt  ,(4, 2077138822, 8) ,(4, 2090444422, 9)"
    i_tzt="$i_tzt  ,(4, 2108588422, 8) ,(4, 2121894022, 9)"
dlenev@brandersnatch.localdomain's avatar
Fix for bug #4508 "CONVERT_TZ() function with new time zone as param crashes server".  
dlenev@brandersnatch.localdomain committed
620 621 
    i_tzt="$i_tzt  ,(4, 2140038022, 8)"
    i_tzt="$i_tzt  ,(5, -1009875600, 1);"
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 
  fi
fi

if test ! -f $mdata/time_zone_transition_type.frm
then
  if test "$1" = "verbose" ; then
   echo "Preparing time_zone_transition_type table" 1>&2;
  fi

  c_tztt="$c_tztt CREATE TABLE time_zone_transition_type ("
  c_tztt="$c_tztt   Time_zone_id int unsigned NOT NULL,"
  c_tztt="$c_tztt   Transition_type_id int unsigned NOT NULL,"
  c_tztt="$c_tztt   Offset int signed DEFAULT 0 NOT NULL,"
  c_tztt="$c_tztt   Is_DST tinyint unsigned DEFAULT 0 NOT NULL,"
  c_tztt="$c_tztt   Abbreviation char(8) DEFAULT '' NOT NULL,"
  c_tztt="$c_tztt   PRIMARY KEY TzIdTrTId (Time_zone_id, Transition_type_id)"
serg@serg.mylan's avatar
merged  
serg@serg.mylan committed
638 
  c_tztt="$c_tztt ) engine=MyISAM CHARACTER SET utf8"
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 
  c_tztt="$c_tztt   comment='Time zone transition types';"
  
  if test "$1" = "test" 
  then
    i_tztt="$i_tztt INSERT INTO time_zone_transition_type (Time_zone_id,"
    i_tztt="$i_tztt  Transition_type_id, Offset, Is_DST, Abbreviation) VALUES"
    i_tztt="$i_tztt   (1, 0, 7200, 1, 'MEST') ,(1, 1, 3600, 0, 'MET')"
    i_tztt="$i_tztt  ,(1, 2, 7200, 1, 'MEST') ,(1, 3, 3600, 0, 'MET')"
    i_tztt="$i_tztt  ,(2, 0, 0, 0, 'UTC')"
    i_tztt="$i_tztt  ,(3, 0, 9000, 0, 'MMT') ,(3, 1, 12648, 1, 'MST')"
    i_tztt="$i_tztt  ,(3, 2, 9048, 0, 'MMT') ,(3, 3, 16248, 1, 'MDST')"
    i_tztt="$i_tztt  ,(3, 4, 10800, 0, 'MSK') ,(3, 5, 14400, 1, 'MSD')"
    i_tztt="$i_tztt  ,(3, 6, 18000, 1, 'MSD') ,(3, 7, 7200, 0, 'EET')"
    i_tztt="$i_tztt  ,(3, 8, 10800, 0, 'MSK') ,(3, 9, 14400, 1, 'MSD')"
    i_tztt="$i_tztt  ,(3, 10, 10800, 1, 'EEST') ,(3, 11, 7200, 0, 'EET')"
    i_tztt="$i_tztt  ,(4, 0, 9000, 0, 'MMT') ,(4, 1, 12648, 1, 'MST')"
    i_tztt="$i_tztt  ,(4, 2, 9048, 0, 'MMT') ,(4, 3, 16248, 1, 'MDST')"
    i_tztt="$i_tztt  ,(4, 4, 10800, 0, 'MSK') ,(4, 5, 14400, 1, 'MSD')"
    i_tztt="$i_tztt  ,(4, 6, 18000, 1, 'MSD') ,(4, 7, 7200, 0, 'EET')"
    i_tztt="$i_tztt  ,(4, 8, 10800, 0, 'MSK') ,(4, 9, 14400, 1, 'MSD')"
dlenev@brandersnatch.localdomain's avatar
Fix for bug #4508 "CONVERT_TZ() function with new time zone as param crashes server".  
dlenev@brandersnatch.localdomain committed
659 660 
    i_tztt="$i_tztt  ,(4, 10, 10800, 1, 'EEST') ,(4, 11, 7200, 0, 'EET')"
    i_tztt="$i_tztt  ,(5, 0, 32400, 0, 'CJT') ,(5, 1, 32400, 0, 'JST');"
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
661 662 663 664 665 666 667 668 669 670 671 672 673 
  fi
fi

if test ! -f $mdata/time_zone_leap_second.frm
then
  if test "$1" = "verbose" ; then
   echo "Preparing time_zone_leap_second table" 1>&2;
  fi

  c_tzls="$c_tzls CREATE TABLE time_zone_leap_second ("
  c_tzls="$c_tzls   Transition_time bigint signed NOT NULL,"
  c_tzls="$c_tzls   Correction int signed NOT NULL,"
  c_tzls="$c_tzls   PRIMARY KEY TranTime (Transition_time)"
serg@serg.mylan's avatar
merged  
serg@serg.mylan committed
674 
  c_tzls="$c_tzls ) engine=MyISAM CHARACTER SET utf8"
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 
  c_tzls="$c_tzls   comment='Leap seconds information for time zones';"
  
  if test "$1" = "test" 
  then
    i_tzls="$i_tzls INSERT INTO time_zone_leap_second "
    i_tzls="$i_tzls  (Transition_time, Correction) VALUES "
    i_tzls="$i_tzls  (78796800, 1) ,(94694401, 2) ,(126230402, 3)"
    i_tzls="$i_tzls ,(157766403, 4) ,(189302404, 5) ,(220924805, 6)"
    i_tzls="$i_tzls ,(252460806, 7) ,(283996807, 8) ,(315532808, 9)"
    i_tzls="$i_tzls ,(362793609, 10) ,(394329610, 11) ,(425865611, 12)"
    i_tzls="$i_tzls ,(489024012, 13) ,(567993613, 14) ,(631152014, 15)"
    i_tzls="$i_tzls ,(662688015, 16) ,(709948816, 17) ,(741484817, 18)"
    i_tzls="$i_tzls ,(773020818, 19) ,(820454419, 20) ,(867715220, 21)"
    i_tzls="$i_tzls ,(915148821, 22);"
  fi
fi
pem@mysql.telia.com's avatar
Merging 4.1 into 5.0 (second pass; post-merge fixes).  
pem@mysql.telia.com committed
692 693 694 
if test ! -f $mdata/proc.frm
then
  c_p="$c_p CREATE TABLE proc ("
pem@mysql.com's avatar
Fixed BUG#11365: Stored Procedure: Crash on Procedure operation  
pem@mysql.com committed
695 
  c_p="$c_p   db                char(64) collate utf8_bin DEFAULT '' NOT NULL,"
pem@mysql.comhem.se's avatar
Fixed BUG#3259: Stored procedure names are case sensitive.  
pem@mysql.comhem.se committed
696 
  c_p="$c_p   name              char(64) DEFAULT '' NOT NULL,"
pem@mysql.comhem.se's avatar
WL#1363: Update the mysql.proc table and add new fields.  
pem@mysql.comhem.se committed
697 
  c_p="$c_p   type              enum('FUNCTION','PROCEDURE') NOT NULL,"
pem@mysql.comhem.se's avatar
Fixed BUG#3259: Stored procedure names are case sensitive.  
pem@mysql.comhem.se committed
698 
  c_p="$c_p   specific_name     char(64) DEFAULT '' NOT NULL,"
pem@mysql.comhem.se's avatar
WL#1363: Update the mysql.proc table and add new fields.  
pem@mysql.comhem.se committed
699 
  c_p="$c_p   language          enum('SQL') DEFAULT 'SQL' NOT NULL,"
pem@mysql.comhem.se's avatar
Implemented the stored procedure data access characteristics:  
pem@mysql.comhem.se committed
700 701 702 703 704 
  c_p="$c_p   sql_data_access   enum('CONTAINS_SQL',"
  c_p="$c_p			     'NO_SQL',"
  c_p="$c_p			     'READS_SQL_DATA',"
  c_p="$c_p			     'MODIFIES_SQL_DATA'"
  c_p="$c_p                     ) DEFAULT 'CONTAINS_SQL' NOT NULL,"
pem@mysql.comhem.se's avatar
WL#1363: Update the mysql.proc table and add new fields.  
pem@mysql.comhem.se committed
705 
  c_p="$c_p   is_deterministic  enum('YES','NO') DEFAULT 'NO' NOT NULL,"
pem@mysql.comhem.se's avatar
In order to make ALTER PROCEDURE|FUNCTION work correctly, and in general to  
pem@mysql.comhem.se committed
706 707 708 
  c_p="$c_p   security_type     enum('INVOKER','DEFINER') DEFAULT 'DEFINER' NOT NULL,"
  c_p="$c_p   param_list        blob DEFAULT '' NOT NULL,"
  c_p="$c_p   returns           char(64) DEFAULT '' NOT NULL,"
jimw@mysql.com's avatar
Increase allowed size of stored procedure bodies to 4GB, and  
jimw@mysql.com committed
709 
  c_p="$c_p   body              longblob DEFAULT '' NOT NULL,"
pem@mysql.com's avatar
Fixed BUG#11365: Stored Procedure: Crash on Procedure operation  
pem@mysql.com committed
710 
  c_p="$c_p   definer           char(77) collate utf8_bin DEFAULT '' NOT NULL,"
pem@mysql.comhem.se's avatar
WL#1363: Update the mysql.proc table and add new fields.  
pem@mysql.comhem.se committed
711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 
  c_p="$c_p   created           timestamp,"
  c_p="$c_p   modified          timestamp,"
  c_p="$c_p   sql_mode          set("
  c_p="$c_p                         'REAL_AS_FLOAT',"
  c_p="$c_p                         'PIPES_AS_CONCAT',"
  c_p="$c_p                         'ANSI_QUOTES',"
  c_p="$c_p                         'IGNORE_SPACE',"
  c_p="$c_p                         'NOT_USED',"
  c_p="$c_p                         'ONLY_FULL_GROUP_BY',"
  c_p="$c_p                         'NO_UNSIGNED_SUBTRACTION',"
  c_p="$c_p                         'NO_DIR_IN_CREATE',"
  c_p="$c_p                         'POSTGRESQL',"
  c_p="$c_p                         'ORACLE',"
  c_p="$c_p                         'MSSQL',"
  c_p="$c_p                         'DB2',"
  c_p="$c_p                         'MAXDB',"
  c_p="$c_p                         'NO_KEY_OPTIONS',"
  c_p="$c_p                         'NO_TABLE_OPTIONS',"
  c_p="$c_p                         'NO_FIELD_OPTIONS',"
  c_p="$c_p                         'MYSQL323',"
  c_p="$c_p                         'MYSQL40',"
  c_p="$c_p                         'ANSI',"
jimw@mysql.com's avatar
Add all SQL_MODE settings to proc table. (Bug #8902)  
jimw@mysql.com committed
733 734 735 736 737 738 739 740 741 742 743 
  c_p="$c_p                         'NO_AUTO_VALUE_ON_ZERO',"
  c_p="$c_p                         'NO_BACKSLASH_ESCAPES',"
  c_p="$c_p                         'STRICT_TRANS_TABLES',"
  c_p="$c_p                         'STRICT_ALL_TABLES',"
  c_p="$c_p                         'NO_ZERO_IN_DATE',"
  c_p="$c_p                         'NO_ZERO_DATE',"
  c_p="$c_p                         'INVALID_DATES',"
  c_p="$c_p                         'ERROR_FOR_DIVISION_BY_ZERO',"
  c_p="$c_p                         'TRADITIONAL',"
  c_p="$c_p                         'NO_AUTO_CREATE_USER',"
  c_p="$c_p                         'HIGH_NOT_PRECEDENCE'"
pem@mysql.com's avatar
Fixed BUG#11365: Stored Procedure: Crash on Procedure operation  
pem@mysql.com committed
744 745 
  c_p="$c_p                     ) DEFAULT '' NOT NULL,"
  c_p="$c_p   comment           char(64) collate utf8_bin DEFAULT '' NOT NULL,"
pem@mysql.comhem.se's avatar
Renamed the "schema" column to "db" in mysql.proc to keep it in style with  
pem@mysql.comhem.se committed
746 
  c_p="$c_p   PRIMARY KEY (db,name,type)"
pem@mysql.com's avatar
Fixed BUG#11365: Stored Procedure: Crash on Procedure operation  
pem@mysql.com committed
747 748 749 
  c_p="$c_p ) engine=MyISAM"
  c_p="$c_p character set utf8"
  c_p="$c_p comment='Stored Procedures';"
pem@mysql.telia.com's avatar
Merging 4.1 into 5.0 (second pass; post-merge fixes).  
pem@mysql.telia.com committed
750 
fi
pem@mysql.comhem.se's avatar
WL#1363: Update the mysql.proc table and add new fields.  
pem@mysql.comhem.se committed
751
andrey@lmy004's avatar
WL #1034 (Internal CRON) pre-push updates  
andrey@lmy004 committed
752
cps@outpost.site's avatar
WL1019: complete patch. Reapplied patch to the clean  
cps@outpost.site committed
753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 
if test ! -f $mdata/general_log.frm
then
  if test "$1" = "verbose" ; then
   echo "Preparing general_log table" 1>&2;
  fi
    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;
CALL create_general_log_table();
DROP PROCEDURE create_general_log_table;"
fi


if test ! -f $mdata/slow_log.frm
then
  if test "$1" = "verbose" ; then
   echo "Preparing slow_log table" 1>&2;
  fi
    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;
CALL create_slow_log_table();
DROP PROCEDURE create_slow_log_table;"
fi
andrey@lmy004's avatar
WL #1034 (Internal CRON) pre-push updates  
andrey@lmy004 committed
774 775 776 777 
if test ! -f $mdata/event.frm
then
  c_ev="$c_ev CREATE TABLE event ("
  c_ev="$c_ev   db char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',"
andrey@lmy004's avatar
fix for bug#16415 Events names are case sensitive  
andrey@lmy004 committed
778 
  c_ev="$c_ev   name char(64) CHARACTER SET utf8 NOT NULL default '',"
andrey@lmy004's avatar
WL #1034 (Internal CRON) pre-push updates  
andrey@lmy004 committed
779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 
  c_ev="$c_ev   body longblob NOT NULL,"
  c_ev="$c_ev   definer char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',"
  c_ev="$c_ev   execute_at DATETIME default NULL,"
  c_ev="$c_ev   interval_value int(11) default NULL,"
  c_ev="$c_ev   interval_field ENUM('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK',"
  c_ev="$c_ev                        'SECOND','MICROSECOND', 'YEAR_MONTH','DAY_HOUR',"
  c_ev="$c_ev                        'DAY_MINUTE','DAY_SECOND',"
  c_ev="$c_ev                        'HOUR_MINUTE','HOUR_SECOND',"
  c_ev="$c_ev                        'MINUTE_SECOND','DAY_MICROSECOND',"
  c_ev="$c_ev                        'HOUR_MICROSECOND','MINUTE_MICROSECOND',"
  c_ev="$c_ev                        'SECOND_MICROSECOND') default NULL,"
  c_ev="$c_ev   created TIMESTAMP NOT NULL,"
  c_ev="$c_ev   modified TIMESTAMP NOT NULL,"
  c_ev="$c_ev   last_executed DATETIME default NULL,"
  c_ev="$c_ev   starts DATETIME default NULL,"
  c_ev="$c_ev   ends DATETIME default NULL,"
  c_ev="$c_ev   status ENUM('ENABLED','DISABLED') NOT NULL default 'ENABLED',"
  c_ev="$c_ev   on_completion ENUM('DROP','PRESERVE') NOT NULL default 'DROP',"
andrey@lmy004's avatar
partial fix for bug#16407 (sql_mode not regarded)  
andrey@lmy004 committed
797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 
  c_ev="$c_ev   sql_mode          set("
  c_ev="$c_ev                         'REAL_AS_FLOAT',"
  c_ev="$c_ev                         'PIPES_AS_CONCAT',"
  c_ev="$c_ev                         'ANSI_QUOTES',"
  c_ev="$c_ev                         'IGNORE_SPACE',"
  c_ev="$c_ev                         'NOT_USED',"
  c_ev="$c_ev                         'ONLY_FULL_GROUP_BY',"
  c_ev="$c_ev                         'NO_UNSIGNED_SUBTRACTION',"
  c_ev="$c_ev                         'NO_DIR_IN_CREATE',"
  c_ev="$c_ev                         'POSTGRESQL',"
  c_ev="$c_ev                         'ORACLE',"
  c_ev="$c_ev                         'MSSQL',"
  c_ev="$c_ev                         'DB2',"
  c_ev="$c_ev                         'MAXDB',"
  c_ev="$c_ev                         'NO_KEY_OPTIONS',"
  c_ev="$c_ev                         'NO_TABLE_OPTIONS',"
  c_ev="$c_ev                         'NO_FIELD_OPTIONS',"
  c_ev="$c_ev                         'MYSQL323',"
  c_ev="$c_ev                         'MYSQL40',"
  c_ev="$c_ev                         'ANSI',"
  c_ev="$c_ev                         'NO_AUTO_VALUE_ON_ZERO',"
  c_ev="$c_ev                         'NO_BACKSLASH_ESCAPES',"
  c_ev="$c_ev                         'STRICT_TRANS_TABLES',"
  c_ev="$c_ev                         'STRICT_ALL_TABLES',"
  c_ev="$c_ev                         'NO_ZERO_IN_DATE',"
  c_ev="$c_ev                         'NO_ZERO_DATE',"
  c_ev="$c_ev                         'INVALID_DATES',"
  c_ev="$c_ev                         'ERROR_FOR_DIVISION_BY_ZERO',"
  c_ev="$c_ev                         'TRADITIONAL',"
  c_ev="$c_ev                         'NO_AUTO_CREATE_USER',"
  c_ev="$c_ev                         'HIGH_NOT_PRECEDENCE'"
  c_ev="$c_ev                     ) DEFAULT '' NOT NULL,"
andrey@lmy004's avatar
fix for bug #16401 Events: mysql.event.comment is varchar(64)  
andrey@lmy004 committed
829 
  c_ev="$c_ev   comment char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',"
andrey@lmy004's avatar
fix for bug#16642 (Events: No INFORMATION_SCHEMA.EVENTS table)  
andrey@lmy004 committed
830 
  c_ev="$c_ev   PRIMARY KEY  (definer, db, name)"
andrey@lmy004's avatar
WL #1034 (Internal CRON) pre-push updates  
andrey@lmy004 committed
831 832 833 
  c_ev="$c_ev ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT 'Events';"
fi
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
834 835 
cat << END_OF_DATA
use mysql;
serg@serg.mylan's avatar
cleanup  
serg@serg.mylan committed
836 
set storage_engine=myisam;
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
837 838 839 840 841 842 843 844 845 846 847 848 
$c_d
$i_d

$c_h
$i_h

$c_u
$i_u

$c_f
$i_f
svoj@poseidon.ndb.mysql.com's avatar
WL#2575 - Fulltext: Parser plugin for FTS  
svoj@poseidon.ndb.mysql.com committed
849 850 851 
$c_pl
$i_pl
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
852 853 854 855 856 857 858 
$c_t
$c_c

$c_ht
$c_hc
$c_hr
$c_hk
pem@mysql.telia.com's avatar
Merging 4.1 into 5.0 (second pass; post-merge fixes).  
pem@mysql.telia.com committed
859
dlenev@brandersnatch.localdomain's avatar
WL#1264 "Per-thread time zone support infrastructure".  
dlenev@brandersnatch.localdomain committed
860 861 862 863 864 865 866 867 868 869 
$c_tzn
$i_tzn
$c_tz
$i_tz
$c_tzt
$i_tzt
$c_tztt
$i_tztt
$c_tzls
$i_tzls
monty@mysql.com's avatar
Merge with 4.1.3-beta  
monty@mysql.com committed
870
pem@mysql.telia.com's avatar
Merging 4.1 into 5.0 (second pass; post-merge fixes).  
pem@mysql.telia.com committed
871 
$c_p
acurtis@pcgem.rdg.cyberkinetica.com's avatar
WL#925 - Privileges for stored routines  
acurtis@pcgem.rdg.cyberkinetica.com committed
872 
$c_pp
pem@mysql.telia.com's avatar
Merging 4.1 into 5.0 (second pass; post-merge fixes).  
pem@mysql.telia.com committed
873
cps@outpost.site's avatar
WL1019: complete patch. Reapplied patch to the clean  
cps@outpost.site committed
874 875 
$c_gl
$c_sl
andrey@lmy004's avatar
WL #1034 (Internal CRON) pre-push updates  
andrey@lmy004 committed
876 
$c_ev
tomas@poseidon.ndb.mysql.com's avatar
Bug #17805 Cluster_replication database should be renamed to just cluster  
tomas@poseidon.ndb.mysql.com committed
877 878 
CREATE DATABASE IF NOT EXISTS cluster;
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;
andrey@lmy004's avatar
WL #1034 (Internal CRON) pre-push updates  
andrey@lmy004 committed
879
vva@eagle.mysql.r18.ru's avatar
new version of help  
vva@eagle.mysql.r18.ru committed
880 881 
END_OF_DATA
GitLab Nexedi Edition | About GitLab | About Nexedi | 沪ICP备2021021310号-2 | 沪ICP备2021021310号-7