﻿-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost
-- 生成日期: 2007 年 06 月 28 日 14:21
-- 服务器版本: 5.0.20
-- PHP 版本: 5.1.6
-- 
-- 数据库: `link`
-- 

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

-- 
-- 表的结构 `ad`
-- 

DROP TABLE IF EXISTS `ad`;
CREATE TABLE IF NOT EXISTS `ad` (
  `Id` int(11) NOT NULL auto_increment,
  `title` varchar(100) default NULL,
  `url` varchar(200) default NULL,
  `updatetime` datetime default NULL,
  `userid` varchar(50) default NULL,
  `webtype` int(11) default '0',
  `yesno` int(2) default '0',
  `zhuangtai` int(11) NOT NULL default '1',
  `admintime` datetime default NULL,
  `good` int(11) NOT NULL default '0',
  `click` int(11) default '0',
  PRIMARY KEY  (`Id`)
)TYPE=MyISAM;

-- 
-- 导出表中的数据 `ad`
-- 

INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (10,'gfhfg','http://hfghgfh.com','2007-06-20 12:04:12','a22586041',8,1,1,'2007-06-21 09:34:45',0,3);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (11,'百变晴晴模仿宋丹丹 不','http://s','2007-06-22 08:09:10','leaf',8,1,1,'2007-06-22 08:13:17',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (41,'免费小A短片...','http://www.163.com','2007-06-22 03:01:33','a22586041',8,1,1,'2007-06-22 03:03:45',0,4);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (42,'kisssssssss','http://www.kiss5.com','2007-06-25 01:53:11','a22586041',8,1,1,'2007-06-25 01:57:15',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (43,'djjjjjjjjjj','http://djjj','2007-06-25 01:53:22','a22586041',8,0,1,'2007-06-28 11:13:22',0,1);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (44,'aaaaaaaaaaa','http://aaaaaaaaaa','2007-06-25 01:53:55','a22586041',8,0,1,NULL,0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (45,'ddddddddddd','http://','2007-06-25 01:54:02','a22586041',8,1,1,'2007-06-28 11:13:18',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (46,'11111111111','http://','2007-06-25 01:54:17','a22586041',8,1,1,'2007-06-25 02:04:14',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (47,'88888888888','http://88888888888888888888','2007-06-25 01:54:27','a22586041',8,1,1,'2007-06-25 02:04:13',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (48,'99999999999','http://9999999999999999','2007-06-25 01:54:32','a22586041',8,1,1,'2007-06-25 02:04:12',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (49,'44444444444','http://','2007-06-25 01:54:37','a22586041',8,1,1,'2007-06-25 02:04:11',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (50,'66666666644','http://6666666644444444444444444444','2007-06-25 01:54:50','a22586041',8,1,1,'2007-06-25 02:06:33',1,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (51,'英雄世纪 01话','http://www.kiss5.com','2007-06-28 11:10:07','a22586041',8,1,1,'2007-06-28 11:12:59',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (52,'午夜凶铃','http://','2007-06-28 11:10:53','a22586041',8,1,1,'2007-06-28 11:12:59',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (53,'星球大战','http://','2007-06-28 11:11:10','a22586041',1,1,1,'2007-06-28 11:12:58',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (54,'侏罗纪公园','http://','2007-06-28 11:11:21','a22586041',4,1,1,'2007-06-28 11:14:08',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (55,'007全集','http://','2007-06-28 11:11:29','a22586041',5,1,1,'2007-06-28 11:14:08',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (56,'a终结者','http://','2007-06-28 11:11:38','a22586041',8,0,1,NULL,0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (57,'哈利波特','http://哈利波特','2007-06-28 11:11:54','a22586041',7,1,1,'2007-06-28 11:12:57',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (58,'黑客帝国','http:// 黑客帝国','2007-06-28 11:12:01','a22586041',3,1,1,'2007-06-28 11:12:56',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (59,'恋爱时代','http://','2007-06-28 11:12:10','a22586041',2,1,1,'2007-06-28 11:45:44',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (60,'恋爱时代1','http://','2007-06-28 11:12:29','a22586041',8,1,1,'2007-06-28 11:12:55',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (61,'恋爱时代2','http://','2007-06-28 11:13:13','a22586041',8,1,1,'2007-06-28 11:14:04',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (62,'完全娱乐','http://','2007-06-28 11:15:25','a22586041',8,1,1,'2007-06-28 11:18:52',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (63,'鲁豫有约','http://','2007-06-28 11:15:30','a22586041',8,1,1,'2007-06-28 11:18:48',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (64,'锵锵三人行','http://','2007-06-28 11:15:38','a22586041',1,1,1,'2007-06-28 11:18:48',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (65,'国光帮帮忙','http://','2007-06-28 11:16:18','a22586041',1,1,1,'2007-06-28 11:27:22',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (66,'我的美人计','http://','2007-06-28 11:16:23','a22586041',8,1,1,'2007-06-28 11:18:47',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (67,'开运鉴定团','http://','2007-06-28 11:16:33','a22586041',8,1,1,'2007-06-28 11:18:45',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (68,'天才冲冲冲','http://','2007-06-28 11:16:41','a22586041',8,1,1,'2007-06-28 11:29:37',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (69,'娱乐百分百','http://','2007-06-28 11:16:51','a22586041',8,1,1,'2007-06-28 11:18:43',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (70,'频道最多','http://','2007-06-28 11:22:36','a22586041',8,1,1,'2007-06-28 11:24:35',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (71,'频道最多1','http://','2007-06-28 11:22:47','a22586041',8,1,1,'2007-06-28 11:24:35',0,0);
INSERT INTO `ad` (`Id`,`title`,`url`,`updatetime`,`userid`,`webtype`,`yesno`,`zhuangtai`,`admintime`,`good`,`click`) VALUES (72,'频道最多2','http://','2007-06-28 11:23:03','a22586041',8,1,1,'2007-06-28 11:24:49',0,0);

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

-- 
-- 表的结构 `adminad`
-- 

DROP TABLE IF EXISTS `adminad`;
CREATE TABLE IF NOT EXISTS `adminad` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `TitleColor` varchar(10) default NULL,
  `url` varchar(255) NOT NULL,
  `vurl` varchar(255) NOT NULL default 'http://www.9123.com/jh/bbb/888.htm',
  `pic` varchar(255) NOT NULL,
  `updatetime` datetime NOT NULL,
  `webtype` int(11) NOT NULL,
  `adtype` varchar(20) NOT NULL default '0x0',
  `yesno` int(2) NOT NULL default '1',
  `click` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `adminad`
-- 

INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (1,'上传后的现实信息分身乏术地方','','dfgd','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_04_05_10.jpg','2007-06-14 08:47:41',1,'468x60',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (2,'标上传后的现实信息题','','http','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_04_04_57.jpg','2007-06-14 09:18:07',1,'468x60',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (3,'测试数据68','0a3f81','http://dfsfs.com68','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_03_17_00.jpg','2007-06-14 01:39:28',1,'760x60',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (4,'测试数据','','http://dfsfs.com','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_03_16_42.jpg','2007-06-14 01:39:34',1,'760x60',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (5,'测试数据12','','http://dfsfs.com12','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-14_04_42_31.jpg','2007-06-14 02:34:44',1,'760x60',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (6,'都是自己的都是自己的都是自己的都是自己的','0a3f81','dfgd','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-14_04_42_23.jpg','2007-06-14 02:35:11',1,'760x60',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (7,'5标题','','连接地址','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-14_04_42_14.jpg','2007-06-14 02:37:51',1,'760x60',1,1);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (8,'上传尔特人他后的现实信息','','et','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_04_04_41.jpg','2007-06-14 02:39:05',1,'468x60',1,1);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (9,'标题标题标题标题标题标题标题标题标题标题','','fgh','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_04_06_43.jpg','2007-06-14 02:40:01',1,'300x300',1,1);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (10,'标题：标题：标题：标题：标题：标题：','','标题：','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_04_06_43.jpg','2007-06-14 02:40:30',1,'300x300',1,1);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (11,'867','','786','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-17_10_48_17.jpg','2007-06-14 02:40:40',1,'300x300',1,1);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (12,'867','f44e28','786','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-17_10_48_17.jpg','2007-06-14 02:42:20',1,'300x300',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (13,'645','FF0000','67567','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-17_10_48_02.jpg','2007-06-14 02:43:25',1,'300x300',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (14,'上传后的现实信息上传后的现实信息','','tyut','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_04_04_18.jpg','2007-06-14 02:43:48',4,'468x60',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (18,'4真的是测试的数据了啊','505050','46','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-14_04_22_28.jpg','2007-06-14 02:49:48',1,'760x60',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (19,'3标题53标题53标题53标题53标题53','FF0000','http://424234234','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-14_04_18_35.jpg','2007-06-14 02:50:43',1,'760x60',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (20,'2标题标题标题标题标题标题','47a6d6','http://www.leaf8.com','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-14_04_08_06.jpg','2007-06-14 04:08:09',1,'760x60',1,1);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (21,'1不知道该填写什么了就这样吧','FF0000','http://leaf8.com/link/','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_03_06_49.jpg','2007-06-15 03:06:50',1,'760x60',1,3);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (23,'顶顶顶顶顶顶顶顶顶顶顶顶淡淡的','#FF0000','大法官','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_04_06_43.jpg','2007-06-15 04:06:44',1,'468x60',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (24,'特瑞特瑞特瑞特瑞特瑞他','#FF0000','645645645','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_04_08_45.jpg','2007-06-15 04:08:46',1,'468x60',1,2);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (25,'标题标题标题标题标题','#505050','tttt','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-17_11_03_56.jpg','2007-06-17 11:04:07',1,'300x300',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (26,'标题标题标题标题标题标题标题标题标题','#FF0000','r','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-17_01_10_28.jpg','2007-06-17 01:10:49',1,'300x300',1,0);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (27,'eteteteter让人人','','rrr','http://www.9123.com/jh/bbb/888.htm','upload/upload/2007-06-15_03_43_44.jpg','2007-06-21 07:42:31',8,'760x60',1,1);
INSERT INTO `adminad` (`id`,`title`,`TitleColor`,`url`,`vurl`,`pic`,`updatetime`,`webtype`,`adtype`,`yesno`,`click`) VALUES (29,'超级美女','#FF0000','http://www.guangdongec.com','http://www.guangdongec.com','upload/upload/2007-06-22_04_52_06.jpg','2007-06-22 04:53:05',1,'760x60',1,0);

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

-- 
-- 表的结构 `adminmsg`
-- 

DROP TABLE IF EXISTS `adminmsg`;
CREATE TABLE IF NOT EXISTS `adminmsg` (
  `Id` int(11) NOT NULL auto_increment,
  `userid` varchar(20) default NULL,
  `password` varchar(50) default NULL,
  `admintype` varchar(100) NOT NULL default '0',
  `click` int(11) default '0',
  PRIMARY KEY  (`Id`)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `adminmsg`
-- 

INSERT INTO `adminmsg` VALUES (1, 'admin', 'admin', '1', 0);
INSERT INTO `adminmsg` VALUES (2, 'leaf', 'leaf', '1', 0);
INSERT INTO `adminmsg` VALUES (3, 'ppy', 'ppy', '0', 0);

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

-- 
-- 表的结构 `jifen`
-- 

DROP TABLE IF EXISTS `jifen`;
CREATE TABLE IF NOT EXISTS `jifen` (
  `id` int(11) NOT NULL auto_increment,
  `updatetime` datetime NOT NULL,
  `jfnum` varchar(50) NOT NULL default '0',
  `rmb` varchar(50) NOT NULL default '0',
  `shenhe` int(11) NOT NULL default '0',
  `content` varchar(255) NOT NULL default 'no',
  `jiesuan` int(11) NOT NULL default '0',
  `userid` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
)TYPE=MyISAM;

-- 
-- 导出表中的数据 `jifen`
-- 

INSERT INTO `jifen` VALUES (1, '2007-06-20 11:51:05', '1', '0', 1, 'no', 1, 'leaf');
INSERT INTO `jifen` VALUES (2, '2007-06-21 12:04:43', '1', '0', 1, 'no', 1, 'leaf');
INSERT INTO `jifen` VALUES (3, '2007-06-22 02:31:13', '1000', '100', 1, 'no1212', 1, 'leaf');
INSERT INTO `jifen` VALUES (4, '2007-06-22 04:09:44', '10000', '1000', 0, 'no', 0, 'a22586041');

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

-- 
-- 表的结构 `msg`
-- 

DROP TABLE IF EXISTS `msg`;
CREATE TABLE IF NOT EXISTS `msg` (
  `Id` int(11) NOT NULL auto_increment,
  `title` varchar(110) default NULL,
  `content` text,
  `userid` varchar(110) default NULL,
  `updatetime` datetime default NULL,
  `backmsg` varchar(255) default NULL,
  `btime` datetime default NULL,
  PRIMARY KEY  (`Id`)
)TYPE=MyISAM;

-- 
-- 导出表中的数据 `msg`
-- 

INSERT INTO `msg` VALUES (1, '1', '1', 'leaf', '2007-06-11 12:42:21', NULL, NULL);
INSERT INTO `msg` VALUES (2, 'fg', 'dfg', 'leaf', '2007-06-11 12:44:08', NULL, NULL);
INSERT INTO `msg` VALUES (3, 'fdgdf', 'gdfgd', 'siwaa', '2007-06-18 06:42:27', NULL, NULL);

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

-- 
-- 表的结构 `notice`
-- 

DROP TABLE IF EXISTS `notice`;
CREATE TABLE IF NOT EXISTS `notice` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `titlefont` varchar(20) default 'CCC',
  `updatetime` datetime NOT NULL,
  `click` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `notice`
-- 

INSERT INTO `notice` (`id`,`title`,`content`,`titlefont`,`updatetime`,`click`) VALUES (1,'发生的方式发生的方式发生的','发生的方式发生的方式发生的方式发生的方式','CCC','2007-06-13 09:13:16',0);
INSERT INTO `notice` (`id`,`title`,`content`,`titlefont`,`updatetime`,`click`) VALUES (2,'公告标题公告标题公告标题公告标题1大范甘迪鳏寡孤独覆盖','公告内容公告内容公告内容公告内容公告内容','CCC','2007-06-13 09:15:12',0);
INSERT INTO `notice` (`id`,`title`,`content`,`titlefont`,`updatetime`,`click`) VALUES (3,'公告测试中','公告测试中','CCC','2007-06-13 02:42:50',0);
INSERT INTO `notice` (`id`,`title`,`content`,`titlefont`,`updatetime`,`click`) VALUES (4,'公告测试中斯蒂芬森地方','公告测试中飞','CCC','2007-06-13 02:43:03',0);
INSERT INTO `notice` (`id`,`title`,`content`,`titlefont`,`updatetime`,`click`) VALUES (5,'下次而特特瑞特瑞特瑞特','各分店个','CCC','2007-06-13 02:43:22',0);

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

-- 
-- 表的结构 `sys`
-- 

DROP TABLE IF EXISTS `sys`;
CREATE TABLE IF NOT EXISTS `sys` (
  `id` int(11) NOT NULL auto_increment,
  `webname` varchar(100) NOT NULL,
  `weburl` varchar(100) NOT NULL,
  `userreg` varchar(10) NOT NULL default '1',
  `email` varchar(100) default NULL,
  `qq` varchar(20) NOT NULL,
  `tel` varchar(20) NOT NULL,
  `fax` varchar(20) NOT NULL,
  `jifennum` varchar(100) NOT NULL default '1',
  PRIMARY KEY  (`id`)
)TYPE=MyISAM;

-- 
-- 导出表中的数据 `sys`
-- 

INSERT INTO `sys` (`id`,`webname`,`weburl`,`userreg`,`email`,`qq`,`tel`,`fax`,`jifennum`) VALUES (1,'网站链接交换系统','http://yq.itws.cn/','1','admin@admin.com','77575','123456789000','55345345345345345111','100');

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

-- 
-- 表的结构 `userip`
-- 

DROP TABLE IF EXISTS `userip`;
CREATE TABLE IF NOT EXISTS `userip` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(50) NOT NULL default '0.0.0.0',
  `adid` int(11) NOT NULL default '0',
  `userid` varchar(50) NOT NULL default '0',
  `updatetime` datetime NOT NULL,
  `daytime` datetime NOT NULL,
  `fromweburl` varchar(255) default NULL,
  `click` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)TYPE=MyISAM;

-- 
-- 导出表中的数据 `userip`
-- 

INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (5,'219.138.199.168',23,'siwaa','2007-06-18 06:48:42','2007-06-18 00:00:00',NULL,4);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (9,'219.138.199.168',8,'22586041','2007-06-18 10:06:15','2007-06-18 00:00:00',NULL,2);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (11,'60.0.97.194',26,'leaf','2007-06-18 11:42:50','2007-06-18 00:00:00',NULL,4);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (12,'60.0.188.167',20,'leaf','2007-06-19 02:46:45','2007-06-19 00:00:00',NULL,7);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (13,'60.0.152.156',22,'leaf','2007-06-20 08:32:35','2007-06-20 00:00:00',NULL,0);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (14,'219.138.199.168',21,'a22586041','2007-06-20 11:48:46','2007-06-20 00:00:00',NULL,1);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (15,'60.0.102.87',9,'siwaa','2007-06-20 08:18:11','2007-06-20 00:00:00',NULL,0);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (16,'219.138.199.168',21,'a22586041','2007-06-21 10:06:02','2007-06-21 00:00:00',NULL,11);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (17,'58.62.97.15',20,'aaaaa','2007-06-22 09:49:16','2007-06-22 00:00:00',NULL,3);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (18,'60.0.154.19',21,'leaf','2007-06-22 01:47:13','2007-06-22 00:00:00',NULL,0);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (19,'219.138.199.168',24,'a22586041','2007-06-22 04:09:17','2007-06-22 00:00:00',NULL,14);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (20,'219.138.199.168',24,'a22586041','2007-06-23 06:32:28','2007-06-23 00:00:00',NULL,18);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (21,'58.62.104.63',8,'a22586041','2007-06-23 02:55:40','2007-06-23 00:00:00',NULL,12);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (22,'60.0.103.69',27,'leaf','2007-06-23 10:18:19','2007-06-23 00:00:00',NULL,1);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (23,'219.138.199.168',7,'a22586041','2007-06-25 12:03:30','2007-06-25 00:00:00',NULL,1);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (24,'219.138.199.168',10,'a22586041','2007-06-27 01:33:18','2007-06-27 00:00:00',NULL,4);
INSERT INTO `userip` (`id`,`ip`,`adid`,`userid`,`updatetime`,`daytime`,`fromweburl`,`click`) VALUES (25,'219.138.199.168',11,'a22586041','2007-06-28 05:27:45','2007-06-28 00:00:00',NULL,8);

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

-- 
-- 表的结构 `userjfcount`
-- 

DROP TABLE IF EXISTS `userjfcount`;
CREATE TABLE IF NOT EXISTS `userjfcount` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(50) NOT NULL,
  `userclick` int(11) NOT NULL default '0',
  `webclick` int(11) NOT NULL default '0',
  `daytime` datetime NOT NULL,
  `content` text,
  PRIMARY KEY  (`id`)
)TYPE=MyISAM;

-- 
-- 导出表中的数据 `userjfcount`
-- 

INSERT INTO `userjfcount` VALUES (1, 'leaf', 1, 0, '2007-06-17 00:00:00', 'no');
INSERT INTO `userjfcount` VALUES (2, 'leaf', 1, 0, '2007-06-18 00:00:00', 'no');
INSERT INTO `userjfcount` VALUES (3, 'leaf', 1, 1, '2007-06-19 00:00:00', 'no');
INSERT INTO `userjfcount` VALUES (4, 'leaf', 1, 0, '2007-06-20 00:00:00', 'no');
INSERT INTO `userjfcount` VALUES (5, 'a22586041', 1, 1, '2007-06-20 00:00:00', 'no');
INSERT INTO `userjfcount` VALUES (6, 'a22586041', 1, 1, '2007-06-21 00:00:00', 'no');
INSERT INTO `userjfcount` VALUES (7, 'leaf', 0, 1, '2007-06-21 00:00:00', 'no');
INSERT INTO `userjfcount` VALUES (32, 'leaf', 0, 1000, '2007-06-23 00:00:00', 'admin');
INSERT INTO `userjfcount` VALUES (33, 'leaf', 1, 1, '2007-06-22 00:00:00', NULL);
INSERT INTO `userjfcount` VALUES (34, 'a22586041', 1, 1, '2007-06-22 00:00:00', NULL);
INSERT INTO `userjfcount` VALUES (35, 'a22586041', 2, 1, '2007-06-23 00:00:00', NULL);
INSERT INTO `userjfcount` VALUES (36, 'a22586041', 1, 0, '2007-06-25 00:00:00', NULL);

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

-- 
-- 表的结构 `usermsg`
-- 

DROP TABLE IF EXISTS `usermsg`;
CREATE TABLE IF NOT EXISTS `usermsg` (
  `Id` int(11) NOT NULL auto_increment,
  `userid` varchar(110) default NULL,
  `password` varchar(50) default NULL,
  `weburl` varchar(110) default NULL,
  `tel` varchar(30) default NULL,
  `username` varchar(20) default NULL,
  `qq` varchar(11) default NULL,
  `email` varchar(50) default NULL,
  `card` varchar(50) default NULL,
  `bankcardname` varchar(20) default NULL,
  `bankcardnumber` varchar(50) default NULL,
  `bankaddress` varchar(110) default NULL,
  `updatetime` datetime default NULL,
  `lasttime` datetime default NULL,
  `click` int(11) default '0',
  `webtype` int(11) default NULL,
  PRIMARY KEY  (`Id`)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `usermsg`
-- 

INSERT INTO `usermsg` VALUES (1, 'leaf', 'leaf', 'leaf2323', 'leaf', 'leaf32323', '12132311', '456456546', '345645654', '3', '3', 'ÉÏ°àÖÐ', '2007-06-08 03:28:29', '2007-06-08 03:28:29', 0, 6);
INSERT INTO `usermsg` VALUES (2, 'siwaa', 'link', 'www.163.com', 'jkhjk', 'jhkhjk', '2524', '22121@126.com', '12121', '12212', '121', '211111', '2007-06-18 06:38:04', '2007-06-18 06:38:04', 0, 1);
INSERT INTO `usermsg` VALUES (3, 'admin', 'link', 'sdfsdfsd', '3434', 'ttreter', '345345345', 'admin@admin.com', '', '', '', '', '2007-06-18 06:59:11', '2007-06-18 06:59:11', 0, 1);
INSERT INTO `usermsg` VALUES (4, '22586041', 'link', '2222', 'fghfgh', 'fhf', '22586041', '22288@126.com', '22586041', 'hfgh', 'hfg', 'fghfg', '2007-06-18 10:05:38', '2007-06-18 10:05:38', 0, 1);
INSERT INTO `usermsg` VALUES (5, 'a22586041', 'a22586041', 'a22586041', 'a22586041', 'a22586041', '22586041', 'a22586041@1216.com', 'a22586041', '', '', '', '2007-06-20 11:47:09', '2007-06-20 11:47:09', 0, 8);
INSERT INTO `usermsg` VALUES (6, 'ppy', 'ppy', 'ppy', 'hgfhgf', 'fghfgh', '454645', 'ppy@www.com', 'sfsd', 'ppy', '', '', '2007-06-20 11:55:09', '2007-06-20 11:55:09', 0, 8);
INSERT INTO `usermsg` VALUES (7, 'aaaaa', 'aaaaa', 'aaaaa', 'aaaaa', 'aaaaa', 'aaaaa', 'aaaaa', '', '', '', '', '2007-06-22 09:12:55', '2007-06-22 09:12:55', 0, 8);
INSERT INTO `usermsg` VALUES (8, 'bbbbb', 'bbbbb', 'www.68ws.cn', '02033616626', '123', '624885129', 'web@68ws.com', '', '', '', '', '2007-06-22 03:53:45', '2007-06-22 03:53:45', 0, 1);

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

-- 
-- 表的结构 `webip`
-- 

DROP TABLE IF EXISTS `webip`;
CREATE TABLE IF NOT EXISTS `webip` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(100) NOT NULL,
  `ip` varchar(50) NOT NULL,
  `daytime` datetime NOT NULL,
  `click` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)TYPE=MyISAM;

-- 
-- 导出表中的数据 `webip`
-- 

INSERT INTO `webip` VALUES (2, 'leaf', '219.138.199.168', '2007-06-19 00:00:00', 4);
INSERT INTO `webip` VALUES (3, 'siwaa', '60.0.103.252', '2007-06-20 00:00:00', 0);
INSERT INTO `webip` VALUES (4, 'a22586041', '60.0.103.252', '2007-06-20 00:00:00', 0);
INSERT INTO `webip` VALUES (5, 'leaf', '219.138.199.168', '2007-06-21 00:00:00', 0);
INSERT INTO `webip` VALUES (6, 'a22586041', '219.138.199.168', '2007-06-21 00:00:00', 0);
INSERT INTO `webip` VALUES (7, 'leaf', '219.138.199.168', '2007-06-22 00:00:00', 10);
INSERT INTO `webip` VALUES (8, 'a22586041', '219.138.199.168', '2007-06-22 00:00:00', 3);
INSERT INTO `webip` VALUES (9, 'leaf', '219.138.199.168', '2007-06-23 00:00:00', 2);
INSERT INTO `webip` VALUES (10, 'a22586041', '219.138.199.168', '2007-06-23 00:00:00', 1);
INSERT INTO `webip` VALUES (11, 'a22586041', '59.41.216.250', '2007-06-25 00:00:00', 0);
INSERT INTO `webip` VALUES (12, 'a22586041', '219.138.199.168', '2007-06-25 00:00:00', 2);
INSERT INTO `webip` VALUES (13, 'a22586041', '219.138.199.168', '2007-06-27 00:00:00', 2);
INSERT INTO `webip` VALUES (14, 'a22586041', '219.138.199.168', '2007-06-28 00:00:00', 5);

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

-- 
-- 表的结构 `webtype`
-- 

DROP TABLE IF EXISTS `webtype`;
CREATE TABLE IF NOT EXISTS `webtype` (
  `Id` int(11) NOT NULL auto_increment,
  `title` varchar(50) default NULL,
  `content` varchar(110) default NULL,
  `orderby` int(11) default '0',
  PRIMARY KEY  (`Id`)
)TYPE=MyISAM;

-- 
-- 导出表中的数据 `webtype`
-- 

INSERT INTO `webtype` (`Id`,`title`,`content`,`orderby`) VALUES (1,'美女',NULL,1);
INSERT INTO `webtype` (`Id`,`title`,`content`,`orderby`) VALUES (2,'社会',NULL,2);
INSERT INTO `webtype` (`Id`,`title`,`content`,`orderby`) VALUES (3,'猎奇',NULL,3);
INSERT INTO `webtype` (`Id`,`title`,`content`,`orderby`) VALUES (4,'八卦',NULL,4);
INSERT INTO `webtype` (`Id`,`title`,`content`,`orderby`) VALUES (5,'游戏',NULL,5);
INSERT INTO `webtype` (`Id`,`title`,`content`,`orderby`) VALUES (6,'下载',NULL,6);
INSERT INTO `webtype` (`Id`,`title`,`content`,`orderby`) VALUES (7,'音乐',NULL,7);
INSERT INTO `webtype` (`Id`,`title`,`content`,`orderby`) VALUES (8,'电影',NULL,0);