项目语言:PHP
权限:read-only(如需更高权限请先加入项目)
Index: push.php
===================================================================
--- push.php (revision 0)
+++ push.php (revision 77)
@@ -0,0 +1,2 @@
+fopen('http://im./index.php/user/push/ios', 'r');
\ No newline at end of file
Index: imapp_db.sql
===================================================================
--- imapp_db.sql (revision 0)
+++ imapp_db.sql (revision 77)
@@ -0,0 +1,1044 @@
+-- phpMyAdmin SQL Dump
+-- version 4.0.10.1
+-- http://www.phpmyadmin.net
+-- Host: localhost
+-- Generation Time: Oct 28, 2014 at 03:03 PM
+-- Server version: 5.5.38
+-- PHP Version: 5.3.3
+SET SQL_MODE = &NO_AUTO_VALUE_ON_ZERO&;
+SET time_zone = &+00:00&;
+/*!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 */;
+-- Database: `research`
+CREATE DATABASE IF NOT EXISTS `imapp_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_
+USE `imapp_db`;
+-- --------------------------------------------------------
+-- Table structure for table `im_admin`
+DROP TABLE IF EXISTS `im_admin`;
+CREATE TABLE IF NOT EXISTS `im_admin` (
`userid` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
`roleid` smallint(5) DEFAULT '0',
`encrypt` varchar(6) DEFAULT NULL,
`lastloginip` varchar(15) DEFAULT NULL,
`lastlogintime` int(10) unsigned DEFAULT '0',
`lastlifetime` int(10) unsigned DEFAULT '0',
`email` varchar(40) DEFAULT NULL,
`realname` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`userid`),
KEY `username` (`username`)
+) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+-- Dumping data for table `im_admin`
+INSERT INTO `im_admin` (`userid`, `username`, `password`, `roleid`, `encrypt`, `lastloginip`, `lastlogintime`, `lastlifetime`, `email`, `realname`) VALUES
+(1, 'admin', '0d90b1cf3fdc50df2baadbd', 1, 'WxrSHN', '125.70.13.105', , , '', '');
+-- --------------------------------------------------------
+-- Table structure for table `im_admin_role`
+DROP TABLE IF EXISTS `im_admin_role`;
+CREATE TABLE IF NOT EXISTS `im_admin_role` (
`roleid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`rolename` varchar(50) NOT NULL,
`description` text NOT NULL,
`listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
`disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`roleid`),
KEY `listorder` (`listorder`),
KEY `disabled` (`disabled`)
+) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+-- Dumping data for table `im_admin_role`
+INSERT INTO `im_admin_role` (`roleid`, `rolename`, `description`, `listorder`, `disabled`) VALUES
+(1, '超级管理员', '超级管理员', 0, 0);
+-- --------------------------------------------------------
+-- Table structure for table `im_admin_role_priv`
+DROP TABLE IF EXISTS `im_admin_role_priv`;
+CREATE TABLE IF NOT EXISTS `im_admin_role_priv` (
`roleid` tinyint(3) unsigned NOT NULL DEFAULT '0',
`m` char(20) NOT NULL,
`a` char(20) NOT NULL,
`data` char(30) NOT NULL DEFAULT '',
KEY `roleid` (`roleid`,`m`,`a`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+-- --------------------------------------------------------
+-- Table structure for table `im_area`
+DROP TABLE IF EXISTS `im_area`;
+CREATE TABLE IF NOT EXISTS `im_area` (
`areaid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '地址ID',
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '地区名字',
`parentid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '上级路径ID',
`vieworder` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '顺序',
`state` varchar(6) NOT NULL DEFAULT '',
PRIMARY KEY (`areaid`),
KEY `idx_name` (`name`),
KEY `idx_parentid_vieworder` (`parentid`,`vieworder`)
+) ENGINE=MyISAM
DEFAULT CHARSET=utf8 COMMENT='统一地区库' AUTO_INCREMENT=820792 ;
+-- Dumping data for table `im_area`
+INSERT INTO `im_area` (`areaid`, `name`, `parentid`, `vieworder`, `state`) VALUES
+(11, '北京', 0, 1, 'closed'),
+(31, '上海', 0, 2, 'closed'),
+(44, '广东', 0, 3, 'closed'),
+(34, '安徽', 0, 4, 'closed'),
+(50, '重庆', 0, 5, 'closed'),
+(35, '福建', 0, 6, 'closed'),
+(46, '海南', 0, 7, 'closed'),
+(13, '河北', 0, 8, 'closed'),
+(41, '河南', 0, 9, 'closed'),
+(23, '黑龙江', 0, 10, 'closed'),
+(42, '湖北', 0, 11, 'closed'),
+(43, '湖南', 0, 12, 'closed'),
+(62, '甘肃', 0, 13, 'closed'),
+(45, '广西', 0, 14, 'closed'),
+(52, '贵州', 0, 15, 'closed'),
+(22, '吉林', 0, 16, 'closed'),
+(36, '江西', 0, 17, 'closed'),
+(32, '江苏', 0, 18, 'closed'),
+(21, '辽宁', 0, 19, 'closed'),
+(15, '内蒙古', 0, 20, 'closed'),
+(64, '宁夏', 0, 21, 'closed'),
+(63, '青海', 0, 22, 'closed'),
+(37, '山东', 0, 23, 'closed'),
+(14, '山西', 0, 24, 'closed'),
+(61, '陕西', 0, 25, 'closed'),
+(51, '四川', 0, 26, 'closed'),
+(12, '天津', 0, 27, 'closed'),
+(54, '西藏', 0, 28, 'closed'),
+(65, '新疆', 0, 29, 'closed'),
+(53, '云南', 0, 30, 'closed'),
+(33, '浙江', 0, 31, 'closed'),
+(71, '台湾', 0, 32, 'closed'),
+(81, '香港', 0, 33, 'closed'),
+(82, '澳门', 0, 34, 'closed'),
+(1129, '延庆', 11, 18, ''),
+(1128, '密云', 11, 17, ''),
+(1127, '怀柔', 11, 16, ''),
+(1126, '平谷', 11, 15, ''),
+(1124, '大兴', 11, 14, ''),
+(1121, '昌平', 11, 13, ''),
+(1113, '顺义', 11, 12, ''),
+(1112, '通州', 11, 11, ''),
+(1111, '房山', 11, 10, ''),
+(1109, '门头沟', 11, 9, ''),
+(1108, '海淀', 11, 8, ''),
+(1107, '石景山', 11, 7, ''),
+(1106, '丰台', 11, 6, ''),
+(1105, '朝阳', 11, 5, ''),
+(1104, '宣武', 11, 4, ''),
+(1103, '崇文', 11, 3, ''),
+(1102, '西城', 11, 2, ''),
+(1101, '东城', 11, 1, ''),
+(1201, '和平', 12, 1, ''),
+(1202, '河东', 12, 2, ''),
+(1203, '河西', 12, 3, ''),
+(1204, '南开', 12, 4, ''),
+(1205, '河北', 12, 5, ''),
+(1206, '红桥', 12, 6, ''),
+(1207, '滨海新区', 12, 7, ''),
+(1210, '东丽', 12, 8, ''),
+(1211, '西青', 12, 9, ''),
+(1212, '津南', 12, 10, ''),
+(1213, '北辰', 12, 11, ''),
+(1221, '宁河', 12, 12, ''),
+(1222, '武清', 12, 13, ''),
+(1223, '静海', 12, 14, ''),
+(1224, '宝坻', 12, 15, ''),
+(1225, '蓟县', 12, 16, ''),
+(1301, '石家庄', 13, 1, ''),
+(1302, '唐山', 13, 2, ''),
+(1303, '秦皇岛', 13, 3, ''),
+(1304, '邯郸', 13, 4, ''),
+(1305, '邢台', 13, 5, ''),
+(1306, '保定', 13, 6, ''),
+(1307, '张家口', 13, 7, ''),
+(1308, '承德', 13, 8, ''),
+(1309, '沧州', 13, 9, ''),
+(1310, '廊坊', 13, 10, ''),
+(1311, '衡水', 13, 11, ''),
+(1401, '太原', 14, 1, ''),
+(1402, '大同', 14, 2, ''),
+(1403, '阳泉', 14, 3, ''),
+(1404, '长治', 14, 4, ''),
+(1405, '晋城', 14, 5, ''),
+(1406, '朔州', 14, 6, ''),
+(1407, '晋中', 14, 7, ''),
+(1408, '运城', 14, 8, ''),
+(1409, '忻州', 14, 9, ''),
+(1410, '临汾', 14, 10, ''),
+(1411, '吕梁', 14, 11, ''),
+(1501, '呼和浩特', 15, 1, ''),
+(1502, '包头', 15, 2, ''),
+(1503, '乌海', 15, 3, ''),
+(1504, '赤峰', 15, 4, ''),
+(1505, '通辽', 15, 5, ''),
+(1506, '鄂尔多斯', 15, 6, ''),
+(1507, '呼伦贝尔', 15, 7, ''),
+(1508, '巴彦淖尔', 15, 8, ''),
+(1509, '乌兰察布', 15, 9, ''),
+(1522, '兴安', 15, 10, ''),
+(1525, '锡林郭勒', 15, 11, ''),
+(1529, '阿拉善', 15, 12, ''),
+(2101, '沈阳', 21, 1, ''),
+(2102, '大连', 21, 2, ''),
+(2103, '鞍山', 21, 3, ''),
+(2104, '抚顺', 21, 4, ''),
+(2105, '本溪', 21, 5, ''),
+(2106, '丹东', 21, 6, ''),
+(2107, '锦州', 21, 7, ''),
+(2108, '营口', 21, 8, ''),
+(2109, '阜新', 21, 9, ''),
+(2110, '辽阳', 21, 10, ''),
+(2111, '盘锦', 21, 11, ''),
+(2112, '铁岭', 21, 12, ''),
+(2113, '朝阳', 21, 13, ''),
+(2114, '葫芦岛', 21, 14, ''),
+(2201, '长春', 22, 1, ''),
+(2202, '吉林', 22, 2, ''),
+(2203, '四平', 22, 3, ''),
+(2204, '辽源', 22, 4, ''),
+(2205, '通化', 22, 5, ''),
+(2206, '白山', 22, 6, ''),
+(2207, '松原', 22, 7, ''),
+(2208, '白城', 22, 8, ''),
+(2224, '延边', 22, 9, ''),
+(2301, '哈尔滨', 23, 1, ''),
+(2302, '齐齐哈尔', 23, 2, ''),
+(2303, '鸡西', 23, 3, ''),
+(2304, '鹤岗', 23, 4, ''),
+(2305, '双鸭山', 23, 5, ''),
+(2306, '大庆', 23, 6, ''),
+(2307, '伊春', 23, 7, ''),
+(2308, '佳木斯', 23, 8, ''),
+(2309, '七台河', 23, 9, ''),
+(2310, '牡丹江', 23, 10, ''),
+(2311, '黑河', 23, 11, ''),
+(2312, '绥化', 23, 12, ''),
+(2327, '大兴安岭', 23, 13, ''),
+(3101, '黄浦', 31, 1, ''),
+(3103, '卢湾', 31, 2, ''),
+(3104, '徐汇', 31, 3, ''),
+(3105, '长宁', 31, 4, ''),
+(3106, '静安', 31, 5, ''),
+(3107, '普陀', 31, 6, ''),
+(3108, '闸北', 31, 7, ''),
+(3109, '虹口', 31, 8, ''),
+(3110, '杨浦', 31, 9, ''),
+(3112, '闵行', 31, 10, ''),
+(3113, '宝山', 31, 11, ''),
+(3114, '嘉定', 31, 12, ''),
+(3115, '浦东新区', 31, 13, ''),
+(3116, '金山', 31, 14, ''),
+(3117, '松江', 31, 15, ''),
+(3126, '奉贤', 31, 16, ''),
+(3129, '青浦', 31, 17, ''),
+(3130, '崇明', 31, 18, ''),
+(3201, '南京', 32, 1, ''),
+(3202, '无锡', 32, 2, ''),
+(3203, '徐州', 32, 3, ''),
+(3204, '常州', 32, 4, ''),
+(3205, '苏州', 32, 5, ''),
+(3206, '南通', 32, 6, ''),
+(3207, '连云港', 32, 7, ''),
+(3208, '淮安', 32, 8, ''),
+(3209, '盐城', 32, 9, ''),
+(3210, '扬州', 32, 10, ''),
+(3211, '镇江', 32, 11, ''),
+(3212, '泰州', 32, 12, ''),
+(3213, '宿迁', 32, 13, ''),
+(3301, '杭州', 33, 1, ''),
+(3302, '宁波', 33, 2, ''),
+(3303, '温州', 33, 3, ''),
+(3304, '嘉兴', 33, 4, ''),
+(3305, '湖州', 33, 5, ''),
+(3306, '绍兴', 33, 6, ''),
+(3307, '金华', 33, 7, ''),
+(3308, '衢州', 33, 8, ''),
+(3309, '舟山', 33, 9, ''),
+(3310, '台州', 33, 10, ''),
+(3311, '丽水', 33, 11, ''),
+(3401, '合肥', 34, 1, ''),
+(3402, '芜湖', 34, 2, ''),
+(3403, '蚌埠', 34, 3, ''),
+(3404, '淮南', 34, 4, ''),
+(3405, '马鞍山', 34, 5, ''),
+(3406, '淮北', 34, 6, ''),
+(3407, '铜陵', 34, 7, ''),
+(3408, '安庆', 34, 8, ''),
+(3410, '黄山', 34, 9, ''),
+(3411, '滁州', 34, 10, ''),
+(3412, '阜阳', 34, 11, ''),
+(3413, '宿州', 34, 12, ''),
+(3414, '巢湖', 34, 13, ''),
+(3415, '六安', 34, 14, ''),
+(3416, '亳州', 34, 15, ''),
+(3417, '池州', 34, 16, ''),
+(3418, '宣城', 34, 17, ''),
+(3501, '福州', 35, 1, ''),
+(3502, '厦门', 35, 2, ''),
+(3503, '莆田', 35, 3, ''),
+(3504, '三明', 35, 4, ''),
+(3505, '泉州', 35, 5, ''),
+(3506, '漳州', 35, 6, ''),
+(3507, '南平', 35, 7, ''),
+(3508, '龙岩', 35, 8, ''),
+(3509, '宁德', 35, 9, ''),
+(3601, '南昌', 36, 1, ''),
+(3602, '景德镇', 36, 2, ''),
+(3603, '萍乡', 36, 3, ''),
+(3604, '九江', 36, 4, ''),
+(3605, '新余', 36, 5, ''),
+(3606, '鹰潭', 36, 6, ''),
+(3607, '赣州', 36, 7, ''),
+(3608, '吉安', 36, 8, ''),
+(3609, '宜春', 36, 9, ''),
+(3610, '抚州', 36, 10, ''),
+(3611, '上饶', 36, 11, ''),
+(3701, '济南', 37, 1, ''),
+(3702, '青岛', 37, 2, ''),
+(3703, '淄博', 37, 3, ''),
+(3704, '枣庄', 37, 4, ''),
+(3705, '东营', 37, 5, ''),
+(3706, '烟台', 37, 6, ''),
+(3707, '潍坊', 37, 7, ''),
+(3708, '济宁', 37, 8, ''),
+(3709, '泰安', 37, 9, ''),
+(3710, '威海', 37, 10, ''),
+(3711, '日照', 37, 11, ''),
+(3712, '莱芜', 37, 12, ''),
+(3713, '临沂', 37, 13, ''),
+(3714, '德州', 37, 14, ''),
+(3715, '聊城', 37, 15, ''),
+(3716, '滨州', 37, 16, ''),
+(3717, '菏泽', 37, 17, ''),
+(4101, '郑州', 41, 1, ''),
+(4102, '开封', 41, 2, ''),
+(4103, '洛阳', 41, 3, ''),
+(4104, '平顶山', 41, 4, ''),
+(4105, '安阳', 41, 5, ''),
+(4106, '鹤壁', 41, 6, ''),
+(4107, '新乡', 41, 7, ''),
+(4108, '焦作', 41, 8, ''),
+(4109, '濮阳', 41, 9, ''),
+(4110, '许昌', 41, 10, ''),
+(4111, '漯河', 41, 11, ''),
+(4112, '三门峡', 41, 12, ''),
+(4113, '南阳', 41, 13, ''),
+(4114, '商丘', 41, 14, ''),
+(4115, '信阳', 41, 15, ''),
+(4116, '周口', 41, 16, ''),
+(4117, '驻马店', 41, 17, ''),
+(4118, '济源', 41, 18, ''),
+(4201, '武汉', 42, 1, ''),
+(4202, '黄石', 42, 2, ''),
+(4203, '十堰', 42, 3, ''),
+(4205, '宜昌', 42, 4, ''),
+(4206, '襄樊', 42, 5, ''),
+(4207, '鄂州', 42, 6, ''),
+(4208, '荆门', 42, 7, ''),
+(4209, '孝感', 42, 8, ''),
+(4210, '荆州', 42, 9, ''),
+(4211, '黄冈', 42, 10, ''),
+(4212, '咸宁', 42, 11, ''),
+(4213, '随州', 42, 12, ''),
+(4228, '恩施', 42, 13, ''),
+(4229, '仙桃', 42, 14, ''),
+(4230, '潜江', 42, 15, ''),
+(4231, '天门', 42, 16, ''),
+(4232, '神农架', 42, 17, ''),
+(4301, '长沙', 43, 1, ''),
+(4302, '株洲', 43, 2, ''),
+(4303, '湘潭', 43, 3, ''),
+(4304, '衡阳', 43, 4, ''),
+(4305, '邵阳', 43, 5, ''),
+(4306, '岳阳', 43, 6, ''),
+(4307, '常德', 43, 7, ''),
+(4308, '张家界', 43, 8, ''),
+(4309, '益阳', 43, 9, ''),
+(4310, '郴州', 43, 10, ''),
+(4311, '永州', 43, 11, ''),
+(4312, '怀化', 43, 12, ''),
+(4313, '娄底', 43, 13, ''),
+(4331, '湘西', 43, 14, ''),
+(4401, '广州', 44, 1, ''),
+(4402, '韶关', 44, 2, ''),
+(4403, '深圳', 44, 3, ''),
+(4404, '珠海', 44, 4, ''),
+(4405, '汕头', 44, 5, ''),
+(4406, '佛山', 44, 6, ''),
+(4407, '江门', 44, 7, ''),
+(4408, '湛江', 44, 8, ''),
+(4409, '茂名', 44, 9, ''),
+(4412, '肇庆', 44, 10, ''),
+(4413, '惠州', 44, 11, ''),
+(4414, '梅州', 44, 12, ''),
+(4415, '汕尾', 44, 13, ''),
+(4416, '河源', 44, 14, ''),
+(4417, '阳江', 44, 15, ''),
+(4418, '清远', 44, 16, ''),
+(4419, '东莞', 44, 17, ''),
+(4420, '中山', 44, 18, ''),
+(4451, '潮州', 44, 19, ''),
+(4452, '揭阳', 44, 20, ''),
+(4453, '云浮', 44, 21, ''),
+(4501, '南宁', 45, 1, ''),
+(4502, '柳州', 45, 2, ''),
+(4503, '桂林', 45, 3, ''),
+(4504, '梧州', 45, 4, ''),
+(4505, '北海', 45, 5, ''),
+(4506, '防城港', 45, 6, ''),
+(4507, '钦州', 45, 7, ''),
+(4508, '贵港', 45, 8, ''),
+(4509, '玉林', 45, 9, ''),
+(4510, '百色', 45, 10, ''),
+(4511, '贺州', 45, 11, ''),
+(4512, '河池', 45, 12, ''),
+(4513, '来宾', 45, 13, ''),
+(4514, '崇左', 45, 14, ''),
+(4601, '海口', 46, 1, ''),
+(4602, '三亚', 46, 2, ''),
+(4603, '五指山', 46, 3, ''),
+(4604, '琼海', 46, 4, ''),
+(4605, '儋州', 46, 5, ''),
+(4606, '文昌', 46, 6, ''),
+(4607, '万宁', 46, 7, ''),
+(4608, '东方', 46, 8, ''),
+(5001, '万州', 50, 1, ''),
+(5002, '涪陵', 50, 2, ''),
+(5003, '渝中', 50, 3, ''),
+(5004, '大渡口', 50, 4, ''),
+(5005, '江北', 50, 5, ''),
+(5006, '沙坪坝', 50, 6, ''),
+(5007, '九龙坡', 50, 7, ''),
+(5008, '南岸', 50, 8, ''),
+(5009, '北碚', 50, 9, ''),
+(5010, '万盛', 50, 10, ''),
+(5011, '双桥', 50, 11, ''),
+(5012, '渝北', 50, 12, ''),
+(5013, '巴南', 50, 13, ''),
+(5021, '长寿', 50, 14, ''),
+(5022, '綦江', 50, 15, ''),
+(5023, '潼南', 50, 16, ''),
+(5024, '铜梁', 50, 17, ''),
+(5025, '大足', 50, 18, ''),
+(5026, '荣昌', 50, 19, ''),
+(5027, '璧山', 50, 20, ''),
+(5028, '梁平', 50, 21, ''),
+(5029, '城口', 50, 22, ''),
+(5030, '丰都', 50, 23, ''),
+(5031, '垫江', 50, 24, ''),
+(5032, '武隆', 50, 25, ''),
+(5033, '忠县', 50, 26, ''),
+(5034, '开县', 50, 27, ''),
+(5035, '云阳', 50, 28, ''),
+(5036, '奉节', 50, 29, ''),
+(5037, '巫山', 50, 30, ''),
+(5038, '巫溪', 50, 31, ''),
+(5039, '黔江', 50, 32, ''),
+(5040, '石柱', 50, 33, ''),
+(5041, '秀山', 50, 34, ''),
+(5042, '酉阳', 50, 35, ''),
+(5043, '彭水', 50, 36, ''),
+(5081, '江津', 50, 37, ''),
+(5082, '合川', 50, 38, ''),
+(5083, '永川', 50, 39, ''),
+(5084, '南川', 50, 40, ''),
+(5101, '成都', 51, 1, ''),
+(5103, '自贡', 51, 2, ''),
+(5104, '攀枝花', 51, 3, ''),
+(5105, '泸州', 51, 4, ''),
+(5106, '德阳', 51, 5, ''),
+(5107, '绵阳', 51, 6, ''),
+(5108, '广元', 51, 7, ''),
+(5109, '遂宁', 51, 8, ''),
+(5110, '内江', 51, 9, ''),
+(5111, '乐山', 51, 10, ''),
+(5113, '南充', 51, 11, ''),
+(5114, '眉山', 51, 12, ''),
+(5115, '宜宾', 51, 13, ''),
+(5116, '广安', 51, 14, ''),
+(5117, '达州', 51, 15, ''),
+(5118, '雅安', 51, 16, ''),
+(5119, '巴中', 51, 17, ''),
+(5120, '资阳', 51, 18, ''),
+(5132, '阿坝', 51, 19, ''),
+(5133, '甘孜', 51, 20, ''),
+(5134, '凉山', 51, 21, ''),
+(5201, '贵阳', 52, 1, ''),
+(5202, '六盘水', 52, 2, ''),
+(5203, '遵义', 52, 3, ''),
+(5204, '安顺', 52, 4, ''),
+(5222, '铜仁', 52, 5, ''),
+(5223, '黔西南', 52, 6, ''),
+(5224, '毕节', 52, 7, ''),
+(5226, '黔东南', 52, 8, ''),
+(5227, '黔南', 52, 9, ''),
+(5301, '昆明', 53, 1, ''),
+(5303, '曲靖', 53, 2, ''),
+(5304, '玉溪', 53, 3, ''),
+(5305, '保山', 53, 4, ''),
+(5306, '昭通', 53, 5, ''),
+(5307, '丽江', 53, 6, ''),
+(5308, '普洱', 53, 7, ''),
+(5309, '临沧', 53, 8, ''),
+(5323, '楚雄', 53, 9, ''),
+(5325, '红河', 53, 10, ''),
+(5326, '文山', 53, 11, ''),
+(5328, '西双版纳', 53, 12, ''),
+(5329, '大理', 53, 13, ''),
+(5331, '德宏', 53, 14, ''),
+(5333, '怒江傈', 53, 15, ''),
+(5334, '迪庆', 53, 16, ''),
+(5401, '拉萨', 54, 1, ''),
+(5421, '昌都', 54, 2, ''),
+(5422, '山南', 54, 3, ''),
+(5423, '日喀则', 54, 4, ''),
+(5424, '那曲', 54, 5, ''),
+(5425, '阿里', 54, 6, ''),
+(5426, '林芝', 54, 7, ''),
+(6101, '西安', 61, 1, ''),
+(6102, '铜川', 61, 2, ''),
+(6103, '宝鸡', 61, 3, ''),
+(6104, '咸阳', 61, 4, ''),
+(6105, '渭南', 61, 5, ''),
+(6106, '延安', 61, 6, ''),
+(6107, '汉中', 61, 7, ''),
+(6108, '榆林', 61, 8, ''),
+(6109, '安康', 61, 9, ''),
+(6110, '商洛', 61, 10, ''),
+(6201, '兰州', 62, 1, ''),
+(6202, '嘉峪关', 62, 2, ''),
+(6203, '金昌', 62, 3, ''),
+(6204, '白银', 62, 4, ''),
+(6205, '天水', 62, 5, ''),
+(6206, '武威', 62, 6, ''),
+(6207, '张掖', 62, 7, ''),
+(6208, '平凉', 62, 8, ''),
+(6209, '酒泉', 62, 9, ''),
+(6210, '庆阳', 62, 10, ''),
+(6211, '定西', 62, 11, ''),
+(6212, '陇南', 62, 12, ''),
+(6229, '临夏', 62, 13, ''),
+(6230, '甘南', 62, 14, ''),
+(6301, '西宁', 63, 1, ''),
+(6321, '海东', 63, 2, ''),
+(6322, '海北', 63, 3, ''),
+(6323, '黄南', 63, 4, ''),
+(6325, '海南', 63, 5, ''),
+(6326, '果洛', 63, 6, ''),
+(6327, '玉树', 63, 7, ''),
+(6328, '海西', 63, 8, ''),
+(6401, '银川', 64, 1, ''),
+(6402, '石嘴山', 64, 2, ''),
+(6403, '吴忠', 64, 3, ''),
+(6404, '固原', 64, 4, ''),
+(6405, '中卫', 64, 5, ''),
+(6501, '乌鲁木齐', 65, 1, ''),
+(6502, '克拉玛依', 65, 2, ''),
+(6521, '吐鲁番', 65, 3, ''),
+(6522, '哈密', 65, 4, ''),
+(6523, '昌吉', 65, 5, ''),
+(6527, '博尔塔拉', 65, 6, ''),
+(6528, '巴音郭楞', 65, 7, ''),
+(6529, '阿克苏', 65, 8, ''),
+(6530, '克孜勒苏', 65, 9, ''),
+(6531, '喀什', 65, 10, ''),
+(6532, '和田', 65, 11, ''),
+(6540, '伊犁', 65, 12, ''),
+(6542, '塔城', 65, 13, ''),
+(6543, '阿勒泰', 65, 14, ''),
+(6544, '石河子', 65, 15, ''),
+(6545, '阿拉尔', 65, 16, ''),
+(6546, '图木舒克', 65, 17, ''),
+(6547, '五家渠', 65, 18, ''),
+(7101, '台北市', 71, 1, ''),
+(7102, '高雄市', 71, 2, ''),
+(7103, '基隆市', 71, 3, ''),
+(7104, '台中市', 71, 4, ''),
+(7105, '台南市', 71, 5, ''),
+(7106, '新竹市', 71, 6, ''),
+(7107, '嘉义市', 71, 7, ''),
+(7108, '台北县', 71, 8, ''),
+(7109, '宜兰县', 71, 9, ''),
+(7110, '新竹县', 71, 10, ''),
+(7111, '桃园县', 71, 11, ''),
+(7112, '苗栗县', 71, 12, ''),
+(7113, '台中县', 71, 13, ''),
+(7114, '彰化县', 71, 14, ''),
+(7115, '南投县', 71, 15, ''),
+(7116, '嘉义县', 71, 16, ''),
+(7117, '云林县', 71, 17, ''),
+(7118, '台南县', 71, 18, ''),
+(7119, '高雄县', 71, 19, ''),
+(7120, '屏东县', 71, 20, ''),
+(7121, '台东县', 71, 21, ''),
+(7122, '花莲县', 71, 22, ''),
+(7123, '澎湖县', 71, 23, ''),
+(8101, '中西区', 81, 1, ''),
+(8102, '东区', 81, 2, ''),
+(8103, '九龙城区', 81, 3, ''),
+(8104, '观塘区', 81, 4, ''),
+(8105, '南区', 81, 5, ''),
+(8106, '深水区', 81, 6, ''),
+(8107, '湾仔区', 81, 7, ''),
+(8108, '黄大仙区', 81, 8, ''),
+(8109, '油尖旺区', 81, 9, ''),
+(8110, '离岛区', 81, 10, ''),
+(8111, '葵青区', 81, 11, ''),
+(8112, '北区', 81, 12, ''),
+(8113, '西贡区', 81, 13, ''),
+(8114, '沙田区', 81, 14, ''),
+(8115, '屯门区', 81, 15, ''),
+(8116, '大埔区', 81, 16, ''),
+(8117, '荃湾区', 81, 17, ''),
+(8118, '元朗区', 81, 18, ''),
+(8201, '花地玛堂区', 82, 1, ''),
+(8202, '圣安多尼堂区', 82, 2, ''),
+(8203, '大堂区', 82, 3, ''),
+(8204, '望德堂区', 82, 4, ''),
+(8205, '风顺堂区', 82, 5, ''),
+(8206, '嘉模堂区', 82, 6, ''),
+(8207, '圣方济各堂区', 82, 7, '');
+-- --------------------------------------------------------
+-- Table structure for table `im_blacklist`
+DROP TABLE IF EXISTS `im_blacklist`;
+CREATE TABLE IF NOT EXISTS `im_blacklist` (
`uid` int(11) unsigned DEFAULT '0',
`fid` int(11) unsigned DEFAULT '0',
KEY `uid` (`uid`,`fid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+-- Table structure for table `im_friend`
+DROP TABLE IF EXISTS `im_friend`;
+CREATE TABLE IF NOT EXISTS `im_friend` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`content` text NOT NULL,
`picture` varchar(1576) NOT NULL DEFAULT '',
`lng` varchar(10) NOT NULL DEFAULT '' COMMENT '经度',
`lat` varchar(10) NOT NULL DEFAULT '' COMMENT '纬度',
`address` varchar(50) NOT NULL DEFAULT '' COMMENT '地区名',
`visible` text NOT NULL COMMENT '可见范围 空-所有人可见 (userid1, userid2)-指定用户12可见',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
+) ENGINE=InnoDB
DEFAULT CHARSET=utf8 COMMENT='朋友圈' AUTO_INCREMENT=1 ;
+-- Table structure for table `im_friend_praise`
+DROP TABLE IF EXISTS `im_friend_praise`;
+CREATE TABLE IF NOT EXISTS `im_friend_praise` (
`uid` int(11) NOT NULL,
`fsid` bigint(11) NOT NULL COMMENT '分享记录id',
`createtime` int(11) NOT NULL,
KEY `uid` (`uid`),
KEY `fsid` (`fsid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='朋友圈赞表';
+-- Table structure for table `im_friend_reply`
+DROP TABLE IF EXISTS `im_friend_reply`;
+CREATE TABLE IF NOT EXISTS `im_friend_reply` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`fsid` bigint(11) NOT NULL COMMENT '分享记录id',
`uid` int(11) NOT NULL COMMENT '回复人',
`fid` int(11) NOT NULL COMMENT '收到回复人',
`content` varchar(100) NOT NULL DEFAULT '',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fsid` (`fsid`),
KEY `uid` (`uid`)
+) ENGINE=InnoDB
DEFAULT CHARSET=utf8 COMMENT='朋友圈评论，回复表' AUTO_INCREMENT=1 ;
+-- Table structure for table `im_friend_user`
+DROP TABLE IF EXISTS `im_friend_user`;
+CREATE TABLE IF NOT EXISTS `im_friend_user` (
`uid` int(11) NOT NULL,
`picture1` varchar(100) NOT NULL DEFAULT '',
`picture2` varchar(100) NOT NULL DEFAULT '',
`picture3` varchar(100) NOT NULL DEFAULT '',
`cover` varchar(100) NOT NULL DEFAULT '' COMMENT '相册封面',
`createtime` int(11) NOT NULL,
KEY `uid` (`uid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='记录用户发布朋友圈最新的三张';
+-- Table structure for table `im_meeting`
+DROP TABLE IF EXISTS `im_meeting`;
+CREATE TABLE IF NOT EXISTS `im_meeting` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`uid` bigint(20) NOT NULL COMMENT '创建者',
`name` varchar(100) NOT NULL COMMENT '会议的标题',
`logo` varchar(255) DEFAULT '0' COMMENT '会议的logo图片',
`content` text NOT NULL COMMENT '会议主题',
`start` bigint(20) NOT NULL COMMENT '开始时间',
`end` bigint(20) NOT NULL COMMENT '结束时间',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+-- Table structure for table `im_meeting_user`
+DROP TABLE IF EXISTS `im_meeting_user`;
+CREATE TABLE IF NOT EXISTS `im_meeting_user` (
`meetingid` bigint(20) NOT NULL,
`uid` bigint(20) NOT NULL,
`role` tinyint(1) NOT NULL DEFAULT '0',
`addtime` int(11) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-申请，1-已是成员',
`content` varchar(255) NOT NULL DEFAULT '' COMMENT '申请理由',
KEY `meetingid` (`meetingid`),
KEY `uid` (`uid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+-- 表的结构 `im_menu`
+DROP TABLE IF EXISTS `im_menu`;
+CREATE TABLE IF NOT EXISTS `im_menu` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` char(40) NOT NULL DEFAULT '',
`parentid` smallint(6) NOT NULL DEFAULT '0',
`module` varchar(40) NOT NULL,
`m` char(20) NOT NULL DEFAULT '',
`a` char(20) NOT NULL DEFAULT '',
`data` char(100) NOT NULL DEFAULT '',
`listorder` smallint(6) unsigned NOT NULL DEFAULT '0',
`display` enum('1','0') NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `listorder` (`listorder`),
KEY `parentid` (`parentid`),
KEY `module` (`m`,`a`)
+) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;
+-- 转存表中的数据 `im_menu`
+INSERT INTO `im_menu` (`id`, `name`, `parentid`, `module`, `m`, `a`, `data`, `listorder`, `display`) VALUES
+(1, '我的面板', 0, '', 'Index', 'index', '', 1, '1'),
+(2, '管理员', 0, '', 'Back', 'index', '', 2, '1'),
+(3, '系统', 0, '', 'System', 'index', '', 3, '1'),
+(4, '网站管理', 0, '', 'Website', 'index', '', 4, '1'),
+(5, '个人信息', 1, 'Admin', 'Admin', 'personal', '', 0, '1'),
+(8, '修改密码', 5, 'Admin', 'Admin', 'public_editPwd', '', 1, '1'),
+(9, '修改个人信息', 5, 'Admin', 'Admin', 'public_editInfo', '', 0, '1'),
+(7, '菜单管理', 3, 'Admin', 'Menu', 'index', '', 2, '1'),
+(12, '菜单列表', 7, 'Admin', 'Menu', 'index', '', 1, '1'),
+(6, '管理员管理', 2, 'Admin', 'Admin', 'index', '', 2, '1'),
+(10, '管理员列表', 6, 'Admin', 'Admin', 'index', '', 1, '1'),
+(11, '角色列表', 6, 'Admin', 'Admin', 'roleList', '', 2, '1'),
+(13, '模块管理', 3, 'Admin', 'Module', 'index', '', 1, '1'),
+(14, '模块列表', 13, 'Admin', 'Module', 'index', '', 0, '1'),
+(15, '用户管理', 4, 'User', 'User', 'index', '', 1, '1'),
+(16, '用户列表', 15, 'User', 'User', 'index', '', 0, '1'),
+(44, 'APP管理', 4, 'Version', 'Version', 'apk', '', 10, '1'),
+(45, 'APK管理列表', 44, 'Version', 'Version', 'apk', '', 0, '1'),
+(23, '群聊管理', 4, 'Session', 'Session', 'index', '', 2, '1'),
+(24, '群聊列表', 23, 'Session', 'Session', 'index', '', 0, '1'),
+(38, '朋友圈管理', 4, 'Friend', 'Friend', 'index', '', 3, '1'),
+(46, '添加', 45, 'Version', 'Version', 'add', '', 0, '1'),
+(47, '编辑', 45, 'Version', 'Version', 'edit', '', 0, '1'),
+(30, '网站设置', 3, 'Admin', 'Logs', 'index', '', 0, '1'),
+(31, 'Logs文件列表', 30, 'Admin', 'Logs', 'index', '', 3, '1'),
+(32, '网站模式', 30, 'Admin', 'Logs', 'debug', '', 0, '1'),
+(34, 'IOS推送设置', 30, 'Admin', 'Push', 'index', '', 1, '1'),
+(35, 'IOS推送证书', 30, 'Admin', 'Push', 'upload', '', 2, '1'),
+(39, '朋友圈列表', 38, 'Friend', 'Friend', 'index', '', 0, '1'),
+(40, '帮助中心', 15, 'User', 'User', 'help', '', 0, '1'),
+(41, '注册协议', 15, 'User', 'User', 'regist', '', 0, '1'),
+(42, '会议管理', 4, 'Meeting', 'Meeting', 'index', '', 4, '1'),
+(43, '会议列表', 42, 'Meeting', 'Meeting', 'index', '', 0, '1'),
+(48, '删除', 45, 'Version', 'Version', 'delete', '', 0, '1'),
+(49, 'IOS管理列表', 44, 'Version', 'Version', 'ios', '', 0, '1'),
+(50, '添加', 49, 'Version', 'Version', 'iosAdd', '', 0, '1'),
+(51, '编辑', 49, 'Version', 'Version', 'iosEdit', '', 0, '1'),
+(52, '删除', 49, 'Version', 'Version', 'delete', '', 0, '1');
+-- --------------------------------------------------------
+-- Table structure for table `im_message`
+DROP TABLE IF EXISTS `im_message`;
+CREATE TABLE IF NOT EXISTS `im_message` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fromid` int(11) NOT NULL DEFAULT '0',
`from` text NOT NULL,
`toid` int(11) NOT NULL DEFAULT '0',
`to` text NOT NULL,
`image` varchar(255) NOT NULL DEFAULT '',
`voice` varchar(255) NOT NULL DEFAULT '',
`location` varchar(255) NOT NULL DEFAULT '',
`content` varchar(1024) NOT NULL DEFAULT '',
`typechat` smallint(3) NOT NULL DEFAULT '100' COMMENT '100-单聊 200-群聊',
`typefile` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1-文字 2-图片 3-声音 4-位置',
`tag` varchar(50) NOT NULL DEFAULT '',
`time` varchar(15) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `from` (`fromid`),
KEY `to` (`toid`),
KEY `typechat` (`typechat`)
+) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+-- Table structure for table `im_module`
+DROP TABLE IF EXISTS `im_module`;
+CREATE TABLE IF NOT EXISTS `im_module` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(40) NOT NULL,
`displayname` varchar(40) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '模块状态 0-未运行 1-运行中',
`description` varchar(100) DEFAULT NULL,
`version` varchar(20) NOT NULL,
`author` varchar(20) DEFAULT NULL,
`price` double DEFAULT '0',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
+-- Dumping data for table `im_module`
+INSERT INTO `im_module` (`id`, `name`, `displayname`, `status`, `description`, `version`, `author`, `price`, `createtime`) VALUES
+(1, 'User', '用户模块', 1, '这是用户模块的描述信息', '1.0', 'wqdsoft', 10, 0),
+(2, 'Session', '群聊模块', 1, '群聊信息，用户可以创建群聊', '1.0', 'wqdsoft', 10, 0),
+(3, 'Friend', '朋友圈模块', 1, '这是朋友圈模块的描述信息', '1.0', 'wqdsoft', 10, 0),
+(4, 'Meeting', '会议模块', 1, '这是会议模块的描述信息', '1.0', 'wqdsoft', 10, 0);
+-- --------------------------------------------------------
+-- Table structure for table `im_notice`
+DROP TABLE IF EXISTS `im_notice`;
+CREATE TABLE IF NOT EXISTS `im_notice` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`type` smallint(6) NOT NULL,
`uid` varchar(255) NOT NULL DEFAULT '' COMMENT '通知人',
`toUid` int(11) NOT NULL,
`content` text NOT NULL,
`createtime` varchar(10) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+-- Table structure for table `im_session`
+DROP TABLE IF EXISTS `im_session`;
+CREATE TABLE IF NOT EXISTS `im_session` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`name` varchar(100) NOT NULL DEFAULT '',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
+) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+-- Table structure for table `im_session_user`
+DROP TABLE IF EXISTS `im_session_user`;
+CREATE TABLE IF NOT EXISTS `im_session_user` (
`sessionid` int(11) unsigned NOT NULL DEFAULT '0',
`uid` int(11) unsigned NOT NULL DEFAULT '0',
`role` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-成员 1-创建者',
`getmsg` tinyint(1) DEFAULT '1' COMMENT '0-不接收 1-接收',
`nickname` varchar(20) NOT NULL DEFAULT '' COMMENT '我的群昵称',
`addtime` int(11) NOT NULL DEFAULT '0',
KEY `sessionid` (`sessionid`,`uid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+-- Table structure for table `im_times`
+DROP TABLE IF EXISTS `im_times`;
+CREATE TABLE IF NOT EXISTS `im_times` (
`username` char(40) NOT NULL,
`ip` char(15) NOT NULL,
`logintime` int(10) unsigned NOT NULL DEFAULT '0',
`isadmin` tinyint(1) NOT NULL DEFAULT '0',
`times` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`username`,`isadmin`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+-- --------------------------------------------------------
+-- Table structure for table `im_user`
+DROP TABLE IF EXISTS `im_user`;
+CREATE TABLE IF NOT EXISTS `im_user` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`sort` varchar(5) NOT NULL DEFAULT '',
`phone` varchar(20) NOT NULL DEFAULT '',
`nickname` varchar(30) NOT NULL DEFAULT '',
`headsmall` varchar(100) NOT NULL DEFAULT '',
`sign` varchar(255) NOT NULL DEFAULT '',
`openfire` varchar(10) NOT NULL DEFAULT '',
`password` varchar(50) NOT NULL DEFAULT '',
`gender` tinyint(1) NOT NULL DEFAULT '2' COMMENT '0-男 1-女 2-未填写',
`province` varchar(20) NOT NULL DEFAULT '',
`city` varchar(20) NOT NULL DEFAULT '',
`verify` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0-不验证 1-验证',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`uid`)
+) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=200020 ;
+-- Table structure for table `im_user_code`
+DROP TABLE IF EXISTS `im_user_code`;
+CREATE TABLE IF NOT EXISTS `im_user_code` (
`phone` varchar(20) NOT NULL,
`code` varchar(10) NOT NULL,
KEY `phone` (`phone`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+-- Table structure for table `im_user_favorite`
+DROP TABLE IF EXISTS `im_user_favorite`;
+CREATE TABLE IF NOT EXISTS `im_user_favorite` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '收藏人',
`fid` int(11) NOT NULL COMMENT '被收藏人的id',
`otherid` varchar(128) NOT NULL DEFAULT '' COMMENT '其他id,比如群聊的id',
`content` text NOT NULL COMMENT '收藏内容',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
+) ENGINE=InnoDB
DEFAULT CHARSET=utf8 COMMENT='用户收藏表' AUTO_INCREMENT=1 ;
+-- Table structure for table `im_user_feedback`
+DROP TABLE IF EXISTS `im_user_feedback`;
+CREATE TABLE IF NOT EXISTS `im_user_feedback` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '反馈人',
`content` text NOT NULL COMMENT '反馈意见',
`isdeal` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-未处理 1-处理',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
+) ENGINE=InnoDB
DEFAULT CHARSET=utf8 COMMENT='反馈意见' AUTO_INCREMENT=1 ;
+-- Table structure for table `im_user_friend`
+DROP TABLE IF EXISTS `im_user_friend`;
+CREATE TABLE IF NOT EXISTS `im_user_friend` (
`uid` int(11) unsigned DEFAULT '0',
`fid` int(11) unsigned DEFAULT '0',
`isblack` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-好友 1-黑名单',
`remark` varchar(20) NOT NULL DEFAULT '',
`isstar` tinyint(1) NOT NULL DEFAULT '0',
`getmsg` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0-不接收 1-接收 是否接收消息',
`fauth1` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'u不看f 0-看 1-不看',
`fauth2` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'f不看u 0-看 1-不看',
`addtime` int(11) NOT NULL DEFAULT '0',
KEY `uid` (`uid`,`fid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+-- Table structure for table `im_user_push`
+DROP TABLE IF EXISTS `im_user_push`;
+CREATE TABLE IF NOT EXISTS `im_user_push` (
`uid` int(11) NOT NULL COMMENT '用户',
`udid` varchar(100) NOT NULL DEFAULT '' COMMENT '设备号',
`bnotice` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0-不接收 1-接收',
KEY `uid` (`uid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户ios消息推送表';
+-- Table structure for table `im_version`
+DROP TABLE IF EXISTS `im_version`;
+CREATE TABLE IF NOT EXISTS `im_version` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`version` varchar(16) NOT NULL,
`description` text NOT NULL,
`updatetype` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-正常（用户可以暂不升级）,1—警告升级（用户可以暂不升级），2—强制升级，用户不升级退出软件',
`url` varchar(255) NOT NULL DEFAULT '',
`createtime` int(11) NOT NULL DEFAULT '0',
`type` varchar(10) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+/*!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 */;
Index: index.html
===================================================================
Index: develop.pem
===================================================================
--- develop.pem (revision 0)
+++ develop.pem (revision 77)
@@ -0,0 +1,66 @@
+-----BEGIN CERTIFICATE-----
+MIIFiTCCBHGgAwIBAgIIf4kEW88x/ucwDQYJKoZIhvcNAQEFBQAwgZYxCzAJBgNV
+BAYTAlVTMRMwEQYDVQQKDApBcHBsZSBJbmMuMSwwKgYDVQQLDCNBcHBsZSBXb3Js
+ZHdpZGUgRGV2ZWxvcGVyIFJlbGF0aW9uczFEMEIGA1UEAww7QXBwbGUgV29ybGR3
+aWRlIERldmVsb3BlciBSZWxhdGlvbnMgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkw
+HhcNMTQxMTA0MDI0NTQwWhcNMTUxMTA0MDI0NTQwWjCBiDEiMCAGCgmSJomT8ixk
+AQEMEmNvbS5VQ2hhdC5SZVNlYXJjaDFAMD4GA1UEAww3QXBwbGUgRGV2ZWxvcG1l
+bnQgSU9TIFB1c2ggU2VydmljZXM6IGNvbS5VQ2hhdC5SZVNlYXJjaDETMBEGA1UE
+CwwKNUJKOUQ2Mk41NDELMAkGA1UEBhMCQ04wggEiMA0GCSqGSIb3DQEBAQUAA4IB
+DwAwggEKAoIBAQDLIQ5qiCovXQ5GmmIS9V8CLVak+H2JtHB5/PmnLpZyMR9X8BCG
+8o+95ZmPmnddOEMNWo0DHlQDpVxQvqeXGbzlv8G8Yz6UWfr2aLAW5X7PXIfzue0s
+DooRm6/sbpgEwlY6m03++yXiXU6wdvbhBIFpJuGZlMvR7oJD+YZ9CLrgNMjBcuE5
+Ls8m+D8x1yvAQiNqHpyBO0vyH7l/GWp1JxyeC6EpzWDc6N1QbfjjyVX/kmxYHYiS
+z5KT9UE4oCYZJAeIRJeMUm9Lqi0I8N1MoKz1eOKRLUzRgem7oM0nVX43J3oB/0+Q
+OXRnHcXgFUmhkeDVp70F5AKmOL0Z6OmaJ0h9AgMBAAGjggHlMIIB4TAdBgNVHQ4E
+FgQU5HGFSJ13+1RftLc9PiP5DpPd6+swCQYDVR0TBAIwADAfBgNVHSMEGDAWgBSI
+JxcJqbYYYIvs67r2R1nFUlSjtzCCAQ8GA1UdIASCAQYwggECMIH/BgkqhkiG92Nk
+BQEwgfEwgcMGCCsGAQUFBwICMIG2DIGzUmVsaWFuY2Ugb24gdGhpcyBjZXJ0aWZp
+Y2F0ZSBieSBhbnkgcGFydHkgYXNzdW1lcyBhY2NlcHRhbmNlIG9mIHRoZSB0aGVu
+IGFwcGxpY2FibGUgc3RhbmRhcmQgdGVybXMgYW5kIGNvbmRpdGlvbnMgb2YgdXNl
+LCBjZXJ0aWZpY2F0ZSBwb2xpY3kgYW5kIGNlcnRpZmljYXRpb24gcHJhY3RpY2Ug
+c3RhdGVtZW50cy4wKQYIKwYBBQUHAgEWHWh0dHA6Ly93d3cuYXBwbGUuY29tL2Fw
+cGxlY2EvME0GA1UdHwRGMEQwQqBAoD6GPGh0dHA6Ly9kZXZlbG9wZXIuYXBwbGUu
+Y29tL2NlcnRpZmljYXRpb25hdXRob3JpdHkvd3dkcmNhLmNybDALBgNVHQ8EBAMC
+B4AwEwYDVR0lBAwwCgYIKwYBBQUHAwIwEAYKKoZIhvdjZAYDAQQCBQAwDQYJKoZI
+hvcNAQEFBQADggEBAJrgnXRzBYYgaNb8JO6WwVwaGvkrP3I32kVOlpxS8f7GR+F5
+kFJZ34f2hp1sM8nrebsYWMZ9htwxeyqLj52oq368XySajOl4P8n6qX4C30be2TGN
+Jhy80mTzQhLKyy8a96fuWfxW1skmZgzv+YY6C3/7G7cbVkjIF5rCUdFO9dKQGhiL
+PGXtyOJuGsgMLav/1Snw+AdNEDbvJQBS/waNaRxR7VRJFKfjlO9muQ6iRoD1rzg2
+jmDKg6/5udv4ZMfs1Y1cOpQ9pwImDafuEVBBYOfrMD0A3rSzjvJZGvO9xXQl3gWc
+vpbdvhpoaNa2jzHT5TqXKgtEIMVr1wpdpnur/ww=
+-----END CERTIFICATE-----
+Bag Attributes
friendlyName: ReSearchPushDevelopment
localKeyID: E4 71 85 48 9D 77 FB 54 5F B4 B7 3D 3E 23 F9 0E 93 DD EB EB
+Key Attributes: &No Attributes&
+-----BEGIN RSA PRIVATE KEY-----
+Proc-Type: 4,ENCRYPTED
+DEK-Info: DES-EDE3-CBC,768B1D60B872F8D4
+LFuUHeGZxzamN7Dimbl8BfsMMwVIqWgo3MX/TkDhB1R1fnxyHQd1X2AGy5YZp4Rj
+9kf1F7RwrvFec1yFBCFTqgbVsSjQHxdm7xNwmd5ZCwTIuFrjDppLfFGqz1eQyEmq
+7ucPfGob9AFxNKPZR/pMvPAaOaelVCm2ON/VG7eQYN6oYT4VaCcKjmweIdBxMMbu
+ng9KnuUemPDduUcq5RYqUu6D/eK+sLZR9y9cLavee4xsOeHd5klK20oXbTqt/krH
+8vqmIVtwyshqJEMTKLJmBTvGfE9aW2Fva2uJUkKXiX5y9NnjNLR3DlA1p2PGGGG/
++BkJvaU/PAVyR4kZkk5Ke9PqN0MPwV1q+EOZkgcs6rVycwPdSUuVykUYUAn+ExDz
+B7B4n3GPrGkFRT92fs+EmRUTTk+6wKw5TdS8zw4VUpOizQQllq73/rMkRrZysTkY
+jRqbfLp5dJUVgvroMOCf0Fv1RmOHY3wLcVJVeUE+I9uXv8F1Yz4QCULwZNmckFSE
+U7ASQs/dw43IvrlCL86CmQos5afEHzWxmFpAe9CkcByuPkqlxMjhQJ/GobPr9sLe
+q7O4zZnQ6KLN3lJ+1Dik5rS+Ybv/zrtWUzAIUTYRY2TBenwj2v72Y3WelaNa8U3m
+0L3QTZv995VSYrVPpVjpQ5e6nar09vEnUgIeTXBUSNEla8p0OA0bToxpQ1PfXkc3
+txQp0F1mHBjlsh2kiaADN9vv1V16lxyVXRxztdMyaMG1O2m4N9pWhUcbgehkv9zM
+bVnAyGi1ehTWMZ23HsHb99bfU8vZvg01++j85o/wIUSXuFe0YquRP5B7Mg1GOVtE
+a4aL46+zFMBW2qM/e0wOTAf/gzDoMxhK1M2x1rue4Hr0/7nejjxJlVbMHuhMHT27
+EXib8VzpRA5DU3Lf5a6luSLqoNcOAocMhh7qTZDaub8Frh/ZbIIYbXtK1f43pGiU
+JQAzyBFGQEi7X9NnduatGeZjFQC305pF0GgHhP4ts5WTZwTJ6fvDJY6gA0OBfsvN
+mTzJSSn++i7lpEQOvhHPrGWNhzUwXcj0D2oPTIx12GXu2R+Xo9jhX7O2FJLmh0Wz
+dy/hyka3RD8DvxX2lufwxVurQ2s5xaVafFiLT6GS1sGIHmPe2QXTbTbHKMwNyOtT
+xVapzTfoVuM8Op/zv1n9wq+6//KOH0EhnPB+YSEuK3nlertwRwzWhgb6E/iHtzxc
+9T7DO85ofPzEBb/Rhc3WJd75o8USiJA6Q8mgfWKB3k1q8JoXgiehQYZCe0YJkGaU
+ZMU/VjsQsh1ShN5I3URlcDBMTLbiZavdBfrh8r3vjIQJKvr/rv9cMZ/ndXG/2DAW
+XPl4SG3dpMJ2QFA7n4DS4wfNn8SCVm2uYJs95ncj/xqn+vSbZbSh7sdzbkqjDSzo
+4LI59zbovUcdOOaaYleYUMJzI834GCIbSLEM4OTR3f+0Y2CgzJ5dTAWb2cECSChS
+62PBNY9aa01hlXijZVP8/TBFcmOhaU68H4hOTIBzWvteXfHv0HPfpYFhPSbi4luU
+vn0DR5jngGlBc67iWDOK7ZyKbzTOjJiFbJC4la8rYetvLRt8++5bFw==
+-----END RSA PRIVATE KEY-----
Index: release.pem
===================================================================
--- release.pem (revision 0)
+++ release.pem (revision 77)
@@ -0,0 +1,66 @@
+-----BEGIN CERTIFICATE-----
+MIIFiDCCBHCgAwIBAgIIMkbPkcvRMNgwDQYJKoZIhvcNAQEFBQAwgZYxCzAJBgNV
+BAYTAlVTMRMwEQYDVQQKDApBcHBsZSBJbmMuMSwwKgYDVQQLDCNBcHBsZSBXb3Js
+ZHdpZGUgRGV2ZWxvcGVyIFJlbGF0aW9uczFEMEIGA1UEAww7QXBwbGUgV29ybGR3
+aWRlIERldmVsb3BlciBSZWxhdGlvbnMgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkw
+HhcNMTQxMTA0MDYxODQwWhcNMTUxMTA0MDYxODQwWjCBhzEiMCAGCgmSJomT8ixk
+AQEMEmNvbS5VQ2hhdC5SZVNlYXJjaDE/MD0GA1UEAww2QXBwbGUgUHJvZHVjdGlv
+biBJT1MgUHVzaCBTZXJ2aWNlczogY29tLlVDaGF0LlJlU2VhcmNoMRMwEQYDVQQL
+DAo1Qko5RDYyTjU0MQswCQYDVQQGEwJDTjCCASIwDQYJKoZIhvcNAQEBBQADggEP
+ADCCAQoCggEBAMkV7zDvlsMgdNLAC7hosiMoTI7edrHoJNQ2G8cb0vWh9+QLUxNw
+UZ8pHcUEa0MvvSzwXBGGppVUK2ecBYCmkLXmnO+mu+cNlPghA5oQyQS/xStGoSIL
+RlET0vUaA5T1QoEu4UaJtDxHfK1WPEPTnlLEahyZ2bm111TrlzhC6jnyaQwqgT4i
+99XPzKGjtvxnDGAlKu4/BqbE4TrBPjbNjoKOc5PsUnIF/+j7Kh4O1ykt7le5T5Kc
+Prnnx4RgGW72eZSnfwbGTDFE01AaQhav1yV23PjC67FBpj4XDXm8FlaWnYLk+vBS
+LWf6imANddWNAKzvGXzRMo9hUa3VtzuRT4UCAwEAAaOCAeUwggHhMB0GA1UdDgQW
+BBRqPfKpWtE9UcippWwU9zbbrVbFPjAJBgNVHRMEAjAAMB8GA1UdIwQYMBaAFIgn
+Fwmpthhgi+zruvZHWcVSVKO3MIIBDwYDVR0gBIIBBjCCAQIwgf8GCSqGSIb3Y2QF
+ATCB8TCBwwYIKwYBBQUHAgIwgbYMgbNSZWxpYW5jZSBvbiB0aGlzIGNlcnRpZmlj
+YXRlIGJ5IGFueSBwYXJ0eSBhc3N1bWVzIGFjY2VwdGFuY2Ugb2YgdGhlIHRoZW4g
+YXBwbGljYWJsZSBzdGFuZGFyZCB0ZXJtcyBhbmQgY29uZGl0aW9ucyBvZiB1c2Us
+IGNlcnRpZmljYXRlIHBvbGljeSBhbmQgY2VydGlmaWNhdGlvbiBwcmFjdGljZSBz
+dGF0ZW1lbnRzLjApBggrBgEFBQcCARYdaHR0cDovL3d3dy5hcHBsZS5jb20vYXBw
+bGVjYS8wTQYDVR0fBEYwRDBCoECgPoY8aHR0cDovL2RldmVsb3Blci5hcHBsZS5j
+b20vY2VydGlmaWNhdGlvbmF1dGhvcml0eS93d2RyY2EuY3JsMAsGA1UdDwQEAwIH
+gDATBgNVHSUEDDAKBggrBgEFBQcDAjAQBgoqhkiG92NkBgMCBAIFADANBgkqhkiG
+9w0BAQUFAAOCAQEACpHP2zZvfdbgL/9bfkO+PtXnPdPrpNCvMDC00y3VTlNWIfiI
+H94SCCBnUta6MqP3PCEWGrADnjZwzKhdmX2c4q9Cm5HQlbNxQTHnxTI4e4ojmjyl
+KfY4gs8QuoZoiBDvU9IbFN7OvKeZhBBeLomQjlKUodHWP0at+EjHQrNrGBVM6EXm
+foinUaUSIztiaS6uwP01L5h/gK8eLIwMA3hzFAqxrNkQsy0h4YzQ65RbW1/CzLEJ
+KcYDkUv+32WnNvIw0ifBoJUzBs63w9XUlnookh1i8lGfWIeatwCp2ISHxGxz4qQN
+oPhcXJwGYxOF/5+7sdOPRuCiYiHCpyPrA0swrQ==
+-----END CERTIFICATE-----
+Bag Attributes
friendlyName: ReSearchPushProduction
localKeyID: 6A 3D F2 A9 5A D1 3D 51 C8 A9 A5 6C 14 F7 36 DB AD 56 C5 3E
+Key Attributes: &No Attributes&
+-----BEGIN RSA PRIVATE KEY-----
+Proc-Type: 4,ENCRYPTED
+DEK-Info: DES-EDE3-CBC,D75F2C
+1CROpKt2oC3KZokV7sNj/lkkAKYQeXYMloGwIoIHYfp8p2SYA3EUvciURBf1b5/g
+fGfKYbowZi7yffA/uvSN+qPHWS5xskHaGXEmxcDE3Kzs+lfA4NOcrQc7gZ58nF6x
+v4UMPVYgkjEFoxR4DgBlZkMI8PeZ5oJzRDNPULe9zt0KR0GzG5rZNZAD98/sByKV
+98NGI7/N2XttOU8aVzRpu9/BOr1ncwprmEBHCbQWEeheS+f0X/v7D0LtLmsIgqVG
+TB9DyVFXC9BapNwUWZcY0PV/avMpSM/S0GiqHYtd54p1Bj+3y0csl5RaCvSpo3Ga
+PenDEV/HDmo+b0iQYllu+zOCh5AWN/i1O686MoJ4h5rXt/8+7Xgoaj42rDQm07dW
+oLg8UeyEeRCRtR4kVoOpNlHTXHUDQIs710FlZsHLp9HdwBzMf5ffYgiAdFDEc+5z
+XPlJStyTmk/T9C6QMXAcd9GES4anfCOBlxOSaarIUzE3nG5i0xDYKmgMYLhUEf+Y
+JXbLkI4FN6vyJvn+DzIeCQmMsr9VvXFQ1/OeH3GUu/oxQGBYdxs9xOOUthzgDp4n
+qTgZbdu5FvlApzeQAzQthVqrQeRNRy7zJgGrZeTJDFYPMUvJ/cgkhX9LhHKck4Et
+6HQErxv5hhuVcNWVNgd0X0gI1ys5pJlAwGHjBZKCvD3dR0ovC73AJA2JRdYhYN6I
+boaZm7hDOwv6h6u3IIkjbZ/pZYQCSZNZbR6Rz+zO7k+KRo8cz+F6x8U2bTrE5TWE
+8A+HMiFHtKdjduBx39/WRLlHISTCCPWPqG3ow7/iFKoPO1g+XT12RzHBmAUsbaJQ
+GgLQLk/dw3dvKbKrefhqf0d4v6c7DY09QO/y0JSnHY/llp4R0UtbX7PyUZwup/SY
+7300ffnzTUD1o3kTgUqrq4enyOg+wxQAZnKH/sGxlYEmQnwqf0C0R+2sycv9Hp1Q
+/qc2bPNUuN0IasZOwtUVbjWHfYkBFrQGuOwpgGcPcZVxi23JXiMh1ZP0rP90rrZr
+sVYvtoXblBXH7wEhdJyK5B751CUE+Nj/QRZMT4w9K5z91pZpbjfVa+YV0as/xhLx
+YL/XbiV+KdtYes0LmClpukMt3RY7B7umwpKxlUg+uVZEDpcx3XyJXireCewgsrc/
+INxWsm1qZVdKi5ZjdKxhDeQcRYE99G9km3OMxLyFP5AD+q13gS3D3QZaP7h5sg6f
+cWEglboW287touwpPr4ueqNe3cxxHzXJcL4HdstiW4NtASQvHupHc/n9UD4Kxzt2
+5lcPQC+k1Jig0RESdHz9XzR1hJ8NHkIFo65fwYdI6Xq92uB9NrPZPMKRIbOtgqj0
+qAhaMCg2aQqYZiaEp/qZKydluO9Br4WlaXhjLuyZJTJTvgzSNJmoWXQiNPQcoA1r
+EBJK6sXJ1pCRariZJteI+KdP2p2c8HjMv11XQcbG5eiz8TdwVqQkj0x8r69BrGiS
+zSHUNjt/3wH5qTDd2mx+w+xIAX7Ektegg8ZjZVP7FldtQr8ZxFCyvGdZPxTf6C0i
+r+LcZq4T7JknDmt/kwhfcbTfCcVzOdekGGfSploIKmpDcUeAwEfnydZjUB2sigRr
+-----END RSA PRIVATE KEY-----
(C)&&2013&&Alibaba&&Inc.&&All&&rights&&resvered.
Powered by