-- MySQL dump 10.13  Distrib 5.1.73, for redhat-linux-gnu (x86_64)
--
-- Host: localhost    Database: jaain
-- ------------------------------------------------------
-- Server version	5.1.73

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


--
-- Table structure for table `pw_ad`
--

DROP TABLE IF EXISTS `pw_ad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_ad` (
  `ad_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `place` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:中部 1:头部 2:左侧 3:右侧 4:底部',
  `content` text,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_closable` tinyint(1) NOT NULL DEFAULT '0',
  `ctime` int(11) DEFAULT NULL,
  `mtime` int(11) DEFAULT NULL,
  `display_order` smallint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ad_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_admin_log`
--

DROP TABLE IF EXISTS `pw_admin_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `uid` int(11) NOT NULL COMMENT '操作人UID',
  `type` tinyint(4) NOT NULL,
  `data` text NOT NULL,
  `ctime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_app`
--

DROP TABLE IF EXISTS `pw_app`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_app` (
  `app_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_name` varchar(255) NOT NULL,
  `app_alias` varchar(255) NOT NULL,
  `description` text,
  `version` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0:关闭 1:默认 2:可选',
  `category` varchar(255) DEFAULT NULL,
  `release_date` varchar(255) DEFAULT NULL,
  `last_update_date` varchar(255) DEFAULT NULL,
  `host_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0：本地应用 1：远程应用',
  `app_entry` varchar(255) DEFAULT NULL,
  `icon_url` varchar(255) DEFAULT NULL,
  `large_icon_url` varchar(255) DEFAULT NULL,
  `admin_entry` varchar(255) DEFAULT NULL,
  `statistics_entry` varchar(255) DEFAULT NULL,
  `homepage_url` varchar(255) DEFAULT NULL,
  `sidebar_title` varchar(255) DEFAULT NULL,
  `sidebar_entry` varchar(255) DEFAULT NULL,
  `sidebar_icon_url` varchar(255) DEFAULT NULL,
  `sidebar_support_submenu` tinyint(1) NOT NULL DEFAULT '0',
  `sidebar_is_submenu_active` tinyint(1) NOT NULL DEFAULT '0',
  `author_name` varchar(255) DEFAULT NULL,
  `author_email` varchar(255) DEFAULT NULL,
  `author_homepage_url` varchar(255) DEFAULT NULL,
  `contributor_name` text,
  `display_order` smallint(5) NOT NULL DEFAULT '0',
  `ctime` int(11) DEFAULT NULL,
  PRIMARY KEY (`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_app_signs`
--

DROP TABLE IF EXISTS `pw_app_signs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_app_signs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `user_key` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `phone_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `device_token` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '手机设备token，用于消息推送',
  `ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ctime` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_area`
--

DROP TABLE IF EXISTS `pw_area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_area` (
  `area_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `pid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`area_id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_credit_setting`
--

DROP TABLE IF EXISTS `pw_credit_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_credit_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'user',
  `info` text NOT NULL,
  `score` int(11) NOT NULL DEFAULT '0',
  `experience` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_credit_type`
--

DROP TABLE IF EXISTS `pw_credit_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_credit_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `alias` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_credit_user`
--

DROP TABLE IF EXISTS `pw_credit_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_credit_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `score` int(11) NOT NULL,
  `experience` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_education`
--

DROP TABLE IF EXISTS `pw_education`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_education` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `location_x` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '学校坐标x',
  `location_y` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '学校坐标y',
  `pid` int(11) NOT NULL DEFAULT '0',
  `area_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属城市id',
  `type` varchar(10) NOT NULL DEFAULT '0' COMMENT '类型。0学校 1学院 2专业',
  `ctime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`),
  KEY `idx_area` (`area_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_follow`
--

DROP TABLE IF EXISTS `pw_follow`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_follow` (
  `follow_id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `fid` int(11) NOT NULL,
  `remark` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `follow_group_id` int(11) NOT NULL DEFAULT '0',
  `ctime` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '好友状态。0屏蔽好友 1已申请好友 2已添加好友 3互为好友',
  PRIMARY KEY (`follow_id`),
  UNIQUE KEY `uid` (`uid`,`fid`),
  KEY `uid_2` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_follow_group`
--

DROP TABLE IF EXISTS `pw_follow_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_follow_group` (
  `follow_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `ctime` int(11) DEFAULT NULL,
  PRIMARY KEY (`follow_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_friend`
--

DROP TABLE IF EXISTS `pw_friend`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_friend` (
  `follow_id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `fid` int(11) NOT NULL,
  `remark` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ctime` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '好友状态。0屏蔽好友 1已申请好友 2已添加好友 3互为好友',
  PRIMARY KEY (`follow_id`),
  UNIQUE KEY `uid` (`uid`,`fid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_im_huanxin`
--

DROP TABLE IF EXISTS `pw_im_huanxin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_im_huanxin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '环信用户名',
  `passwd` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '环信用户密码',
  `ctime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='环信聊天-记录用户通行token';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_im_tim`
--

DROP TABLE IF EXISTS `pw_im_tim`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_im_tim` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL COMMENT '用户id',
  `username` char(32) COLLATE utf8_unicode_ci NOT NULL COMMENT '用户名',
  `usersig` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'user sig',
  `etime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '过期时间',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='腾讯云通信，账号体系';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_impress_comment`
--

DROP TABLE IF EXISTS `pw_impress_comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_impress_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0,
  `content` varchar(1000) DEFAULT NULL,
  `cdata` text NOT NULL DEFAULT '',
  `reply_uid` int(11) NOT NULL DEFAULT '0',
  `source_id` int(11) NOT NULL DEFAULT 0,
  `im_id` int(11) NOT NULL DEFAULT 0 COMMENT '好友印象id',
  `ctime` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_impress_grade`
--

DROP TABLE IF EXISTS `pw_impress_grade`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_impress_grade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL COMMENT '用户uid',
  `im_id` int(10) unsigned NOT NULL COMMENT '印象id',
  `score` int(10) unsigned NOT NULL COMMENT '用户对印象评级(打分)',
  `anonymous` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否匿名。0默认不匿名 1匿名',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '打分时间',
  PRIMARY KEY (`id`),
  KEY `idx_uid_time` (`uid`,`ctime`),
  KEY `idx_imid_time` (`im_id`,`ctime`),
  KEY `idx_uid_imid` (`uid`,`im_id`),
  KEY `idx_ctime` (`ctime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_impress_gradeauto`
--

DROP TABLE IF EXISTS `pw_impress_gradeauto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_impress_gradeauto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `im_id` int(10) unsigned NOT NULL COMMENT '印象id',
  `score` int(10) unsigned NOT NULL COMMENT '用户对印象评级(打分)',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '打分时间',
  PRIMARY KEY (`id`),
  KEY `idx_imid` (`im_id`),
  KEY `idx_ctime` (`ctime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_impress_like`
--

DROP TABLE IF EXISTS `pw_impress_like`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_impress_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `im_id` int(11) NOT NULL,
  `ctime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `im_id` (`im_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_impress_nsfw`
--

DROP TABLE IF EXISTS `pw_impress_nsfw`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_impress_nsfw` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `im_id` int(11) unsigned NOT NULL DEFAULT '0',
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `risk_level` varchar(10) NOT NULL DEFAULT '' COMMENT '风险等级：high、medium、low、none',
  `request_id` varchar(40) NOT NULL DEFAULT '' COMMENT '请求id',
  `data_id` varchar(20) NOT NULL DEFAULT '' COMMENT '请求时自定义data id',
  `detail` varchar(1000) NOT NULL DEFAULT '' COMMENT '请求结果详情',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `ctime` int(11) unsigned NOT NULL DEFAULT '0',
  `utime` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `im_id` (`im_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='图片nsfw检测结果';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_invitecode`
--

DROP TABLE IF EXISTS `pw_invitecode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_invitecode` (
  `invite_code_id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `code` varchar(120) NOT NULL,
  `is_used` tinyint(1) NOT NULL,
  `type` char(40) NOT NULL,
  `is_received` tinyint(1) NOT NULL,
  PRIMARY KEY (`invite_code_id`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_login`
--

DROP TABLE IF EXISTS `pw_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_login` (
  `login_id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `type_uid` varchar(255) NOT NULL DEFAULT '',
  `type` char(80) NOT NULL,
  `oauth_token` varchar(150) DEFAULT NULL,
  `oauth_token_secret` varchar(150) DEFAULT NULL,
  `is_sync` tinyint(1) NOT NULL,
  PRIMARY KEY (`login_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_login_record`
--

DROP TABLE IF EXISTS `pw_login_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_login_record` (
  `login_record_id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(15) NOT NULL DEFAULT '',
  `place` varchar(255) NOT NULL DEFAULT '',
  `ctime` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`login_record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_node`
--

DROP TABLE IF EXISTS `pw_node`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_node` (
  `node_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_name` varchar(255) NOT NULL,
  `app_alias` varchar(255) DEFAULT NULL,
  `mod_name` varchar(255) NOT NULL,
  `mod_alias` varchar(255) DEFAULT NULL,
  `act_name` varchar(255) NOT NULL,
  `act_alias` varchar(255) DEFAULT NULL,
  `parent_node_id` int(11) NOT NULL COMMENT '??action',
  `description` text,
  PRIMARY KEY (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_notify`
--

DROP TABLE IF EXISTS `pw_notify`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_notify` (
  `notify_id` int(11) NOT NULL AUTO_INCREMENT,
  `from` int(11) NOT NULL DEFAULT '0',
  `receive` int(11) NOT NULL DEFAULT 0,
  `type` char(80) NOT NULL DEFAULT '',
  `data` varchar(2000) NOT NULL DEFAULT '',
  `is_mass` tinyint(1) NOT NULL DEFAULT '0',
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `ctime` int(11) NOT NULL DEFAULT 0,
  `mtime` int(11) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`notify_id`),
  KEY `receive` (`receive`,`is_read`),
  KEY `ctime` (`ctime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_notify_mass`
--

DROP TABLE IF EXISTS `pw_notify_mass`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_notify_mass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `notify_id` int(11) NOT NULL,
  `ctime` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_picture`
--

DROP TABLE IF EXISTS `pw_picture`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_picture` (
  `pic_id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `intro` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `path` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '1',
  `ctime` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`pic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_plugin`
--

DROP TABLE IF EXISTS `pw_plugin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_plugin` (
  `plugin_id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin_name` varchar(120) NOT NULL,
  `icon_pic` varchar(120) NOT NULL,
  `plugin_path` varchar(255) NOT NULL,
  PRIMARY KEY (`plugin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user`
--

DROP TABLE IF EXISTS `pw_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL DEFAULT '',
  `mobile` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL DEFAULT '',
  `uname` varchar(128) NOT NULL DEFAULT '' COMMENT '用户昵称',
  `sex` tinyint(1) NOT NULL DEFAULT '3' COMMENT '1为男，0为女',
  `admin_level` varchar(255) DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_init` tinyint(1) NOT NULL DEFAULT 0,
  `is_synchronizing` tinyint(1) NOT NULL DEFAULT '0',
  `ctime` int(11) NOT NULL DEFAULT 0,
  `mtime` int(11) NOT NULL DEFAULT 0,
  `score` int(11) NOT NULL DEFAULT '0',
  `work_status` tinyint(1) NOT NULL DEFAULT '0',
  `domain` varchar(100) NOT NULL DEFAULT '',
  `wechat_id` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`),
  KEY `domain` (`domain`),
  KEY `mobile` (`mobile`),
  KEY `idx_wechat` (`wechat_id`),
  KEY `idx_sex` (`sex`)
) ENGINE=InnoDB AUTO_INCREMENT=20264 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_app`
--

DROP TABLE IF EXISTS `pw_user_app`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_app` (
  `user_app_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `app_id` int(11) NOT NULL DEFAULT 0,
  `uid` int(11) NOT NULL DEFAULT 0,
  `display_order` int(5) NOT NULL DEFAULT '0',
  `ctime` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`user_app_id`),
  KEY `display_order` (`display_order`),
  KEY `app_id` (`app_id`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_baseinfo`
--

DROP TABLE IF EXISTS `pw_user_baseinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_baseinfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `sign` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `relation` tinyint(4) NOT NULL DEFAULT '0' COMMENT '个人状态。0单身',
  `birth` int(11) NOT NULL DEFAULT '0',
  `province` int(11) NOT NULL DEFAULT '1',
  `city` int(11) NOT NULL DEFAULT '2',
  `location` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mtime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`),
  KEY `idx_city` (`city`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_blacklist`
--

DROP TABLE IF EXISTS `pw_user_blacklist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_blacklist` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `fid` int(11) NOT NULL,
  `ctime` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`,`fid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_browse_record`
--

DROP TABLE IF EXISTS `pw_user_browse_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_browse_record` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `feed_id` int(11) unsigned NOT NULL COMMENT '动态id',
  `ctime` int(11) unsigned NOT NULL COMMENT '浏览时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_2` (`uid`,`feed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='用户浏览动态记录表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_contact`
--

DROP TABLE IF EXISTS `pw_user_contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `fid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '通讯录手机号的用户id',
  `mobile` varchar(20) CHARACTER SET gbk DEFAULT NULL COMMENT '通讯录号码',
  `name` varchar(32) CHARACTER SET gbk DEFAULT NULL COMMENT '通讯录姓名',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态。0号码尚未注册，1号码已注册但未添加好友，2已添加好友',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_2` (`uid`,`mobile`),
  KEY `mobile` (`mobile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_education`
--

DROP TABLE IF EXISTS `pw_user_education`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_education` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0,
  `school_id` int(11) NOT NULL DEFAULT '0' COMMENT '学校id',
  `ins_id` int(11) NOT NULL DEFAULT '0' COMMENT '学院id',
  `major_id` int(11) NOT NULL DEFAULT '0' COMMENT '专业id',
  `stime` int(11) NOT NULL DEFAULT '0' COMMENT '入学时间',
  `etime` int(11) NOT NULL DEFAULT '0' COMMENT '毕业时间',
  `ctime` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态。0已删除 1默认未删除',
  PRIMARY KEY (`id`),
  KEY `idx_uid_school` (`uid`,`school_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_feed`
--

DROP TABLE IF EXISTS `pw_user_feed`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_feed` (
  `feed_id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0',
  `ass_id` int(11) NOT NULL DEFAULT '0',
  `data` text NOT NULL,
  `ctime` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `pf_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '印象隐私设置。1所有好友可见 2仅自己可见',
  PRIMARY KEY (`feed_id`),
  UNIQUE KEY `uid` (`uid`,`ass_id`,`type`),
  KEY `ctime` (`ctime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_gold`
--

DROP TABLE IF EXISTS `pw_user_gold`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_gold` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0,
  `amount` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '金币状态。0冻结，1正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_impress`
--

DROP TABLE IF EXISTS `pw_user_impress`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_impress` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0,
  `pic_id` int(11) NOT NULL DEFAULT '0',
  `path` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `intro` varchar(2000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `im_by` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '1',
  `ctime` int(11) NOT NULL DEFAULT '0',
  `utime` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `nsfw_check` tinyint(1) NOT NULL DEFAULT '0' COMMENT '检测状态 0未检测 1检测正常 2检测异常',
  `datas` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source` int(11) DEFAULT '0',
  `recommend` int(11) DEFAULT '0',
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '赞和踩的总分，赞+1踩-1，总分可能为负数',
  `grade` decimal(3,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '图片等级，通过用户打分计算平均值',
  `comment` int(11) DEFAULT '0',
  `comment_new` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '存取最新6条评论',
  `visit` int(11) unsigned DEFAULT '0' COMMENT '访问次数纪录',
  `pub_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '印象发布类型。1个人，2头条，3头条审核中',
  `pf_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '印象隐私设置。0仅对自己可见 1所有好友可见',
  `sm_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '模仿范本id',
  `user_gender` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '用户性别',
  `user_city` int(10) unsigned NOT NULL DEFAULT '2' COMMENT '用户所在城市',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_industry`
--

DROP TABLE IF EXISTS `pw_user_industry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_industry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0,
  `ind_id` int(11) NOT NULL DEFAULT '0' COMMENT '行业id',
  `ctime` int(11) NOT NULL DEFAULT '0',
  `stauts` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态。0已删除 1默认未删除',
  PRIMARY KEY (`id`),
  KEY `idx_uid_industry` (`uid`,`ind_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_location`
--

DROP TABLE IF EXISTS `pw_user_location`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_location` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `location_x` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '坐标x(经度)',
  `location_y` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '坐标y(纬度)',
  `location_z` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '坐标z(三维空间使用，高度)',
  `ctime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `mtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='用户位置坐标表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_location_record`
--

DROP TABLE IF EXISTS `pw_user_location_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_location_record` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `location_x` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '坐标x(经度)',
  `location_y` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '坐标y(纬度)',
  `location_z` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '坐标z(三维空间使用，高度)',
  `ctime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='用户位置坐标记录表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pw_user_visit_record`
--

DROP TABLE IF EXISTS `pw_user_visit_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pw_user_visit_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `to_uid` int(11) NOT NULL,
  `ctime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-03-27 22:42:31
