CREATE TABLE `product_serial` ( `id` int(11) NOT NULL AUTO_INCREMENT, `serial` int(11) DEFAULT NULL, `uid` varchar(255) DEFAULT NULL, `cg` int(11) DEFAULT NULL, `issueddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1