mysql的慢查询日志记录了以下语句的执行比较慢,请那位高手帮忙优化一下表的索引。
______________________________________________________________________ 001 ___
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S') AND profilevalue_3 LIKE 'S' ORDER BY user_dateupdated DESC LIMIT N, N;Query sample:
SET timestamp=1243433801;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0') AND profilevalue_3 LIKE '%616234235%' ORDER BY user_dateupdated DESC LIMIT 0, 24;______________________________________________________________________ 002 ___
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S') AND (month(profilevalue_4)=month('S') OR month('S')=N) AND (day(profilevalue_4)=day('S') OR day('S')=N) AND (year(profilevalue_4)=year('S') OR year('S')=N) ORDER BY user_dateupdated DESC LIMIT N, N;Query sample:
SET timestamp=1243434036;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0') AND (MONTH(profilevalue_4)=MONTH('1975-06-28') OR MONTH('1975-06-28')=0) AND (DAY(profilevalue_4)=DAY('1975-06-28') OR DAY('1975-06-28')=0) AND (YEAR(profilevalue_4)=YEAR('1975-06-28') OR YEAR('1975-06-28')=0) ORDER BY user_dateupdated DESC LIMIT 0, 24;______________________________________________________________________ 003 ___
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S') AND (se_users.user_username LIKE 'S' OR CONCAT(se_users.user_fname, 'S', se_users.user_lname) LIKE 'S' OR se_profilevalues.profilevalue_2 LIKE 'S' OR se_profilevalues.profilevalue_3 LIKE 'S' OR se_profilevalues.profilevalue_5 IN (SELECT CASE WHEN languagevar_id='S' THEN N WHEN languagevar_id='S' THEN N end AS value FROM se_languagevars WHERE languagevar_id IN (N2) AND languagevar_value LIKE 'S')) ORDER BY se_users.user_id DESC LIMIT N, N;Query sample:
SET timestamp=1243478371;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0') AND (se_users.user_username LIKE '%392255693%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_2` LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_3` LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_5` IN (SELECT CASE WHEN languagevar_id='500382' THEN 1 WHEN languagevar_id='500383' THEN 2 END AS value FROM se_languagevars WHERE languagevar_id IN (500382, 500383) AND languagevar_value LIKE '%392255693%')) ORDER BY se_users.user_id DESC LIMIT 0, 21;______________________________________________________________________ 004 ___
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S') AND (se_users.user_username LIKE 'S' OR CONCAT(se_users.user_fname, 'S', se_users.user_lname) LIKE 'S' OR se_profilevalues.profilevalue_2 LIKE 'S' OR se_profilevalues.profilevalue_3 LIKE 'S' OR se_profilevalues.profilevalue_5 IN (SELECT CASE WHEN languagevar_id='S' THEN N WHEN languagevar_id='S' THEN N end AS value FROM se_languagevars WHERE languagevar_id IN (N2) AND languagevar_value LIKE 'S')) LIMIT N;Query sample:
SET timestamp=1243478231;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0') AND (se_users.user_username LIKE '%392255693%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_2` LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_3` LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_5` IN (SELECT CASE WHEN languagevar_id='500382' THEN 1 WHEN languagevar_id='500383' THEN 2 END AS value FROM se_languagevars WHERE languagevar_id IN (500382, 500383) AND languagevar_value LIKE '%392255693%')) LIMIT 201;
______________________________________________________________________ 001 ___
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S') AND profilevalue_3 LIKE 'S' ORDER BY user_dateupdated DESC LIMIT N, N;Query sample:
SET timestamp=1243433801;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0') AND profilevalue_3 LIKE '%616234235%' ORDER BY user_dateupdated DESC LIMIT 0, 24;______________________________________________________________________ 002 ___
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S') AND (month(profilevalue_4)=month('S') OR month('S')=N) AND (day(profilevalue_4)=day('S') OR day('S')=N) AND (year(profilevalue_4)=year('S') OR year('S')=N) ORDER BY user_dateupdated DESC LIMIT N, N;Query sample:
SET timestamp=1243434036;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0') AND (MONTH(profilevalue_4)=MONTH('1975-06-28') OR MONTH('1975-06-28')=0) AND (DAY(profilevalue_4)=DAY('1975-06-28') OR DAY('1975-06-28')=0) AND (YEAR(profilevalue_4)=YEAR('1975-06-28') OR YEAR('1975-06-28')=0) ORDER BY user_dateupdated DESC LIMIT 0, 24;______________________________________________________________________ 003 ___
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S') AND (se_users.user_username LIKE 'S' OR CONCAT(se_users.user_fname, 'S', se_users.user_lname) LIKE 'S' OR se_profilevalues.profilevalue_2 LIKE 'S' OR se_profilevalues.profilevalue_3 LIKE 'S' OR se_profilevalues.profilevalue_5 IN (SELECT CASE WHEN languagevar_id='S' THEN N WHEN languagevar_id='S' THEN N end AS value FROM se_languagevars WHERE languagevar_id IN (N2) AND languagevar_value LIKE 'S')) ORDER BY se_users.user_id DESC LIMIT N, N;Query sample:
SET timestamp=1243478371;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0') AND (se_users.user_username LIKE '%392255693%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_2` LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_3` LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_5` IN (SELECT CASE WHEN languagevar_id='500382' THEN 1 WHEN languagevar_id='500383' THEN 2 END AS value FROM se_languagevars WHERE languagevar_id IN (500382, 500383) AND languagevar_value LIKE '%392255693%')) ORDER BY se_users.user_id DESC LIMIT 0, 21;______________________________________________________________________ 004 ___
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S') AND (se_users.user_username LIKE 'S' OR CONCAT(se_users.user_fname, 'S', se_users.user_lname) LIKE 'S' OR se_profilevalues.profilevalue_2 LIKE 'S' OR se_profilevalues.profilevalue_3 LIKE 'S' OR se_profilevalues.profilevalue_5 IN (SELECT CASE WHEN languagevar_id='S' THEN N WHEN languagevar_id='S' THEN N end AS value FROM se_languagevars WHERE languagevar_id IN (N2) AND languagevar_value LIKE 'S')) LIMIT N;Query sample:
SET timestamp=1243478231;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0') AND (se_users.user_username LIKE '%392255693%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_2` LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_3` LIKE '%392255693%' OR `se_profilevalues`.`profilevalue_5` IN (SELECT CASE WHEN languagevar_id='500382' THEN 1 WHEN languagevar_id='500383' THEN 2 END AS value FROM se_languagevars WHERE languagevar_id IN (500382, 500383) AND languagevar_value LIKE '%392255693%')) LIMIT 201;
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_profilecat_id='S' AND se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S');Query sample:
SET timestamp=1243459113;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_profilecat_id='1' AND se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0');______________________________________________________________________ 006 ___
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S') AND profilevalue_5='S';Query sample:
SET timestamp=1243631988;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0') AND profilevalue_5='2';______________________________________________________________________ 007 ___
Query abstract:
SET timestamp=N; SELECT COUNT(location_id) AS total FROM rc_locations JOIN se_users ON se_users.user_id = rc_locations.location_user_id WHERE location_country LIKE 'S';Query sample:
SET timestamp=1243444784;
SELECT COUNT(location_id) as total FROM rc_locations JOIN se_users ON se_users.user_id = rc_locations.location_user_id WHERE location_country LIKE '%涓浗%';______________________________________________________________________ 008 ___
Query abstract:
SET timestamp=N; SELECT COUNT(location_id) AS total FROM rc_locations JOIN se_users ON se_users.user_id = rc_locations.location_user_id WHERE location_name LIKE 'S';Query sample:
SET timestamp=1243436355;
SELECT COUNT(location_id) as total FROM rc_locations JOIN se_users ON se_users.user_id = rc_locations.location_user_id WHERE location_name LIKE '%灞呬綇鍦?';______________________________________________________________________ 009 ___
Query abstract:
SET timestamp=N; SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='S' AND se_users.user_enabled='S' AND (se_users.user_search='S' OR se_levels.level_profile_search='S') AND profilevalue_5='S' ORDER BY user_dateupdated DESC LIMIT N, N;Query sample:
SET timestamp=1243564654;
SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0') AND profilevalue_5='1' ORDER BY user_dateupdated DESC LIMIT 0, 24;______________________________________________________________________ 010 ___
Query abstract:
SET timestamp=N; SELECT COUNT(location_id) AS total FROM rc_locations JOIN se_users ON se_users.user_id = rc_locations.location_user_id;Query sample:
SET timestamp=1243470555;
SELECT COUNT(location_id) as total FROM rc_locations JOIN se_users ON se_users.user_id = rc_locations.location_user_id;
CREATE TABLE IF NOT EXISTS `se_profilevalues` (
`profilevalue_id` int(9) NOT NULL AUTO_INCREMENT,
`profilevalue_user_id` int(9) NOT NULL DEFAULT '0',
`profilevalue_2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`profilevalue_3` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`profilevalue_4` date NOT NULL DEFAULT '0000-00-00',
`profilevalue_5` int(2) DEFAULT '-1',
PRIMARY KEY (`profilevalue_id`),
KEY `INDEX` (`profilevalue_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1762925 ;CREATE TABLE IF NOT EXISTS `se_users` (
`user_id` int(9) NOT NULL AUTO_INCREMENT,
`user_level_id` int(9) NOT NULL DEFAULT '0',
`user_subnet_id` int(9) NOT NULL DEFAULT '0',
`user_profilecat_id` int(9) NOT NULL DEFAULT '0',
`user_email` varchar(70) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_newemail` varchar(70) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_fname` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_lname` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_username` int(9) NOT NULL,
`user_displayname` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`user_password` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_password_method` tinyint(1) NOT NULL DEFAULT '0',
`user_code` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_enabled` int(1) NOT NULL DEFAULT '0',
`user_verified` int(1) NOT NULL DEFAULT '0',
`user_language_id` int(9) NOT NULL DEFAULT '0',
`user_signupdate` int(14) NOT NULL DEFAULT '0',
`user_lastlogindate` int(14) NOT NULL DEFAULT '0',
`user_lastactive` int(14) NOT NULL DEFAULT '0',
`user_ip_signup` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_ip_lastactive` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_status` varchar(190) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_status_date` int(14) NOT NULL DEFAULT '0',
`user_logins` int(9) NOT NULL DEFAULT '0',
`user_invitesleft` int(3) NOT NULL DEFAULT '0',
`user_timezone` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_dateupdated` int(14) NOT NULL DEFAULT '0',
`user_blocklist` text COLLATE utf8_unicode_ci,
`user_invisible` int(1) NOT NULL DEFAULT '0',
`user_saveviews` int(1) NOT NULL DEFAULT '0',
`user_photo` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`user_search` int(1) NOT NULL DEFAULT '0',
`user_privacy` int(2) NOT NULL DEFAULT '0',
`user_comments` int(2) NOT NULL DEFAULT '0',
`user_hasnotifys` tinyint(1) NOT NULL DEFAULT '0',
`user_profile_album` enum('tab','side') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'tab',
`user_privacy_winks` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`wink_total` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_username` (`user_username`),
UNIQUE KEY `user_email` (`user_email`),
KEY `dateupdated_idx` (`user_dateupdated`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1762922 ;
rc_locations 表不存在,建议提供 create table 信息。估计其它表可能也有。建议你一个一个语句来问,某则太多的语句很容易混乱。写出一句需要优化的SQL语句。
写出这个SQL语句中相关的表信息。
测试一下在你自己的机器上执行花了多久?
给出explain sql.... 这个语句的信息。
`location_id` int(9) NOT NULL AUTO_INCREMENT,
`location_user_id` int(9) NOT NULL DEFAULT '0',
`location_name` varchar(20) NOT NULL,
`location_address` varchar(50) NOT NULL,
`location_city` varchar(30) NOT NULL,
`location_region` varchar(20) NOT NULL,
`location_country` varchar(20) NOT NULL,
`location_notes` text,
PRIMARY KEY (`location_id`),
KEY `INDEX` (`location_user_id`),
KEY `location_idx` (`location_country`,`location_region`,`location_city`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1751682 ;
`level_id` int(9) NOT NULL AUTO_INCREMENT,
`level_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`level_desc` text COLLATE utf8_unicode_ci NOT NULL,
`level_default` int(1) NOT NULL DEFAULT '0',
`level_signup` int(1) NOT NULL DEFAULT '0',
`level_message_allow` int(1) NOT NULL DEFAULT '0',
`level_message_inbox` int(3) NOT NULL DEFAULT '0',
`level_message_outbox` int(3) NOT NULL DEFAULT '0',
`level_message_recipients` int(3) NOT NULL DEFAULT '1',
`level_profile_style` int(1) NOT NULL DEFAULT '0',
`level_profile_style_sample` int(1) NOT NULL DEFAULT '0',
`level_profile_block` int(1) NOT NULL DEFAULT '0',
`level_profile_search` int(1) NOT NULL DEFAULT '0',
`level_profile_privacy` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`level_profile_comments` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`level_profile_status` int(1) NOT NULL DEFAULT '0',
`level_profile_invisible` int(1) NOT NULL,
`level_profile_views` int(1) NOT NULL,
`level_profile_change` int(1) NOT NULL DEFAULT '0',
`level_profile_delete` int(1) NOT NULL DEFAULT '0',
`level_photo_allow` int(1) NOT NULL DEFAULT '0',
`level_photo_width` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`level_photo_height` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`level_photo_exts` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`level_album_allow` int(1) NOT NULL DEFAULT '1',
`level_album_maxnum` int(3) NOT NULL DEFAULT '10',
`level_album_exts` text COLLATE utf8_unicode_ci NOT NULL,
`level_album_mimes` text COLLATE utf8_unicode_ci NOT NULL,
`level_album_storage` bigint(11) NOT NULL DEFAULT '5242880',
`level_album_maxsize` bigint(11) NOT NULL DEFAULT '2048000',
`level_album_width` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '500',
`level_album_height` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '500',
`level_album_style` int(1) NOT NULL DEFAULT '1',
`level_album_search` int(1) NOT NULL DEFAULT '1',
`level_album_privacy` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a:6:{i:0;s:1:"1";i:1;s:1:"3";i:2;s:1:"7";i:3;s:2:"15";i:4;s:2:"31";i:5;s:2:"63";}',
`level_album_comments` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a:7:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"3";i:3;s:1:"7";i:4;s:2:"15";i:5;s:2:"31";i:6;s:2:"63";}',
`level_album_profile` set('side','tab') COLLATE utf8_unicode_ci DEFAULT NULL,
`level_album_tag` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a:7:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"3";i:3;s:1:"7";i:4;s:2:"15";i:5;s:2:"31";i:6;s:2:"63";}',
`level_blog_view` tinyint(3) unsigned NOT NULL DEFAULT '1',
`level_blog_create` tinyint(3) unsigned NOT NULL DEFAULT '1',
`level_blog_entries` smallint(5) unsigned NOT NULL DEFAULT '20',
`level_blog_style` tinyint(3) unsigned NOT NULL DEFAULT '1',
`level_blog_search` tinyint(3) unsigned NOT NULL DEFAULT '1',
`level_blog_privacy` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a:6:{i:0;s:1:"1";i:1;s:1:"3";i:2;s:1:"7";i:3;s:2:"15";i:4;s:2:"31";i:5;s:2:"63";}',
`level_blog_comments` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a:7:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"3";i:3;s:1:"7";i:4;s:2:"15";i:5;s:2:"31";i:6;s:2:"63";}',
`level_blog_trackbacks_allow` tinyint(4) NOT NULL DEFAULT '1',
`level_blog_trackbacks_detect` tinyint(4) NOT NULL DEFAULT '1',
`level_blog_html` text COLLATE utf8_unicode_ci,
`level_blog_category_create` tinyint(4) NOT NULL DEFAULT '1',
`level_chat_allow` tinyint(3) unsigned NOT NULL DEFAULT '1',
`level_im_allow` tinyint(3) unsigned NOT NULL DEFAULT '1',
`level_group_allow` tinyint(1) NOT NULL DEFAULT '7',
`level_group_photo` tinyint(1) NOT NULL DEFAULT '1',
`level_group_photo_width` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '200',
`level_group_photo_height` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '200',
`level_group_photo_exts` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'jpeg,jpg,gif,png',
`level_group_titles` int(1) NOT NULL DEFAULT '1',
`level_group_officers` int(1) NOT NULL DEFAULT '1',
`level_group_approval` int(1) NOT NULL DEFAULT '1',
`level_group_style` int(1) NOT NULL DEFAULT '1',
`level_group_album_exts` text COLLATE utf8_unicode_ci,
`level_group_album_mimes` text COLLATE utf8_unicode_ci,
`level_group_album_storage` bigint(11) NOT NULL DEFAULT '5242880',
`level_group_album_maxsize` bigint(11) NOT NULL DEFAULT '2048000',
`level_group_album_width` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '500',
`level_group_album_height` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '500',
`level_group_maxnum` int(3) NOT NULL DEFAULT '10',
`level_group_search` int(1) NOT NULL DEFAULT '1',