
CREATE TABLE IF NOT EXISTS `#~eifr~#_ad` (
  `id` int(4) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `channel_id` text NOT NULL,
  `layout_id` int(4) NOT NULL DEFAULT '0',
  `addtime` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `starttime` int(11) NOT NULL DEFAULT '0',
  `endtime` int(11) NOT NULL DEFAULT '0',
  `content_open` text NOT NULL,
  `content_stop` text NOT NULL,
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  `uid` int(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_address` (
  `id` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `ordernum` int(2) NOT NULL DEFAULT '0',
  `uid` int(6) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `addtime` int(11) NOT NULL DEFAULT '0',
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_adminmenu` (
  `id` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(20) NOT NULL DEFAULT '',
  `tourl` varchar(255) NOT NULL DEFAULT '',
  `fileurl` varchar(255) NOT NULL DEFAULT '',
  `acl` int(4) NOT NULL DEFAULT '0',
  `parameter` text NOT NULL,
  `ordernum` int(2) NOT NULL DEFAULT '0',
  `intro` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `uid` int(10) NOT NULL DEFAULT '0',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_article` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `redirectaddress` varchar(255) NOT NULL DEFAULT '',
  `relation_type` tinyint(1) NOT NULL DEFAULT '0',
  `relation_info` varchar(255) NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `channel_id` varchar(20) NOT NULL DEFAULT '',
  `channel_ids` text NOT NULL,
  `user_channel_channelid` text NOT NULL,
  `issuetime` int(11) NOT NULL DEFAULT '0',
  `endtime` int(11) NOT NULL DEFAULT '0',
  `addtime` int(11) NOT NULL DEFAULT '0',
  `edittime` int(11) NOT NULL DEFAULT '0',
  `fileurl` text NOT NULL,
  `price` float NOT NULL DEFAULT '0',
  `quantity` int(8) NOT NULL DEFAULT '0',
  `dimension` float NOT NULL,
  `timelimit` int(6) NOT NULL,
  `intro` text NOT NULL,
  `words` longtext NOT NULL COMMENT 'no html element, words field include title, intro, keyword, article_content.title, article_content.content',
  `sourcename` varchar(50) NOT NULL DEFAULT '',
  `sourceurl` varchar(255) NOT NULL DEFAULT '',
  `keyword` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  `ordernum` int(4) NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `viewnum` int(8) NOT NULL DEFAULT '0',
  `commentnum` int(4) NOT NULL DEFAULT '0',
  `uid` mediumint(8) NOT NULL DEFAULT '0',
  `viewauth_type` tinyint(1) NOT NULL DEFAULT '0',
  `viewauth_info` varchar(255) NOT NULL DEFAULT '',
  `is_comment` tinyint(1) NOT NULL DEFAULT '0',
  `title_style` varchar(255) NOT NULL,
  `attribute` varchar(255) NOT NULL,
  `parameter` text NOT NULL,
  `template_id` int(4) NOT NULL DEFAULT '0',
  `layout_id` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------


CREATE TABLE IF NOT EXISTS `#~eifr~#_article_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `article_id` int(10) NOT NULL DEFAULT '0',
  `ordernum` int(2) NOT NULL DEFAULT '1',
  `title` varchar(255) NOT NULL DEFAULT '',
  `content` longtext NOT NULL,
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_channel` (
  `id` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(30) NOT NULL DEFAULT '',
  `fileurl` text NOT NULL,
  `intro` text NOT NULL,
  `ordernum` int(2) NOT NULL DEFAULT '0',
  `parameter` varchar(255) NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `flag` int(1) NOT NULL DEFAULT '0',
  `redirecturl` varchar(255) NOT NULL DEFAULT '',
  `uid` int(10) NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `addtime` int(11) NOT NULL DEFAULT '0',
  `template_id` int(4) NOT NULL DEFAULT '0',
  `article_template_id` int(4) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------


CREATE TABLE IF NOT EXISTS `#~eifr~#_comment` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `ratevalue` tinyint(2) NOT NULL DEFAULT '0',
  `addtime` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `uid` int(8) NOT NULL DEFAULT '0',
  `nickname` varchar(20) NOT NULL DEFAULT '',
  `article_id` int(10) NOT NULL DEFAULT '0',
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  `parent_id` int(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_config` (
  `id` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `varname` varchar(30) NOT NULL DEFAULT '',
  `varvalue` varchar(255) NOT NULL DEFAULT '',
  `intro` varchar(255) NOT NULL DEFAULT '',
  `ordernum` int(4) NOT NULL DEFAULT '0',
  `vartype` varchar(20) NOT NULL DEFAULT '',
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_file` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `article_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `fileurl` text NOT NULL,
  `mediatype` smallint(6) NOT NULL DEFAULT '1',
  `addtime` int(11) NOT NULL DEFAULT '0',
  `edittime` int(11) NOT NULL DEFAULT '0',
  `ordernum` int(4) NOT NULL,
  `flag` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `article_id` (`article_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_guestbook` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `replycontent` text NOT NULL,
  `addtime` int(11) NOT NULL DEFAULT '0',
  `replytime` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `uid` int(8) NOT NULL DEFAULT '0',
  `nickname` varchar(20) NOT NULL DEFAULT '',
  `replyuid` int(8) NOT NULL,
  `replynickname` varchar(20) NOT NULL,
  `contact` text NOT NULL,
  `layout_id` text NOT NULL,
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_link` (
  `id` int(4) NOT NULL DEFAULT '0',
  `ordernum` int(4) NOT NULL DEFAULT '0',
  `weburl` varchar(255) NOT NULL DEFAULT '',
  `webname` varchar(30) NOT NULL DEFAULT '',
  `intro` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `logo` varchar(255) NOT NULL DEFAULT '',
  `addtime` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `layout_id` text NOT NULL,
  `channel_id` text NOT NULL,
  `flag` tinyint(1) NOT NULL DEFAULT '1',
  `uid` int(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `fileurl` varchar(255) NOT NULL DEFAULT '',
  `content` longtext NOT NULL,
  `addtime` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `usertype` tinyint(1) NOT NULL DEFAULT '0',
  `uid` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `senderid` int(11) DEFAULT '0',
  `recipientid` int(11) DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `flag` tinyint(1) DEFAULT '0',
  `sendip` varchar(15) DEFAULT NULL,
  `viewip` varchar(15) DEFAULT NULL,
  `sendtime` int(11) DEFAULT '0',
  `edittime` int(11) DEFAULT '0',
  `viewtime` int(11) DEFAULT '0',
  `type` tinyint(1) DEFAULT '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `addtime` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(50) NOT NULL,
  `count` int(8) DEFAULT '0',
  `order_number` varchar(50) DEFAULT NULL,
  `flag` tinyint(1) DEFAULT '0',
  `consignor_name` varchar(50) DEFAULT NULL,
  `consignor_gender` tinyint(1) DEFAULT '0',
  `consignor_address` varchar(255) DEFAULT NULL,
  `consignor_zipcode` varchar(20) DEFAULT NULL,
  `consignor_tel` varchar(50) DEFAULT NULL,
  `consignor_mobile` varchar(50) DEFAULT NULL,
  `consignor_email` varchar(50) DEFAULT NULL,
  `zipcode` varchar(20) DEFAULT NULL,
  `leave_words` text,
  `payment_id` tinyint(1) DEFAULT '0',
  `delivery_id` int(8) DEFAULT '0',
  `delivery_time` varchar(100) DEFAULT NULL,
  `total` float NOT NULL DEFAULT '0',
  `realname` varchar(50) DEFAULT NULL,
  `gender` tinyint(1) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `tel` varchar(50) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `uid` int(11) DEFAULT '0',
  `fare` float NOT NULL DEFAULT '0',
  `is_invoice` tinyint(1) DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `seller_uid` int(8) NOT NULL DEFAULT '0',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_order_article` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(20) NOT NULL DEFAULT '',
  `article_id` int(6) NOT NULL DEFAULT '0',
  `price` float NOT NULL DEFAULT '0',
  `quantity` int(6) NOT NULL DEFAULT '0',
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_poll` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `ordernum` int(2) NOT NULL DEFAULT '0',
  `article_id` int(8) NOT NULL DEFAULT '0',
  `ratevale` int(4) NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_poll_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `notion` varchar(255) NOT NULL DEFAULT '',
  `poll_id` int(8) NOT NULL DEFAULT '0',
  `article_id` int(8) NOT NULL DEFAULT '0',
  `uid` int(8) NOT NULL DEFAULT '0',
  `addtime` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_soft_update` (
  `id` int(4) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` text NOT NULL,
  `addtime` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------

--
-- 表的结构 `#~eifr~#_style`
--

CREATE TABLE IF NOT EXISTS `#~eifr~#_style` (
  `id` varchar(10) NOT NULL DEFAULT '',
  `title` varchar(50) NOT NULL DEFAULT '',
  `intro` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_subject_relation` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `article_id` int(10) NOT NULL DEFAULT '0',
  `layout_id` int(4) NOT NULL DEFAULT '0',
  `article_list` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_template` (
  `id` int(4) NOT NULL DEFAULT '0',
  `title` varchar(50) NOT NULL DEFAULT '',
  `intro` text NOT NULL,
  `template_filename` varchar(50) NOT NULL DEFAULT '',
  `program_filename` varchar(50) NOT NULL DEFAULT '',
  `ordernum` int(4) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_template_layout` (
  `id` int(4) NOT NULL DEFAULT '0',
  `layout_code` varchar(50) NOT NULL DEFAULT '',
  `title` varchar(50) NOT NULL DEFAULT '',
  `intro` varchar(255) NOT NULL DEFAULT '',
  `sql_select` text NOT NULL,
  `parameter` varchar(255) NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `template_id` int(4) NOT NULL DEFAULT '0',
  `ordernum` int(4) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_user` (
  `uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `gender` tinyint(1) NOT NULL DEFAULT '0',
  `boss_uid` int(8) unsigned NOT NULL,
  `user_class_id` varchar(20) NOT NULL DEFAULT '',
  `channel_id` text NOT NULL,
  `regip` varchar(15) NOT NULL DEFAULT '',
  `fileurl` varchar(255) NOT NULL,
  `birthday` int(11) NOT NULL DEFAULT '0',
  `regtime` int(11) NOT NULL DEFAULT '0',
  `lastip` varchar(15) NOT NULL DEFAULT '',
  `lasttime` int(11) NOT NULL DEFAULT '0',
  `loginnum` int(10) unsigned NOT NULL DEFAULT '0',
  `zipcode` smallint(6) unsigned NOT NULL DEFAULT '0',
  `credit` int(10) NOT NULL DEFAULT '0',
  `email` varchar(60) NOT NULL DEFAULT '',
  `im` text NOT NULL COMMENT 'qq:1000;qq:2000;msn:test@msn.com',
  `address_id` varchar(20) NOT NULL,
  `address` varchar(200) NOT NULL DEFAULT '',
  `marriage` tinyint(1) NOT NULL DEFAULT '0',
  `ordernum` int(10) NOT NULL DEFAULT '0',
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  `timeoffset` char(3) NOT NULL DEFAULT '',
  `tel` varchar(50) NOT NULL DEFAULT '',
  `fax` varchar(50) NOT NULL DEFAULT '',
  `mobile` varchar(50) NOT NULL DEFAULT '',
  `realname` varchar(30) NOT NULL DEFAULT '',
  `nickname` varchar(30) NOT NULL DEFAULT '',
  `company` varchar(200) NOT NULL DEFAULT '',
  `detail` text NOT NULL,
  `word` text NOT NULL,
  `certificate_type` varchar(50) NOT NULL DEFAULT '',
  `certificate_code` varchar(100) NOT NULL DEFAULT '',
  `parameter` text NOT NULL,
  `layout_id` text NOT NULL,
  PRIMARY KEY (`uid`),
  KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_user_channel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channelid` varchar(20) NOT NULL,
  `title` varchar(30) NOT NULL DEFAULT '',
  `fileurl` text NOT NULL,
  `intro` text NOT NULL,
  `ordernum` int(2) NOT NULL DEFAULT '0',
  `parameter` varchar(255) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `flag` int(1) NOT NULL DEFAULT '0',
  `redirecturl` varchar(255) NOT NULL DEFAULT '',
  `uid` int(10) NOT NULL DEFAULT '0',
  `shjiaid` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `addtime` int(11) NOT NULL DEFAULT '0',
  `template_id` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_user_class` (
  `id` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(30) NOT NULL DEFAULT '',
  `fileurl` varchar(255) NOT NULL DEFAULT '',
  `intro` varchar(255) NOT NULL DEFAULT '',
  `ordernum` int(2) NOT NULL DEFAULT '0',
  `parameter` varchar(255) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `flag` int(1) NOT NULL DEFAULT '0',
  `loginurl` varchar(255) NOT NULL DEFAULT '',
  `acl` text NOT NULL,
  `channel_id` text NOT NULL,
  `uid` int(6) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `addtime` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=#~lang~#;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_user_relations` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(8) unsigned NOT NULL,
  `ruid` int(8) unsigned NOT NULL,
  `type` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `#~eifr~#_user_repository` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag` text NOT NULL,
  `relation_type` tinyint(1) NOT NULL DEFAULT '0',
  `relation_info` varchar(255) NOT NULL,
  `ratevalue` int(4) NOT NULL DEFAULT '0',
  `content` longtext NOT NULL,
  `uid` int(8) NOT NULL DEFAULT '0',
  `user_channel_channelid` varchar(255) NOT NULL,
  `addtime` int(11) NOT NULL DEFAULT '0',
  `edittime` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `flag` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=#~lang~# AUTO_INCREMENT=1 ;
