DROP TABLE IF EXISTS `i_xna_category`;
CREATE TABLE `i_xna_category` (
  `cid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cate_title` varchar(120) NOT NULL DEFAULT '0',
  `cate_content` varchar(255) NOT NULL,
  `feed_count` int(11) NOT NULL DEFAULT '0',
  `cate_sort` tinyint(1) NOT NULL DEFAULT '0',
  `displayorder` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM;


DROP TABLE IF EXISTS `i_xna_comment`;
CREATE TABLE `i_xna_comment` (
  `commid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `feedid` int(11) unsigned NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL,
  `author` varchar(20) NOT NULL DEFAULT '',
  `email` varchar(60) NOT NULL,
  `url` varchar(255) NOT NULL DEFAULT '',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `content` mediumtext NOT NULL,
  `ipaddress` varchar(16) NOT NULL DEFAULT '',
  `support` smallint(6) NOT NULL DEFAULT '0',
  `against` smallint(6) NOT NULL DEFAULT '0',
  `state` tinyint(0) NOT NULL DEFAULT '0',
  PRIMARY KEY (`commid`),
  KEY `articleid` (`feedid`),
  KEY `dateline` (`addtime`),
  KEY `ipaddress` (`ipaddress`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `i_xna_feed`;
CREATE TABLE `i_xna_feed` (
  `feedid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL DEFAULT '0',
  `siteid` int(11) NOT NULL DEFAULT '0',
  `rss_cate` int(11) NOT NULL DEFAULT '0',
  `site_name` varchar(100) NOT NULL DEFAULT '0',
  `feed_title` varchar(100) NOT NULL DEFAULT '0',
  `feed_description` text,
  `feed_content` text,
  `feed_url` varchar(255) DEFAULT NULL,
  `feed_url_hash` varchar(32) DEFAULT NULL,
  `feed_vote` smallint(6) NOT NULL DEFAULT '0',
  `feed_count` smallint(6) NOT NULL DEFAULT '0',
  `feed_hits` smallint(6) NOT NULL DEFAULT '0',
  `comments` int(11) NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `addtime` int(10) NOT NULL DEFAULT '0',
  `displayorder` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`feedid`),
  KEY `feed_url_hash` (`feed_url_hash`),
  FULLTEXT KEY `title_index` (`feed_title`),
  FULLTEXT KEY `content_index` (`feed_content`),
  FULLTEXT KEY `site_name` (`site_name`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `i_xna_links`;
CREATE TABLE `i_xna_links` (
  `linkid` int(11) NOT NULL AUTO_INCREMENT,
  `link_title` varchar(60) DEFAULT NULL,
  `link_url` varchar(255) DEFAULT NULL,
  `link_img` varchar(255) DEFAULT NULL,
  `link_content` varchar(255) DEFAULT NULL,
  `displayorder` tinyint(1) NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `addtime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`linkid`),
  KEY `linkid` (`linkid`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `i_xna_search`;
CREATE TABLE `i_xna_search` (
  `searchid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `addtime` int(10) NOT NULL DEFAULT '0',
  `sortby` varchar(32) NOT NULL DEFAULT '',
  `orderby` varchar(4) NOT NULL DEFAULT '',
  `tatols` smallint(6) NOT NULL DEFAULT '0',
  `ids` text NOT NULL,
  `searchfrom` varchar(30) NOT NULL DEFAULT '',
  `ipaddress` varchar(16) NOT NULL DEFAULT '',
  PRIMARY KEY (`searchid`),
  KEY `addtime` (`addtime`),
  KEY `sortby` (`sortby`),
  KEY `orderby` (`orderby`),
  KEY `searchfrom` (`searchfrom`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `i_xna_sessions`;
CREATE TABLE `i_xna_sessions` (
  `hash` varchar(20) NOT NULL DEFAULT '',
  `uid` mediumint(8) NOT NULL DEFAULT '0',
  `groupid` smallint(6) NOT NULL,
  `ipaddress` varchar(16) NOT NULL DEFAULT '',
  `agent` varchar(200) DEFAULT NULL,
  `lastactivity` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`hash`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `i_xna_settings`;
CREATE TABLE `i_xna_settings` (
  `title` varchar(50) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  PRIMARY KEY (`title`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `i_xna_site`;
CREATE TABLE `i_xna_site` (
  `siteid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0',
  `site_title` varchar(60) DEFAULT NULL,
  `site_url` varchar(255) DEFAULT NULL,
  `site_icon` varchar(255) DEFAULT NULL,
  `addtime` int(10) NOT NULL DEFAULT '0',
  `uptime` int(10) NOT NULL DEFAULT '0',
  `keywords` varchar(100) DEFAULT NULL,
  `site_email` varchar(60) DEFAULT NULL,
  `site_count` smallint(6) NOT NULL DEFAULT '0',
  `site_content` text,
  `cate_count` int(11) NOT NULL DEFAULT '0',
  `feed_count` int(11) NOT NULL DEFAULT '0',
  `rss_url` varchar(255) DEFAULT NULL,
  `rss_cate` tinyint(1) NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `isupdate` tinyint(1) NOT NULL DEFAULT '0',
  `displayorder` tinyint(1) NOT NULL DEFAULT '0',  
  PRIMARY KEY (`siteid`),
  KEY `site_title` (`site_title`),
  KEY `rss_url` (`rss_url`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `i_xna_statistics`;
CREATE TABLE `i_xna_statistics` (
  `statid` int(11) NOT NULL AUTO_INCREMENT,
  `site_count` int(11) NOT NULL DEFAULT '0',
  `cate_count` int(11) NOT NULL DEFAULT '0',
  `feed_count` int(11) NOT NULL DEFAULT '0',
  `comment_count` int(11) NOT NULL DEFAULT '0',
  `tag_count` int(11) NOT NULL DEFAULT '0',
  `all_view_count` int(11) NOT NULL DEFAULT '0',
  `today_view_count` int(11) NOT NULL DEFAULT '0',
  `user_count` int(11) NOT NULL DEFAULT '0',
  `curdate` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`statid`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `i_xna_style`;
CREATE TABLE `i_xna_style` (
  `styleid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `value` text NOT NULL,
  `visible` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`styleid`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `i_xna_tags`;
CREATE TABLE `i_xna_tags` (
  `tagid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `tag` varchar(100) NOT NULL DEFAULT '',
  `usenum` int(11) NOT NULL DEFAULT '0',
  `aids` text NOT NULL,
  PRIMARY KEY (`tagid`),
  KEY `usenum` (`usenum`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `i_xna_users`;
CREATE TABLE `i_xna_users` (
  `uid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(60) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `email` varchar(60) NOT NULL,
  `url` varchar(200) DEFAULT NULL,
  `lasttime` int(11) NOT NULL DEFAULT '0',
  `logintime` int(10) DEFAULT NULL,
  `loginip` varchar(16) NOT NULL DEFAULT '0',
  `regtime` int(10) DEFAULT '0',
  `regip` varchar(16) DEFAULT NULL,
  `logincount` smallint(6) NOT NULL DEFAULT '0',
  `groupid` smallint(6) NOT NULL,
  `feed_count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM;


INSERT INTO `i_xna_category` VALUES ('1', 'General', '普通', '0', '0', '1');
INSERT INTO `i_xna_category` VALUES ('2', 'Personal', '个人', '0', '0', '2');
INSERT INTO `i_xna_links` VALUES ('1', '剑气凌人', 'http://zxsv.com/', null, '剑气凌人', '1', '1', '0');
INSERT INTO `i_xna_settings` VALUES ('allow_search_comments', '1');
INSERT INTO `i_xna_settings` VALUES ('archives_num', '0');
INSERT INTO `i_xna_settings` VALUES ('article_comment_num', '20');
INSERT INTO `i_xna_settings` VALUES ('article_order', 'dateline');
INSERT INTO `i_xna_settings` VALUES ('artlink_ext', 'html');
INSERT INTO `i_xna_settings` VALUES ('audit_comment', '0');
INSERT INTO `i_xna_settings` VALUES ('audit_trackback', '0');
INSERT INTO `i_xna_settings` VALUES ('banip_enable', '1');
INSERT INTO `i_xna_settings` VALUES ('ban_ip', '');
INSERT INTO `i_xna_settings` VALUES ('censoruser', 'test,操你妈,rinima,日你妈,鸡,鸭,admin,TMD,胡景涛,温家宝');
INSERT INTO `i_xna_settings` VALUES ('close', '1');
INSERT INTO `i_xna_settings` VALUES ('closereg', '0');
INSERT INTO `i_xna_settings` VALUES ('close_note', '系统升级中....');
INSERT INTO `i_xna_settings` VALUES ('collect', 'magpierss');
INSERT INTO `i_xna_settings` VALUES ('commentlist_num', '200');
INSERT INTO `i_xna_settings` VALUES ('comment_max_len', '10000');
INSERT INTO `i_xna_settings` VALUES ('comment_min_len', '10');
INSERT INTO `i_xna_settings` VALUES ('comment_order', '1');
INSERT INTO `i_xna_settings` VALUES ('comment_post_space', '200');
INSERT INTO `i_xna_settings` VALUES ('comment_timeformat', 'Y, F j, g:i A');
INSERT INTO `i_xna_settings` VALUES ('description', 'iXNA聚合灵感');
INSERT INTO `i_xna_settings` VALUES ('display_attach', '1');
INSERT INTO `i_xna_settings` VALUES ('enable_trackback', '1');
INSERT INTO `i_xna_settings` VALUES ('gzipcompress', '1');
INSERT INTO `i_xna_settings` VALUES ('hottags_shownum', '0');
INSERT INTO `i_xna_settings` VALUES ('icp', '鄂ICP备05000057号');
INSERT INTO `i_xna_settings` VALUES ('js_cache_life', '1000');
INSERT INTO `i_xna_settings` VALUES ('js_enable', '1');
INSERT INTO `i_xna_settings` VALUES ('js_lock_url', '');
INSERT INTO `i_xna_settings` VALUES ('listtime', 'Y-m-d');
INSERT INTO `i_xna_settings` VALUES ('rss_all_output', '0');
INSERT INTO `i_xna_settings` VALUES ('name', '聚合灵感');
INSERT INTO `i_xna_settings` VALUES ('normaltime', 'Y, F j, g:i A');
INSERT INTO `i_xna_settings` VALUES ('normal_shownum', '8');
INSERT INTO `i_xna_settings` VALUES ('pos_padding', '5');
INSERT INTO `i_xna_settings` VALUES ('random_links', '1');
INSERT INTO `i_xna_settings` VALUES ('recentcomment_limit', '16');
INSERT INTO `i_xna_settings` VALUES ('recentcomment_num', '10');
INSERT INTO `i_xna_settings` VALUES ('recent_comment_timeformat', 'm-d');
INSERT INTO `i_xna_settings` VALUES ('related_order', 'dateline');
INSERT INTO `i_xna_settings` VALUES ('related_shownum', '0');
INSERT INTO `i_xna_settings` VALUES ('related_title_limit', '0');
INSERT INTO `i_xna_settings` VALUES ('remote_open', '0');
INSERT INTO `i_xna_settings` VALUES ('rewrite_enable', '0');
INSERT INTO `i_xna_settings` VALUES ('rewrite_ext', 'html');
INSERT INTO `i_xna_settings` VALUES ('rss_enable', '1');
INSERT INTO `i_xna_settings` VALUES ('rss_num', '30');
INSERT INTO `i_xna_settings` VALUES ('rss_ttl', '30');
INSERT INTO `i_xna_settings` VALUES ('search_keywords_min_len', '3');
INSERT INTO `i_xna_settings` VALUES ('search_post_space', '0');
INSERT INTO `i_xna_settings` VALUES ('seccode', '0');
INSERT INTO `i_xna_settings` VALUES ('seccode_enable', '1');
INSERT INTO `i_xna_settings` VALUES ('server_timezone', '-12');
INSERT INTO `i_xna_settings` VALUES ('showmsg', '1');
INSERT INTO `i_xna_settings` VALUES ('show_archives', '1');
INSERT INTO `i_xna_settings` VALUES ('show_calendar', '0');
INSERT INTO `i_xna_settings` VALUES ('show_categories', '1');
INSERT INTO `i_xna_settings` VALUES ('show_debug', '1');
INSERT INTO `i_xna_settings` VALUES ('show_statistics', '1');
INSERT INTO `i_xna_settings` VALUES ('sidebarlinknum', '15');
INSERT INTO `i_xna_settings` VALUES ('smarturl', '1');
INSERT INTO `i_xna_settings` VALUES ('spam_content_size', '2000');
INSERT INTO `i_xna_settings` VALUES ('spam_enable', '1');
INSERT INTO `i_xna_settings` VALUES ('spam_url_num', '3');
INSERT INTO `i_xna_settings` VALUES ('spam_words', '虚拟主机,域名注册,出租网,六合彩,铃声下载,手机铃声,和弦铃声,手机游戏,免费铃声,彩铃,网站建设,操你妈,rinima,日你妈,αngel,鸡,操,鸡吧,小姐,fuck,胡锦涛,温家宝,胡温,李洪志,法轮,民运,反共,专制,专政,独裁,极权,中共,共产,共党,六四,民主,人权,毛泽东,中国政府,中央政府,游行示威,天安门,达赖,他妈的,我操,强奸,法轮');
INSERT INTO `i_xna_settings` VALUES ('tags_shownum', '100');
INSERT INTO `i_xna_settings` VALUES ('usercheck', '1');
INSERT INTO `i_xna_settings` VALUES ('templatename', 'default');
INSERT INTO `i_xna_settings` VALUES ('title_keywords', '');
INSERT INTO `i_xna_settings` VALUES ('title_limit', '01');
INSERT INTO `i_xna_settings` VALUES ('url', 'http://www.ixna.net/');
INSERT INTO `i_xna_settings` VALUES ('viewmode', 'normal');
INSERT INTO `i_xna_settings` VALUES ('wap_article_pagenum', '10');
INSERT INTO `i_xna_settings` VALUES ('wap_article_title_limit', '0');
INSERT INTO `i_xna_settings` VALUES ('wap_comment_pagenum', '5');
INSERT INTO `i_xna_settings` VALUES ('wap_enable', '1');
INSERT INTO `i_xna_settings` VALUES ('wap_tags_pagenum', '15');
INSERT INTO `i_xna_settings` VALUES ('wap_trackback_pagenum', '5');
INSERT INTO `i_xna_settings` VALUES ('watermark', '0');
INSERT INTO `i_xna_settings` VALUES ('watermarktrans', '100');
INSERT INTO `i_xna_settings` VALUES ('watermark_size', '300x300');
INSERT INTO `i_xna_settings` VALUES ('waterpos', '2');
INSERT INTO `i_xna_settings` VALUES ('sitemap_enable', '1');
INSERT INTO `i_xna_settings` VALUES ('sitemap_num', '1000');
INSERT INTO `i_xna_settings` VALUES ('rsstime', '30');
INSERT INTO `i_xna_site` VALUES ('1', '1', '剑气凌人', 'http://zxsv.com/', 'http://zxsv.com/favicon.ico', '1167580800', '1217131024', '', '0', '', '0', '0', 'http://zxsv.com/feed/', '30', '2', '2', '1', '0');
INSERT INTO `i_xna_site` VALUES ('2', '2', 'Plod', 'http://plod.popoever.com/', 'http://plod.popoever.com/favicon.ico', '1217127244', '1217131028', '', '0', 'ttt', '0', '0', 'http://plod.popoever.com/atom.xml', '30', '2', '4', '1', '0');
INSERT INTO `i_xna_statistics` VALUES ('1', '2', '2', '11', '0', '0', '0', '0', '1', '');