summaryrefslogtreecommitdiff
path: root/netware/test_db.sql
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2003-02-17 02:14:37 +0200
committermonty@mashka.mysql.fi <>2003-02-17 02:14:37 +0200
commit6051b2f9988f1e317be41e49c64718cc610c1260 (patch)
tree49ba5df63376ec1ba88e54e1446b29a777bba1a9 /netware/test_db.sql
parent153cefc61b15e182157ab7da9a14ab014c4f95de (diff)
downloadmariadb-git-6051b2f9988f1e317be41e49c64718cc610c1260.tar.gz
Fixed multi-table-delete for InnoDB tables
Novell patches
Diffstat (limited to 'netware/test_db.sql')
-rw-r--r--netware/test_db.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/netware/test_db.sql b/netware/test_db.sql
index 453d81693ed..d43b632289c 100644
--- a/netware/test_db.sql
+++ b/netware/test_db.sql
@@ -1,3 +1,6 @@
+CREATE DATABASE mysql;
+CREATE DATABASE test;
+
USE mysql;
CREATE TABLE db (Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Select_priv enum('N','Y') DEFAULT 'N' NOT NULL, Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL, Update_priv enum('N','Y') DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL, Create_priv enum('N','Y') DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL, References_priv enum('N','Y') DEFAULT 'N' NOT NULL, Index_priv enum('N','Y') DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL, Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL, Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL, PRIMARY KEY Host (Host,Db,User), KEY User (User)) comment='Database privileges';