diff options
| author | unknown <kent@mysql.com> | 2005-03-29 19:04:19 +0200 |
|---|---|---|
| committer | unknown <kent@mysql.com> | 2005-03-29 19:04:19 +0200 |
| commit | 646f072d2c7d0caef821ebcb28dc47108278f497 (patch) | |
| tree | a12074ebe17c8f982613061aa062e94f0ce8e039 | |
| parent | 054c0650e9db52417825b5a9de1198df1e67c7e9 (diff) | |
| download | mariadb-git-646f072d2c7d0caef821ebcb28dc47108278f497.tar.gz | |
init_db.sql:
Updates to be in sync with 'mysql_create_system_tables'
mysql-test/lib/init_db.sql:
Updates to be in sync with 'mysql_create_system_tables'
| -rw-r--r-- | mysql-test/lib/init_db.sql | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/mysql-test/lib/init_db.sql b/mysql-test/lib/init_db.sql index e3bf669db4e..97fa6fb955c 100644 --- a/mysql-test/lib/init_db.sql +++ b/mysql-test/lib/init_db.sql @@ -84,6 +84,7 @@ CREATE TABLE user ( Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, + Create_user_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, ssl_type enum('','ANY','X509', 'SPECIFIED') COLLATE utf8_general_ci DEFAULT '' NOT NULL, ssl_cipher BLOB NOT NULL, x509_issuer BLOB NOT NULL, @@ -98,9 +99,9 @@ CHARACTER SET utf8 COLLATE utf8_bin comment='Users and global privileges'; -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','','','','',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','','','','',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','','','','',0,0,0,0); +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','','','','',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','','','','',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','','','','',0,0,0,0); INSERT INTO user (host,user) VALUES ('localhost',''); INSERT INTO user (host,user) VALUES ('@HOSTNAME@%',''); @@ -147,11 +148,11 @@ comment='Column privileges'; CREATE TABLE help_topic ( help_topic_id int unsigned not null, - name varchar(64) not null, + name char(64) not null, help_category_id smallint unsigned not null, description text not null, example text not null, - url varchar(128) not null, + url char(128) not null, primary key (help_topic_id), unique index (name) ) engine=MyISAM @@ -161,9 +162,9 @@ comment='help topics'; CREATE TABLE help_category ( help_category_id smallint unsigned not null, - name varchar(64) not null, + name char(64) not null, parent_category_id smallint unsigned null, - url varchar(128) not null, + url char(128) not null, primary key (help_category_id),unique index (name) ) engine=MyISAM CHARACTER SET utf8 @@ -172,7 +173,7 @@ comment='help categories'; CREATE TABLE help_keyword ( help_keyword_id int unsigned not null, - name varchar(64) not null, + name char(64) not null, primary key (help_keyword_id),unique index (name) ) engine=MyISAM CHARACTER SET utf8 |