TaskManager.php.create__SYNC_TASK_PERCENT.sql 600 B

12345678910111213
  1. CREATE TABLE IF NOT EXISTS `_SYNC_TASK_PERCENT` (
  2. `ID_TASK` int(11) NOT NULL,
  3. `ID_PARENT_TASK` int(11) NOT NULL DEFAULT 0,
  4. `A_PROBLEM_COMPLETE_PERCENT` varchar(6) NOT NULL DEFAULT '',
  5. `L_APPOITMENT_PERIOD` varchar(30) NOT NULL DEFAULT '',
  6. `A_SYNCHRONIZED` int(1) NOT NULL DEFAULT '0',
  7. `A_LAST_SYNC` datetime DEFAULT NULL,
  8. `SYNC_SORT_PRIO` int(11) NOT NULL DEFAULT '0',
  9. `CHILDS_COUNT` int(11) NOT NULL DEFAULT '0',
  10. `CHILDS_DONE_COUNT` int(11) NOT NULL DEFAULT '0',
  11. UNIQUE KEY `ID_TASK` (`ID_TASK`),
  12. KEY `ID_PARENT_TASK` (`ID_PARENT_TASK`)
  13. ) ENGINE=MyISAM DEFAULT CHARSET=latin2;