DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
  `prod_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `link` bigint(20) unsigned NOT NULL,
  `kind` enum('servers','switches') NOT NULL DEFAULT 'servers',
  `description` text NOT NULL,
  `customer_num` int(10) unsigned NOT NULL,
  PRIMARY KEY (`prod_id`),
  UNIQUE KEY `prod_id` (`prod_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 CHECKSUM=1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (1,1,'servers','LP-2220-2H, 2 x 500GB drives, 16GB memory',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (2,2,'servers','Demo LP-4240-8H Server',99);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (3,3,'servers','Demo LP-4240-8H Server',99);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (4,4,'servers','LP-4240-2H 16GB 2 x 1TB\r\nprod-db1',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (5,5,'servers','LP-4240-2H\r\nprod-db2',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (6,6,'servers','LP-2220-2H\r\nsp1.pogoseat.com',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (7,7,'servers','LP-2220-2H\r\nprod-lb1 prod-lb1.pogoseat.com',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (8,8,'servers','# LP-4240-2H\r\nprod-db3 prod-db3.pogoseat.com',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (9,9,'servers','# LP-4240-2H\r\nprod-fe1 prod-fe1.pogoseat.com',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (10,10,'servers','# LP-2220-2H\r\nprod-cache1 prod-cache1.pogoseat.com',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (11,0,'servers','LP-2180\r\nfw.pogoseat.com',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (12,11,'servers','Special LP-2220 with 12v input for San Jose City IT',6);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (13,12,'servers','LP-2180-2H 4GB ram 2 x 320GB\r\nMethodics (router in HE?)',3);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (14,13,'servers','LP-4240-6H',3);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (15,14,'servers','LP-4240-6H 16GB',3);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (16,15,'servers','LP-4240-8H with RAID card\r\nSecond Methodics proxmox server.  Supermicro PS.',3);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (17,16,'servers','LP-4240-8H with RAID card\r\nMethodics proxmox server',3);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (19,17,'servers','LP-2160-2I\r\nOnly one of it\'s kind ~:^)',1);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (20,18,'servers','LP-2230-6H\r\nMethodics office server\r\n4 x 500GB HDD, 16GiB',3);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (21,19,'servers','LP-2180-2H\r\nmethodics internal web server',3);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (22,20,'servers','LP-2180-2H\r\nmethodics firewall/router',3);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (23,0,'servers','R & D Server\r\nLGA 2011 socket, 8 DIMM slots, 7 PCIe slots, 10 SATA (2 SATA3, 8 SATA2), 2 Gigabit, 1 IPMI',99);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (24,21,'servers','pogoseat backup server',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (25,22,'servers','pogoseat dual core, dual 120GB SSD',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (26,23,'servers','pogoseat VM server',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (27,24,'servers','pogoseat hypervisor',5);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (28,25,'servers','LP-4240-6H\r\npostgres server (1 of 2) for xtuple',1);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (29,26,'servers','LP-4240-6H\r\npostgresql server (2 of 2) for xtuple',1);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (30,0,'servers','Placeholder for Supermicro X9SBAA-F motherboard in R & D.',99);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (31,27,'servers','LP-2180-2I w/ 1x 1TB drive\r\n',4);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (32,28,'servers','LP-2180-2H w/ 2 x 1TB drive',4);
INSERT INTO `products` (`prod_id`, `link`, `kind`, `description`, `customer_num`) VALUES (33,29,'servers','LP-2180-2H w/ 2 x 1TB drive',4);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;

