summaryrefslogtreecommitdiff
path: root/scripts/mysql_create_system_tables.sh
diff options
context:
space:
mode:
authorunknown <pem@mysql.com>2003-09-24 11:29:38 +0200
committerunknown <pem@mysql.com>2003-09-24 11:29:38 +0200
commitcd8508d3716e78c06eea3585641ff2527ad463cb (patch)
tree4f2fa31d20ec4c9a54f602c624b20c1cf4ddf493 /scripts/mysql_create_system_tables.sh
parent4e09f14b18ededb18aab527abe582fca34afe79c (diff)
parentc21755eb5f4187c95986185b46e22d7d0026d594 (diff)
downloadmariadb-git-cd8508d3716e78c06eea3585641ff2527ad463cb.tar.gz
Merging 4.1 -> 5.0
BitKeeper/etc/ignore: auto-union BitKeeper/etc/logging_ok: auto-union client/mysql.cc: Auto merged configure.in: Auto merged include/my_pthread.h: Auto merged include/mysql_com.h: Auto merged libmysql/libmysql.c: Auto merged BitKeeper/deleted/.del-sel000100.result~84ed46856cb3a69f: Auto merged BitKeeper/deleted/.del-sel000100.test~548501cad19a1a59: Auto merged myisam/mi_check.c: Auto merged myisam/myisamchk.c: Auto merged mysql-test/r/connect.result: Auto merged mysql-test/r/show_check.result: Auto merged mysql-test/r/subselect.result: Auto merged mysql-test/r/symlink.result: Auto merged mysql-test/t/subselect.test: Auto merged mysys/my_pthread.c: Auto merged scripts/mysql_create_system_tables.sh: Auto merged scripts/mysql_install_db.sh: Auto merged sql/filesort.cc: Auto merged sql/ha_berkeley.cc: Auto merged sql/ha_innodb.cc: Auto merged sql/ha_myisam.cc: Auto merged sql/item_cmpfunc.cc: Auto merged sql/item_create.cc: Auto merged sql/item_func.cc: Auto merged sql/item_func.h: Auto merged sql/item_subselect.cc: Auto merged sql/item_sum.cc: Auto merged sql/lex.h: Auto merged sql/lock.cc: Auto merged sql/log.cc: Auto merged sql/log_event.cc: Auto merged sql/mysql_priv.h: Auto merged sql/mysqld.cc: Auto merged sql/protocol.cc: Auto merged sql/records.cc: Auto merged sql/repl_failsafe.cc: Auto merged sql/set_var.cc: Auto merged sql/slave.cc: Auto merged sql/sql_acl.cc: Auto merged sql/sql_base.cc: Auto merged sql/sql_cache.cc: Auto merged sql/sql_class.cc: Auto merged sql/sql_class.h: Auto merged sql/sql_db.cc: Auto merged sql/sql_derived.cc: Auto merged sql/sql_insert.cc: Auto merged sql/sql_lex.cc: Auto merged sql/sql_load.cc: Auto merged sql/sql_repl.cc: Auto merged sql/sql_repl.h: Auto merged sql/sql_select.cc: Auto merged sql/sql_show.cc: Auto merged sql/sql_table.cc: Auto merged sql/sql_update.cc: Auto merged sql/sql_yacc.yy: Auto merged
Diffstat (limited to 'scripts/mysql_create_system_tables.sh')
-rw-r--r--scripts/mysql_create_system_tables.sh20
1 files changed, 20 insertions, 0 deletions
diff --git a/scripts/mysql_create_system_tables.sh b/scripts/mysql_create_system_tables.sh
index c4cdc7b52d7..1600fe051f3 100644
--- a/scripts/mysql_create_system_tables.sh
+++ b/scripts/mysql_create_system_tables.sh
@@ -39,6 +39,7 @@ c_hc=""
c_hr=""
c_hk=""
i_ht=""
+c_p=""
# Check for old tables
if test ! -f $mdata/db.frm
@@ -285,6 +286,22 @@ then
c_hr="$c_hr comment='keyword-topic relation';"
fi
+if test ! -f $mdata/proc.frm
+then
+ c_p="$c_p CREATE TABLE proc ("
+ c_p="$c_p name char(64) binary DEFAULT '' NOT NULL,"
+ c_p="$c_p type enum('function','procedure') NOT NULL,"
+ c_p="$c_p body blob DEFAULT '' NOT NULL,"
+ c_p="$c_p creator char(77) binary DEFAULT '' NOT NULL,"
+ c_p="$c_p modified timestamp,"
+ c_p="$c_p created timestamp,"
+ c_p="$c_p suid enum ('N', 'Y') DEFAULT 'Y' NOT NULL,"
+ c_p="$c_p comment char(64) binary DEFAULT '' NOT NULL,"
+ c_p="$c_p PRIMARY KEY (name,type)"
+ c_p="$c_p )"
+ c_p="$c_p comment='Stored Procedures';"
+fi
+
cat << END_OF_DATA
use mysql;
$c_d
@@ -306,5 +323,8 @@ $c_ht
$c_hc
$c_hr
$c_hk
+
+$c_p
+
END_OF_DATA