
CREATE TABLE IF NOT EXISTS `lab_tblcloth` (
`clothid` int(3) NOT NULL,
  `name` varchar(50) NOT NULL,
  `careid` int(3) NOT NULL,
  `colorvalue` varchar(7) NOT NULL,
  `trade` varchar(50) NOT NULL,
  `fabricweight` varchar(20) NOT NULL,
  `pic` varchar(100) NOT NULL,
  `type` varchar(5) NOT NULL,
  `description` text NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `approved` varchar(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

ALTER TABLE `lab_tblcloth`
 ADD PRIMARY KEY (`clothid`);

ALTER TABLE `lab_tblcloth`
MODIFY `clothid` int(3) NOT NULL AUTO_INCREMENT;
