广告联盟数据库www.keyrun.com.sql

VIP信息处理系统源码

  `adser_user` varchar(20) NOT NULL default '0',
  `ads_id` int(11) NOT NULL default '0',
  `own_type` int(1) NOT NULL default '0',
  `ads_type` int(1) NOT NULL default '1',
  `date` date NOT NULL default '0000-00-00',
  `coltime` int(11) NOT NULL default '0',
  `open_num` int(11) NOT NULL default '0',
  `click_num` int(11) NOT NULL default '0',
  `pv_num` int(11) NOT NULL default '0',
  `price` double(10,2) NOT NULL default '0.00',
  `profit` double(5,3) NOT NULL default '0.000',
  `rate` double(10,5) NOT NULL default '0.00000',
  `web_money` double(10,2) NOT NULL default '0.00',
  `adser_money` double(10,2) NOT NULL default '0.00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# 导出表中的数据 `daydata`
#


# --------------------------------------------------------

#
# 表的结构 `droit`
#

CREATE TABLE `droit` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `is_admin` int(1) NOT NULL default '0',
  `m1` int(1) NOT NULL default '0',
  `m2` int(1) NOT NULL default '0',
  `m3` int(1) NOT NULL default '0',
  `m4` int(1) NOT NULL default '0',
  `m5` int(1) NOT NULL default '0',
  `m6` int(1) NOT NULL default '0',
  `m8` int(1) NOT NULL default '0',
  `m9` int(1) NOT NULL default '0',
  `m10` int(1) NOT NULL default '0',
  `m11` int(1) NOT NULL default '0',
  `m12` int(1) NOT NULL default '0',
  `m13` int(1) NOT NULL default '0',
  `m14` int(1) NOT NULL default '0',
  `m15` int(1) NOT NULL default '0',
  `m16` int(1) NOT NULL default '0',
  `m17` int(1) NOT NULL default '0',
  `m18` int(1) NOT NULL default '0',
  `m19` int(1) NOT NULL default '0',
  `m20` int(1) NOT NULL default '0',
  `m21` int(1) NOT NULL default '0',
  `m22` int(1) NOT NULL default '0',
  `m23` int(1) NOT NULL default '0',
  `m24` int(1) NOT NULL default '0',
  `m25` int(1) NOT NULL default '0',
  `m26` int(1) NOT NULL default '0',
  `m27` int(1) NOT NULL default '0',
  `m28` int(1) NOT NULL default '0',
  `m29` int(1) NOT NULL default '0',
  `m30` int(1) NOT NULL default '0',
  `m31` int(1) NOT NULL default '0',
  `m32` int(1) NOT NULL default '0',
  `m33` int(1) NOT NULL default '0',
  `m34` int(1) NOT NULL default '0',
  `m35` int(1) NOT NULL default '0',
  `m36` int(1) NOT NULL default '0',
  `m37` int(1) NOT NULL default '0',
  `m38` int(1) NOT NULL default '0',
  `m39` int(1) NOT NULL default '0',
  `m40` int(1) NOT NULL default '0',
  `m41` int(1) NOT NULL default '0',
  `m42` int(1) NOT NULL default '0',
  `m43` int(1) NOT NULL default '0',
  `m44` int(1) NOT NULL default '0',
  `m45` int(1) NOT NULL default '0',
  `m46` int(1) NOT NULL default '0',
  `m47` int(1) NOT NULL default '0',
  `m48` int(1) NOT NULL default '0',
  `m49` int(1) NOT NULL default '0',
  `m50` int(1) NOT NULL default '0',
  `m51` int(1) NOT NULL default '0',
  `m52` int(1) NOT NULL default '0',
  `m53` int(1) NOT NULL default '0',
  `m54` int(1) NOT NULL default '0',
  `m55` int(1) NOT NULL default '0',
  `m56` int(1) NOT NULL default '0',
  `m57` int(1) NOT NULL default '0',
  `m59` int(1) NOT NULL default '0',
  `m60` int(1) NOT NULL default '0',
  `m61` int(1) NOT NULL default '0',
  `m62` int(1) NOT NULL default '0',
  `m63` int(1) NOT NULL default '0',
  `m64` int(1) NOT NULL default '0',
  `m65` int(1) NOT NULL default '0',
  `m66` int(1) NOT NULL default '0',
  `m67` int(1) NOT NULL default '0',
  `m68` int(1) NOT NULL default '0',
  `m69` int(1) NOT NULL default '0',
  `m70` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM;

#
# 导出表中的数据 `droit`
#

INSERT INTO `droit` VALUES (2, 'admin', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

# --------------------------------------------------------

#
# 表的结构 `menu`
#

CREATE TABLE `menu` (
  `id` int(11) NOT NULL auto_increment,
  `s_id` int(11) NOT NULL default '0',
  `item` varchar(50) NOT NULL default '',
  `sort` int(11) NOT NULL default '0',
  `url` varchar(50) NOT NULL default '',
  `type` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# 导出表中的数据 `menu`
#

INSERT INTO `menu` VALUES (1, 0, '网站主管理<br>Webmaster', 10, 'admin.php?tm=1', 1);
INSERT INTO `menu` VALUES (53, 3, '历史数据图示', 30, 'data_historypic', 1);
INSERT INTO `menu` VALUES (2, 0, '广告主管理<br>Advertizer', 20, 'admin.php?tm=2', 1);
INSERT INTO `menu` VALUES (3, 0, '数据统计<br>Data Stat.', 30, 'admin.php?tm=3', 1);
INSERT INTO `menu` VALUES (4, 0, '留言公告<br>Message', 40, 'admin.php?tm=4', 1);
INSERT INTO `menu` VALUES (5, 0, '用户管理<br>User', 50, 'admin.php?tm=5', 1);
INSERT INTO `menu` VALUES (6, 0, '功能菜单管理<br>MenuManager', 60, 'admin.php?tm=6', 1);
INSERT INTO `menu` VALUES (8, 1, '新会员审核', 10, 'web_admin&op=new', 1);
INSERT INTO `menu` VALUES (9, 1, '修改待审核', 20, 'web_admin&op=modify', 1);
INSERT INTO `menu` VALUES (10, 1, '正常会员列表', 30, 'web_admin&op=normal', 1);
INSERT INTO `menu` VALUES (11, 1, '全部会员列表', 40, 'web_admin&op=all', 1);
INSERT INTO `menu` VALUES (12, 1, '-', 50, '#', 1);
INSERT INTO `menu` VALUES (13, 1, '佣金支付记录', 60, 'webpay_admin', 1);
INSERT INTO `menu` VALUES (14, 2, '新会员审核', 10, 'adser_admin&op=new', 1);
INSERT INTO `menu` VALUES (15, 2, '修改待审会员', 20, 'adser_admin&op=modify', 1);
INSERT INTO `menu` VALUES (16, 2, '正常会员列表', 30, 'adser_admin&op=normal', 1);
INSERT INTO `menu` VALUES (17, 2, '全部会员列表', 40, 'adser_admin&op=all', 1);
INSERT INTO `menu` VALUES (18, 2, '-', 50, '#', 1);
INSERT INTO `menu` VALUES (19, 2, '帐户充值确认', 60, 'balance_admin', 1);
INSERT INTO `menu` VALUES (20, 2, '订单明细', 70, 'bankorder_admin', 1);
INSERT INTO `menu` VALUES (21, 2, '余额结算', 80, 'apply_admin', 1);
INSERT INTO `menu` VALUES (22, 2, '-', 90, '#', 1);
INSERT INTO `menu` VALUES (23, 2, '新广告审核', 100, 'ads_admin&op=new', 1);
INSERT INTO `menu` VALUES (24, 2, '修改待审广告', 110, 'ads_admin_modify', 1);
INSERT INTO `menu` VALUES (25, 2, '正常广告列表', 120, 'ads_admin&op=normal', 1);
INSERT INTO `menu` VALUES (26, 2, '暂停广告列表', 130, 'ads_admin&op=over', 1);
INSERT INTO `menu` VALUES (27, 2, '全部广告列表', 140, 'ads_admin&op=all', 1);
INSERT INTO `menu` VALUES (28, 2, '-', 150, '#', 1);
INSERT INTO `menu` VALUES (29, 2, '公益广告列表', 160, 'ads_admin&op=comm', 1);
INSERT INTO `menu` VALUES (30, 2, '添加公益广告', 170, 'ads_comm_add', 1);
INSERT INTO `menu` VALUES (31, 2, '-', 180, '#', 1);
INSERT INTO `menu` VALUES (32, 2, '广告规格列表', 190, 'ads_form', 1);
INSERT INTO `menu` VALUES (33, 2, '添加广告规格', 200, 'ads_form_add', 1);
INSERT INTO `menu` VALUES (34, 3, '本日数据统计', 10, 'data_stat', 1);
INSERT INTO `menu` VALUES (35, 3, '历史数据统计', 20, 'data_history', 1);
INSERT INTO `menu` VALUES (36, 4, '网站主公告', 10, 'affiche_admin&op=web', 1);
INSERT INTO `menu` VALUES (37, 4, '发布网站主公告', 20, 'affiche_add&op=web', 1);
INSERT INTO `menu` VALUES (38, 4, '-', 30, '#', 1);
INSERT INTO `menu` VALUES (39, 4, '广告主公告', 40, 'affiche_admin&op=adser', 1);
INSERT INTO `menu` VALUES (40, 4, '发布广告主公告', 50, 'affiche_add&op=adser', 1);
INSERT INTO `menu` VALUES (41, 4, '-', 60, '#', 1);
INSERT INTO `menu` VALUES (42, 4, '查看网站主留言', 70, 'message_admin&op=web', 1);
INSERT INTO `menu` VALUES (43, 4, '添加网站主留言', 80, 'message_add&op=web', 1);
INSERT INTO `menu` VALUES (44, 4, '-', 90, '#', 1);
INSERT INTO `menu` VALUES (45, 4, '查看广告主留言', 100, 'message_admin&op=adser', 1);
INSERT INTO `menu` VALUES (46, 4, '添加广告主留言', 110, 'message_add&op=adser', 1);
INSERT INTO `menu` VALUES (47, 5, '用户列表', 10, 'user_admin', 1);
INSERT INTO `menu` VALUES (48, 5, '添加用户', 20, 'user_add', 1);
INSERT INTO `menu` VALUES (49, 5, '修改密码', 30, 'passwd', 1);
INSERT INTO `menu` VALUES (50, 6, '功能菜单管理', 10, 'menu_manage', 1);
INSERT INTO `menu` VALUES (51, 6, '添加顶级菜单', 20, 'menu_add', 1);
INSERT INTO `menu` VALUES (52, 5, '用户授权', 25, 'user_droit', 1);
INSERT INTO `menu` VALUES (54, 4, '网站主公告内容', 15, 'affiche_view&op=web', 0);
INSERT INTO `menu` VALUES (55, 4, '广告主公告内容', 45, 'affiche_view&op=adser', 0);
INSERT INTO `menu` VALUES (56, 4, '网站主留言内容', 75, 'message_view&op=web', 0);
INSERT INTO `menu` VALUES (57, 4, '广告主留言内容', 105, 'message_view&op=adser', 0);
INSERT INTO `menu` VALUES (59, 3, '异常数据管理', 40, 'charge_admin', 1);
INSERT INTO `menu` VALUES (60, 3, '-', 35, '#', 1);
INSERT INTO `menu` VALUES (61, 3, '查看投放网站', 32, 'view_web', 1);
INSERT INTO `menu` VALUES (62, 2, '撤消广告列表', 135, 'ads_admin&op=quash', 1);
INSERT INTO `menu` VALUES (63, 5, '修改资料', 24, 'user_modify', 1);
INSERT INTO `menu` VALUES (64, 5, '-', 40, '#', 1);
INSERT INTO `menu` VALUES (65, 5, '本月佣金查询', 50, 'rakeoff_month', 1);
INSERT INTO `menu` VALUES (66, 5, '佣金支付记录', 60, 'rakeoff_history', 1);
INSERT INTO `menu` VALUES (67, 5, '-', 70, '#', 1);
INSERT INTO `menu` VALUES (68, 5, '推荐人佣金支付', 80, 'rakeoff_admin', 1);
INSERT INTO `menu` VALUES (69, 5, '推荐人佣金结算', 75, 'rakeoff_coll', 1);
INSERT INTO `menu` VALUES (70, 1, '佣金支付详细', 70, 'webpay', 0);

# --------------------------------------------------------

#
# 表的结构 `message`
#

CREATE TABLE `message` (
  `id` int(11) NOT NULL auto_increment,
  `s_id` int(11) NOT NULL default '0',
  `tit` varchar(100) NOT NULL default '',
  `conn` text NOT NULL,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `userid` int(11) NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  `s_name` varchar(20) NOT NULL default '',
  `to_type` int(1) NOT NULL default '0',
  `mes_type` int(1) NOT NULL default '0',
  `is_view` int(11) NOT NULL default '0',
  `admin_time` int(11) NOT NULL default '0',
  `admin_user` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# 导出表中的数据 `message`
#


# --------------------------------------------------------

#
# 表的结构 `openip`
#

CREATE TABLE `openip` (
  `id` int(11) NOT NULL auto_increment,
  `adsid` int(11) NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  `adsuser` varchar(20) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# 导出表中的数据 `openip`
#


# --------------------------------------------------------

#
# 表的结构 `payed`
#

CREATE TABLE `payed` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '0',
  `pay_type` int(1) NOT NULL default '1',
  `ought_money` double(10,2) NOT NULL default '0.00',
  `down_money` double(13,3) NOT NULL default '0.000',
  `real_money` double(10,2) NOT NULL default '0.00',
  `pay_date` date NOT NULL default '0000-00-00',
  `admin_stat` int(1) NOT NULL default '0',
  `periods` int(11) NOT NULL default '0',
  `admin_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `admin_user` varchar(20) NOT NULL default '',
  `scale` double(4,2) NOT NULL default '0.00',
  `remark` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# 导出表中的数据 `payed`
#


# --------------------------------------------------------

#
# 表的结构 `webmember`
#

CREATE TABLE `webmember` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `up_user` varchar(20) NOT NULL default '',
  `s_name` varchar(20) NOT NULL default '',
  `url` varchar(200) NOT NULL default '',
  `s_type` int(1) NOT NULL default '0',
  `pwd` varchar(20) NOT NULL default '',
  `retime` datetime NOT NULL default '0000-00-00 00:00:00',
  `email` varchar(50) NOT NULL default '',
  `email_2` varchar(50) NOT NULL default '',
  `qq` varchar(20) NOT NULL default '',
  `tel` varchar(50) NOT NULL default '',
  `zip` varchar(10) NOT NULL default '',
  `addr` varchar(80) NOT NULL default '',
  `bank` varchar(50) NOT NULL default '',
  `bankcode` varchar(30) NOT NULL default '',
  `bankname` varchar(12) NOT NULL default '',
  `realname` varchar(12) NOT NULL default '',
  `linkmanno` varchar(20) NOT NULL default '',
  `admin_stat` int(1) NOT NULL default '0',
  `admin_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `admin_user` varchar(20) NOT NULL default '',
  `is_lock` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM;

#
# 导出表中的数据 `webmember`
#