php商业版酒店源码

# phpMyAdmin SQL Dump # version 3.3.2 # http://www.phpmyadmin.net # # 主机: localhost # 生成日期: 2010 年 05 月 05 日 04:53 # 服务器版本: 5.0.45 # PHP 版本: 5.2.9-2 # # 数据库: `dev_4110` # # ############################ # # 表的结构 `dev_advs_duilian` # CREATE TABLE IF NOT EXISTS `dev_advs_duilian` ( `id` int(4) NOT NULL auto_increment, `groupname` char(200) NOT NULL, `src` char(100) NOT NULL default '', `src2` char(100) NOT NULL default '', `url` char(200) NOT NULL default '', `url2` varchar(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; # # 转存表中的数据 `dev_advs_duilian` # # ############################ # # 表的结构 `dev_advs_lb` # CREATE TABLE IF NOT EXISTS `dev_advs_lb` ( `id` int(20) NOT NULL auto_increment, `groupid` int(5) NOT NULL default '1', `title` char(100) NOT NULL default '', `src` char(100) NOT NULL default '', `url` char(100) NOT NULL default '', `xuhao` int(5) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=45 ; # # 转存表中的数据 `dev_advs_lb` # INSERT INTO `dev_advs_lb` (`id`, `groupid`, `title`, `src`, `url`, `xuhao`) VALUES (39, 1, '广告标题', 'advs/pics/20100428/1272441233.jpg', 'http://', 1), (40, 1, '广告标题', 'advs/pics/20100428/1272441239.jpg', 'http://', 3), (41, 1, '广告标题', 'advs/pics/20100428/1272441236.jpg', 'http://', 2); # ############################ # # 表的结构 `dev_advs_lbgroup` # CREATE TABLE IF NOT EXISTS `dev_advs_lbgroup` ( `id` int(3) NOT NULL auto_increment, `groupname` varchar(50) NOT NULL default '', `xuhao` int(5) NOT NULL default '0', `moveable` int(1) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; # # 转存表中的数据 `dev_advs_lbgroup` # INSERT INTO `dev_advs_lbgroup` (`id`, `groupname`, `xuhao`, `moveable`) VALUES (1, '默认轮播广告组', 1, 0); # ############################ # # 表的结构 `dev_advs_link` # CREATE TABLE IF NOT EXISTS `dev_advs_link` ( `id` int(12) NOT NULL auto_increment, `groupid` int(5) NOT NULL default '0', `name` varchar(200) NOT NULL default '', `url` varchar(200) NOT NULL default '', `xuhao` int(5) NOT NULL default '0', `type` varchar(20) NOT NULL default '', `src` varchar(100) NOT NULL default '', `cl` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=61 ; # # 转存表中的数据 `dev_advs_link` # INSERT INTO `dev_advs_link` (`id`, `groupid`, `name`, `url`, `xuhao`, `type`, `src`, `cl`) VALUES (56, 1, '2', 'http://www.baidu.com', 0, '', 'advs/pics/20100105/1262680791.gif', 0), (57, 1, '2', 'http://www.baidu.com', 0, '', 'advs/pics/20100105/1262680800.gif', 0), (58, 1, '2', 'http://www.baidu.com', 0, '', 'advs/pics/20100105/1262680854.gif', 0), (59, 1, '2', 'http://www.baidu.com', 0, '', 'advs/pics/20100106/1262763267.gif', 0), (60, 1, '2', 'http://www.baidu.com', 0, '', 'advs/pics/20100106/1262763295.gif', 0); # ############################ # # 表的结构 `dev_advs_linkgroup` # CREATE TABLE IF NOT EXISTS `dev_advs_linkgroup` ( `id` int(3) NOT NULL auto_increment, `groupname` varchar(50) NOT NULL default '', `xuhao` int(5) NOT NULL default '0', `moveable` int(1) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; # # 转存表中的数据 `dev_advs_linkgroup` # INSERT INTO `dev_advs_linkgroup` (`id`, `groupname`, `xuhao`, `moveable`) VALUES (1, '默认友情链接组', 1, 0); # ############################ # # 表的结构 `dev_advs_logo` # CREATE TABLE IF NOT EXISTS `dev_advs_logo` ( `id` int(4) NOT NULL auto_increment, `groupname` char(200) NOT NULL, `src` char(100) NOT NULL default '', `url` char(200) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; # # 转存表中的数据 `dev_advs_logo` # INSERT INTO `dev_advs_logo` (`id`, `groupname`, `src`, `url`) VALUES (1, '网站标志一', 'advs/pics/20100108/1262918757.gif', '#'); # ############################ # # 表的结构 `dev_advs_movi` # CREATE TABLE IF NOT EXISTS `dev_advs_movi` ( `id` int(4) NOT NULL auto_increment, `groupname` char(200) NOT NULL, `src` char(100) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; # # 转存表中的数据 `dev_advs_movi` # INSERT INTO `dev_advs_movi` (`id`, `groupname`, `src`) VALUES (1, '视频广告测试一', 'http://vhead.blog.sina.com.cn/player/outer_player.swf?auto=1&vid=16205152&uid=1504617052'); # ############################ # # 表的结构 `dev_advs_pic` # CREATE TABLE IF NOT EXISTS `dev_advs_pic` ( `id` int(4) NOT NULL auto_increment, `groupname` char(200) NOT NULL, `src` char(100) NOT NULL default '', `url` char(200) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=2 ; # # 转存表中的数据 `dev_advs_pic` # INSERT INTO `dev_advs_pic` (`id`, `groupname`, `src`, `url`) VALUES (1, '测试图片广告', 'advs/pics/20091126/1259213779.gif', 'http://www.try.com'); # ############################ # # 表的结构 `dev_advs_pop` # CREATE TABLE IF NOT EXISTS `dev_advs_pop` ( `id` int(12) NOT NULL auto_increment, `title` varchar(255) NOT NULL, `body` text, `ifpop` int(1) NOT NULL default '0', `popwidth` int(10) default NULL, `popheight` int(10) default NULL, `popleft` int(10) default NULL, `poptop` int(10) default NULL, `poptoolbar` int(1) default NULL, `popmenubar` int(1) default NULL, `popstatus` int(1) default NULL, `poplocation` int(1) default NULL, `popscrollbars` varchar(50) default NULL, `popresizable` int(1) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; # # 转存表中的数据 `dev_advs_pop` # INSERT INTO `dev_advs_pop` (`id`, `title`, `body`, `ifpop`, `popwidth`, `popheight`, `popleft`, `poptop`, `poptoolbar`, `popmenubar`, `popstatus`, `poplocation`, `popscrollbars`, `popresizable`) VALUES (1, '弹出窗口', '窗口内容 ', 0, 400, 300, 0, 0, 0, 0, 0, 0, 'auto', 0); # ############################ # # 表的结构 `dev_advs_text` # CREATE TABLE IF NOT EXISTS `dev_advs_text` ( `id` int(4) NOT NULL auto_increment, `groupname` char(200) NOT NULL, `text` char(200) NOT NULL default '', `url` char(200) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; # # 转存表中的数据 `dev_advs_text` # INSERT INTO `dev_advs_text` (`id`, `groupname`, `text`, `url`) VALUES (1, '促销广告一', '公司最新公告公司最新公告公司最新公告公司最新公告', 'http://www.com'); # ############################ # # 表的结构 `dev_base_admin` # CREATE TABLE IF NOT EXISTS `dev_base_admin` ( `id` int(6) NOT NULL auto_increment, `user` varchar(30) NOT NULL default '', `password` varchar(50) NOT NULL default '', `name` varchar(50) NOT NULL default '', `job` varchar(50) NOT NULL, `jobid` varchar(20) NOT NULL, `moveable` int(1) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ; # # 转存表中的数据 `dev_base_admin` # INSERT INTO `dev_base_admin` (`id`, `user`, `password`, `name`, `job`, `jobid`, `moveable`) VALUES (3, 'admin', '21232f297a57a5a743894a0e4a801fc3', '管理员', '管理员', 'A001', 0); # ############################ # # 表的结构 `dev_base_adminauth` # CREATE TABLE IF NOT EXISTS `dev_base_adminauth` ( `id` int(6) NOT NULL auto_increment, `coltype` varchar(30) NOT NULL, `auth` int(5) NOT NULL default '0', `name` char(50) NOT NULL default '', `intro` char(255) NOT NULL default '', `xuhao` int(10) NOT NULL default '0', `pid` int(10) NOT NULL default '0', `pname` char(20) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARS