用文本打开jive_mysql.sql文件,把前面没有#的代码粘贴到dos中执行。mysql> use jive;
Database changed
粘贴代码:
如:mysql> CREATE TABLE jiveForum (
-> forumID BIGINT NOT NULL,
-> name VARCHAR(255) UNIQUE NOT NULL,
-> description TEXT,
-> modDefaultThreadVal BIGINT NOT NULL,
-> modMinThreadVal BIGINT NOT NULL,
-> modDefaultMsgVal BIGINT NOT NULL,
-> modMinMsgVal BIGINT NOT NULL,
-> modifiedDate VARCHAR(15) NOT NULL,
-> creationDate VARCHAR(15) NOT NULL,
-> PRIMARY KEY (forumID),
-> INDEX jiveForum_name_idx (name(10))
-> );
然后出现:Query OK, 0 rows affected (0.04 sec)