$res = mysql_query("INSERT INTO
b_lists_users_ids
SET user_vk_id = ".$_POST['user_vk_id']."
, bl_acc_to_app = '1'
, not_srch_posts_vk = '1'
, reason = '".mysql_real_escape_string($_POST['reason'])."'
, user_vk_id_add = '".$_SESSION['vk_id']."'
, date_add = UNIX_TIMESTAMP()
, user_vk_id_edit = '".$_SESSION['vk_id']."'
, date_edit = UNIX_TIMESTAMP()
ON DUPLICATE KEY UPDATE
is_active = '1'
, bl_acc_to_app = '1'
, not_srch_posts_vk = '1'
, reason = '".mysql_real_escape_string($_POST['reason'])."'
, user_vk_id_edit = '".$_SESSION['vk_id']."'
, date_edit = UNIX_TIMESTAMP()
");
CREATE TABLE IF NOT EXISTS `b_lists_users_ids` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_vk_id` bigint(20) unsigned NOT NULL,
`b_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`reason` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`user_vk_id_add` bigint(20) unsigned NOT NULL,
`date_add` int(10) unsigned NOT NULL,
`user_vk_id_edit` bigint(20) unsigned NOT NULL,
`date_edit` int(10) unsigned NOT NULL,
`is_active` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
`bl_acc_to_app` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
`not_srch_posts_vk` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `user_vk_id` (`user_vk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=259 ;