数据库脚本.sql

来自「LINUX下POS收银系统,可以对货物及工作人员进行管理.近本实现增删改查的功能」· SQL 代码 · 共 539 行 · 第 1/2 页

insert into table_commodity values (seq_test.nextval,'CN000044', '白又嫩', '瓶', '400ml', 18, 11, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000045', '鸡牌洗衣粉', '袋', '200g', 3, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000046', '便当', '盒', '自助', 5, 3, 99, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000047', '少年纸尿片', '张', '10片', 1, 0.7, 9994, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000048', '宜而爽', '条', '10包', 5, 3, 9998, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000049', '黄历', '本', '16开', 10, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000050', '狗牌', '个', '10G', 99, 4, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000051', '杯子', '个', '200g', 3, 1.8, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000052', '大杯子', '支', '35g', 2, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000053', '特大杯子', '瓶', '400ml', 20, 12, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000054', '小杯子', '瓶', '400ml', 18, 11, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000055', '很小的杯子', '瓶', '400ml', 3, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000056', '非常小的杯子', '瓶', '400ml', 5, 3, 99, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000057', '中年纸尿片', '张', '10片', 1, 0.7, 9994, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000058', '小白兔奶糖', '条', '10包', 5, 3, 9998, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000059', '健身器材', '套', '12件组', 1000, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000060', '高级健身器材', '套', '18件组', 5000, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000061', '高露洁牙刷', '盒', '200g', 3, 1.8, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000062', '佳洁士牙线', '支', '35g', 2, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000063', '硝化甘油', '瓶', '400ml', 20, 12, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000064', '硫酸', '瓶', '400ml', 18, 11, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000065', '黑火药', '袋', '200g', 3, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000066', '成套工具', '盒', '自助', 5, 3, 99, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000067', '打印纸', '张', '10片', 1, 0.7, 9994, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000068', '某品牌香烟', '条', '10包', 5, 3, 9998, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000069', '高级笔记本电脑', '本', '12寸', 8999, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000070', '家居用品', '套', '10件组', 900, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000071', '枕头', '个', '200g', 30, 1.8, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000072', '佳洁士牙线', '支', '35g', 2, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000073', '牙签', '瓶', '100根', 20, 12, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000074', '泰迪熊', '个', '10KG', 180, 11, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000075', '黑巧克力', '盒', '200g', 30, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000076', '牛奶巧克力', '盒', '200g', 30, 3, 99, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000077', '杏仁巧克力', '盒子', '200g', 30, 0.7, 9994, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000078', '某知名品牌香烟', '条', '10包', 50, 3, 9998, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000079', 'XBOX', '套', '360', 2999, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000080', '枕头套', '套', '1个', 90, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000081', '席梦思', '床', '200g', 300, 1.8, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000082', '劣质牙线', '根', '假冒', 1, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000083', '劣质牙签', '瓶', '10根', 2, 12, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000084', '劣质泰迪熊', '个', '1假冒', 18, 11, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000085', '黑胡椒巧克力', '盒', '200g', 30, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000086', '难吃的巧克力', '盒', '200g', 3, 3, 99, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000087', '杏仁', '盒', '200g', 30, 0.7, 9994, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000088', '假冒香烟', '条', '10包', 5, 3, 9998, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000089', 'PS 3', '套', '360', 2999, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000090', '衣服', '套', '1个', 90, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000091', '寿衣', '套', '200g', 300, 1.8, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000092', '死人穿的衣服', '套', '高级', 1000, 100, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000093', '活人穿的高级衣服', '套', '高级', 200, 120, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000094', 'WINDOWS VISTA', '片', '假冒', 10, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000095', 'WINDOWS VISTA', '盒', '真货', 5000, 1000, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000096', 'WINDOWS 98', '盒', '别买', 300, 3, 99, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000097', 'AMD双核3800', '盒装', '性价比', 700, 600.7, 9994, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000098', 'INTER 迅驰 5250', '盒装', '乱贵', 1800, 1300, 9998, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000099', 'nVIDIA 6200 AGP', '显卡', '二手', 199, 100, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000100', 'NIKE鞋子', '双', '2个', 900, 800, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000101', '高级书包', '个', '200g', 1300, 1.8, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000102', '低级书包', '个', '低级', 120, 100, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000103', '低级皮包', '个', '低级', 200, 120, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000104', '假LV包', '个', '假冒', 100, 19, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000105', 'TT风扇', '盒', '真货', 150, 100, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000106', '太阳眼镜', '盒', '黑', 300, 3, 99, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000107', '包包', '个', '吃的', 1, 0.7, 9994, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000108', '我的太阳', '骂人', '我日', 1800, 1300, 9998, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000109', '猴子的屁股', '对', '红的', 199, 100, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000110', 'ADIDAS鞋子', '双', '2个', 900, 800, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000111', '西装', '套', 'XL', 1300, 811.8, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000112', '高级西装', '套', '高级', 1720, 1100, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000113', '低级西装', '套', '洗坏', 100, 20, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000114', '假LV包', '个', '假冒', 100, 19, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000115', '高级TT风扇', '盒', '真货', 180, 100, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000116', '月亮眼镜', '盒', '金色', 300, 3, 99, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000117', '周经帖', '张', '每周', 1, 0.7, 9994, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000118', '炫耀贴', '张', '喷之', 10, 10, 9998, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000119', '猴子的屁股', '对', '特红', 199, 100, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000120', '很黄很暴力', '句', '张X凡', 10, 1, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000121', '很好很强大', '句', '天涯', 1300, 811.8, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000122', '最XXX，没有之一', '句', 'MOPer', 1720, 1100, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000123', '太平间公主', '句', '死了', 100, 20, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000124', '很爱很爱你', '的', '钱', 100, 19, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000125', '我想你的每一天', '都', '犯困', 150, 100, 9999, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000126', '牛仔玩具', '个', '很忙', 300, 3, 99, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000127', '我的笑话', '非常', '冷！', 1, 0.7, 9994, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000128', '从前有只企鹅', '叫', '豆豆', 10, 10, 9998, 1, 0);

 
insert into table_commodity values (seq_test.nextval,'CN000129', '后来它', '被打', '死了', 199, 100, 9999, 1, 0);


select * from table_commodity

insert into table_employee values('100001','本。拉登','123456',1,0,'退货用户');
insert into table_employee values('000000','布什','123456',0,0,'管理员')
insert into table_employee values('000001','布朗','123456',2,0,'普通职员')

select * from table_employee