esybzCWG

1DROP SCHEMA IF EXISTS `FOG` ;
2CREATE SCHEMA `FOG`;
3USE `FOG`;
4
5DROP TABLE IF EXISTS `items`;
6CREATE TABLE `items` (
7	`id` INT(11) NOT NULL,
8	`description` VARCHAR(100) NOT NULL,
9	`length` INT(11) DEFAULT NULL,
10    `unit` VARCHAR(25) NOT NULL,
11    `descriptions_customer` VARCHAR(100) NOT NULL,
12    `stockquantity` INT(11) NOT NULL,
13	PRIMARY KEY (`id`)
14)engine=INNODB;
15
16INSERT INTO `items` VALUES('plastmo bundskruer 200 stk.', 0, 'Pakke',250);
17INSERT INTO `items` VALUES('hulbånd 1x20 mm. 10 mtr.', 0,'Rulle',750);
18INSERT INTO `items` VALUES('universal 190 mm. højre', 0,'Stk',400);
19INSERT INTO `items` VALUES('universal 190 mm. venstre', 0, 'Stk', 800);
20INSERT INTO `items` VALUES('4,5 x 60 mm. skruer 200 stk.', 0, 'Pakke',1000);
21
22INSERT INTO `items` VALUES('4,0 x 60 mm. beslagskruer 250 stk.', 0, 'Pakke',300);
23INSERT INTO `items` VALUES('bræddebolt 10 x 120 mm.', 0, 'Stk',600);
24INSERT INTO `items` VALUES('firkantskiver 40 x 40 x 11 mm', 0, 'Stk',150);
25INSERT INTO `items` VALUES('4,5 x 70 mm. skruer 400 stk.', 0, 'Pakke',280);
26INSERT INTO `items` VALUES('4,5 x 50 mm. skruer 300 stk.', 0, 'Pakke',350);
27
28
29INSERT INTO `items` VALUES('stalddørsgreb 50 x 75 mm.', 0, 'Sæt',150);
30INSERT INTO `items` VALUES('t hængsel 390 mm.', 0, 'Stk',100);
31INSERT INTO `items` VALUES('Vinkelbeslag 35 mm', 0, 'Stk',200);
32
33
34
35INSERT INTO `items` VALUES('25x200 mm. trykimp. Brædt', 360,'Stk',300);
36INSERT INTO `items` VALUES('25x200 mm. trykimp. Brædt', 540,'Stk',500);
37INSERT INTO `items` VALUES('25x125 mm. trykimp. Brædt', 360,'Stk',180);
38INSERT INTO `items` VALUES('25x125 mm. trykimp. Brædt', 540,'Stk',980);
39INSERT INTO `items` VALUES('19x100 mm. trykimp. Brædt', 210,'Stk',130);
40INSERT INTO `items` VALUES('19x100 mm. trykimp. Brædt', 540,'Stk',380);
41INSERT INTO `items` VALUES('19x100 mm. trykimp. Brædt', 360,'Stk',410);
42
43INSERT INTO `items` VALUES('38x73 mm. Lægte ubh.', 420,'Stk',1000);
44
45INSERT INTO `items` VALUES('45x95 mm. Reglar ubh.', 270,'Stk',330);
46INSERT INTO `items` VALUES('45x95 mm. Reglar ubh.', 240,'Stk',200);
47
48
49INSERT INTO `items` VALUES('45x195 mm. spærtræ ubh.', 600,'Stk',710);
50INSERT INTO `items` VALUES('45x195 mm. spærtræ ubh.', 480,'Stk',990);
51INSERT INTO `items` VALUES('45x195 mm. spærtræ ubh.', 600,'Stk',190);
52
53INSERT INTO `items` VALUES('97x97 mm. trykimp. stolpe', 300,'Stk',710);
54
55INSERT INTO `items` VALUES('Plastmo Exolite blåtonet', 600,'Stk',905);
56INSERT INTO `items` VALUES('Plastmo Exolite blåtonet.', 360,'Stk', 390);