www.pudn.com > YHCMSstruts.rar > yhcms.sql

/* 
MySQL Data Transfer 
Source Host: localhost 
Source Database: yhcms 
Target Host: localhost 
Target Database: yhcms 
Date: 2007/04/05 17:22:38 
*/ 
 
SET FOREIGN_KEY_CHECKS=0; 
-- ---------------------------- 
-- Table structure for aboutus 
-- ---------------------------- 
CREATE TABLE `aboutus` (
  `id` smallint(10) unsigned NOT NULL,
  `aboutus` text,
  `copyright` text,
  `contactus` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Table structure for admin 
-- ---------------------------- 
CREATE TABLE `admin` (
  `id` int(10) unsigned NOT NULL,
  `username` char(16) NOT NULL,
  `password` char(40) NOT NULL,
  `groupid` smallint(5) unsigned NOT NULL default '0',
  `groupname` varchar(16) NOT NULL default ' ',
  `lasttime` datetime NOT NULL default '1900-01-01 00:00:00',
  `lastip` char(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `a_id_name` (`id`,`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Table structure for artclass 
-- ---------------------------- 
CREATE TABLE `artclass` (
  `id` tinyint(4) unsigned NOT NULL default '0',
  `parentid` tinyint(4) NOT NULL default '0',
  `name` char(10) default NULL,
  `sort` tinyint(3) unsigned NOT NULL default '0',
  `isclass` tinyint(1) unsigned NOT NULL default '1',
  `url` char(60) NOT NULL,
  `about` char(100) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `in_id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Table structure for article 
-- ---------------------------- 
CREATE TABLE `article` (
  `id` int(10) unsigned NOT NULL,
  `ftitle` char(120) NOT NULL,
  `stitle` varchar(100) NOT NULL default ' ',
  `cmfrom` varchar(100) NOT NULL default ' ',
  `author` char(10) NOT NULL,
  `editor` char(10) NOT NULL,
  `bigclassid` tinyint(3) unsigned NOT NULL default '0',
  `bigclass` char(15) NOT NULL,
  `content` mediumtext NOT NULL,
  `ftime` date NOT NULL default '2000-01-01',
  `fip` char(20) NOT NULL,
  `readtimes` int(10) unsigned NOT NULL default '0',
  `bid` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `in_bigclass` (`bigclassid`),
  KEY `in_id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 ROW_FORMAT=DYNAMIC; 
 
-- ---------------------------- 
-- Table structure for comt 
-- ---------------------------- 
CREATE TABLE `comt` (
  `id` int(10) unsigned NOT NULL,
  `artid` int(11) unsigned NOT NULL default '0',
  `name` char(12) NOT NULL,
  `email` varchar(30) NOT NULL default ' ',
  `content` varchar(255) NOT NULL default ' ',
  `ip` char(20) NOT NULL default '',
  `ptime` datetime NOT NULL default '1900-01-01 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Table structure for info 
-- ---------------------------- 
CREATE TABLE `info` (
  `name` varchar(20) NOT NULL,
  `url` varchar(80) NOT NULL,
  `title` varchar(225) NOT NULL,
  `logo` varchar(100) NOT NULL,
  `banner` varchar(150) NOT NULL,
  `banlink` varchar(150) NOT NULL,
  `copyright` varchar(100) NOT NULL,
  `record` varchar(100) NOT NULL,
  `contact` varchar(200) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Table structure for link 
-- ---------------------------- 
CREATE TABLE `link` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default ' ',
  `url` varchar(40) NOT NULL default ' ',
  `type` enum('1','0') NOT NULL default '1' COMMENT '1:text 0:image',
  `content` varchar(30) default NULL,
  `logo` varchar(50) character set gbk default ' ',
  `master` varchar(20) default ' ',
  `contact` varchar(40) default NULL,
  `sort` smallint(6) unsigned NOT NULL default '0',
  `checked` enum('1','0') character set gbk default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Table structure for magroup 
-- ---------------------------- 
CREATE TABLE `magroup` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(16) NOT NULL default ' ',
  `popedom` varchar(50) NOT NULL default ' ',
  `about` varchar(255) NOT NULL default ' ',
  `addby` varchar(16) NOT NULL default ' ',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Table structure for note 
-- ---------------------------- 
CREATE TABLE `note` (
  `id` int(10) unsigned NOT NULL default '0',
  `author` varchar(16) NOT NULL,
  `comefrom` varchar(50) NOT NULL default ' ',
  `weburl` varchar(50) NOT NULL default ' ',
  `email` varchar(50) NOT NULL,
  `qq` varchar(11) NOT NULL default '0',
  `image` varchar(6) NOT NULL default ' ',
  `title` varchar(40) NOT NULL default ' ',
  `content` text NOT NULL,
  `ptime` date NOT NULL default '2000-01-01',
  `ip` varchar(16) NOT NULL default ' ',
  `answer` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Table structure for notice 
-- ---------------------------- 
CREATE TABLE `notice` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default ' ',
  `content` mediumtext NOT NULL,
  `display` enum('1','0') character set gbk NOT NULL default '1',
  `posttime` date NOT NULL default '1900-01-01',
  `byuser` varchar(16) NOT NULL default ' ',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Table structure for survey 
-- ---------------------------- 
CREATE TABLE `survey` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` char(30) NOT NULL,
  `content` char(30) NOT NULL,
  `times` int(10) unsigned NOT NULL default '0',
  `ptime` date NOT NULL default '1900-00-00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Table structure for upload 
-- ---------------------------- 
CREATE TABLE `upload` (
  `id` int(10) unsigned NOT NULL,
  `artid` int(10) NOT NULL default '0',
  `author` int(10) NOT NULL default '0',
  `filename` varchar(50) NOT NULL default ' ',
  `filetype` varchar(5) NOT NULL default ' ',
  `filesize` int(10) NOT NULL default '0',
  `realname` varchar(50) NOT NULL default ' ',
  `ptime` date NOT NULL default '2000-01-01',
  `path` varchar(50) NOT NULL default ' ',
  `width` smallint(6) NOT NULL default '0',
  `height` smallint(6) NOT NULL default '0',
  `downtimes` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `fid` (`id`),
  KEY `fartid` (`artid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Records  
-- ---------------------------- 
INSERT INTO `aboutus` VALUES ('1', '关于我们:由由华网/stephen\r\n', '版权申明:由由华网', 'QQ:7348002\r\nE_MAIL:yyhweb@126.com\r\nMSN:stephen7822@hotmail.com\r\n'); 
INSERT INTO `admin` VALUES ('1', 'yang', '96E79218965EB72C92A549DD5A33011200', '1', '超级用户', '2007-04-05 05:20:46', '127.0.0.1'); 
INSERT INTO `artclass` VALUES ('1', '0', 'JAVA技术', '1', '1', '', 'yyhweb'); 
INSERT INTO `artclass` VALUES ('3', '0', '数据库', '4', '1', '', 'yyhweb'); 
INSERT INTO `artclass` VALUES ('4', '0', '简单生活', '5', '1', '', 'yyhweb'); 
INSERT INTO `artclass` VALUES ('2', '0', '编程相关', '2', '1', '', 'yyhweb'); 
INSERT INTO `artclass` VALUES ('5', '0', '休闲娱乐', '6', '0', 'Game.html', 'yyhweb'); 
INSERT INTO `artclass` VALUES ('6', '0', '网站留言', '7', '0', 'NoteShow.html', 'yyhweb'); 
INSERT INTO `artclass` VALUES ('7', '0', '业界新闻', '3', '1', '', '业界新闻'); 
INSERT INTO `info` VALUES ('由由华网', 'http://www.yyhweb.com', '欢迎访问[由由华网]http://www.yyhweb.com', 'logo0.gif', 'app/images/banner.gif', 'http://www.yyhweb.com', '由由华网', '沪 00000001号', 'QQ-7348002   e_mail:yyhweb@126.com'); 
INSERT INTO `link` VALUES ('1', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '1', '1'); 
INSERT INTO `link` VALUES ('2', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '2', '1'); 
INSERT INTO `link` VALUES ('3', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '3', '1'); 
INSERT INTO `link` VALUES ('4', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '4', '1'); 
INSERT INTO `link` VALUES ('5', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '5', '1'); 
INSERT INTO `link` VALUES ('6', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '6', '1'); 
INSERT INTO `link` VALUES ('7', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '7', '1'); 
INSERT INTO `link` VALUES ('8', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '8', '1'); 
INSERT INTO `link` VALUES ('9', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '9', '1'); 
INSERT INTO `link` VALUES ('10', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '10', '1'); 
INSERT INTO `link` VALUES ('11', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '11', '1'); 
INSERT INTO `link` VALUES ('12', '由由华网', 'www.yyhweb.com', '0', '由由华网', '', 'stephen', '7348002', '12', '1'); 
INSERT INTO `magroup` VALUES ('1', '超级用户', '111,111,1111,11111111', '具有系统最高权限', 'yang'); 
INSERT INTO `notice` VALUES ('1', 'Test', 'test', '1', '2007-03-21', 'yang');