diff options
author | monty@mysql.com <> | 2005-03-22 15:48:06 +0200 |
---|---|---|
committer | monty@mysql.com <> | 2005-03-22 15:48:06 +0200 |
commit | cc5600513076e4b7ef1fde465983e2f086cfd57d (patch) | |
tree | c6c0d1b66f3806c56a502e647603e7e2566f6604 /scripts/fill_func_tables.sh | |
parent | 06862bc15f4d8c8a0ba8263d9e969b525a1d7881 (diff) | |
download | mariadb-git-cc5600513076e4b7ef1fde465983e2f086cfd57d.tar.gz |
Hack to ensure that CHAR's created in 5.0 are not converted to VARCHAR even if the row type is dynamic
(For 4.1 tables old 'VARCHAR' fields are converted to true VARCHAR in the next ALTER TABLE)
This ensures that one can use MySQL 5.0 privilege tables with MySQL 4.1
Diffstat (limited to 'scripts/fill_func_tables.sh')
-rw-r--r-- | scripts/fill_func_tables.sh | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/scripts/fill_func_tables.sh b/scripts/fill_func_tables.sh index 459afee2fe1..203c730dd9a 100644 --- a/scripts/fill_func_tables.sh +++ b/scripts/fill_func_tables.sh @@ -131,8 +131,8 @@ print "USE mysql_help;\n"; print "DROP TABLE IF EXISTS function;\n"; print "CREATE TABLE function ("; print " func_id int unsigned not null auto_increment,"; -print " name varchar(64) not null,"; -print " url varchar(128) not null,"; +print " name char(64) not null,"; +print " url char(128) not null,"; print " description text not null,"; print " example text not null,"; print " min_args tinyint not null,"; @@ -145,8 +145,8 @@ print ") type=myisam;\n\n"; print "DROP TABLE IF EXISTS function_category_name;\n"; print "CREATE TABLE function_category_name ("; print " cat_id smallint unsigned not null auto_increment,"; -print " name varchar(64) not null,"; -print " url varchar(128) not null,"; +print " name char(64) not null,"; +print " url char(128) not null,"; print " date_created datetime not null,"; print " last_modified timestamp not null,"; print " primary key (cat_id)"; |