DROP TABLE IF EXISTS `ourphp_user`;
CREATE TABLE `ourphp_user` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Useremail` varchar(255) NOT NULL default '',
`OP_Userpass` varchar(255) NOT NULL default '',
`OP_Username` varchar(255) NOT NULL default '',
`OP_Usertel` varchar(255) NOT NULL default '',
`OP_Userqq`  varchar(255) NOT NULL default '',
`OP_Userskype` varchar(255) NOT NULL default '',
`OP_Useraliww` varchar(255) NOT NULL default '',
`OP_Useradd` varchar(255) NOT NULL default '',
`OP_Userclass` int(11) NOT NULL default '0', /*会员级别*/
`OP_Usersource` varchar(255) NOT NULL default '',/*会员来源*/
`OP_Userhead` varchar(255) NOT NULL default '',/*会员头像*/
`OP_Usermoney` decimal(10,2) NOT NULL default '0', /*账户现金*/
`OP_Userintegral` decimal(10,2) NOT NULL default '0', /*账户积分*/
`OP_Userip` varchar(255) NOT NULL default '',/*会员ip地址*/
`OP_Userproblem` varchar(255) NOT NULL default '',/*会员找回密码时的问题*/
`OP_Useranswer` varchar(255) NOT NULL default '',/*会员找回密码时的答案*/
`OP_Userstatus` int(11) NOT NULL default '0', /*账户状态 1开启 2锁定*/
`OP_Usertext` text,/*人生宣言*/
`logintime` varchar(255) NOT NULL default '',/*登录时间*/
`OP_Usercode` varchar(255) NOT NULL default '',
`OP_Usercoin` decimal(20,8) NOT NULL default '0',
`time` datetime,
`OP_Userregcode` int(11) NOT NULL default '0',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_userproblem`;
CREATE TABLE `ourphp_userproblem` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Userproblem` varchar(255) NOT NULL default '',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_userleve`;
CREATE TABLE `ourphp_userleve` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Userlevename` varchar(255) NOT NULL default '',
`OP_Userweight` int(11) NOT NULL default '0', /*用户组权重*/
`OP_Useropen` int(11) NOT NULL default '0',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_usermessage`;
CREATE TABLE `ourphp_usermessage` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Usersend` varchar(255) NOT NULL default '',
`OP_Usercollect` varchar(255) NOT NULL default '',
`OP_Usercontent` text,
`OP_Userclass` int(11) NOT NULL default '0',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_userpay`;
CREATE TABLE `ourphp_userpay` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Useremail` varchar(255) NOT NULL default '',
`OP_Usermoney` decimal(10,2) NOT NULL default '0', /*账户现金*/
`OP_Userintegral` decimal(10,2) NOT NULL default '0', /*账户积分*/
`OP_Usercontent` text,
`OP_Useradmin` varchar(255) NOT NULL default '',
`OP_Uservoucherone` varchar(255) NOT NULL default '',
`OP_Uservouchertwo` varchar(255) NOT NULL default '',
`OP_Userpaytype` varchar(255) NOT NULL default '',
`OP_Usercoin` decimal(10,2) NOT NULL default '0',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_book`;
CREATE TABLE `ourphp_book` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Bookcontent` text,
`OP_Bookname` varchar(255) NOT NULL default '',
`OP_Booktel` varchar(255) NOT NULL default '',
`OP_Bookip` varchar(255) NOT NULL default '',
`OP_Bookclass` int(11) NOT NULL default '0',
`OP_Booklang` varchar(255) NOT NULL default '',
`OP_Bookreply` text,
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_banner`;
CREATE TABLE `ourphp_banner` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Bannerimg` text,
`OP_Bannertitle` varchar(255) NOT NULL default '',
`OP_Bannerurl` varchar(255) NOT NULL default '',
`OP_Bannerlang` varchar(255) NOT NULL default '',
`time` datetime,
`OP_Bannerclass` int(11) NOT NULL default '0',
`OP_Bannertext` text,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_qq`;
CREATE TABLE `ourphp_qq` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_QQname` varchar(255) NOT NULL default '',
`OP_QQnumber` varchar(255) NOT NULL default '',
`OP_QQclass` varchar(255) NOT NULL default '',
`OP_QQsorting` int(11) NOT NULL default '0',
`OP_QQother` varchar(255) NOT NULL default '',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_link`;
CREATE TABLE `ourphp_link` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Linkname` varchar(255) NOT NULL default '',
`OP_Linkurl` varchar(255) NOT NULL default '',
`OP_Linkclass` varchar(255) NOT NULL default '',
`OP_Linkimg` text,
`OP_Linksorting` int(11) NOT NULL default '0',
`OP_Linkstate` int(11) NOT NULL default '0', /*显示隐藏 1显示 2隐藏*/
`time` datetime,
`OP_Linktarget` varchar(255) NOT NULL default '',
`OP_Linknofollow` varchar(255) NOT NULL default '',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_ad`;
CREATE TABLE `ourphp_ad` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Adtitle` varchar(255) NOT NULL default '',
`OP_Adcontent` text,
`OP_Adclass` varchar(255) NOT NULL default '',
`OP_Adpiaofui` varchar(255) NOT NULL default '',
`OP_Adpiaofuu` text,
`OP_Adyouxiat` varchar(255) NOT NULL default '',
`OP_Adyouxiaf` text,
`OP_Adduilianli` varchar(255) NOT NULL default '',
`OP_Adduilianlu` text,
`OP_Adduilianri` varchar(255) NOT NULL default '',
`OP_Adduilianru` text,
`OP_Adstateo` int(11) NOT NULL default '0',/*显示隐藏 1显示 2隐藏*/
`OP_Adstatet` int(11) NOT NULL default '0',
`OP_Adstates` int(11) NOT NULL default '0',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;