CREATE TABLE IF NOT EXISTS `lab_tblcare` (
`careid` int(3) NOT NULL,
  `strcode` varchar(7) NOT NULL,
  `marktyp` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `pic` varchar(100) NOT NULL,
  `type` varchar(5) NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `approved` varchar(3) NOT NULL DEFAULT 'no'
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Daten für Tabelle `lab_tblcare`
--

INSERT INTO `lab_tblcare` (`careid`, `strcode`, `marktyp`, `description`, `pic`, `type`, `modified`, `approved`) VALUES
(1, 'LBXABZZ', 'multiple', '              \r\n                                 \r\n                   <p><span style="color: rgb(51, 51, 51); font-family: " helvetica="" neue",="" helvetica,="" arial,="" sans-serif;="" font-size:="" 30px;="" background-color:="" rgb(248,="" 248,="" 248);"="">60° Waschen, Chlor- und Sauerstoffbleiche, nicht Trocknen im Trumbier, nicht heiß bügeln, Professionelle Textilpflege</span></p>', 'uploads/cares/5317a2e065.png', 'image', '2025-10-28 16:43:22', 'no');

ALTER TABLE `lab_tblcare`
 ADD PRIMARY KEY (`careid`);

ALTER TABLE `lab_tblcare`
MODIFY `careid` int(3) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;