yBNquCVs

1DROP TABLE IF EXISTS `sessions_temp`;
2CREATE TABLE IF NOT EXISTS `sessions_temp` (
3  `id` varchar(64) NOT NULL DEFAULT '',
4  `customers_id` int(11) unsigned DEFAULT NULL,
5  `data` text NOT NULL,
6  `modified` int(11) NOT NULL,
7  `lifetime` int(11) NOT NULL,
8  `force_update` tinyint(1) unsigned DEFAULT NULL,
9  UNIQUE KEY `id` (`id`),
10  KEY `customers_id` (`customers_id`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12
13RENAME TABLE sessions TO sessions_old,
14             sessions_temp TO sessions;
15
16INSERT INTO sessions
17SELECT * FROM sessions_old as s
18WHERE s.customers_id <> 22509;