phpbb_dm ?????? ?? ??????? , ?? ?????? phpbb_dm ???? ????? ???????? , ?????? ????? ????????? ?????? ????? ???????? ?? phpbb_ ? ?? ???? ?? ?? ????? ????? ???????? ???? , ???? ??? ??? ??? ????? ????? ???????? ???? bb_ ?? ???????? ?? ?? ??
? ??????? ?????? ?????? ?????? ???????? ? ???????? , ????? ??? ????? ?? ??????
? ?? ?????? ???? ????? ? ????? ???? ???? ???????? ? ??? , ?? ?????? ?? ???? ????? ???????
كود: تحديد الكل
CREATE DATABASE IF NOT EXISTS `phpbb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `phpbb`;
-- --------------------------------------------------------
--
-- Tabellenstruktur f?r Tabelle `phpbb_dm_video`
--
CREATE TABLE IF NOT EXISTS `phpbb_dm_video` (
`video_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`video_title` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`video_url` mediumtext COLLATE utf8_bin NOT NULL,
`video_songtext` mediumtext COLLATE utf8_bin NOT NULL,
`video_singer` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`video_duration` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`video_user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`video_username` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
`video_time` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
`video_cat_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`video_approval` tinyint(3) NOT NULL DEFAULT '0',
`video_counter` int(11) unsigned NOT NULL DEFAULT '0',
`video_votetotal` int(8) unsigned NOT NULL DEFAULT '0',
`video_votesum` int(8) unsigned NOT NULL DEFAULT '0',
`last_poster_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`last_poster_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`last_poster_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
`last_poster_time` int(11) unsigned NOT NULL DEFAULT '0',
`last_poster_cat_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`video_image` tinytext COLLATE utf8_bin NOT NULL,
`bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`bbcode_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
`bbcode_options` mediumint(4) NOT NULL DEFAULT '0',
`video_reported` tinyint(1) NOT NULL DEFAULT '1',
`enable_magic_url` tinyint(1) NOT NULL DEFAULT '0',
`enable_smilies` tinyint(1) NOT NULL DEFAULT '0',
`enable_bbcode` tinyint(1) NOT NULL DEFAULT '0',
`video_announced` tinyint(1) NOT NULL DEFAULT '0',
`video_points` int(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`video_id`),
KEY `video_cat_id` (`video_cat_id`),
KEY `video_user_id` (`video_user_id`),
KEY `video_time` (`video_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
--
-- Daten f?r Tabelle `phpbb_dm_video`
--
INSERT INTO `phpbb_dm_video` (`video_id`, `video_title`, `video_url`, `video_songtext`, `video_singer`, `video_duration`, `video_user_id`, `video_username`, `video_time`, `video_cat_id`, `video_approval`, `video_counter`, `video_votetotal`, `video_votesum`, `last_poster_id`, `last_poster_name`, `last_poster_colour`, `last_poster_time`, `last_poster_cat_id`, `video_image`, `bbcode_bitfield`, `bbcode_uid`, `bbcode_options`, `video_reported`, `enable_magic_url`, `enable_smilies`, `enable_bbcode`, `video_announced`, `video_points`) VALUES
(1, '??? ?? ??? ??????', 'http://www.youtube.com/watch?v=CwrL94dVQQs', '??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? \n\n??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? \n\n??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ???\n\n??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? \n\n??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ???', '??? ? ???', '', 2, 'Admin-C', '1387800356', 1, 1, 6, 0, 0, 2, 'Admin-C', 'AA0000', 1387800356, 1, '', '', '', 7, 1, 1, 1, 1, 0, 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur f?r Tabelle `phpbb_dm_video_cat`
--
CREATE TABLE IF NOT EXISTS `phpbb_dm_video_cat` (
`cat_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`left_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
`right_id` mediumint(8) unsigned NOT NULL DEFAULT '2',
`cat_parents` mediumtext COLLATE utf8_bin NOT NULL,
`cat_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`cat_desc` mediumtext COLLATE utf8_bin NOT NULL,
`cat_desc_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
`cat_desc_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`cat_desc_options` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=5 ;
--
-- Daten f?r Tabelle `phpbb_dm_video_cat`
--
INSERT INTO `phpbb_dm_video_cat` (`cat_id`, `parent_id`, `left_id`, `right_id`, `cat_parents`, `cat_name`, `cat_desc`, `cat_desc_uid`, `cat_desc_bitfield`, `cat_desc_options`) VALUES
(1, 0, 1, 4, '', '????????????????????????', '', '', '', 7),
(2, 0, 5, 8, '', '?????????????????????', '', '', '', 7),
(3, 1, 2, 3, '', '??? ?????', '', '', '', 7),
(4, 2, 6, 7, '', '??? ?????', '', '', '', 7);
-- --------------------------------------------------------
--
-- Tabellenstruktur f?r Tabelle `phpbb_dm_video_comment`
--
CREATE TABLE IF NOT EXISTS `phpbb_dm_video_comment` (
`comment_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`video_id` int(11) unsigned NOT NULL DEFAULT '0',
`video_user_id` int(8) unsigned NOT NULL DEFAULT '0',
`video_username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`video_user_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
`video_time` int(11) unsigned NOT NULL DEFAULT '0',
`video_comment` mediumtext COLLATE utf8_bin NOT NULL,
`comment_bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`comment_bbcode_options` int(4) unsigned NOT NULL DEFAULT '0',
`comment_bbcode_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
`enable_magic_url` tinyint(1) NOT NULL DEFAULT '1',
`enable_smilies` tinyint(1) NOT NULL DEFAULT '1',
`enable_bbcode` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur f?r Tabelle `phpbb_dm_video_config`
--
CREATE TABLE IF NOT EXISTS `phpbb_dm_video_config` (
`config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`config_value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`config_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Daten f?r Tabelle `phpbb_dm_video_config`
--
INSERT INTO `phpbb_dm_video_config` (`config_name`, `config_value`) VALUES
('copyright_email', 'sample@yourdomain.com'),
('copyright_show', 'Sample At Yourdomain Dot Com'),
('delicious_enable', '1'),
('digg_enable', '1'),
('facebook_enable', '1'),
('facebook_path', ''),
('myspace_enable', '1'),
('new_video_pm_from', '2'),
('new_video_pm_to', '2'),
('newest_videos', '5'),
('share_enable', '1'),
('technorati_enable', '1'),
('top_ratings', '10'),
('top_views', '10'),
('video_announce_enable', '0'),
('video_announce_forum_id', '0'),
('video_comments_page1', '5'),
('video_page_acp', '15'),
('video_page_comment', '15'),
('video_page_user', '15'),
('video_points_enable', '0'),
('video_points_value', '0');
-- --------------------------------------------------------
--
-- Tabellenstruktur f?r Tabelle `phpbb_dm_video_rating`
--
CREATE TABLE IF NOT EXISTS `phpbb_dm_video_rating` (
`video_id` int(8) unsigned NOT NULL DEFAULT '0',
`user_id` int(8) unsigned NOT NULL DEFAULT '0',
`video_rating` int(8) unsigned NOT NULL DEFAULT '0',
`rating_date` int(11) unsigned NOT NULL DEFAULT '0',
`user_ip` varchar(40) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`video_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;