算是对"创建测试环境数据库语句.txt"的补充吧
mysql<4.1
复制内容到剪贴板
代码:
DROP TABLE IF EXISTS moophp_test;
CREATE TABLE moophp_test (
id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
title CHAR(80) NOT NULL,
dateline INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (id)
) TYPE = MyISAM;
INSERT INTO moophp_test VALUES (1, 'Title NO\.1', 1191244504);
INSERT INTO moophp_test VALUES (2, 'Title NO\.2', 1191244505);
INSERT INTO moophp_test VALUES (3, 'Title NO\.3', 1191244506);
CREATE TABLE moophp_settings (
param varchar(32) NOT NULL default '',
value text NOT NULL,
PRIMARY KEY (param)
) TYPE = MyISAM;
INSERT INTO moophp_settings VALUES ('sitename', 'MooPHP Demo Site');
INSERT INTO moophp_settings VALUES ('siteurl', 'http://www.moophp.net');
DROP TABLE IF EXISTS moophp_blogs;
CREATE TABLE moophp_blogs (
id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
title CHAR(80) NOT NULL,
content text NOT NULL,
dateline INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (id)
) TYPE = MyISAM;
INSERT INTO moophp_blogs VALUES (1, 'Title NO\.1', 'Content NO.1', 1191244504);
INSERT INTO moophp_blogs VALUES (2, 'Title NO\.2', 'Content NO.2', 1191244505);
INSERT INTO moophp_blogs VALUES (3, 'Title NO\.3', 'Content NO.3', 1191244506);Mysql>=4.1
复制内容到剪贴板
代码:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
DROP TABLE IF EXISTS moophp_test;
CREATE TABLE moophp_test (
id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
title CHAR(80) NOT NULL,
dateline INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (id)
) ENGINE = MyISAM DEFAULT CHARSET=utf8;
INSERT INTO moophp_test VALUES (1, 'Title NO\.1', 1191244504);
INSERT INTO moophp_test VALUES (2, 'Title NO\.2', 1191244505);
INSERT INTO moophp_test VALUES (3, 'Title NO\.3', 1191244506);
CREATE TABLE moophp_settings (
param varchar(32) NOT NULL default '',
value text NOT NULL,
PRIMARY KEY (param)
) ENGINE = MyISAM DEFAULT CHARSET=utf8;
INSERT INTO moophp_settings VALUES ('sitename', 'MooPHP Demo Site');
INSERT INTO moophp_settings VALUES ('siteurl', 'http://www.moophp.net');
DROP TABLE IF EXISTS moophp_blogs;
CREATE TABLE moophp_blogs (
id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
title CHAR(80) NOT NULL,
content text NOT NULL,
dateline INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (id)
) ENGINE = MyISAM DEFAULT CHARSET=utf8;
INSERT INTO moophp_blogs VALUES (1, 'Title NO\.1', 'Content NO.1', 1191244504);
INSERT INTO moophp_blogs VALUES (2, 'Title NO\.2', 'Content NO.2', 1191244505);
INSERT INTO moophp_blogs VALUES (3, 'Title NO\.3', 'Content NO.3', 1191244506);
