diff options
author | unknown <greg@mysql.com> | 2004-01-13 01:10:21 -0100 |
---|---|---|
committer | unknown <greg@mysql.com> | 2004-01-13 01:10:21 -0100 |
commit | 491ab7f72e37ae16531567c21df4be11e9f6a0db (patch) | |
tree | 7636898f62fa252776f480102424bb9a5f9a6dba /netware/init_db.sql | |
parent | 79a4b2cd49b87da5dd327cd04242deda7188205f (diff) | |
download | mariadb-git-491ab7f72e37ae16531567c21df4be11e9f6a0db.tar.gz |
Minor Novell supplied changes for 4.1 (inside netware directory)
netware/init_db.sql:
Add new tables for 4.1
netware/libmysql.imp:
Comment out simple_command
Diffstat (limited to 'netware/init_db.sql')
-rw-r--r-- | netware/init_db.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/netware/init_db.sql b/netware/init_db.sql index 4613e5c0274..063c1815eb1 100644 --- a/netware/init_db.sql +++ b/netware/init_db.sql @@ -24,3 +24,7 @@ CREATE TABLE tables_priv (Host char(60) binary DEFAULT '' NOT NULL, Db char(64) CREATE TABLE columns_priv (Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Table_name char(64) binary DEFAULT '' NOT NULL, Column_name char(64) binary DEFAULT '' NOT NULL, Timestamp timestamp(14), Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name,Column_name)) comment='Column privileges'; +CREATE TABLE help_topic (help_topic_id int unsigned NOT NULL, name varchar(64) NOT NULL, help_category_id smallint unsigned NOT NULL, description text NOT NULL, example text NOT NULL, url varchar(128) NOT NULL, primary key (help_topic_id), unique index (name))comment='help topics'; +CREATE TABLE help_category (help_category_id smallint unsigned NOT NULL, name varchar(64) NOT NULL, parent_category_id smallint unsigned null, url varchar(128) NOT NULL, primary key (help_category_id), unique index (name)) comment='help categories'; +CREATE TABLE help_keyword (help_keyword_id int unsigned NOT NULL, name varchar(64) NOT NULL, primary key (help_keyword_id), unique index (name)) comment='help keywords'; +CREATE TABLE help_relation (help_topic_id int unsigned NOT NULL references help_topic, help_keyword_id int unsigned NOT NULL references help_keyword, primary key (help_keyword_id, help_topic_id)) comment='keyword-topic relation'; |