database: gb_support2
steps: execute DELETE FROM email;
schema:
CREATE TABLE IF NOT EXISTS `email` (
`id` char(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`time` datetime NOT NULL,
`from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`to` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`),
KEY `time` (`time`),
FULLTEXT KEY `email_full_text` (`text`,`from`,`to`,`subject`,`comment`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Table have 76514 items.
Size of instance 662 MB.
Instance have only one database with one table.
No comments:
Post a Comment