php网上订餐系统

#phpMyAdmin SQL Dump #version 3.2.1 #http://www.phpmyadmin.net -- #主机: localhost #生成日期: 2009 年 11 月 17 日 15:12 #服务器版本: 5.0.45 #PHP 版本: 5.2.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- #数据库: `dev_dingcan` -- #-------------------------------------------------------- -- #表的结构 `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` VALUES(39, 1, '广告标题', 'advs/pics/20091022/1256201258.jpg', 'http://', 1); INSERT INTO `dev_advs_lb` VALUES(40, 1, '广告标题', 'advs/pics/20091029/1256795979.jpg', 'http://', 3); INSERT INTO `dev_advs_lb` VALUES(41, 1, '广告标题', 'advs/pics/20091029/1256795752.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` 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=42 ; -- #转存表中的数据 `dev_advs_link` -- INSERT INTO `dev_advs_link` VALUES(21, 1, '39健康网', 'http://food.39.net/', 1, '', '', 0); INSERT INTO `dev_advs_link` VALUES(22, 1, '天天营养网', 'http://eat.51ttyy.com/', 2, '', '', 0); INSERT INTO `dev_advs_link` VALUES(33, 1, '中国餐饮网', 'http://www.canyin.com/', 3, '', '', 0); INSERT INTO `dev_advs_link` VALUES(34, 1, '餐饮世界网', 'http://www.canyinshijie.com/', 4, '', '', 0); INSERT INTO `dev_advs_link` VALUES(35, 1, '特色菜网', 'http://www.tesecai.cn/', 5, '', '', 0); INSERT INTO `dev_advs_link` VALUES(36, 1, '中国西餐网', 'http://www.westfood.com.cn/', 6, '', '', 0); INSERT INTO `dev_advs_link` VALUES(37, 1, '中华素食网', 'http://www.chinavegan.com/', 7, '', '', 0); INSERT INTO `dev_advs_link` VALUES(38, 1, '中国快餐联盟网', 'http://www.kclm.org/', 8, '', '', 0); INSERT INTO `dev_advs_link` VALUES(39, 1, '搜厨网', 'http://www.souchu.com/', 9, '', '', 0); INSERT INTO `dev_advs_link` VALUES(40, 1, '餐厅设计网', 'http://www.cantingsheji.com/', 10, '', '', 0); INSERT INTO `dev_advs_link` VALUES(41, 1, '美食中国', 'http://www.meishichina.com/', 11, '', '', 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` 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` VALUES(1, '站博士网上订餐系统', 'advs/pics/20091106/1257477260.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` 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` -- #-------------------------------------------------------- -- #表的结构 `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` 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=4 ; -- #转存表中的数据 `dev_advs_text` -- INSERT INTO `dev_advs_text` VALUES(1, '促销广告一', '本季特大优惠活动开始啦qq', '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=19 ; -- #转存表中的数据 `dev_base_admin` -- INSERT INTO `dev_base_admin` VALUES(3, 'admin', '21232f297a57a5a743894a0e4a801fc3', '系统管理员', '系统管理员', 'A001', 0); INSERT INTO `dev_base_admin` VALUES(15, 'cantingjingli', '10a37591fe433c727009cd1e99f00