· 7 years ago · Jan 16, 2019, 05:44 PM
1Было:
2DROP TABLE IF EXISTS `{dbPrefix}advertising_area`;
3CREATE TABLE IF NOT EXISTS `{dbPrefix}advertising_area` (
4 `id` int(11) NOT NULL AUTO_INCREMENT,
5 `id_advertising` int(11) NOT NULL DEFAULT '0',
6 `page` text NULL,
7 `date_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
8 PRIMARY KEY (`id`)
9) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
10
11Ñтало:
12) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
13
14DROP TABLE IF EXISTS `{dbPrefix}advertising_area`;
15CREATE TABLE IF NOT EXISTS `{dbPrefix}advertising_area` (
16 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
17 `id_advertising` int(11) NOT NULL DEFAULT '0',
18 `page` text NULL,
19 `date_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
20 PRIMARY KEY (`id`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;