text: BEGIN TRANSACTION;
  INSERT INTO "inv_details" ("WID","serial","desc","qty","location","kit") VALUES ('W8R5987',NULL,1,25,1,NULL),
   ('W8R6354','0987654321',2,1,1,NULL),
   ('W8R1122','1234567654',2,1,11,NULL),
   ('W8R0987','8765456787',2,1,1,NULL),
   ('W8R7766','2983746537',3,1,2,NULL),
   ('W8R0001','5683567247',3,1,2,NULL),
   ('W8R0984','8745876536',3,1,2,NULL),
   ('W8R1222','9988776655',3,1,5,NULL),
   ('W8R4343','0192837464',4,1,5,NULL),
   ('W8R1243','0OIU765TR3',4,1,3,NULL),
   ('W8R5454','34567UIOLK',4,1,3,NULL),
   ('W8R3334','234DF678F3',4,1,11,NULL);
  INSERT INTO "inv_desc" ("id","name","desc","model","NSN","NSN_desc") VALUES (1,'Battery - XTS 2500','Rechargable handheld battery','HT45939123F45','21-99876','HANDHELD TRANSMITTER RECEIVER POWER SOURCE'),
   (2,'XTS 2500','Handheld, no buttons or screen','HT45939123F66','21-09876','HANDHELD TRANSMITTER RECEIVER'),
   (3,'XTS 2500','Handheld, 6 button & screen','HF45932223F66','21-09877','HANDHELD TRANSMITTER RECEIVER'),
   (4,'XTS 2500','Handheld, full keypad & screen','HB45937823F55','21-09878','HANDHELD TRANSMITTER RECEIVER');
  INSERT INTO "locations" ("id","name","bldg") VALUES (1,'SHELF 001',1),
   (2,'SHELF 001',2),
   (3,'SHELF 002',2),
   (4,'SHELF 002',1),
   (5,'ROOM 12',3),
   (6,'SHELF 003',1),
   (7,'SHELF 004',1),
   (8,'SHELF 005',1),
   (9,'SHELF 006',1),
   (10,'SHELF 003',2),
   (11,'SHELF 004',2);
  INSERT INTO "buildings" ("id","name","bldgNum","address") VALUES (1,'8 OSS TF - HQ','164','39 Alert Blvd, Astra'),
   (2,'8 OSS TF - C-SPAN (Formerly MSU)','401','15 Greenwood Ave. Astra'),
   (3,'8 OSS TF - IFRCC','25','1 TOWER ROAD, Astra'),
   (4,'8 OSS TF - MACS Rx SITE','na','21124 Loyalist Pkwy, Carrying Place'),
   (5,'8 OSS TF - MACS Tx SITE','na','323 Point Petre Rd, Cherry Valley');
  COMMIT;
  