CREATE TABLE IF NOT EXISTS `_SYNC_TASK_PERCENT` ( `ID_TASK` int(11) NOT NULL, `ID_PARENT_TASK` int(11) NOT NULL DEFAULT 0, `A_PROBLEM_COMPLETE_PERCENT` varchar(6) NOT NULL DEFAULT '', `L_APPOITMENT_PERIOD` varchar(30) NOT NULL DEFAULT '', `A_SYNCHRONIZED` int(1) NOT NULL DEFAULT '0', `A_LAST_SYNC` datetime DEFAULT NULL, `SYNC_SORT_PRIO` int(11) NOT NULL DEFAULT '0', `CHILDS_COUNT` int(11) NOT NULL DEFAULT '0', `CHILDS_DONE_COUNT` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `ID_TASK` (`ID_TASK`), KEY `ID_PARENT_TASK` (`ID_PARENT_TASK`) ) ENGINE=MyISAM DEFAULT CHARSET=latin2;