· 8 years ago · May 03, 2018, 09:00 PM
1DROP TABLE IF EXISTS `mq_cron`;
2CREATE TABLE `mq_cron` (
3 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
4 `akce` TEXT NULL,
5 `komentar` LONGTEXT NULL,
6 `datcas` BIGINT(20) NOT NULL,
7 `prikaz` INT(10) UNSIGNED NOT NULL DEFAULT '0',
8 `data_int0` INT(10) NOT NULL DEFAULT '0',
9 `data_int1` INT(10) NOT NULL DEFAULT '0',
10 `data_int2` INT(10) NOT NULL DEFAULT '0',
11 `data_int3` INT(10) NOT NULL DEFAULT '0',
12 `data_int4` INT(10) NOT NULL DEFAULT '0',
13 `data_text0` CHAR(200) NOT NULL DEFAULT '',
14 `data_text1` CHAR(200) NOT NULL DEFAULT '',
15 `data_text2` CHAR(200) NOT NULL DEFAULT '',
16 `data_text3` CHAR(200) NOT NULL DEFAULT '',
17 `data_text4` CHAR(200) NOT NULL DEFAULT '',
18 `complete` INT(5) UNSIGNED NOT NULL DEFAULT '0',
19 `complete_datcas` BIGINT(20) NULL DEFAULT NULL,
20 `complete_log` LONGTEXT NULL,
21 PRIMARY KEY (`id`)
22)
23COLLATE='utf8_general_ci'
24ENGINE=InnoDB
25ROW_FORMAT=DEFAULT