kc.sql.svn-base

这是基于spring +hibernate的项目

#
# Data for the `dish` table  (LIMIT 0,500)
#

INSERT INTO `dish` (`id`, `name`, `about`, `shtick`, `material`, `hot`, `price`, `memberprice`, `isnew`, `senddate`, `dishSort_id`) VALUES 
  (5,'葡式牛肉?菠萝饭','葡式牛肉?菠萝饭','gdfg','gdfg',0,32,32,'N','2006-03-17',2),
  (6,'咖喱石斑饭','咖喱石斑饭','gdf','gdfg',0,32,30,'Y','2006-03-17',2),
  (7,'意式斑柳烩意粉','将乳猪洗净,从背上切口挖出内脏和猪脑;用各种调料腌好,再用沸水淋遍猪皮,最后涂上糖醋;用特制的烧叉从臀部插入,置木炭火上烤, 烤制时不停转动烤叉，并均匀地涂上花生油，烤至猪皮呈大红色便成；将烤好的猪同千层饼，酸甜菜，葱球，甜面酱一起食用。','色泽大红，油光明亮，皮脆酥香，肉嫩鲜美，风味独特。','净乳猪，五香盐，糖醋，白糖，豆酱，红腐乳，千层饼，酸甜菜，葱球，蒜泥芝麻酱，花生油，甜面酱，汾酒，木炭。',4,32,20,'Y','2006-03-23',1),
  (8,'火爆腰花','火爆腰花','gdf','ggdfg',0,35,30,'N','2006-03-30',2),
  (9,'时椒炒鳝片','时椒炒鳝片','gdfg','gdfg',0,20,15,'N','2006-03-17',2),
  (10,'生炒鸡丝饭','生炒鸡丝饭 ','gdf','ggdfg',0,12,10,'N','2006-03-15',6),
  (11,'牛腩汤米粉','牛腩汤米粉 ','gdfg','gdfg',0,20,16,'Y','2006-03-25',4),
  (12,'干炒牛河','干炒牛河 ','gdf','ggdfg',0,25,24,'N','2006-03-15',5),
  (13,'四川回锅肉','将肥瘦相连的猪腿肉刮洗干净，放入汤锅内煮至肉熟皮软为度，捞出冷透后，切成5厘米长4厘米宽 0.2厘米厚的片；青蒜苗切成马耳朵形，炒锅置旺火上，放入猪化油烧至六成热，下肉片炒至吐油，肉片呈灯盏窝状时，下剁茸的郫县豆瓣炒上色，放入甜面酱炒出香味，加入酱油炒匀，再放入青蒜苗簸锅炒断生起锅即成。','香辣味浓，油而不腻。','猪腿肉，青蒜苗，郫县豆瓣，甜面酱，酱油，混合油。',0,15,10,'Y','2006-03-21',2),
  (14,'红烧茄子','将净鸭从背尾部横开口，取出内脏，割去肛门洗净；盆内放绍酒，醪糟汁，胡椒粉，川盐，花椒拌匀抹鸭身，腌 8小时捞出，再入沸水内烫一下紧皮，搌干水，放入熏炉内；用花茶，稻草，松柏枝，樟树叶，拌匀做熏料，熏至鸭皮呈黄色取出，再将鸭放入大蒸碗内，上笼蒸 2小时，出笼晾冷；炒锅置旺火上，下熟菜油烧至八成热，放入熏蒸后的鸭炸至鸭皮酥香捞出，刷上芝麻油；将鸭颈斩成段，盛入圆盘中间，再将鸭身斩成条（鸭皮朝上），盖在鸭颈块上，摆成鸭形，另配荷叶软饼上席。','色泽金红，外酥里嫩，带有樟木和茶叶的特殊香气，别具风味。','肥公鸭，花茶，樟树叶，稻草，松柏枝，川盐，绍酒，芝麻油，花椒，胡椒粉，醪糟汁，熟菜油。',0,10,8,'Y','2006-03-30',2),
  (15,'红烧牛腩饭','将鸡宰杀，去毛、去内脏，清水洗净。将整只嫩母鸡入锅，加水（以淹没鸡为度），放姜片、绍酒，加盖烧30分钟左右，至鸡半熟、汤汁趋浓后，再倒入大沙锅内，放入白果、盐，加盖用文火烧15分钟左右，至鸡肉酥烂、汤浓出锅，倒入一只大的圆汤盘内，鸡肚朝上、背脊朝下，白果围在四周即成。','色泽淡黄，汤汁浓白，鸡肉鲜嫩，白果微甜，软熟适口。','新鲜嫩母鸡1只、白果、绍酒、姜片、盐。',0,20,15,'N','2006-03-09',2);

COMMIT;

#
# Data for the `image` table  (LIMIT 0,500)
#

INSERT INTO `image` (`id`, `name`, `newname`, `size`, `uploadtime`, `dish_id`) VALUES 
  (31,'4.jpg','2006040218591550.jpg',65209,NULL,15),
  (32,'3304361.jpg','2006040218591331.jpg',66344,NULL,15),
  (33,'8.jpg','2006040218591013.jpg',47015,NULL,15),
  (34,'10aa94ddfc1.jpg','2006040218590884.jpg',51309,NULL,15),
  (35,'3.jpg','2006040219012047.jpg',59529,NULL,14),
  (36,'8.jpg','2006040219011744.jpg',47015,NULL,14),
  (37,'3027212.jpg','2006040219011380.jpg',27452,NULL,14),
  (38,'109771d132f.jpg','2006040219011131.jpg',325715,NULL,14),
  (39,'3175419.jpg','2006040219035097.jpg',32437,NULL,13),
  (40,'3304362.jpg','2006040219034759.jpg',94497,NULL,13),
  (41,'3304362.jpg','2006040219034414.jpg',94497,NULL,13),
  (42,'3155701.jpg','2006040219040949.jpg',35823,NULL,12),
  (43,'3155705.jpg','2006040219040649.jpg',40158,NULL,12),
  (44,'3304365.jpg','2006040219040465.jpg',106952,NULL,12),
  (45,'20041209134016460.jpg','2006040219042875.jpg',152423,NULL,11),
  (46,'2006321245188672.jpg','2006040219042427.jpg',69313,NULL,11),
  (47,'3304365.jpg','2006040219044520.jpg',106952,NULL,10),
  (48,'3304362.jpg','2006040219044248.jpg',94497,NULL,10),
  (49,'3155712.jpg','2006040219050472.jpg',30246,NULL,6),
  (50,'2006321245188672.jpg','2006040219050141.jpg',69313,NULL,6),
  (51,'3155702.jpg','2006040219053097.jpg',16800,NULL,7),
  (52,'109771d132f.jpg','2006040219052881.jpg',325715,NULL,7),
  (53,'73765.jpg','2006040219055927.jpg',72875,NULL,11),
  (54,'3118717.jpg','2006040219062260.jpg',181675,NULL,9),
  (55,'3155705.jpg','2006040219061933.jpg',40158,NULL,9);

COMMIT;

#
# Data for the `member` table  (LIMIT 0,500)
#

INSERT INTO `member` (`id`, `username`, `password`, `name`, `sex`, `birthday`, `idcard`, `company`, `address`, `email`, `tel`, `handset`, `loginip`, `logintime`, `logincount`) VALUES 
  (4,NULL,NULL,NULL,'男',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
  (5,'gsdg','dsfg',NULL,'男',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
  (6,'gsdgsdf','gdfs','gdfsgdfg','女',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
  (7,'gdsf','gdfg','gdsfg','男',NULL,'gdfg','dfg','dfgsd','fgsdf',NULL,'gdfg',NULL,NULL,NULL),
  (8,'gdfgdf','fsdf','gdfg','男',NULL,'gdfg','dfgdf','gdfg','dfgdf','gdfgdf','gdfg',NULL,NULL,NULL),