1 DROP TABLE IF EXISTS `fer_inventura`;
2 CREATE TABLE `fer_inventura` (
3 `date_scanned` date NOT NULL,
4 `barcode` varchar(20) NOT NULL,
5 `source_id` varchar(20) NOT NULL,
6 `timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
7 UNIQUE KEY `fer_inventura_unique` (`barcode`,`date_scanned`,`source_id`)