www.pudn.com > dsj.zip > SnackSystem.sql
DROP TABLE IF EXISTS `Administrator`;
DROP TABLE IF EXISTS `Flavor` ;
DROP TABLE IF EXISTS `GuestBook`;
DROP TABLE IF EXISTS `Link` ;
DROP TABLE IF EXISTS `Log` ;
DROP TABLE IF EXISTS `Manufacturer` ;
DROP TABLE IF EXISTS `Material` ;
DROP TABLE IF EXISTS `News` ;
DROP TABLE IF EXISTS `Order` ;
DROP TABLE IF EXISTS `OrderDetail` ;
DROP TABLE IF EXISTS `Product` ;
DROP TABLE IF EXISTS `ProductCatalog` ;
DROP TABLE IF EXISTS `ProductComment` ;
DROP TABLE IF EXISTS `ShoppingCart` ;
DROP TABLE IF EXISTS `SystemConfig` ;
DROP TABLE IF EXISTS `User` ;
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2007 年 07 月 29 日 19:31
-- 服务器版本: 4.1.21
-- PHP 版本: 4.4.4
--
-- 数据库: `SnackSystem`
--
set NAMES 'utf8';
SET character_set_client='utf8' ;
SET character_set_connection='utf8' ;
SET character_set_results='utf8';
SET COLLATION_CONNECTION='utf8_bin';
SET character_set_results='utf8';
-- --------------------------------------------------------
--
-- 表的结构 `Administrator`
--
CREATE TABLE `Administrator` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL ,
`Password` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
PRIMARY KEY (`ID`)
) ;
--
-- 导出表中的数据 `Administrator`
--
INSERT INTO `Administrator` (`ID`, `Name`, `Password`) VALUES
(1, 'admin', 'admin');
-- --------------------------------------------------------
--
-- 表的结构 `Flavor`
--
CREATE TABLE `Flavor` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
PRIMARY KEY (`ID`)
);
--
-- 导出表中的数据 `Flavor`
--
INSERT INTO `Flavor` (`ID`, `Name`) VALUES
(1, '鲁菜'),
(2, '淮扬菜'),
(3, '闽菜'),
(4, '浙菜'),
(5, '湘菜'),
(6, '粤菜'),
(7, '川菜'),
(8, '赣菜'),
(9, '徽菜'),
(10, '京菜'),
(11, '津菜'),
(12, '冀菜'),
(13, '其它'),
(14, '潮汕风味');
-- --------------------------------------------------------
--
-- 表的结构 `GuestBook`
--
CREATE TABLE `GuestBook` (
`ID` int(10) unsigned NOT NULL auto_increment,
`User_ID` int(11) default NULL,
`DateTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`REMOTE_ADDR` varchar(100) default NULL,
`Body` text CHARACTER SET utf8 COLLATE utf8_bin,
`Reply` text CHARACTER SET utf8 COLLATE utf8_bin,
PRIMARY KEY (`ID`)
) ;
--
-- 导出表中的数据 `GuestBook`
--
INSERT INTO `GuestBook` (`ID`, `User_ID`, `DateTime`, `REMOTE_ADDR`, `Body`, `Reply`) VALUES
(1, 1, '2006-04-11 12:00:00', '61.195.2.142', '恭喜新系统上线！', '恭喜新系统上线！'),
(2, 1, '2007-04-18 12:00:00', '61.195.2.142', '多谢支持！', '多谢支持！'),
(3, 1, '2007-05-18 12:00:00', '61.195.2.142', '多谢支持！', '多谢支持！');
-- --------------------------------------------------------
--
-- 表的结构 `Link`
--
CREATE TABLE `Link` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`LINK_HREF` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`HINT` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
PRIMARY KEY (`ID`)
) ;
--
-- 导出表中的数据 `Link`
--
INSERT INTO `Link` (`ID`, `Name`, `LINK_HREF`, `HINT`) VALUES
(1, '点石金订餐系统', 'http://www.dianshijin.cn/', '点石金订餐系统'),
(2, '点石金智能电子', 'http://shop34480016.taobao.com/', '点石金智能电子'),
(3, 'google搜索', 'http://www.google.com/', 'google搜索');
-- --------------------------------------------------------
--
-- 表的结构 `Log`
--
CREATE TABLE `Log` (
`ID` int(10) unsigned NOT NULL auto_increment,
`User_Name` text CHARACTER SET utf8 COLLATE utf8_bin,
`Administrator_Name` text CHARACTER SET utf8 COLLATE utf8_bin,
`DateTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`REMOTE_ADDR` varchar(100) default NULL,
`Action` text CHARACTER SET utf8 COLLATE utf8_bin,
PRIMARY KEY (`ID`)
);
--
-- 导出表中的数据 `Log`
--
INSERT INTO `Log` (`ID`, `User_Name`, `Administrator_Name`, `DateTime`, `REMOTE_ADDR`, `Action`) VALUES
(1, '', 'admin', '2007-07-28 22:21:38', '127.0.0.1', '浏览菜式管理页面'),
(2, '', 'admin', '2007-07-28 22:21:42', '127.0.0.1', '浏览菜式管理页面'),
(3, '', 'admin', '2007-07-28 23:06:10', '127.0.0.1', '浏览菜式管理页面'),
(4, '', 'admin', '2007-07-28 23:06:12', '127.0.0.1', '浏览菜式分类页面'),
(5, '', 'admin', '2007-07-28 23:06:13', '127.0.0.1', '浏览菜式风味页面'),
(6, '', 'admin', '2007-07-28 23:06:16', '127.0.0.1', '浏览生产厂商页面'),
(7, '', 'admin', '2007-07-28 23:06:17', '127.0.0.1', '浏览菜式管理页面'),
(8, '', 'admin', '2007-07-28 23:06:18', '127.0.0.1', '浏览菜式管理页面'),
(9, '', 'admin', '2007-07-28 23:06:19', '127.0.0.1', '浏览会员管理页面'),
(10, '', 'admin', '2007-07-28 23:06:22', '127.0.0.1', '浏览修改管理密码页面'),
(11, '', 'admin', '2007-07-28 23:06:23', '127.0.0.1', '浏览菜式管理页面'),
(12, '', 'admin', '2007-07-28 23:06:32', '127.0.0.1', '浏览菜式管理页面'),
(13, '', 'admin', '2007-07-28 23:06:34', '127.0.0.1', '浏览菜式管理页面'),
(14, '', 'admin', '2007-07-29 16:31:03', '127.0.0.1', '浏览菜式管理页面'),
(15, '', 'admin', '2007-07-29 16:31:18', '127.0.0.1', '浏览菜式管理页面'),
(16, '', 'admin', '2007-07-29 16:31:43', '127.0.0.1', '浏览菜式管理页面'),
(17, '', 'admin', '2007-07-29 16:31:46', '127.0.0.1', '浏览菜式管理页面'),
(18, 'xiaona', '', '2007-07-29 16:33:57', '127.0.0.1', '浏览首页页面'),
(19, 'xiaona', '', '2007-07-29 16:33:59', '127.0.0.1', '浏览首页页面'),
(20, 'xiaona', '', '2007-07-29 16:34:09', '127.0.0.1', '浏览首页页面'),
(21, 'xiaona', '', '2007-07-29 16:34:42', '127.0.0.1', '浏览首页页面'),
(22, 'xiaona', '', '2007-07-29 16:36:02', '127.0.0.1', '浏览首页页面'),
(23, 'xiaona', '', '2007-07-29 16:36:07', '127.0.0.1', '浏览首页页面'),
(24, 'xiaona', '', '2007-07-29 16:36:52', '127.0.0.1', '浏览首页页面'),
(25, '', 'admin', '2007-07-29 16:37:17', '127.0.0.1', '浏览菜式管理页面'),
(26, 'xiaona', '', '2007-07-29 16:38:46', '127.0.0.1', '浏览首页页面'),
(27, 'xiaona', '', '2007-07-29 16:38:48', '127.0.0.1', '浏览首页页面'),
(28, '', 'admin', '2007-07-29 16:41:16', '127.0.0.1', '浏览菜式管理页面'),
(29, '', 'admin', '2007-07-29 16:41:19', '127.0.0.1', '浏览会员管理页面'),
(30, '', 'admin', '2007-07-29 16:41:20', '127.0.0.1', '浏览新闻发布页面'),
(31, 'xiaona', '', '2007-07-29 16:41:28', '127.0.0.1', '浏览首页页面'),
(32, '', 'admin', '2007-07-29 16:53:15', '127.0.0.1', '浏览新闻发布页面'),
(33, '', 'admin', '2007-07-29 16:53:42', '127.0.0.1', '浏览菜式管理页面'),
(34, '', 'admin', '2007-07-29 16:53:43', '127.0.0.1', '浏览菜式管理页面'),
(35, '', 'admin', '2007-07-29 16:53:49', '127.0.0.1', '浏览菜式管理页面'),
(36, '', 'admin', '2007-07-29 16:53:51', '127.0.0.1', '浏览菜式管理页面'),
(37, '', 'admin', '2007-07-29 16:54:27', '127.0.0.1', '浏览菜式管理页面'),
(38, '', 'admin', '2007-07-29 16:54:27', '127.0.0.1', '菜式更新, ID为(10) '),
(39, '', 'admin', '2007-07-29 16:54:29', '127.0.0.1', '浏览菜式管理页面'),
(40, '', 'admin', '2007-07-29 16:54:41', '127.0.0.1', '浏览菜式管理页面'),
(41, '', 'admin', '2007-07-29 16:54:41', '127.0.0.1', '浏览菜式管理页面'),
(42, '', 'admin', '2007-07-29 16:54:52', '127.0.0.1', '浏览菜式管理页面'),
(43, '', 'admin', '2007-07-29 16:54:52', '127.0.0.1', '菜式更新, ID为(9) '),
(44, '', 'admin', '2007-07-29 16:54:54', '127.0.0.1', '浏览菜式管理页面'),
(45, '', 'admin', '2007-07-29 17:21:03', '127.0.0.1', '浏览菜式管理页面'),
(46, '', 'admin', '2007-07-29 17:21:08', '127.0.0.1', '浏览菜式管理页面'),
(47, 'xiaona', '', '2007-07-29 17:21:14', '127.0.0.1', '浏览首页页面'),
(48, '', 'admin', '2007-07-29 17:21:38', '127.0.0.1', '浏览菜式风味页面'),
(49, '', 'admin', '2007-07-29 17:21:50', '127.0.0.1', '浏览菜式风味页面'),
(50, '', 'admin', '2007-07-29 17:22:15', '127.0.0.1', '浏览菜式管理页面'),
(51, '', 'admin', '2007-07-29 17:22:17', '127.0.0.1', '浏览菜式管理页面'),
(52, '', 'admin', '2007-07-29 17:33:44', '127.0.0.1', '浏览菜式管理页面'),
(53, '', 'admin', '2007-07-29 17:33:46', '127.0.0.1', '浏览菜式管理页面'),
(54, 'xiaona', '', '2007-07-29 17:33:50', '127.0.0.1', '浏览首页页面'),
(55, '', 'admin', '2007-07-29 17:35:49', '127.0.0.1', '浏览菜式管理页面'),
(56, '', 'admin', '2007-07-29 17:36:03', '127.0.0.1', '浏览菜式管理页面'),
(57, '', 'admin', '2007-07-29 17:36:08', '127.0.0.1', '浏览菜式管理页面'),
(58, '', 'admin', '2007-07-29 17:36:19', '127.0.0.1', '浏览菜式管理页面'),
(59, '', 'admin', '2007-07-29 19:00:01', '127.0.0.1', '浏览菜式管理页面'),
(60, '', 'admin', '2007-07-29 19:00:03', '127.0.0.1', '浏览菜式管理页面'),
(61, '', 'admin', '2007-07-29 19:02:47', '127.0.0.1', '浏览菜式管理页面'),
(62, '', 'admin', '2007-07-29 19:02:59', '127.0.0.1', '浏览菜式管理页面'),
(63, '', 'admin', '2007-07-29 19:05:11', '127.0.0.1', '浏览菜式管理页面'),
(64, '', 'admin', '2007-07-29 19:05:18', '127.0.0.1', '浏览菜式管理页面'),
(65, '', 'admin', '2007-07-29 19:05:21', '127.0.0.1', '浏览菜式管理页面'),
(66, '', 'admin', '2007-07-29 19:05:33', '127.0.0.1', '浏览菜式管理页面');
-- --------------------------------------------------------
--
-- 表的结构 `Manufacturer`
--
CREATE TABLE `Manufacturer` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
PRIMARY KEY (`ID`)
);
--
-- 导出表中的数据 `Manufacturer`
--
INSERT INTO `Manufacturer` (`ID`, `Name`) VALUES
(1, '本公司'),
(2, '其他公司'),
(3, '旺旺食品');
-- --------------------------------------------------------
--
-- 表的结构 `Material`
--
CREATE TABLE `Material` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL ,
PRIMARY KEY (`ID`)
) ;
--
-- 导出表中的数据 `Material`
--
INSERT INTO `Material` (`ID`, `Name`) VALUES
(1, '猪肉'),
(2, '牛肉'),
(3, '牛排'),
(4, '其它');
-- --------------------------------------------------------
--
-- 表的结构 `News`
--
CREATE TABLE `News` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Body` text CHARACTER SET utf8 COLLATE utf8_bin,
`Type` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`PublishDateTime` text CHARACTER SET utf8 COLLATE utf8_bin,
PRIMARY KEY (`ID`)
) ;
--
-- 导出表中的数据 `News`
--
INSERT INTO `News` (`ID`, `Subject`, `Body`, `Type`, `PublishDateTime`) VALUES
(1, '本店正式开始营业, 欢迎光临!', '本店正式开始营业, 欢迎光临!', '新闻动态', '2006-04-25 22:52:00'),
(2, '点石金网络订餐系统v0.2版正式发布!', '谢谢大家对点石金网络订餐系统一如既往的支持！ 点击此处下载！', '新闻动态', '2006-04-25 22:52:00'),
(3, '点石金网络订餐系统v0.2版正式发布!', '谢谢大家对点石金网络订餐系统一如既往的支持！ 点击此处下载！', '新闻动态', '2006-04-25 22:52:00'),
(4, '点石金网络订餐系统v0.2版正式发布!', '谢谢大家对点石金网络订餐系统一如既往的支持！ 点击此处下载！', '新闻动态', '2006-04-25 22:52:00'),
(5, '点石金网络订餐系统v0.2版正式发布!', '谢谢大家对点石金网络订餐系统一如既往的支持！ 点击此处下载！', '新闻动态', '2006-04-25 22:52:00'),
(6, '饮食文化版面正式开张了!', '饮食文化版面正式开张了
', '饮食文化', '2006-04-25 22:52:00');
-- --------------------------------------------------------
--
-- 表的结构 `Order`
--
CREATE TABLE `Order` (
`ID` int(10) unsigned NOT NULL auto_increment,
`User_ID` int(11) default NULL,
`UserName` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Code` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`ChineseName` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Telephpone1` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Telephpone1Ext` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Telephpone2` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Telephpone2Ext` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`EMail` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Address` text CHARACTER SET utf8 COLLATE utf8_bin,
`Company` text CHARACTER SET utf8 COLLATE utf8_bin,
`Memo` text CHARACTER SET utf8 COLLATE utf8_bin,
`Total` double default NULL,
`Point` double default NULL,
`GetPoint` double default NULL,
`PayMoney` double default NULL,
`PayPoint` double default NULL,
`REMOTE_ADDR` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`DateTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`PayTerm` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Disposal` tinyint(1) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `Code` (`Code`)
) ;
--
-- 导出表中的数据 `Order`
--
INSERT INTO `Order` (`ID`, `User_ID`, `UserName`, `Code`, `ChineseName`, `Telephpone1`, `Telephpone1Ext`, `Telephpone2`, `Telephpone2Ext`, `EMail`, `Address`, `Company`, `Memo`, `Total`, `Point`, `GetPoint`, `PayMoney`, `PayPoint`, `REMOTE_ADDR`, `DateTime`, `PayTerm`, `Disposal`) VALUES
(1, -1, '', '20070729-000000', '贺先生', '0769-85691939', '', '', '', 'xxxxxxxxxxxx@126.com', '石排福隆三路c栋505', '', '菜加辣，饭多点', 20, 6.2, 0, 20, 0, '127.0.0.1', '2007-07-29 16:29:43', '现金支付', 1),
(2, 3, 'xiaona', '20070729-000001', '余小姐', '13431321445', '', '', '', 'xiaona123456@126.com', '石排福隆二路c栋505', '', '请11点30分前送到，否则拒绝收货', 20, 13.3, 13.3, 20, 0, '127.0.0.1', '2007-07-29 16:36:52', '现金支付', 1);
-- --------------------------------------------------------
--
-- 表的结构 `OrderDetail`
--
CREATE TABLE `OrderDetail` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Order_ID` int(11) default NULL,
`Product_ID` int(11) default NULL,
`Count` int(11) default NULL,
`Code` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Manufacturer_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Material` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Price` double default NULL,
`Point` double default NULL,
`Memo` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
PRIMARY KEY (`ID`)
) ;
--
-- 导出表中的数据 `OrderDetail`
--
INSERT INTO `OrderDetail` (`ID`, `Order_ID`, `Product_ID`, `Count`, `Code`, `Name`, `Manufacturer_ID`, `Photo`, `Material`, `Price`, `Point`, `Memo`) VALUES
(1, 1, 6, 1, 'A001', '辣椒炒牛排', NULL, NULL, NULL, 10, 2.9, ''),
(2, 1, 15, 1, 'A001', '椰汁', NULL, NULL, NULL, 10, 3.3, ''),
(3, 2, 3, 1, 'A001', '卤肉饭', NULL, NULL, NULL, 10, 10, '加辣'),
(4, 2, 14, 1, 'A001', '百事可乐', NULL, NULL, NULL, 10, 3.3, '要冰冻的'),
(5, 3, 16, 1, 'A002', '西兰花炒瘦肉', NULL, NULL, NULL, 8, 0.08, ''),
(6, 3, 17, 1, 'A003', '西红柿炒蛋', NULL, NULL, NULL, 8, 0.08, '');
-- --------------------------------------------------------
--
-- 表的结构 `Product`
--
CREATE TABLE `Product` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Code` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Manufacturer_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Material` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Price` double default NULL,
`Point` double default NULL,
`ProductCatalog_ID` int(11) default NULL,
`Flavor_ID` int(11) default NULL,
`Introduce` text CHARACTER SET utf8 COLLATE utf8_bin,
`Monday` tinyint(1) default NULL,
`Tuesday` tinyint(1) default NULL,
`Wednesday` tinyint(1) default NULL,
`Thursday` tinyint(1) default NULL,
`Friday` tinyint(1) default NULL,
`Saturday` tinyint(1) default NULL,
`Sunday` tinyint(1) default NULL,
`TodayRecommend` tinyint(1) default NULL,
PRIMARY KEY (`ID`)
) ;
--
-- 导出表中的数据 `Product`
--
INSERT INTO `Product` (`ID`, `Code`, `Name`, `Manufacturer_ID`, `Photo`, `Material`, `Price`, `Point`, `ProductCatalog_ID`, `Flavor_ID`, `Introduce`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`, `Saturday`, `Sunday`, `TodayRecommend`) VALUES
(1, 'A001', '扬州炒饭', '1', './photos/NewsProduct_1.jpg', '配料有鸡蛋、玉米、青豆、火腿肉等混合起来炒', 5, 0.5, 5, 2, '简介鸡蛋、淋上卤肉汁,饭香味美 淋上卤肉汁,饭香味美', 1, 0, 0, 0, 0, 1, 1, 1),
(2, 'A001', '京酱肉丝饭', '1', './photos/NewsProduct_1.jpg', '由卤肉，香菇，胡萝卜等混合炒成置于饭上', 5, 0.3, 5, 2, '等混合炒成置于饭上，淋上卤肉汁,饭香味美', 1, 0, 1, 0, 0, 1, 1, 1),
(3, 'A001', '卤肉饭', '1', './photos/NewsProduct_1.jpg', '鸭肉酱爆而成', 10, 10, 5, 2, '鸭肉酱爆而成，味酥而香，色酱红 淋上卤肉汁,饭香味美', 0, 1, 1, 0, 0, 1, 1, 1),
(4, 'A001', '爆烧鸭套餐', '1', './photos/NewsProduct_1.jpg', '鸡蛋、玉米、青豆', 15, 1.5, 5, 2, '口味咸、鲜、香，色泽枣红，口感酥烂，滑而不腻', 0, 0, 1, 0, 0, 1, 0, 1),
(5, 'A001', '红烧肉套餐', '1', './photos/NewsProduct_1.jpg', '鸡蛋、玉米、青豆', 15, 1.9, 4, 2, '等混合炒成置于饭上，淋上卤肉汁等混合炒成置于饭上，淋上卤肉汁', 0, 0, 1, 0, 1, 1, 0, 1),
(6, 'A001', '辣椒炒牛排', '1', './photos/NewsProduct_1.jpg', '鸡蛋、玉米、青豆', 10, 2.9, 4, 2, '等混合炒成置于, 等混合炒成置于饭上，淋上卤肉汁', 1, 0, 0, 1, 0, 1, 1, 1),
(7, 'A001', '青椒炒蛋', '1', './photos/NewsProduct_1.jpg', '鸡蛋、玉米、青豆', 10, 3.3, 4, 2, '等混合炒成置于, 等混合炒成置于饭上，淋上卤肉汁', 1, 0, 0, 1, 0, 1, 1, 1),
(8, 'A001', '青椒炒蛋', '1', './photos/NewsProduct_1.jpg', '鸡蛋、玉米、青豆', 10, 3.3, 4, 2, '等混合炒成置于, 等混合炒成置于饭上，淋上卤肉汁', 1, 0, 0, 1, 0, 1, 1, 1),
(9, 'A001', '青椒炒蛋', '1', './photos/NewsProduct_1.jpg', '鸡蛋、玉米、青豆', 10, 0.1, 4, 2, '等混合炒成置于, 等混合炒成置于饭上，淋上卤肉汁', 1, 0, 0, 1, 0, 1, 1, 1),
(10, 'A001', '青岛啤酒', '1', './photos/NewsProduct_1.jpg', '青岛啤酒', 10, 0.1, 1, 2, '青岛啤酒', 1, 0, 0, 1, 0, 1, 1, 1),
(11, 'A001', '雪花啤酒', '1', './photos/NewsProduct_1.jpg', '雪花啤酒', 10, 3.3, 1, 2, '雪花啤酒', 1, 0, 0, 1, 0, 1, 1, 1),
(12, 'A001', '五粮液', '1', './photos/NewsProduct_1.jpg', '五粮液', 10, 3.3, 1, 2, '五粮液', 1, 0, 0, 1, 0, 1, 1, 1),
(13, 'A001', '小糊涂仙', '1', './photos/NewsProduct_1.jpg', '小糊涂仙', 10, 3.3, 1, 2, '小糊涂仙', 1, 0, 0, 1, 0, 1, 1, 1),
(14, 'A001', '百事可乐', '1', './photos/NewsProduct_1.jpg', '百事可乐', 10, 3.3, 1, 2, '百事可乐', 1, 0, 0, 1, 0, 1, 1, 1),
(15, 'A001', '椰汁', '1', './photos/NewsProduct_1.jpg', '椰汁', 10, 3.3, 1, 2, '椰汁', 1, 0, 0, 1, 0, 1, 1, 1),
(16, 'A002', '西兰花炒瘦肉', '1', 'Photos/80017090-9936929-IMG_1109.JPG', '西兰花 瘦肉', 8, 0.08, 4, 6, '大家尝尝，加了肉片的西兰花吸收了肉的鲜味\r\n和香味，味道很好的哦', 1, 1, 1, 1, 1, 1, 1, 1),
(17, 'A003', '西红柿炒蛋', '1', 'Photos/15475464-61691704-IMG_1113.JPG', '西红柿 蛋', 8, 0.08, 5, 1, '足量，好味', 1, 1, 1, 1, 1, 1, 1, 1);
-- --------------------------------------------------------
--
-- 表的结构 `ProductCatalog`
--
CREATE TABLE `ProductCatalog` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Type` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
PRIMARY KEY (`ID`)
) ;
--
-- 导出表中的数据 `ProductCatalog`
--
INSERT INTO `ProductCatalog` (`ID`, `Name`, `Type`) VALUES
(1, '酒水', '副食'),
(2, '饮料', '副食'),
(3, '西餐', '主食'),
(4, '中餐', '主食'),
(5, '快餐', '主食');
-- --------------------------------------------------------
--
-- 表的结构 `ProductComment`
--
CREATE TABLE `ProductComment` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Product_ID` int(11) default NULL,
`User_ID` int(11) default NULL,
`DateTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`REMOTE_ADDR` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Comment` text CHARACTER SET utf8 COLLATE utf8_bin,
PRIMARY KEY (`ID`)
) ;
--
-- 导出表中的数据 `ProductComment`
--
INSERT INTO `ProductComment` (`ID`, `Product_ID`, `User_ID`, `DateTime`, `REMOTE_ADDR`, `Comment`) VALUES
(1, 1, 1, '2006-04-18 12:00:00', '61.195.2.142', '这菜不错'),
(2, 1, 1, '2006-04-18 12:00:00', '61.195.2.142', '这菜确实不错'),
(3, 2, 1, '2006-04-18 12:00:00', '61.195.2.142', '这菜也不错');
-- --------------------------------------------------------
--
-- 表的结构 `ShoppingCart`
--
CREATE TABLE `ShoppingCart` (
`ID` int(10) unsigned NOT NULL auto_increment,
`SESSIONID` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`User_ID` int(11) default NULL,
`Product_ID` int(11) default NULL,
`DateTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`Count` int(11) default NULL,
`Memo` text CHARACTER SET utf8 COLLATE utf8_bin,
PRIMARY KEY (`ID`)
) ;
--
-- 导出表中的数据 `ShoppingCart`
--
-- --------------------------------------------------------
--
-- 表的结构 `SystemConfig`
--
CREATE TABLE `SystemConfig` (
`BaseDir` VARCHAR( 255 ) NOT NULL DEFAULT 'http://www.dianshijin.cn/',
`SiteTitle` varchar(100) NOT NULL,
`SnackTelephone` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`ServiceTelephone` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`LogoURL` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`BannerURL` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`TaoBaoURL` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Aboutus` text CHARACTER SET utf8 COLLATE utf8_bin,
`Footer` text CHARACTER SET utf8 COLLATE utf8_bin,
`GetPointForRegister` double default NULL,
`SMTPServer` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`SMTPServerPort` int(11) default NULL,
`SMTPUserMail` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`SMTPUser` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`SMTPPassword` varchar(100) default NULL
) ;
--
-- 导出表中的数据 `SystemConfig`
--
INSERT INTO `SystemConfig` (`SiteTitle`, `SnackTelephone`, `ServiceTelephone`, `LogoURL`, `BannerURL`, `TaoBaoURL`, `Aboutus`, `Footer`, `GetPointForRegister`, `SMTPServer`, `SMTPServerPort`, `SMTPUserMail`, `SMTPUser`, `SMTPPassword`) VALUES
('点石金网络订餐系统', '0769-85691939', '0769-85691939', 'images/logo.jpg', 'images/128logo.jpg', 'http://shop34480016.taobao.com/',
'
点石金网络订餐系统v0.2版正式发布!
点击此处下载！
中心简介：
coowill网络快餐配送中心，是一家专门致力于为广州写字楼白领提供物美价廉营养美食的网络快餐配送中心。中心以现代化的信息交互手段，极其亲密的方式给消费者提供快捷、自主、个性化的就餐服务，力争打造快餐行业的优秀品牌。
宗旨：美味、营养、卫生、快捷、实惠
我们的承诺：
原料：每天选购最新鲜的蔬菜、鱼、肉、禽蛋。
烹调：科学的设计每天的菜谱，专业高级厨师烹制。
运输：专业的送餐队伍，一份起送，半小时内快速送餐。
卫生：干净、明亮的中央厨房、环保的餐具。
对象：企事业单位、个人、团体定餐、大型活动供餐。
经营理念：经营连锁化、服务标准化、品质营养化、订餐网络化。
服务时间：
1、营业时间： 星期一至星期六 上午9:00—下午13：30
2、送餐时间： 午餐：上午11:30—下午13:00
3、会员订餐时间： 午餐：上午11:30之前
服务范围：
赤岗大厦，世港公寓
目前本店正处于发展初期，配送人员有限，所以只能针对以上写字楼白领供餐，其它区域暂不能配送，敬请谅解！
本系统全面支持
IE 5.5+ (Windows), Firefox 1.0+, Mozilla 1.3+ 以及Netscape 7+.
',
' @dianshijin.cn版权所有',
0, 'smtp.126.com', 25, 'dianshijin_128kc@126.com', 'dianshijin_128kc', 'dianshijin');
-- --------------------------------------------------------
--
-- 表的结构 `User`
--
CREATE TABLE `User` (
`ID` int(10) unsigned NOT NULL auto_increment,
`UserType_ID` int(11) default NULL,
`Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Password` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Point` double default NULL,
`ChineseName` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Telephpone1` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Telephpone1Ext` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Telephpone2` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Telephpone2Ext` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`EMail` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin default NULL,
`Company` text CHARACTER SET utf8 COLLATE utf8_bin,
`Address` text CHARACTER SET utf8 COLLATE utf8_bin,
`DateTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`),
UNIQUE KEY `Name` (`Name`),
UNIQUE KEY `EMail` (`EMail`)
) ;
--
-- 导出表中的数据 `User`
--
INSERT INTO `User` (`ID`, `UserType_ID`, `Name`, `Password`, `Point`, `ChineseName`, `Telephpone1`, `Telephpone1Ext`, `Telephpone2`, `Telephpone2Ext`, `EMail`, `Company`, `Address`, `DateTime`) VALUES
(1, 1, 'hexing', 'hexing', 1, '点石金用户1', '0769-85691939', '234', '12345678990', '234', 'dianshijin.cn@qq.com', '广东东莞南城', '广东东莞南城3路23栋', '2006-04-24 10:59:00'),
(2, 1, 'xiao', '88', 1, '点石金用户2', '0769-85691939', '234', '12345678990', '234', 'xiaona@126.com', '广东东莞南城', '广东东莞南城3路23栋', '2006-04-24 10:59:00'),
(3, 1, 'xiaona', 'xiaona', 13.3, '贺先生', '0769-85691939', '', '', '', 'xiaona123456@126.com', '', '石排福隆二路c栋505', '2007-07-29 16:36:52');
ALTER TABLE `Administrator` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `Flavor` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `GuestBook` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `Link` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `Log` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `Manufacturer` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `Material` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `News` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `Order` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `OrderDetail` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `Product` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `ProductCatalog` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `ProductComment` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `ShoppingCart` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `SystemConfig` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
ALTER TABLE `User` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
-- ALTER DATABASE `###` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
