INSERT INTO Template VALUES(0,'Metric Standart',0,'USD','Dollar',0,78,'CCM',2,0,1,1);

INSERT INTO MaterialDb VALUES(1, 'sldstandartmaterials.db');
INSERT INTO MaterialDb VALUES(2, 'sldDINmaterials.db');

INSERT INTO GENERAL VALUES(1, 'Steel', 1);
INSERT INTO GENERAL VALUES(2, 'Aluminium', 2);

INSERT INTO SPECIFIC VALUES(1, 1, 'Steel AISI 123', 72, 3000);
INSERT INTO SPECIFIC VALUES(2, 1, 'Steel 567', 42, 4000);
INSERT INTO SPECIFIC VALUES(3, 2, 'Aluminium Alloy 1090', 72, 3000);
INSERT INTO SPECIFIC VALUES(4, 2, 'Aluminium swdef', 42, 4000);

INSERT INTO MATERIAL VALUES(1,1,'My Steel 1');
INSERT INTO MATERIAL VALUES(2,2,'My Steel 2');
INSERT INTO MATERIAL VALUES(3,3,'Aluminium 1');
INSERT INTO MATERIAL VALUES(4,4,'Aluminium 2');

INSERT INTO SetupCost VALUES(1,'test',0,23,1);
INSERT INTO SetupCost VALUES(2,'abother test',1,42,0);

INSERT INTO StockMaterial VALUES(1,1,1,14,342,67);
INSERT INTO StockMaterial VALUES(2,2,2,144,42,78);

INSERT INTO CutOPERATION VALUES(1,'Cut Method',23,34);
INSERT INTO CutOPERATION VALUES(2,'Cut Method1',33,44);

INSERT INTO CutOperationCost VALUES(1,1,1,76,56);
INSERT INTO CutOperationCost VALUES(2,1,2,12,67);

INSERT INTO MillOPERATION VALUES(1,'Machine 1',1,43,37);
INSERT INTO MillOPERATION VALUES(2,'Machine 2',1,53,46);

INSERT INTO MillOperationCost VALUES(1,1, 1, 1, 1, 76, 45,23,34,45);
INSERT INTO MillOperationCost VALUES(2,1, 1, 1, 2, 76, 45,23,34,45);

INSERT INTO DrillOPERATION VALUES(1,'Machine 1',2,443,337);
INSERT INTO DrillOPERATION VALUES(2,'Machine 2',2,553,446);

INSERT INTO DrillOperationCost VALUES(1,1, 1, 1, 4, 5, 7, 4);
INSERT INTO DrillOperationCost VALUES(2,1, 2, 2, 9, 5, 7, 4);

INSERT INTO LIBRARYFEATURE VALUES(1,'Library Feature1',31,1);
INSERT INTO LIBRARYFEATURE VALUES(2,'Library Feature1',31,2);

INSERT INTO LIBRARYFEATURECOST VALUES(1,1,444);
INSERT INTO LIBRARYFEATURECOST VALUES(1,2,344);

INSERT INTO CustomOperation VALUES(1, 'Custom Operation 1', 1, 23, 1, 1, 1);
INSERT INTO CustomOperation VALUES(2, 'Custom Operation 2', 2, 23, 1, 2, 0);