منتديات phpBBArabia

كود: تحديد الكل

DROP TABLE IF EXISTS `phpbb_im`;
CREATE TABLE IF NOT EXISTS `phpbb_im` (
  `from` mediumint(8) NOT NULL,
  `to` mediumint(8) NOT NULL,
  `message` text collate utf8_bin NOT NULL,
  `sent` int(11) NOT NULL,
  `recd` tinyint(1) unsigned NOT NULL default '0',
  KEY `sent` (`sent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

DROP TABLE IF EXISTS `phpbb_users_im`;
CREATE TABLE IF NOT EXISTS `phpbb_users_im` (
  `user_id` mediumint(9) NOT NULL,
  `user_status` varchar(1024) default NULL,
  `user_deny_im` tinyint(1) default '0',
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `phpbb_config` (config_name, config_value, is_dynamic) VALUES ( 'im_only_friends', '1', 1);

كود: تحديد الكل

DROP TABLE IF EXISTS `phpbb_im`;
CREATE TABLE IF NOT EXISTS `phpbb_im` (
  `from` mediumint(8) NOT NULL,
  `to` mediumint(8) NOT NULL,
  `message` text collate utf8_bin NOT NULL,
  `sent` int(11) NOT NULL,
  `recd` tinyint(1) unsigned NOT NULL default '0',
  KEY `sent` (`sent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;