CREATE TABLE `asset_audit` (
`audit_id` int(16) NOT NULL,
`audit_asset_id` varchar(16) NOT NULL,
`audit_date` date NOT NULL,
`audit_present` varchar(16) NOT NULL,
`audit_repairs` varchar(16) NOT NULL,
`audit_comment` varchar(256) NOT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
CREATE TABLE `asset` (
`asset_id` int(32) NOT NULL,
`type` varchar(64) NOT NULL,
`supplier` varchar(16) NOT NULL,
`asset_name` varchar(64) NOT NULL,
`asset_desc` varchar(128) NOT NULL,
`qty` int(32) NOT NULL,
`serial` varchar(32) NOT NULL,
`gcyo_id` varchar(32) NOT NULL,
`purch_date` date NOT NULL,
`purc_price` varchar(32) NOT NULL,
`invoice_num` varchar(32) NOT NULL,
`asset_image` varchar(256) NOT NULL
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;
INSERT INTO `asset_audit` (`audit_id`, `audit_asset_id`, `audit_date`, `audit_present`, `audit_repairs`, `audit_comment`) VALUES
(8, '1', '2023-03-01', '1', '0', 'this was the second audit of this piano, what a fine piano it is'),
(1, '1', '2023-02-01', '1', '0', 'this is the first audit date'),
(5, '1', '2023-04-04', '1', '0', 'these are the comments'),
(6, '1', '2023-04-04', '1', '1', 'repairs required'),
(7, '1', '2023-04-04', '0', '0', 'not in stock'),
(9, '3', '2023-04-02', '1', '0', 'this is the second asset');
INSERT INTO `asset` (`asset_id`, `type`, `supplier`, `asset_name`, `asset_desc`, `qty`, `serial`, `gcyo_id`, `purch_date`, `purc_price`, `invoice_num`, `asset_image`) VALUES
(1, '1', '1', 'Grand Piano', 'big piano on wheels', 1, '222333', '1001', '2023-04-03', '13,000.65', '1420TY445', 'images/1_Grand Piano.png'),
(3, '9', '3', 'Camera', 'avkans camera', 1, '22233333', '1004', '2023-03-28', '1,200.00', '1420TY44533', '');