-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2012 年 01 月 06 日 05:28
-- 服务器版本: 5.0.90
-- PHP 版本: 5.2.14
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 */;
--
-- 数据库: `qqdb`
--
-- --------------------------------------------------------
--
-- 表的结构 `qaddreq`
--
CREATE TABLE IF NOT EXISTS `qaddreq` (
`id` int(11) NOT NULL auto_increment,
`uid` double NOT NULL,
`adduid` double NOT NULL,
`reqresult` int(11) NOT NULL default '0',
`reqtext` varchar(50) NOT NULL default ' ',
`reqdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=41 ;
--
-- 转存表中的数据 `qaddreq`
--
-- --------------------------------------------------------
--
-- 表的结构 `qfriend`
--
CREATE TABLE IF NOT EXISTS `qfriend` (
`id` int(11) NOT NULL auto_increment,
`Uid` double NOT NULL,
`FUid` double NOT NULL,
`Gid` double NOT NULL,
`Name2` varchar(50) NOT NULL default ' ',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=51 ;
--
-- 转存表中的数据 `qfriend`
--
INSERT INTO `qfriend` (`id`, `Uid`, `FUid`, `Gid`, `Name2`) VALUES
(1, 10000, 10001, 1, '测试者'),
(2, 10001, 10000, 4, '管理员'),
(20, 10000, 10005, 1, ''),
(21, 10000, 10006, 1, ''),
(22, 10006, 10000, 13, ''),
(23, 10005, 10000, 10, ''),
(24, 10007, 10000, 16, ''),
(25, 10000, 10007, 1, ''),
(26, 10016, 10000, 43, ''),
(27, 10011, 10000, 28, ''),
(28, 10012, 10000, 32, ' '),
(29, 10014, 10000, 37, 'h'),
(30, 10015, 10000, 41, ' '),
(31, 10000, 10015, 1, ''),
(32, 10000, 10014, 1, ''),
(33, 10000, 10012, 1, ''),
(34, 10000, 10011, 1, ''),
(35, 10000, 10016, 1, ''),
(36, 10008, 10000, 19, ''),
(37, 10000, 10008, 1, ''),
(38, 10009, 10000, 23, ' '),
(39, 10000, 10009, 1, ''),
(43, 10000, 10004, 1, ''),
(42, 10004, 10000, 7, ''),
(44, 10013, 10000, 34, ''),
(45, 10000, 10017, 1, ''),
(46, 10017, 10000, 46, ''),
(47, 10018, 10000, 49, ''),
(48, 10000, 10018, 1, ''),
(49, 10019, 10000, 53, ' '),
(50, 10000, 10019, 1, '');
-- --------------------------------------------------------
--
-- 表的结构 `qgroup`
--
CREATE TABLE IF NOT EXISTS `qgroup` (
`GId` int(11) NOT NULL auto_increment,
`Uid` double NOT NULL,
`GroupName` varchar(50) NOT NULL default ' ',
`GroupSort` int(11) NOT NULL default '0',
`FriendCount` int(11) NOT NULL default '0',
PRIMARY KEY (`GId`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=94 ;
--
-- 转存表中的数据 `qgroup`
--
INSERT INTO `qgroup` (`GId`, `Uid`, `GroupName`, `GroupSort`, `FriendCount`) VALUES
(1, 10000, '我的好友', 0, 1),
(2, 10000, '陌生人', 1, 0),
(3, 10000, '黑名单', 2, 0),
(4, 10001, '我的好友', 0, 1),
(5, 10001, '陌生人', 1, 0),
(6, 10001, '黑名单', 2, 0),
(7, 10004, '我的好友', 0, 0),
(8, 10004, '陌生人', 1, 0),
(9, 10004, '黑名单', 2, 0),
(10, 10005, '我的好友', 0, 0),
(11, 10005, '陌生人', 1, 0),
(12, 10005, '黑名单', 2, 0),
(13, 10006, '我的好友', 0, 0),
(14, 10006, '陌生人', 1, 0),
(15, 10006, '黑名单', 2, 0),
(16, 10007, '我的好友', 0, 0),
(17, 10007, '陌生人', 1, 0),
(18, 10007, '黑名单', 2, 0),
(19, 10008, '我的好友', 0, 0),
(20, 10008, '陌生人', 1, 0),
(21, 10008, '黑名单', 2, 0),
(22, 10009, '我的好友', 0, 0),
(23, 10009, '陌生人', 1, 0),
(24, 10009, '黑名单', 2, 0),
(25, 10010, '我的好友', 0, 0),
(26, 10010, '陌生人', 1, 0),
(27, 10010, '黑名单', 2, 0),
(28, 10011, '我的好友', 0, 0),
(29, 10011, '陌生人', 1, 0),
(30, 10011, '黑名单', 2, 0),
(31, 10012, '我的好友', 0, 0),
(32, 10012, '陌生人', 1, 0),
(33, 10012, '黑名单', 2, 0),
(34, 10013, '我的好友', 0, 0),
(35, 10013, '陌生人', 1, 0),
(36, 10013, '黑名单', 2, 0),
(37, 10014, '我的好友', 0, 0),
(38, 10014, '陌生人', 1, 0),
(39, 10014, '黑名单', 2, 0),
(40, 10015, '我的好友', 0, 0),
(41, 10015, '陌生人', 1, 0),
(42, 10015, '黑名单', 2, 0),
(43, 10016, '我的好友', 0, 0),
(44, 10016, '陌生人', 1, 0),
(45, 10016, '黑名单', 2, 0),
(46, 10017, '我的好友', 0, 0),
(47, 10017, '陌生人', 1, 0),
(48, 10017, '黑名单', 2, 0),
(49, 10018, '我的好友', 0, 0),
(50, 10018, '陌生人', 1, 0),
(51, 10018, '黑名单', 2, 0),
(52, 10019, '我的好友', 0, 0),
(53, 10019, '陌生人', 1, 0),
(54, 10019, '黑名单', 2, 0),
(55, 10020, '我的好友', 0, 0),
(56, 10020, '陌生人', 1, 0),
(57, 10020, '黑名单', 2, 0),
(58, 10021, '我的好友', 0, 0),
(59, 10021, '陌生人', 1, 0),
(60, 10021, '黑名单', 2, 0),
(61, 10022, '我的好友', 0, 0),
(62, 10022, '陌生人', 1, 0),
(63, 10022, '黑名单', 2, 0),
(64, 10023, '我的好友', 0, 0),
(65, 10023, '陌生人', 1, 0),
(66, 10023, '黑名单', 2, 0),
(67, 10024, '我的好友', 0, 0),
(68, 10024, '陌生人', 1, 0),
(69, 10024, '黑名单', 2, 0),
(70, 10025, '我的好友', 0, 0),
(71, 10025, '陌生人', 1, 0),
(72, 10025, '黑名单', 2, 0),
(73, 10026, '我的好友', 0, 0),
(74, 10026, '陌生人', 1, 0),
(75, 10026, '黑名单', 2, 0),
(76, 10027, '我的好友', 0, 0),
(77, 10027, '陌生人', 1, 0),
(78, 10027, '黑名单', 2, 0),
(79, 10028, '我的好友', 0, 0),
(80, 10028, '陌生人', 1, 0),
(81, 10028, '黑名单', 2, 0),
(82, 10029, '我的好友', 0, 0),
(83, 10029, '陌生人', 1, 0),
(84, 10029, '黑名单', 2, 0),
(85, 10030, '我的好友', 0, 0),
(86, 10030, '陌生人', 1, 0),
(87, 10030, '黑名单', 2, 0),
(88, 10031, '我的好友', 0, 0),
(89, 10031, '陌生人', 1, 0),
(90, 10031, '黑名单', 2, 0),
(91, 10032, '我的好友', 0, 0),
(92, 10032, '陌生人', 1, 0),
(93, 10032, '黑名单', 2, 0);
-- --------------------------------------------------------
--
-- 表的结构 `qmsgs`
--
CREATE TABLE IF NOT EXISTS `qmsgs` (
`id` double NOT NULL auto_increment,
`Uid` double NOT NULL,
`FUid` double NOT NULL,
`Message` varbinary(2000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;
--
-- 转存表中的数据 `qmsgs`
--
-- --------------------------------------------------------
--
-- 表的结构 `qstates`
--
CREATE TABLE IF NOT EXISTS `qstates` (
`Uid` double NOT NULL,
`OnlineStates` int(11) NOT NULL,
`OnlineDate` datetime NOT NULL,
`IPS` varchar(50) NOT NULL default ' ',
`UKey` varchar(200) NOT NULL,
`LastTime` datetime NOT NULL,
`InIPS` varchar(50) NOT NULL default ' ',
PRIMARY KEY (`Uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
--
-- 转存表中的数据 `qstates`
--
INSERT INTO `qstates` (`Uid`, `OnlineStates`, `OnlineDate`, `IPS`, `UKey`, `LastTime`, `InIPS`) VALUES
(10000, 6, '2012-01-06 13:22:22', '10.0.0.18:5700', '7ce65c5dc010635e19b13a480d641855', '2012-01-06 13:23:22', '10.0.0.18:5700'),
(10001, 0, '2011-10-19 13:46:32', '10.0.0.111:20390', 'ebdd5248c521cf876be4e88d4a793983', '2011-10-19 13:46:32', '10.0.0.111:20390'),
(10009, 0, '2011-08-21 17:10:09', '192.168.0.101:43942', '38fd42dc58375451ccc6da1d899ed84b', '2011-08-21 17:13:09', '192.168.0.101:43942'),
(10004, 0, '2011-08-21 23:41:58', '192.168.0.101:24087', 'ac86443eb5fbcfa3784d5db985aa4816', '2011-08-21 23:43:58', '192.168.0.101:24087'),
(10002, 0, '2011-08-21 23:41:46', '192.168.0.101:52012', 'c8f93dd1cc89253ac22ac38b7b6c2930', '2011-08-21 23:41:46', '192.168.0.101:52012'),
(10003, 0, '2011-08-21 16:31:43', '192.168.0.101:15908', 'e2e0bf3da210b6ab148f0c4ea4a8cfa9', '2011-08-21 16:31:43', '192.168.0.101:15908'),
(10017, 0, '2011-08-21 23:52:10', '192.168.0.101:6472', '5170dee9c866a9b5594709113b5a5e3a', '2011-08-22 00:02:10', '192.168.0.101:6472'),
(10005, 0, '2011-08-24 03:06:02', '192.168.0.101:3034', '3ea856bafdf6d7926a2912162837be1a', '2011-08-24 03:07:03
完全模仿QQ2011源代码
5星 · 超过95%的资源 需积分: 9 47 浏览量
2012-01-06
16:08:53
上传
评论 26
收藏 21MB RAR 举报 
QQ2011.rar （1个子文件） 
qqdb.sql 15KB
cnwd2004
- 粉丝: 2
- 资源: 13
最新资源
- C#，煎饼排序问题（Pancake Sorting Problem）算法与源代码
- C#，排列组合的堆生成法（Heap’s Algorithm for generating permutations）算法与源代码
- C#，老鼠迷宫问题的回溯法求解（Rat in a Maze）算法与源代码
- 6693eeb8d683458a07938615fba9e68f.apk
- C#，数值计算，解微分方程的龙格-库塔二阶方法与源代码
- C#，数值计算，用割线法（Secant Method）求方程根的算法与源代码
- C#，子集和问题（Subset Sum Problem）的算法与源代码
- mongodb 数据库基本操作
- Linux操作系统基础教程
- Linux操作系统相关习题集
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
- 1
- 2
- 3
- 4
- 5
- 6
前往页