CREATE TABLE `data_synchronize` (
`vn` varchar(13) NOT NULL DEFAULT '',
`vn_guid` varchar(38) DEFAULT NULL,
`hn_guid` varchar(38) DEFAULT NULL,
`cid` varchar(17) DEFAULT NULL,
`last_update` datetime DEFAULT NULL,
`last_sync` datetime DEFAULT NULL,
`sync_complete` char(1) DEFAULT NULL,
`sync_mode` varchar(10) DEFAULT NULL,
`department` char(3) DEFAULT NULL,
PRIMARY KEY (`vn`),
KEY `cid` (`cid`),
KEY `hn_guid` (`hn_guid`),
KEY `last_sync` (`last_sync`),
KEY `last_update` (`last_update`),
KEY `sync_complete` (`sync_complete`),
KEY `sync_mode` (`sync_mode`),
KEY `vn_guid` (`vn_guid`)
) ENGINE=myisam DEFAULT CHARSET=tis620