
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*ݱ `cxjw_admin` ıṹ*/

DROP TABLE IF EXISTS `cxjw_admin`;

CREATE TABLE `cxjw_admin` (
  `CD_ID` int(11) NOT NULL AUTO_INCREMENT,
  `CD_AdminUserName` varchar(64) NOT NULL,
  `CD_AdminPassWord` varchar(64) NOT NULL,
  `CD_LoginIP` varchar(128) DEFAULT NULL,
  `CD_LoginNum` int(11) DEFAULT '0',
  `CD_LastLogin` datetime DEFAULT NULL,
  `CD_IsLock` int(11) NOT NULL DEFAULT '0',
  `CD_Permission` varchar(128) NOT NULL,
  PRIMARY KEY (`CD_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_blog` ıṹ*/

DROP TABLE IF EXISTS `cxjw_blog`;

CREATE TABLE `cxjw_blog` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_uname` varchar(50) NOT NULL,
  `cd_uip` varchar(50) DEFAULT NULL,
  `cd_title` varchar(100) NOT NULL,
  `cd_tag` text,
  `cd_style` text,
  `cd_content` text NOT NULL,
  `cd_noreply` int(11) NOT NULL,
  `cd_hidden` int(11) NOT NULL,
  `cd_hits` int(11) NOT NULL,
  `cd_click1` int(11) NOT NULL,
  `cd_click2` int(11) NOT NULL,
  `cd_click3` int(11) NOT NULL,
  `cd_click4` int(11) NOT NULL,
  `cd_click5` int(11) NOT NULL,
  `cd_addtime` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_class` ıṹ*/

DROP TABLE IF EXISTS `cxjw_class`;

CREATE TABLE `cxjw_class` (
  `CD_ID` int(11) NOT NULL AUTO_INCREMENT,
  `CD_Name` varchar(255) NOT NULL,
  `CD_AliasName` varchar(64) NOT NULL,
  `CD_Template` varchar(64) NOT NULL,
  `CD_FatherID` int(11) NOT NULL DEFAULT '0',
  `CD_TieID` varchar(255) DEFAULT NULL,
  `CD_SystemID` int(11) NOT NULL DEFAULT '1',
  `CD_TheOrder` int(11) NOT NULL DEFAULT '0',
  `CD_IsHide` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`CD_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_comment` ıṹ*/

DROP TABLE IF EXISTS `cxjw_comment`;

CREATE TABLE `cxjw_comment` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_channel` int(11) NOT NULL,
  `cd_dataid` int(11) NOT NULL,
  `cd_content` text NOT NULL,
  `cd_uid` int(11) NOT NULL,
  `cd_username` varchar(50) NOT NULL,
  `cd_uip` varchar(255) NOT NULL,
  `cd_admin` text,
  `cd_addtime` datetime NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_dj` ıṹ*/

DROP TABLE IF EXISTS `cxjw_dj`;

CREATE TABLE `cxjw_dj` (
  `CD_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `CD_Name` varchar(255) NOT NULL,
  `CD_ClassID` int(11) NOT NULL,
  `CD_SpecialID` int(11) NOT NULL,
  `CD_Singer` varchar(50) DEFAULT NULL,
  `CD_User` varchar(50) DEFAULT NULL,
  `CD_Pic` text,
  `CD_Url` text,
  `CD_DownUrl` text,
  `CD_Word` text,
  `CD_Lrc` text,
  `CD_Hits` int(11) NOT NULL,
  `CD_DownHits` int(11) NOT NULL,
  `CD_FavHits` int(11) NOT NULL,
  `CD_uHits` int(11) NOT NULL,
  `CD_dHits` int(11) NOT NULL,
  `CD_DayHits` int(11) NOT NULL,
  `CD_WeekHits` int(11) NOT NULL,
  `CD_MonthHits` int(11) NOT NULL,
  `CD_LastHitTime` datetime DEFAULT NULL,
  `CD_AddTime` datetime DEFAULT NULL,
  `CD_Server` int(11) NOT NULL,
  `CD_Deleted` int(11) NOT NULL,
  `CD_IsBest` int(11) NOT NULL,
  `CD_Error` int(11) NOT NULL,
  `CD_Passed` int(11) NOT NULL,
  `CD_Points` int(11) NOT NULL,
  `CD_Grade` int(11) NOT NULL,
  `CD_Color` int(20) DEFAULT NULL,
  `CD_Skin` varchar(50) NOT NULL,
  PRIMARY KEY (`CD_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_doing` ıṹ*/

DROP TABLE IF EXISTS `cxjw_doing`;

CREATE TABLE `cxjw_doing` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_username` varchar(30) NOT NULL,
  `cd_message` text NOT NULL,
  `cd_ip` varchar(20) NOT NULL,
  `cd_mood` smallint(6) NOT NULL,
  `cd_addtime` datetime NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_fans` ıṹ*/

DROP TABLE IF EXISTS `cxjw_fans`;

CREATE TABLE `cxjw_fans` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_uname` varchar(50) NOT NULL,
  `cd_uids` int(11) NOT NULL,
  `cd_unames` varchar(50) NOT NULL,
  `cd_lock` int(11) NOT NULL,
  `cd_addtime` datetime NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_fav` ıṹ*/

DROP TABLE IF EXISTS `cxjw_fav`;

CREATE TABLE `cxjw_fav` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_type` varchar(10) NOT NULL,
  `cd_uid` int(11) NOT NULL,
  `cd_uname` varchar(20) NOT NULL,
  `cd_musicid` int(11) NOT NULL,
  `cd_musicname` varchar(255) NOT NULL,
  `cd_addtime` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_feed` ıṹ*/

DROP TABLE IF EXISTS `cxjw_feed`;

CREATE TABLE `cxjw_feed` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_username` varchar(50) DEFAULT NULL,
  `cd_icon` varchar(20) NOT NULL,
  `cd_title` text NOT NULL,
  `cd_data` text NOT NULL,
  `cd_image` varchar(255) DEFAULT NULL,
  `cd_imagelink` varchar(255) DEFAULT NULL,
  `cd_dataid` int(11) NOT NULL,
  `cd_addtime` datetime NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_friend` ıṹ*/

DROP TABLE IF EXISTS `cxjw_friend`;

CREATE TABLE `cxjw_friend` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_uname` varchar(50) NOT NULL,
  `cd_uids` int(11) NOT NULL,
  `cd_unames` varchar(50) NOT NULL,
  `cd_lock` int(11) NOT NULL,
  `cd_addtime` datetime NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_message` ıṹ*/

DROP TABLE IF EXISTS `cxjw_message`;

CREATE TABLE `cxjw_message` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_uname` varchar(50) NOT NULL,
  `cd_uids` int(11) NOT NULL,
  `cd_unames` varchar(50) NOT NULL,
  `cd_title` text NOT NULL,
  `cd_content` text NOT NULL,
  `cd_class` int(11) NOT NULL,
  `cd_dela` int(11) NOT NULL,
  `cd_delb` int(11) NOT NULL,
  `cd_addtime` datetime NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_mold` ıṹ*/

DROP TABLE IF EXISTS `cxjw_mold`;

CREATE TABLE `cxjw_mold` (
  `CD_ID` int(11) NOT NULL AUTO_INCREMENT,
  `CD_Name` varchar(255) NOT NULL,
  `CD_TempPath` text NOT NULL,
  `CD_TheOrder` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`CD_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_news` ıṹ*/

DROP TABLE IF EXISTS `cxjw_news`;

CREATE TABLE `cxjw_news` (
  `CD_ID` int(11) NOT NULL AUTO_INCREMENT,
  `CD_ClassID` int(11) NOT NULL,
  `CD_Name` varchar(255) NOT NULL,
  `CD_Intro` text,
  `CD_Hits` int(11) NOT NULL,
  `CD_IsIndex` int(11) NOT NULL,
  `CD_IsBest` int(11) NOT NULL,
  `CD_Color` varchar(20) NOT NULL,
  `CD_AddTime` datetime NOT NULL,
  PRIMARY KEY (`CD_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_newsclass` ıṹ*/

DROP TABLE IF EXISTS `cxjw_newsclass`;

CREATE TABLE `cxjw_newsclass` (
  `CD_ID` int(11) NOT NULL AUTO_INCREMENT,
  `CD_Name` varchar(255) CHARACTER SET gbk NOT NULL,
  `CD_TheOrder` int(11) NOT NULL,
  `CD_IsIndex` int(11) NOT NULL,
  PRIMARY KEY (`CD_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

/*ݱ `cxjw_pay` ıṹ*/

DROP TABLE IF EXISTS `cxjw_pay`;

CREATE TABLE `cxjw_pay` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_name` varchar(50) NOT NULL,
  `cd_points` int(11) NOT NULL,
  `cd_money` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_paylog` ıṹ*/

DROP TABLE IF EXISTS `cxjw_paylog`;

CREATE TABLE `cxjw_paylog` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_uname` varchar(50) DEFAULT NULL,
  `cd_title` varchar(200) NOT NULL,
  `cd_points` int(11) NOT NULL,
  `cd_money` int(11) NOT NULL,
  `cd_lock` int(11) NOT NULL,
  `cd_addtime` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_pic` ıṹ*/

DROP TABLE IF EXISTS `cxjw_pic`;

CREATE TABLE `cxjw_pic` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_uname` varchar(50) NOT NULL,
  `cd_uip` varchar(50) DEFAULT NULL,
  `cd_title` varchar(100) NOT NULL,
  `cd_style` text NOT NULL,
  `cd_url` varchar(200) NOT NULL,
  `cd_hidden` int(11) NOT NULL,
  `cd_hits` int(11) NOT NULL,
  `cd_click1` int(11) NOT NULL,
  `cd_click2` int(11) NOT NULL,
  `cd_click3` int(11) NOT NULL,
  `cd_click4` int(11) NOT NULL,
  `cd_click5` int(11) NOT NULL,
  `cd_addtime` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_server` ıṹ*/

DROP TABLE IF EXISTS `cxjw_server`;

CREATE TABLE `cxjw_server` (
  `CD_ID` int(11) NOT NULL AUTO_INCREMENT,
  `CD_Name` varchar(100) NOT NULL,
  `CD_Url` varchar(255) NOT NULL,
  `CD_DownUrl` varchar(255) DEFAULT NULL,
  `CD_Yes` int(11) NOT NULL,
  PRIMARY KEY (`CD_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_session` ıṹ*/

DROP TABLE IF EXISTS `cxjw_session`;

CREATE TABLE `cxjw_session` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_uname` varchar(30) NOT NULL,
  `cd_uip` varchar(50) NOT NULL,
  `cd_logintime` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_special` ıṹ*/

DROP TABLE IF EXISTS `cxjw_special`;

CREATE TABLE `cxjw_special` (
  `CD_ID` int(11) NOT NULL AUTO_INCREMENT,
  `CD_ClassID` int(11) NOT NULL,
  `CD_Name` varchar(255) DEFAULT NULL,
  `CD_User` varchar(50) DEFAULT NULL,
  `CD_Pic` varchar(255) DEFAULT NULL,
  `CD_GongSi` varchar(50) DEFAULT NULL,
  `CD_YuYan` varchar(50) DEFAULT NULL,
  `CD_Intro` text,
  `CD_Hits` int(11) NOT NULL,
  `CD_IsBest` int(11) NOT NULL,
  `CD_Passed` int(11) NOT NULL,
  `CD_AddTime` datetime NOT NULL,
  PRIMARY KEY (`CD_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_supply` ıṹ*/

DROP TABLE IF EXISTS `cxjw_supply`;

CREATE TABLE `cxjw_supply` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_uname` varchar(20) NOT NULL,
  `cd_uip` varchar(50) DEFAULT NULL,
  `cd_title` varchar(100) NOT NULL,
  `cd_cid` int(11) NOT NULL,
  `cd_cname` varchar(20) NOT NULL,
  `cd_content` text NOT NULL,
  `cd_starttime` datetime NOT NULL,
  `cd_endtime` datetime NOT NULL,
  `cd_province` varchar(15) DEFAULT NULL,
  `cd_city` varchar(15) DEFAULT NULL,
  `cd_contact` varchar(15) DEFAULT NULL,
  `cd_qq` int(12) NOT NULL,
  `cd_phone` int(11) NOT NULL,
  `cd_hits` int(11) NOT NULL,
  `cd_addtime` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_upload` ıṹ*/

DROP TABLE IF EXISTS `cxjw_upload`;

CREATE TABLE `cxjw_upload` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_userid` int(11) NOT NULL,
  `cd_username` varchar(30) NOT NULL,
  `cd_userip` varchar(50) NOT NULL,
  `cd_filetype` varchar(10) NOT NULL,
  `cd_filename` varchar(200) NOT NULL,
  `cd_filesize` int(11) NOT NULL,
  `cd_fileurl` varchar(200) NOT NULL,
  `cd_filetime` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_user` ıṹ*/

DROP TABLE IF EXISTS `cxjw_user`;

CREATE TABLE `cxjw_user` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_name` varchar(30) DEFAULT NULL,
  `cd_nicheng` varchar(30) DEFAULT NULL,
  `cd_password` varchar(50) DEFAULT NULL,
  `cd_question` varchar(50) DEFAULT NULL,
  `cd_answer` varchar(50) DEFAULT NULL,
  `cd_email` varchar(100) DEFAULT NULL,
  `cd_sex` varchar(10) DEFAULT NULL,
  `cd_regdate` datetime NOT NULL,
  `cd_loginip` varchar(30) DEFAULT NULL,
  `cd_loginnum` int(11) NOT NULL,
  `cd_qq` varchar(15) DEFAULT NULL,
  `cd_logintime` datetime DEFAULT NULL,
  `cd_grade` int(11) NOT NULL,
  `cd_lock` int(11) NOT NULL,
  `cd_points` int(11) NOT NULL,
  `cd_photo` varchar(100) DEFAULT NULL,
  `cd_sign` text,
  `cd_hidden` int(11) NOT NULL,
  `cd_birthprovince` varchar(20) DEFAULT NULL,
  `cd_birthcity` varchar(20) DEFAULT NULL,
  `cd_resideprovince` varchar(20) DEFAULT NULL,
  `cd_residecity` varchar(20) DEFAULT NULL,
  `cd_birthday` varchar(20) DEFAULT NULL,
  `cd_vipindate` datetime DEFAULT NULL,
  `cd_vipenddate` datetime DEFAULT NULL,
  `cd_hits` int(11) NOT NULL,
  `cd_isbest` int(11) NOT NULL,
  `cd_money` int(11) NOT NULL,
  `cd_weblock` int(11) NOT NULL,
  `cd_skin` varchar(50) DEFAULT NULL,
  `cd_friendnum` int(11) NOT NULL,
  `cd_creditname` text,
  `cd_rank` int(11) NOT NULL,
  `cd_credit` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_web` ıṹ*/

DROP TABLE IF EXISTS `cxjw_web`;

CREATE TABLE `cxjw_web` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_uid` int(11) NOT NULL,
  `cd_uname` varchar(50) NOT NULL,
  `cd_title` varchar(200) NOT NULL,
  `cd_skin` varchar(50) NOT NULL,
  `cd_hits` int(11) NOT NULL,
  `cd_lock` int(11) NOT NULL,
  `cd_banner` varchar(200) DEFAULT NULL,
  `cd_bg` varchar(200) DEFAULT NULL,
  `cd_addtime` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_label` ıṹ*/

DROP TABLE IF EXISTS `cxjw_label`;

CREATE TABLE `cxjw_label` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_name` varchar(50) NOT NULL,
  `cd_type` varchar(50) NOT NULL,
  `cd_selflable` text NOT NULL,
  `cd_remark` varchar(150) NOT NULL,
  `cd_priority` int(11) NOT NULL,
  `cd_addtime` datetime NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_page` ıṹ*/

DROP TABLE IF EXISTS `cxjw_page`;

CREATE TABLE `cxjw_page` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_name` varchar(50) NOT NULL,
  `cd_type` varchar(50) NOT NULL,
  `cd_html` int(11) NOT NULL,
  `cd_url` varchar(50) NOT NULL,
  `cd_template` varchar(50) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;

/*ݱ `cxjw_link` ıṹ*/

DROP TABLE IF EXISTS `cxjw_link`;

CREATE TABLE `cxjw_link` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_name` varchar(50) NOT NULL,
  `cd_url` varchar(100) NOT NULL,
  `cd_pic` varchar(150) NOT NULL,
  `cd_classid` int(11) NOT NULL,
  `cd_input` varchar(255) NOT NULL,
  `cd_isverify` int(11) NOT NULL,
  `cd_isindex` int(11) NOT NULL,
  `cd_theorder` int(11) NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;