DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `price` int NOT NULL,
  `tax` float NOT NULL DEFAULT 2.5,
  `description` varchar(1000) NOT NULL,
  `stock` int NOT NULL,
  `weight` int NOT NULL,
  `category` int NOT NULL,
  `location` varchar(200) NOT NULL,
  `listed_timestamp` datetime NOT NULL,
  `pending` boolean NOT NULL,
  `archived` boolean NOT NULL,
  `archived_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
);