# MySQL-Front Dump 2.4
#
# Host: localhost Database: mwdb
#--------------------------------------------------------
# Server version 4.0.15-ntUSE mwdb;
#
# Table structure for table 'aboutus'
#DROP TABLE IF EXISTS aboutus;
CREATE TABLE `aboutus` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) default '0',
`title1` varchar(50) default '0',
`picname1` varchar(25) default '0',
`picname2` varchar(25) default '0',
`picname3` varchar(25) default '0',
`aviname1` varchar(25) default '0',
`aviname2` varchar(25) default '0',
`aviname3` varchar(255) default '0',
`memo` text,
`adate` varchar(50) default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;#
# Table structure for table 'adv_media'
#DROP TABLE IF EXISTS adv_media;
CREATE TABLE `adv_media` (
`ID` tinyint(4) unsigned NOT NULL auto_increment,
`MEDIA` varchar(50) default '',
`TYPEID` int(11) unsigned default '0',
`ORDERS` tinyint(3) unsigned default '0',
`SHOWED` varchar(8) default NULL,
KEY `ID` (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'adv_mediatype'
#DROP TABLE IF EXISTS adv_mediatype;
CREATE TABLE `adv_mediatype` (
`id` tinyint(4) NOT NULL auto_increment,
`type_name` varchar(25) default '0',
`type_sizew` int(11) unsigned default '0',
`type_sizeh` int(11) unsigned default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;#
# Table structure for table 'article'
#DROP TABLE IF EXISTS article;
CREATE TABLE `article` (
`ID` tinyint(6) unsigned NOT NULL auto_increment,
`INTITLE` varchar(50) default NULL,
`INTITLE1` varchar(50) default NULL,
`INMEMO` text,
`TEMPLE` tinyint(3) default NULL,
`TITLE` varchar(50) default '',
`RESEDITOR` varchar(50) default NULL,
`TITLE1` varchar(50) default NULL,
`WRITER` varchar(20) default '',
`TEXT` text,
`IFCOPY` varchar(8) default NULL,
`COPYFROM` varchar(50) default '',
`RECOMMENDED` varchar(11) default NULL,
`PUB_ID` tinyint(4) unsigned default '0',
`CATAS_ID` tinyint(4) unsigned default '0',
`PICNAME1` varchar(25) default NULL,
`PICNAME2` varchar(25) default NULL,
`PICNAME3` varchar(25) default NULL,
`AVINAME1` varchar(25) default NULL,
`AVINAME2` tinyint(3) unsigned default NULL,
`AVINAME3` varchar(25) default NULL,
`YEARS` varchar(11) default '0',
`MONTHS` tinyint(11) unsigned default NULL,
`DAYS` tinyint(11) unsigned default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'article_editor'
#DROP TABLE IF EXISTS article_editor;
CREATE TABLE `article_editor` (
`ID` int(11) unsigned NOT NULL auto_increment,
`PUB_ID` int(11) unsigned default '0',
`CATAS_ID` int(11) unsigned default '0',
`UDATE` varchar(25) default '0',
`TITLE` varchar(50) default NULL,
`MEMO` text,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'catalog_idx'
#DROP TABLE IF EXISTS catalog_idx;
CREATE TABLE `catalog_idx` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`NAME` varchar(20) default '',
KEY `ID` (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'catalogs'
#DROP TABLE IF EXISTS catalogs;
CREATE TABLE `catalogs` (
`ID` tinyint(10) unsigned NOT NULL auto_increment,
`PUB_ID` tinyint(4) unsigned default '0',
`CATA_ID` tinyint(3) unsigned default '0',
`ORDERS` tinyint(3) unsigned default '0',
`NAME` varchar(50) default '0',
`PIC1` varchar(50) default NULL,
`PIC2` varchar(50) default NULL,
`PIC3` varchar(50) default NULL,
`IFSHOW` tinyint(3) unsigned default '0',
KEY `ID` (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'draft'
#DROP TABLE IF EXISTS draft;
CREATE TABLE `draft` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`TITLE` varchar(20) default '',
`WRITER` varchar(10) default '',
`UNIT` varchar(50) default '',
`PHONE` varchar(24) default NULL,
`EMAIL` varchar(50) default '',
`FILE` varchar(50) default '',
`MEMO` varchar(250) default '',
`TOWHO` varchar(50) default '',
`DRAFT_TYPE` tinyint(3) unsigned default '0',
`UPDATETIME` varchar(50) default NULL,
`IFSHOW` varchar(11) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'draft_reply'
#DROP TABLE IF EXISTS draft_reply;
CREATE TABLE `draft_reply` (
`id` int(11) NOT NULL auto_increment,
`contri_id` int(11) unsigned default NULL,
`title` varchar(255) default NULL,
`memo` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM;#
# Table structure for table 'draft_type'
#DROP TABLE IF EXISTS draft_type;
CREATE TABLE `draft_type` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`NAME` varchar(20) default '',
`ORDERNUM` tinyint(3) unsigned default '0',
KEY `ID` (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'leaveword'
#DROP TABLE IF EXISTS leaveword;
CREATE TABLE `leaveword` (
`ID` tinyint(3) NOT NULL auto_increment,
`NAME` varchar(20) default '',
`WORK` varchar(50) default NULL,
`EMAIL` varchar(50) default NULL,
`MEMO` text,
`LDATE` varchar(50) default NULL,
`PHONE` int(11) unsigned default NULL,
`FAX` int(11) unsigned default NULL,
`ADDRESS` varchar(50) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'media'
#DROP TABLE IF EXISTS media;
CREATE TABLE `media` (
`ID` tinyint(5) unsigned NOT NULL auto_increment,
`ARTI_ID` tinyint(5) unsigned default '0',
`FILE_PATH` varchar(250) default '',
`TYPE` varchar(12) default '',
KEY `ID` (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'member'
#DROP TABLE IF EXISTS member;
CREATE TABLE `member` (
`ID` tinyint(5) unsigned NOT NULL auto_increment,
`NAME` varchar(20) default '',
`TRUE_NAME` varchar(20) default '',
`UNIT` varchar(50) default '',
`ADDRE` varchar(100) default '',
`PHONE` varchar(24) default '',
`EMAIL` varchar(50) default '',
`PWD` varchar(120) default '',
`MEMO` text,
`IFOK` tinyint(3) unsigned default '0',
KEY `ID` (`ID`)
) TYPE=MyISAM;
上面这段代码就是.sql的文件 在mysql下怎么执行啊
#
# Host: localhost Database: mwdb
#--------------------------------------------------------
# Server version 4.0.15-ntUSE mwdb;
#
# Table structure for table 'aboutus'
#DROP TABLE IF EXISTS aboutus;
CREATE TABLE `aboutus` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) default '0',
`title1` varchar(50) default '0',
`picname1` varchar(25) default '0',
`picname2` varchar(25) default '0',
`picname3` varchar(25) default '0',
`aviname1` varchar(25) default '0',
`aviname2` varchar(25) default '0',
`aviname3` varchar(255) default '0',
`memo` text,
`adate` varchar(50) default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;#
# Table structure for table 'adv_media'
#DROP TABLE IF EXISTS adv_media;
CREATE TABLE `adv_media` (
`ID` tinyint(4) unsigned NOT NULL auto_increment,
`MEDIA` varchar(50) default '',
`TYPEID` int(11) unsigned default '0',
`ORDERS` tinyint(3) unsigned default '0',
`SHOWED` varchar(8) default NULL,
KEY `ID` (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'adv_mediatype'
#DROP TABLE IF EXISTS adv_mediatype;
CREATE TABLE `adv_mediatype` (
`id` tinyint(4) NOT NULL auto_increment,
`type_name` varchar(25) default '0',
`type_sizew` int(11) unsigned default '0',
`type_sizeh` int(11) unsigned default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;#
# Table structure for table 'article'
#DROP TABLE IF EXISTS article;
CREATE TABLE `article` (
`ID` tinyint(6) unsigned NOT NULL auto_increment,
`INTITLE` varchar(50) default NULL,
`INTITLE1` varchar(50) default NULL,
`INMEMO` text,
`TEMPLE` tinyint(3) default NULL,
`TITLE` varchar(50) default '',
`RESEDITOR` varchar(50) default NULL,
`TITLE1` varchar(50) default NULL,
`WRITER` varchar(20) default '',
`TEXT` text,
`IFCOPY` varchar(8) default NULL,
`COPYFROM` varchar(50) default '',
`RECOMMENDED` varchar(11) default NULL,
`PUB_ID` tinyint(4) unsigned default '0',
`CATAS_ID` tinyint(4) unsigned default '0',
`PICNAME1` varchar(25) default NULL,
`PICNAME2` varchar(25) default NULL,
`PICNAME3` varchar(25) default NULL,
`AVINAME1` varchar(25) default NULL,
`AVINAME2` tinyint(3) unsigned default NULL,
`AVINAME3` varchar(25) default NULL,
`YEARS` varchar(11) default '0',
`MONTHS` tinyint(11) unsigned default NULL,
`DAYS` tinyint(11) unsigned default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'article_editor'
#DROP TABLE IF EXISTS article_editor;
CREATE TABLE `article_editor` (
`ID` int(11) unsigned NOT NULL auto_increment,
`PUB_ID` int(11) unsigned default '0',
`CATAS_ID` int(11) unsigned default '0',
`UDATE` varchar(25) default '0',
`TITLE` varchar(50) default NULL,
`MEMO` text,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'catalog_idx'
#DROP TABLE IF EXISTS catalog_idx;
CREATE TABLE `catalog_idx` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`NAME` varchar(20) default '',
KEY `ID` (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'catalogs'
#DROP TABLE IF EXISTS catalogs;
CREATE TABLE `catalogs` (
`ID` tinyint(10) unsigned NOT NULL auto_increment,
`PUB_ID` tinyint(4) unsigned default '0',
`CATA_ID` tinyint(3) unsigned default '0',
`ORDERS` tinyint(3) unsigned default '0',
`NAME` varchar(50) default '0',
`PIC1` varchar(50) default NULL,
`PIC2` varchar(50) default NULL,
`PIC3` varchar(50) default NULL,
`IFSHOW` tinyint(3) unsigned default '0',
KEY `ID` (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'draft'
#DROP TABLE IF EXISTS draft;
CREATE TABLE `draft` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`TITLE` varchar(20) default '',
`WRITER` varchar(10) default '',
`UNIT` varchar(50) default '',
`PHONE` varchar(24) default NULL,
`EMAIL` varchar(50) default '',
`FILE` varchar(50) default '',
`MEMO` varchar(250) default '',
`TOWHO` varchar(50) default '',
`DRAFT_TYPE` tinyint(3) unsigned default '0',
`UPDATETIME` varchar(50) default NULL,
`IFSHOW` varchar(11) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'draft_reply'
#DROP TABLE IF EXISTS draft_reply;
CREATE TABLE `draft_reply` (
`id` int(11) NOT NULL auto_increment,
`contri_id` int(11) unsigned default NULL,
`title` varchar(255) default NULL,
`memo` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM;#
# Table structure for table 'draft_type'
#DROP TABLE IF EXISTS draft_type;
CREATE TABLE `draft_type` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`NAME` varchar(20) default '',
`ORDERNUM` tinyint(3) unsigned default '0',
KEY `ID` (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'leaveword'
#DROP TABLE IF EXISTS leaveword;
CREATE TABLE `leaveword` (
`ID` tinyint(3) NOT NULL auto_increment,
`NAME` varchar(20) default '',
`WORK` varchar(50) default NULL,
`EMAIL` varchar(50) default NULL,
`MEMO` text,
`LDATE` varchar(50) default NULL,
`PHONE` int(11) unsigned default NULL,
`FAX` int(11) unsigned default NULL,
`ADDRESS` varchar(50) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'media'
#DROP TABLE IF EXISTS media;
CREATE TABLE `media` (
`ID` tinyint(5) unsigned NOT NULL auto_increment,
`ARTI_ID` tinyint(5) unsigned default '0',
`FILE_PATH` varchar(250) default '',
`TYPE` varchar(12) default '',
KEY `ID` (`ID`)
) TYPE=MyISAM;#
# Table structure for table 'member'
#DROP TABLE IF EXISTS member;
CREATE TABLE `member` (
`ID` tinyint(5) unsigned NOT NULL auto_increment,
`NAME` varchar(20) default '',
`TRUE_NAME` varchar(20) default '',
`UNIT` varchar(50) default '',
`ADDRE` varchar(100) default '',
`PHONE` varchar(24) default '',
`EMAIL` varchar(50) default '',
`PWD` varchar(120) default '',
`MEMO` text,
`IFOK` tinyint(3) unsigned default '0',
KEY `ID` (`ID`)
) TYPE=MyISAM;
上面这段代码就是.sql的文件 在mysql下怎么执行啊
c:\mysql\bin>mysql -u 帐号 -p mwdb<.sql的文件 (回车)
输入密码 (回车)