pDWFn7QS

1DROP TABLE IF EXISTS `{dbPrefix}apartment_reference`;
2CREATE TABLE IF NOT EXISTS `{dbPrefix}apartment_reference` (
3  `reference_id` int(11) UNSIGNED NOT NULL DEFAULT '0',         //было   `reference_id` int(11) NOT NULL DEFAULT '0',
4  `reference_value_id` int(11) UNSIGNED NOT NULL DEFAULT '0',  //было `reference_value_id` int(11) NOT NULL DEFAULT '0',
5  `apartment_id` int(11) UNSIGNED NOT NULL DEFAULT '0',         //было   `apartment_id` int(11) NOT NULL DEFAULT '0',
6  KEY `apartment_id` (`apartment_id`),
7  KEY `reference_id` (`reference_id`),
8  KEY `reference_value_id` (`reference_value_id`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8;                         //было ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
10
11DROP TABLE IF EXISTS `{dbPrefix}users_sessions`;
12CREATE TABLE IF NOT EXISTS `{dbPrefix}users_sessions` (
13  `user_id` int(11) unsigned NOT NULL DEFAULT '0', //было `user_id` int(11) NOT NULL DEFAULT '0',
14  `id` char(32) NOT NULL DEFAULT '',
15  `expire` int(11) NOT NULL DEFAULT '0',  //было `expire` int(11) DEFAULT NULL,
16  `data` longblob NULL,
17  PRIMARY KEY (`id`),
18  KEY `yiisession_expire_idx` (`expire`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8;    //было ) ENGINE=MyISAM DEFAULT CHARSET=utf8;