--
-- Host: localhost    Database: 907flips
-- ------------------------------------------------------


--
-- Table structure for table `inventory`
--

CREATE TABLE `inventory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `make` varchar(50) NOT NULL,
  `model` varchar(50) NOT NULL,
  `category` varchar(50) NOT NULL,
  `sub_category` varchar(50) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `qty` varchar(50) NOT NULL,
  `active_status` varchar(50) NOT NULL,
  `purchase_price` double(10,2) NOT NULL,
  `list_price` double(10,2) NOT NULL,
  `sold_price` double(10,2) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inventory`
--

INSERT INTO `inventory` VALUES (1,'RS','PRO-2018','electronics',NULL,'http://907flips.com/images/placeholder.png','Scanner boxed like new. Tested & Working','1','yes',20.00,100.00,0.00,NULL,'2020-12-27 06:07:47'),(2,'Samsung','Smart things','electronics',NULL,'http://907flips.com/images/placeholder.png','home monitoring kit. Like new','1','yes',10.00,100.00,NULL,NULL,'2020-12-27 06:37:05'),(3,'UDI','U818a-1','electronics',NULL,'http://907flips.com/images/placeholder.png','RC Drone. Boxed. Used','1','yes',0.00,100.00,0.00,NULL,'2020-12-27 06:39:05'),(4,'RC Club','Fiat 695SS','electronics',NULL,'http://907flips.com/images/placeholder.png','Boxed. Used','1','yes',10.00,80.00,NULL,NULL,'2020-12-27 06:40:12'),(6,'Akai','LPK25','electronics',NULL,'/images/placeholder.png','Bluetooth/USB mini midi controller','1','no',0.00,35.00,0.00,NULL,'2021-01-08 06:48:25'),(7,'TAMIYA','Countach LP500S (Motorized)','electronics',NULL,'/images/placeholder.png','Brand new, boxed kit. Never built. Motorized','1','no',10.00,100.00,0.00,NULL,'2021-01-08 06:53:59'),(8,'TAMIYA','Countach LP500S','other',NULL,'/images/placeholder.png','Brand new, boxed kit. Never built','1','no',10.00,60.00,NULL,NULL,'2021-01-08 06:57:03'),(9,'HP','Jornada','electronics',NULL,'/images/placeholder.png','Boxed like new','1','no',10.00,100.00,NULL,NULL,'2021-01-08 07:00:14'),(10,'Dragonbox','DB5 PLUS','electronics',NULL,'/images/placeholder.png','Boxed like new','1','no',20.00,80.00,NULL,NULL,'2021-01-08 07:02:33'),(11,'Bel','Swingmate G450','electronics',NULL,'/images/placeholder.png','Used but works fine','1','no',5.00,45.00,NULL,NULL,'2021-01-08 07:04:16'),(12,'LG','G PAD 7 (LG-V410)','electronics',NULL,'/images/placeholder.png','Used but works fine. Includes case','1','no',20.00,80.00,NULL,NULL,'2021-01-08 07:11:04'),(13,'Apple','IPAD 2 WIFI 32GB','electronics',NULL,'/images/placeholder.png','Used but works fine. Includes case','1','no',20.00,100.00,NULL,NULL,'2021-01-08 07:13:11'),(14,'Linksys','SR2024C','computers',NULL,'/images/placeholder.png','Used but works fine','2','no',5.00,65.00,NULL,NULL,'2021-01-08 07:15:17'),(15,'Suunto','T4C','electronics',NULL,'/images/placeholder.png','Used but works fine. Boxed','1','no',10.00,100.00,NULL,NULL,'2021-01-08 07:18:23'),(16,'Apple','Airport Express A1398','computers',NULL,'/images/placeholder.png','Used but works fine. With power cable','1','no',10.00,65.00,NULL,NULL,'2021-01-08 07:20:32'),(17,'Nintendo','Family computer Mimi (NES)','vgames',NULL,'/images/placeholder.png','Boxed, slight crushed but all like new','1','no',20.00,95.00,NULL,NULL,'2021-01-08 07:22:33'),(18,'Behringer','UM300','electronics',NULL,'/images/placeholder.png','Used but works fine','1','no',8.00,60.00,NULL,NULL,'2021-01-08 07:24:49'),(19,'Apple','Powerbook G4','computers',NULL,'/images/placeholder.png','Used, few dings but works fine','1','no',10.00,150.00,NULL,NULL,'2021-01-08 07:26:21'),(20,'Rasmey','TV6 Transmitter','electronics',NULL,'/images/placeholder.png','Brand new, boxed kit. Never built','1','no',10.00,100.00,NULL,NULL,'2021-01-08 07:27:52'),(21,'Big Gun','Over Rev','electronics',NULL,'/images/placeholder.png','Untested','1','no',3.00,70.00,NULL,NULL,'2021-01-08 07:28:48'),(22,'Nintendo','Wii U 32GB Black','vgames',NULL,'/images/placeholder.png','Untested, missing power supply','1','no',0.00,75.00,NULL,NULL,'2021-01-08 07:30:26'),(23,'Dodge','RAM Big horn 4x4 decal','other',NULL,'/images/placeholder.png','Used','1','no',5.00,40.00,NULL,NULL,'2021-01-08 07:31:55'),(24,'Sennheiser','HD 280 Pro','electronics',NULL,'/images/placeholder.png','Used but works fine','1','no',0.00,50.00,NULL,NULL,'2021-01-08 07:33:06'),(25,'Rasmey','LPA1C','electronics',NULL,'/images/placeholder.png','Brand new, boxed kit. Never built','1','no',0.00,80.00,NULL,NULL,'2021-01-08 07:37:16'),(26,'Nintendo','Zelda Windwaker','vgames',NULL,'/images/placeholder.png','Used but works fine','1','no',3.00,50.00,NULL,NULL,'2021-01-08 07:39:01'),(27,'Nintendo','Mario Party 10','vgames',NULL,'/images/placeholder.png','Used but works fine','1','no',3.00,45.00,NULL,NULL,'2021-01-08 07:39:48'),(28,'Nesspresso','Frother 3594','other',NULL,'/images/placeholder.png','Used but works fine','1','no',10.00,100.00,NULL,NULL,'2021-01-08 07:42:39'),(29,'Rasmey','LPA1C','electronics',NULL,'/images/placeholder.png','Built, untested','1','no',0.00,75.00,NULL,NULL,'2021-01-08 07:45:53'),(30,'ION','VCR 2 PC','electronics',NULL,'/images/placeholder.png','Boxed like new','1','no',15.00,150.00,NULL,NULL,'2021-01-08 07:53:05'),(31,'Rocketfish','Wireless HD Audio starter kit','electronics',NULL,'/images/placeholder.png','Used but works fine','2','no',20.00,80.00,NULL,NULL,'2021-01-08 07:55:19'),(32,'Sony','DD-10EX','electronics',NULL,'/images/placeholder.png','Used but boxed like new','1','no',10.00,80.00,NULL,NULL,'2021-01-08 08:00:49'),(33,'Mercury','TR-3300','electronics',NULL,'/images/placeholder.png','Used but boxed like new','1','no',20.00,100.00,NULL,NULL,'2021-01-08 08:06:53'),(34,'Wahl','Dog grooming clippers','other',NULL,'/images/placeholder.png','Used but boxed like new','1','no',10.00,65.00,NULL,NULL,'2021-01-08 08:10:48'),(35,'Airtronics','6v 5N-425A','electronics',NULL,'/images/placeholder.png','Tested and working','1','no',5.00,50.00,NULL,NULL,'2021-01-08 08:12:44'),(36,'Robotix','Power pack and computer','electronics',NULL,'/images/placeholder.png','Used but works fine','1','no',15.00,60.00,NULL,NULL,'2021-01-08 08:14:32'),(37,'Rio','Karma MP3','electronics',NULL,'/images/placeholder.png','Used but works fine','1','no',10.00,250.00,NULL,NULL,'2021-01-08 08:22:01'),(38,'Nespresso','Aeroccino','electronics',NULL,'/images/placeholder.png','Brand like new','1','no',10.00,45.00,NULL,NULL,'2021-01-08 08:27:24'),(39,'Dell','Inspiron 15 BLK','computers',NULL,'/images/placeholder.png','15\" Intel, 4GB RAM, 500GB HDD WIFI/DVD','1','no',13.00,130.00,NULL,NULL,'2021-01-14 01:28:54'),(40,'Dell','XPS 15 laptop','computers',NULL,'/images/placeholder.png','I5 5000, 8GB RAM/750GB HDD','1','no',13.00,150.00,NULL,NULL,'2021-01-14 01:30:42'),(41,'Sony','PS2','vgames',NULL,'/images/placeholder.png','PS2, Controller, Power','1','no',15.00,60.00,NULL,NULL,'2021-01-14 01:31:25'),(43,'Spyder','5 Express','electronics',NULL,'/images/placeholder.png','Used but works fine','1','no',7.00,60.00,NULL,NULL,'2021-01-14 01:35:08'),(44,'Pioneer','GM-6300F','electronics',NULL,'/images/placeholder.png','Used, few dings but works fine','1','no',10.00,60.00,NULL,NULL,'2021-01-14 01:38:03'),(45,'Scosche ','500K','computers',NULL,'/images/placeholder.png','Used ','1','no',8.00,25.00,NULL,NULL,'2021-01-14 01:45:02'),(46,'Cobra','138XLR','electronics',NULL,'/images/placeholder.png','Power lead, no mic or antenna','1','no',3.00,150.00,NULL,NULL,'2021-01-17 06:10:26'),(47,'Razor','Blackwidow Ultimate 2016','computers',NULL,'/image/placeholder.png','Used but works fine','1','no',10.00,45.00,NULL,NULL,'2021-01-21 01:31:06'),(48,'Razor','Blackwidow Ultimate 2014','computers',NULL,'/image/placeholder.png','Used but works fine','1','no',10.00,40.00,0.00,NULL,'2021-01-21 01:31:07'),(49,'Vectronics','LP-30','other',NULL,'/image/placeholder.png','Used but works fine','1','no',3.00,40.00,NULL,NULL,'2021-01-21 01:48:07'),(50,'Sony','PS2','vgames',NULL,'/images/placeholder.png','No leads','1','no',8.00,40.00,NULL,NULL,'2021-01-22 22:41:00'),(51,'nintendo','2DS','vgames',NULL,'/images/placeholder.png','Case and charger','1','no',30.00,90.00,NULL,NULL,'2021-01-22 22:46:13'),(52,'Nintendo','Mario Kart WII','vgames',NULL,'/images/placeholder.png','Used but in working order','1','no',4.00,35.00,NULL,NULL,'2021-01-22 22:47:54'),(53,'12Volt Solutions','FRD-6-F1(X3L)','electronics',NULL,'/image/placeholder.png','Remote start for F150','1','no',8.00,75.00,NULL,NULL,'2021-01-24 23:07:00'),(54,'Nintendo','2DS','vgames',NULL,'/image/placeholder.png','With charger and case','1','no',20.00,100.00,NULL,NULL,'2021-01-24 23:26:18'),(55,'Nintendo ','WII U (Complete)','vgames',NULL,'/image/placeholder.png','Boxed, like new','1','no',105.00,200.00,NULL,NULL,'2021-01-24 23:28:34'),(56,'Nintendo','Jeopardy','vgames',NULL,'/image/placeholder.png','25th anniversary ed','1','no',4.00,15.00,NULL,NULL,'2021-01-24 23:31:16'),(57,'PS2','Drakan','vgames',NULL,'/image/placeholder.png','Boxed no manual','1','no',4.00,20.00,NULL,NULL,'2021-01-24 23:32:27'),(58,'Nintendo','DSLite ','computers',NULL,'/image/placeholder.png','Blue, no charger','1','no',20.00,55.00,NULL,NULL,'2021-01-24 23:35:56'),(59,'Apple','IIe Disk drives','computers',NULL,'/image/placeholder.png','untested','1','no',10.00,100.00,NULL,NULL,'2021-01-24 23:43:07'),(60,'Midland','13-895','electronics',NULL,'/image/placeholder.png','Powers on, no mic','1','no',20.00,100.00,NULL,NULL,'2021-01-24 23:54:07');


