在mysql里输入source d:\\alumni.sql
执行没有问题.
[CODE]drop database if exists `dbtest`;
create database dbtest;
use dbtest;
DROP TABLE IF EXISTS `alumni_adminnotice`;
CREATE TABLE `alumni_adminnotice` (
`id` tinyint(4) NOT NULL auto_increment,
`title` varchar(40) NOT NULL default '',
`content` mediumtext NOT NULL,
`name` varchar(8) NOT NULL default '',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_adminnotice`
#
# --------------------------------------------------------
#
# 数据表的结构 `alumni_audio`
#
DROP TABLE IF EXISTS `alumni_audio`;
CREATE TABLE `alumni_audio` (
`id` int(11) NOT NULL auto_increment,
`filename` varchar(20) NOT NULL default '',
`whos` varchar(8) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_audio`
#
# --------------------------------------------------------
#
# 数据表的结构 `alumni_config`
#
DROP TABLE IF EXISTS `alumni_config`;
CREATE TABLE `alumni_config` (
`id` tinyint(4) NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`value` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_config`
#
INSERT INTO `alumni_config` (`id`, `name`, `value`) VALUES (1,
'rowno', '5'),
(2, 'colno', '3'),
(3, 'swidth', '110'),
(4, 'sheight', '110'),
(5, 'adminmail', 'aet_cn@163.net'),
(6, 'totalpm', '10'),
(7, 'totalvister', '271'),
(8, 'audionum', '10');
# --------------------------------------------------------
#
# 数据表的结构 `alumni_forums`
#
DROP TABLE IF EXISTS `alumni_forums`;
CREATE TABLE `alumni_forums` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` char(50) NOT NULL default '',
`active` smallint(6) NOT NULL default '0',
`description` char(255) NOT NULL default '',
`config_suffix` char(50) NOT NULL default '',
`folder` char(1) NOT NULL default '0',
`parent` int(10) unsigned NOT NULL default '0',
`display` int(10) unsigned NOT NULL default '0',
`table_name` char(50) NOT NULL default '',
`moderation` char(1) NOT NULL default 'n',
`email_list` char(50) NOT NULL default '',
`email_return` char(50) NOT NULL default '',
`email_tag` char(50) NOT NULL default '',
`check_dup` smallint(5) unsigned NOT NULL default '0',
`multi_level` smallint(5) unsigned NOT NULL default '0',
`collapse` smallint(5) unsigned NOT NULL default '0',
`flat` smallint(5) unsigned NOT NULL default '0',
`lang` char(50) NOT NULL default '',
`html` char(40) NOT NULL default 'N',
`table_width` char(4) NOT NULL default '',
`table_header_color` char(7) NOT NULL default '',
`table_header_font_color` char(7) NOT NULL default '',
`table_body_color_1` char(7) NOT NULL default '',
`table_body_color_2` char(7) NOT NULL default '',
`table_body_font_color_1` char(7) NOT NULL default '',
`table_body_font_color_2` char(7) NOT NULL default '',
`nav_color` char(7) NOT NULL default '',
`nav_font_color` char(7) NOT NULL default '',
`allow_uploads` char(1) NOT NULL default 'N',
`upload_types` char(100) NOT NULL default '',
`upload_size` int(10) unsigned NOT NULL default '0',
`max_uploads` int(10) unsigned NOT NULL default '0',
`security` int(10) unsigned NOT NULL default '0',
`showip` smallint(5) unsigned NOT NULL default '1',
`emailnotification` smallint(5) unsigned NOT NULL default '1',
`body_color` char(7) NOT NULL default '',
`body_link_color` char(7) NOT NULL default '',
`body_alink_color` char(7) NOT NULL default '',
`body_vlink_color` char(7) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `active` (`active`),
KEY `parent` (`parent`),
KEY `security` (`security`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_forums`
#
INSERT INTO `alumni_forums` (`id`, `name`, `active`,
`description`, `config_suffix`, `folder`, `parent`, `display`,
`table_name`, `moderation`, `email_list`, `email_return`,
`email_tag`, `check_dup`, `multi_level`, `collapse`, `flat`,
`lang`, `html`, `table_width`, `table_header_color`,
`table_header_font_color`, `table_body_color_1`,
`table_body_color_2`, `table_body_font_color_1`,
`table_body_font_color_2`, `nav_color`, `nav_font_color`,
`allow_uploads`, `upload_types`, `upload_size`, `max_uploads`,
`security`, `showip`, `emailnotification`, `body_color`,
`body_link_color`, `body_alink_color`, `body_vlink_color`)
VALUES (2, '友情同学录留言板', 1, '', '', '0', 0, 30,
'alumni_guest', 'n', '', '', '', 1, 2, 1, 1, 'lang/english.php',
'1', '', '#F3CBFF', '#000000', '#F3CBDD', '#F3CBDD', '#000000',
'#000000', '#F3CBDD', '#000000', 'N', '', 0, 0, 0, 1, 0,
'#F3CBDD', '#000000', '#000000', '#000000');
# --------------------------------------------------------
#
# 数据表的结构 `alumni_forums_auth`
#
DROP TABLE IF EXISTS `alumni_forums_auth`;
CREATE TABLE `alumni_forums_auth` (
`id` int(10) unsigned NOT NULL auto_increment,
`sess_id` varchar(32) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`username` varchar(50) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`email` varchar(200) NOT NULL default '',
`webpage` varchar(200) NOT NULL default '',
`image` varchar(200) NOT NULL default '',
`icq` varchar(50) NOT NULL default '',
`aol` varchar(50) NOT NULL default '',
`yahoo` varchar(50) NOT NULL default '',
`msn` varchar(50) NOT NULL default '',
`jabber` varchar(50) NOT NULL default '',
`signature` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `username` (`username`),
KEY `sess_id` (`sess_id`),
KEY `password` (`password`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_forums_auth`
#
# --------------------------------------------------------
#
# 数据表的结构 `alumni_forums_moderators`
#
DROP TABLE IF EXISTS `alumni_forums_moderators`;
CREATE TABLE `alumni_forums_moderators` (
`user_id` int(10) unsigned NOT NULL default '0',
`forum_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`user_id`,`forum_id`),
KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_forums_moderators`
#
INSERT INTO `alumni_forums_moderators` (`user_id`, `forum_id`)
VALUES (1, 0);
# --------------------------------------------------------
#
# 数据表的结构 `alumni_guest`
#
DROP TABLE IF EXISTS `alumni_guest`;
CREATE TABLE `alumni_guest` (
`id` int(10) unsigned NOT NULL default '0',
`datestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`thread` int(10) unsigned NOT NULL default '0',
`parent` int(10) unsigned NOT NULL default '0',
`author` char(37) NOT NULL default '',
`subject` char(255) NOT NULL default '',
`email` char(200) NOT NULL default '',
`host` char(50) NOT NULL default '',
`email_reply` char(1) NOT NULL default 'N',
`approved` char(1) NOT NULL default 'N',
`msgid` char(100) NOT NULL default '',
`modifystamp` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `author` (`author`),
KEY `userid` (`userid`),
KEY `datestamp` (`datestamp`),
KEY `subject` (`subject`),
KEY `thread` (`thread`),
KEY `parent` (`parent`),
KEY `approved` (`approved`),
KEY `msgid` (`msgid`),
KEY `modifystamp` (`modifystamp`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_guest`
#
#
# 数据表的结构 `alumni_guest_bodies`
#
DROP TABLE IF EXISTS `alumni_guest_bodies`;
CREATE TABLE `alumni_guest_bodies` (
`id` int(10) unsigned NOT NULL auto_increment,
`body` text NOT NULL,
`thread` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `thread` (`thread`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_guest_bodies`
#
# --------------------------------------------------------
#
# 数据表的结构 `alumni_photo`
#
DROP TABLE IF EXISTS `alumni_photo`;
CREATE TABLE `alumni_photo` (
`id` tinyint(4) NOT NULL auto_increment,
`name` varchar(35) NOT NULL default '',
`title` varchar(20) NOT NULL default '',
`disc` mediumtext NOT NULL,
`user` varchar(8) NOT NULL default '',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_photo`
#
# --------------------------------------------------------
#
# 数据表的结构 `alumni_pm`
#
DROP TABLE IF EXISTS `alumni_pm`;
CREATE TABLE `alumni_pm` (
`id` tinyint(4) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`content` mediumtext NOT NULL,
`sender` varchar(8) NOT NULL default '',
`receiver` varchar(8) NOT NULL default '',
`sendtime` datetime NOT NULL default '0000-00-00 00:00:00',
`stat` char(1) NOT NULL default '',
`readed` char(1) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_pm`
#
# --------------------------------------------------------
#
# 数据表的结构 `alumni_student`
#
DROP TABLE IF EXISTS `alumni_student`;
CREATE TABLE `alumni_student` (
`id` tinyint(4) NOT NULL auto_increment,
`stuname` varchar(8) NOT NULL default '',
`stuno` varchar(15) NOT NULL default '',
`reged` char(2) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `alumni_student`
#
# --------------------------------------------------------
#
# 数据表的结构 `alumni_user`
#
DROP TABLE IF EXISTS `alumni_user`;
CREATE TABLE `alumni_user` (
`id` tinyint(4) NOT NULL auto_increment,
`stuid` tinyint(4) NOT NULL default '0',
`pass` varchar(18) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`homepage` varchar(100) NOT NULL default '',
`qq` varchar(10) NOT NULL default '0',
`msn` varchar(50) NOT NULL default '',
`tel` varchar(15) NOT NULL default '0',
`address` varchar(100) NOT NULL default '',
`lognum` tinyint(5) NOT NULL default '0',
`jifen` tinyint(6) NOT NULL default '0',
`levle` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM;[/CODE]
