· 9 years ago · Jan 17, 2017, 04:16 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.8
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Aug 29, 2014 at 03:37 PM
7-- Server version: 5.0.96-community
8-- PHP Version: 5.4.23
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `adv`
23--
24
25CREATE TABLE IF NOT EXISTS `adv` (
26 `adv_id` bigint(20) NOT NULL auto_increment,
27 `adv_group` tinyint(3) unsigned NOT NULL default '0',
28 `adv_name` varchar(99) NOT NULL default '',
29 `adv_text` text NOT NULL,
30 `adv_views` bigint(20) NOT NULL default '0',
31 `adv_click` bigint(20) NOT NULL default '0',
32 `adv_addtime` bigint(20) NOT NULL default '0',
33 `adv_status` enum('1','0') NOT NULL default '1',
34 PRIMARY KEY (`adv_id`),
35 KEY `adv_group` (`adv_group`),
36 KEY `adv_addtime` (`adv_addtime`),
37 KEY `adv_status` (`adv_status`)
38) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
39
40
41--
42-- Table structure for table `adv_group`
43--
44
45CREATE TABLE IF NOT EXISTS `adv_group` (
46 `advgrp_id` tinyint(3) unsigned NOT NULL default '0',
47 `advgrp_name` varchar(99) NOT NULL default '',
48 `total_advs` bigint(20) NOT NULL default '0',
49 `advgrp_rotate` enum('1','0') NOT NULL default '1',
50 `advgrp_status` enum('1','0') NOT NULL default '1',
51 `adv_width` tinyint(4) unsigned NOT NULL default '0',
52 `adv_height` tinyint(4) unsigned NOT NULL default '0',
53 KEY `advgrp_name` (`advgrp_name`),
54 KEY `advgrp_rotate` (`advgrp_rotate`),
55 KEY `advgrp_status` (`advgrp_status`)
56) ENGINE=MyISAM DEFAULT CHARSET=utf8;
57
58--
59-- Dumping data for table `adv_group`
60--
61
62INSERT INTO `adv_group` (`advgrp_id`, `advgrp_name`, `total_advs`, `advgrp_rotate`, `advgrp_status`, `adv_width`, `adv_height`) VALUES
63(1, 'index_right', 0, '1', '1', 0, 0),
64(2, 'index_bottom', 0, '1', '1', 0, 0),
65(3, 'videos_right', 0, '1', '1', 0, 0),
66(4, 'videos_bottom', 0, '1', '1', 0, 0),
67(5, 'categories_right', 0, '1', '1', 0, 0),
68(6, 'categories_bottom', 0, '1', '1', 0, 0),
69(7, 'community_right', 0, '1', '1', 0, 0),
70(8, 'community_bottom', 0, '1', '1', 0, 0),
71(9, 'blogs_lefts', 0, '1', '1', 0, 0),
72(10, 'blogs_right', 0, '1', '1', 0, 0),
73(11, 'blogs_bottom', 0, '1', '1', 0, 0),
74(12, 'users_right', 0, '1', '1', 0, 0),
75(13, 'users_bottom', 0, '1', '1', 0, 0),
76(14, 'albums_right', 0, '1', '1', 0, 0),
77(21, 'search_bottom', 0, '1', '1', 0, 0),
78(20, 'search_right', 0, '1', '1', 0, 0),
79(19, 'video_right_second', 0, '1', '1', 0, 0),
80(18, 'photo_bottom', 0, '1', '1', 0, 0),
81(17, 'video_bottom', 0, '1', '1', 0, 0),
82(16, 'video_right', 0, '1', '1', 0, 0),
83(15, 'albums_bottom', 0, '1', '1', 0, 0),
84(22, 'search_photos_right', 0, '1', '1', 0, 0),
85(23, 'search_photos_bottom', 0, '1', '1', 0, 0),
86(24, 'search_users_right', 0, '1', '1', 0, 0),
87(25, 'search_users_bottom', 0, '1', '1', 0, 0),
88(26, 'games_right', 0, '1', '1', 0, 0),
89(27, 'games_bottom', 0, '1', '1', 0, 0),
90(28, 'game_right', 0, '1', '1', 0, 0),
91(29, 'game_bottom', 0, '1', '1', 0, 0),
92(30, 'game_right_second', 0, '1', '1', 0, 0);
93
94-- --------------------------------------------------------
95
96--
97-- Table structure for table `adv_media`
98--
99
100CREATE TABLE IF NOT EXISTS `adv_media` (
101 `adv_id` bigint(20) unsigned NOT NULL auto_increment,
102 `adv_url` varchar(255) NOT NULL default '',
103 `title` varchar(255) NOT NULL default '',
104 `descr` text NOT NULL,
105 `duration` tinyint(3) unsigned NOT NULL default '0',
106 `media` enum('jpg','swf','flv','mp4') NOT NULL default 'flv',
107 `views` bigint(20) NOT NULL default '0',
108 `clicks` bigint(20) NOT NULL default '0',
109 `addtime` int(10) NOT NULL default '0',
110 `status` enum('1','0') NOT NULL default '0',
111 PRIMARY KEY (`adv_id`),
112 KEY `status` (`status`)
113) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
114
115
116
117--
118-- Table structure for table `adv_text`
119--
120
121CREATE TABLE IF NOT EXISTS `adv_text` (
122 `adv_id` bigint(20) unsigned NOT NULL auto_increment,
123 `adv_url` varchar(255) NOT NULL default '',
124 `title` varchar(255) NOT NULL default '',
125 `descr` text NOT NULL,
126 `views` bigint(20) NOT NULL default '0',
127 `clicks` bigint(20) NOT NULL default '0',
128 `addtime` int(10) NOT NULL default '0',
129 `status` enum('1','0') NOT NULL default '0',
130 PRIMARY KEY (`adv_id`),
131 KEY `status` (`status`)
132) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
133
134-- --------------------------------------------------------
135
136--
137-- Table structure for table `albums`
138--
139
140CREATE TABLE IF NOT EXISTS `albums` (
141 `AID` bigint(20) NOT NULL auto_increment,
142 `UID` bigint(20) NOT NULL default '0',
143 `name` varchar(255) NOT NULL default '',
144 `tags` text NOT NULL,
145 `category` tinyint(2) NOT NULL default '0',
146 `total_photos` bigint(20) NOT NULL default '0',
147 `total_views` bigint(20) NOT NULL default '0',
148 `type` enum('public','private') NOT NULL default 'public',
149 `addtime` bigint(20) NOT NULL default '0',
150 `status` enum('1','0') NOT NULL default '1',
151 `adddate` date NOT NULL default '0000-00-00',
152 `rate` float NOT NULL default '0',
153 `ratedby` bigint(20) NOT NULL default '0',
154 `total_comments` bigint(20) NOT NULL default '0',
155 `total_favorites` bigint(20) NOT NULL default '0',
156 `likes` bigint(20) NOT NULL default '0',
157 `dislikes` bigint(20) NOT NULL default '0',
158 PRIMARY KEY (`AID`),
159 KEY `UID` (`UID`),
160 KEY `type` (`type`),
161 KEY `status` (`status`)
162) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
163
164--
165-- Table structure for table `album_categories`
166--
167
168CREATE TABLE IF NOT EXISTS `album_categories` (
169 `CID` bigint(20) NOT NULL auto_increment,
170 `name` varchar(255) NOT NULL default '',
171 `slug` varchar(120) NOT NULL default '',
172 `total_albums` bigint(20) NOT NULL default '0',
173 PRIMARY KEY (`CID`)
174) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
175
176
177--
178-- Table structure for table `bans`
179--
180
181CREATE TABLE IF NOT EXISTS `bans` (
182 `ban_id` bigint(20) NOT NULL auto_increment,
183 `ban_ip` varchar(16) NOT NULL default '',
184 `ban_date` datetime NOT NULL default '0000-00-00 00:00:00',
185 PRIMARY KEY (`ban_id`),
186 KEY `ban_ip` (`ban_ip`)
187) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
188
189-- --------------------------------------------------------
190
191--
192-- Table structure for table `blog`
193--
194
195CREATE TABLE IF NOT EXISTS `blog` (
196 `BID` bigint(20) NOT NULL auto_increment,
197 `UID` bigint(20) NOT NULL default '0',
198 `title` varchar(255) NOT NULL default '',
199 `content` text NOT NULL,
200 `total_views` bigint(20) NOT NULL default '0',
201 `total_comments` bigint(20) NOT NULL default '0',
202 `total_links` bigint(20) NOT NULL default '0',
203 `addtime` bigint(20) NOT NULL default '0',
204 `adddate` date NOT NULL default '0000-00-00',
205 `status` enum('1','0') NOT NULL default '1',
206 PRIMARY KEY (`BID`),
207 KEY `UID` (`UID`),
208 KEY `status` (`status`)
209) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
210
211--
212-- Table structure for table `blog_comments`
213--
214
215CREATE TABLE IF NOT EXISTS `blog_comments` (
216 `CID` bigint(20) NOT NULL auto_increment,
217 `BID` bigint(20) NOT NULL default '0',
218 `UID` bigint(20) NOT NULL default '0',
219 `comment` text NOT NULL,
220 `addtime` bigint(20) NOT NULL default '0',
221 `status` enum('1','0') NOT NULL default '1',
222 PRIMARY KEY (`CID`),
223 KEY `BID` (`BID`),
224 KEY `UID` (`UID`),
225 KEY `status` (`status`)
226) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
227
228
229
230--
231-- Table structure for table `channel`
232--
233
234CREATE TABLE IF NOT EXISTS `channel` (
235 `CHID` bigint(20) NOT NULL auto_increment,
236 `name` varchar(120) NOT NULL default '',
237 `slug` varchar(120) NOT NULL default '',
238 `total_videos` bigint(20) NOT NULL default '0',
239 PRIMARY KEY (`CHID`),
240 UNIQUE KEY `name` (`name`)
241) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
242
243
244
245--
246-- Table structure for table `confirm`
247--
248
249CREATE TABLE IF NOT EXISTS `confirm` (
250 `UID` bigint(20) NOT NULL default '0',
251 `code` varchar(10) NOT NULL default '',
252 KEY `UID` (`UID`),
253 KEY `code` (`code`)
254) ENGINE=MyISAM DEFAULT CHARSET=utf8;
255
256
257
258
259--
260-- Table structure for table `emailinfo`
261--
262
263CREATE TABLE IF NOT EXISTS `emailinfo` (
264 `email_id` varchar(50) NOT NULL default '',
265 `email_subject` varchar(255) NOT NULL default '',
266 `email_path` varchar(255) NOT NULL default '',
267 `comment` varchar(255) default NULL,
268 PRIMARY KEY (`email_id`)
269) ENGINE=MyISAM DEFAULT CHARSET=utf8;
270
271--
272-- Dumping data for table `emailinfo`
273--
274
275INSERT INTO `emailinfo` (`email_id`, `email_subject`, `email_path`, `comment`) VALUES
276('welcome', 'Welcome to {$site_title}', 'emails/welcome.tpl', 'Register welcome email'),
277('recover_password', 'Your {$site_name} Username and Password', 'emails/recover_password.tpl', 'Recovering user login password'),
278('subscribe_email', '{$sender_name} has uploaded a new video', 'emails/subscribe_email.tpl', 'Video Subscription Email'),
279('friend_request', '{$username} added you as a friend on {$site_name}', 'emails/friend_request.tpl', 'Friend Request'),
280('invite_friends_email', '{$sender_name} has sent you a invitation!', 'emails/invite.tpl', 'Invite friends email'),
281('share_video', '{$sender_name} has sent you a video!', 'emails/share_video.tpl', 'Share video email'),
282('share_photo', '{$sender_name} has sent you a photo!', 'emails/share_photo.tpl', 'Share photo email'),
283('share_game', '{$sender_name} has sent you a game!', 'emails/share_game.tpl', 'Share game email'),
284('verify_email', '{$site_name} Confirmation Email', 'emails/verify_email.tpl', 'Email verification'),
285('video_upload', 'Your video was successfuly uploaded to {$site_name}!', 'emails/video_upload.tpl', 'Video upload email'),
286('video_approve', 'Your video was successfuly uploaded to {$site_name}!', 'emails/video_approve.tpl', 'Video upload email'),
287('photo_approve', 'Your album was successfuly uploaded to {$site_name}!', 'emails/photo_approve.tpl', 'Album approve email'),
288('photo_upload', 'Your album was successfuly uploaded to {$site_name}!', 'emails/photo_upload.tpl', 'Album upload email'),
289('game_approve', 'Your game was successfuly uploaded to {$site_name}!', 'emails/game_approve.tpl', 'Game approve email'),
290('game_upload', 'Your game was successfuly uploaded to {$site_name}!', 'emails/game_upload.tpl', 'Game upload email'),
291('wall_comment', 'Your received wall comment!', 'emails/wall_comment.tpl', 'Wall comment email'),
292('request_approved', 'Your friend request has been approved!', 'emails/request_approved.tpl', 'Friend request approve'),
293('request_rejected', 'Your friend request has been approved!', 'emails/request_rejected.tpl', 'Friend request rejected'),
294('video_comment', 'You received video comment from {$username}!', 'emails/video_comment.tpl', 'video comment'),
295('blog_comment', 'You received blog comment from {$username}!', 'emails/blog_comment.tpl', 'blog comment'),
296('game_comment', 'You received game comment from {$username}!', 'emails/game_comment.tpl', 'game comment'),
297('photo_comment', 'You received photo comment from {$username}!', 'emails/photo_comment.tpl', 'photo comment'),
298('player_email', 'I want to share this video with you!', 'emails/player_email.tpl', 'Player email');
299
300-- --------------------------------------------------------
301
302--
303-- Table structure for table `encoding_avs`
304--
305
306CREATE TABLE IF NOT EXISTS `encoding_avs` (
307 `video_type` varchar(10) NOT NULL default '',
308 `aspect` varchar(10) NOT NULL default '',
309 `encode_seq` int(11) NOT NULL default '0',
310 `action` varchar(20) NOT NULL default '',
311 `ovc_profile` varchar(20) NOT NULL default 'standard',
312 `resize_base` varchar(10) NOT NULL default '',
313 `resize_width` int(11) NOT NULL default '0',
314 `resize_height` int(11) NOT NULL default '0',
315 `ref_bitrate` int(11) NOT NULL default '0',
316 `ref_type` varchar(10) NOT NULL default '',
317 `ref_width` int(11) NOT NULL default '0',
318 `ref_height` int(11) NOT NULL default '0',
319 `encodepass` tinyint(1) NOT NULL default '1',
320 `blackbars` tinyint(1) NOT NULL default '0',
321 `audio_sampling` int(5) NOT NULL,
322 `audio_bitrate` int(5) NOT NULL,
323 `nameext` varchar(10) NOT NULL default '',
324 `fileext` varchar(10) NOT NULL default 'flv',
325 PRIMARY KEY (`video_type`,`aspect`,`encode_seq`)
326) ENGINE=MyISAM DEFAULT CHARSET=utf8;
327
328--
329-- Dumping data for table `encoding_avs`
330--
331
332INSERT INTO `encoding_avs` (`video_type`, `aspect`, `encode_seq`, `action`, `ovc_profile`, `resize_base`, `resize_width`, `resize_height`, `ref_bitrate`, `ref_type`, `ref_width`, `ref_height`, `encodepass`, `blackbars`, `audio_sampling`, `audio_bitrate`, `nameext`, `fileext`) VALUES
333('flv', 'all', 1, 'copy_only', 'standard', '', 0, 0, 0, '', 0, 0, 1, 0, 0, 0, '', 'flv'),
334('normal', 'all', 1, 'encode_h263', 'standard', 'both', 853, 480, 800, 'fix', 640, 480, 1, 0, 44100, 128, '', 'flv'),
335('normal', 'all', 2, 'encode_x264', 'standard', 'both', 1280, 720, 1500, 'standard', 1280, 720, 2, 0, 44100, 256, '', 'mp4'),
336('normal', 'all', 3, 'encode_ipod', 'standard', 'both', 768, 432, 750, 'standard', 1280, 720, 1, 0, 44100, 128, '', 'mp4');
337
338-- --------------------------------------------------------
339
340--
341-- Table structure for table `encoding_condition`
342--
343
344CREATE TABLE IF NOT EXISTS `encoding_condition` (
345 `video_type` varchar(10) NOT NULL default '',
346 `aspect` varchar(10) NOT NULL default '',
347 `encode_seq` int(11) NOT NULL default '0',
348 `condition_seq` int(11) NOT NULL default '0',
349 `condition_type` varchar(20) NOT NULL default '',
350 `condition_operator` varchar(10) NOT NULL default '',
351 `condition_value` varchar(20) NOT NULL default '',
352 PRIMARY KEY (`video_type`,`aspect`,`encode_seq`,`condition_seq`)
353) ENGINE=MyISAM DEFAULT CHARSET=utf8;
354
355--
356-- Dumping data for table `encoding_condition`
357--
358
359INSERT INTO `encoding_condition` (`video_type`, `aspect`, `encode_seq`, `condition_seq`, `condition_type`, `condition_operator`, `condition_value`) VALUES
360('normal', 'all', 2, 1, 'width', 'gt', '479');
361
362-- --------------------------------------------------------
363
364--
365-- Table structure for table `favourite`
366--
367
368CREATE TABLE IF NOT EXISTS `favourite` (
369 `UID` bigint(20) NOT NULL default '0',
370 `VID` bigint(20) NOT NULL default '0',
371 UNIQUE KEY `UID` (`UID`,`VID`)
372) ENGINE=MyISAM DEFAULT CHARSET=utf8;
373
374
375
376
377--
378-- Table structure for table `friends`
379--
380
381CREATE TABLE IF NOT EXISTS `friends` (
382 `UID` bigint(20) NOT NULL default '0',
383 `FID` bigint(20) NOT NULL default '0',
384 `invite_date` date NOT NULL default '0000-00-00',
385 `status` enum('Pending','Confirmed','Denied') NOT NULL default 'Pending',
386 `message` text NOT NULL,
387 KEY `UID_FID` (`UID`,`FID`)
388) ENGINE=MyISAM DEFAULT CHARSET=utf8;
389
390
391
392--
393-- Table structure for table `game`
394--
395
396CREATE TABLE IF NOT EXISTS `game` (
397 `GID` bigint(20) NOT NULL auto_increment,
398 `UID` bigint(20) NOT NULL default '0',
399 `title` varchar(255) NOT NULL default '',
400 `tags` text NOT NULL,
401 `category` tinyint(3) NOT NULL default '0',
402 `total_plays` bigint(20) NOT NULL default '0',
403 `total_comments` bigint(20) NOT NULL default '0',
404 `total_favorites` bigint(20) NOT NULL default '0',
405 `rate` float NOT NULL default '0',
406 `ratedby` bigint(20) NOT NULL default '0',
407 `type` enum('public','private') NOT NULL default 'public',
408 `space` bigint(20) NOT NULL default '0',
409 `playtime` datetime NOT NULL default '0000-00-00 00:00:00',
410 `be_commented` enum('yes','no') NOT NULL default 'yes',
411 `be_rated` enum('yes','no') NOT NULL default 'yes',
412 `addtime` bigint(20) NOT NULL default '0',
413 `adddate` date NOT NULL default '0000-00-00',
414 `status` enum('1','0') NOT NULL default '1',
415 `likes` bigint(20) NOT NULL default '0',
416 `dislikes` bigint(20) NOT NULL default '0',
417 PRIMARY KEY (`GID`),
418 KEY `UID` (`UID`),
419 KEY `type` (`type`),
420 KEY `status` (`status`)
421) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
422
423
424
425--
426-- Table structure for table `game_categories`
427--
428
429CREATE TABLE IF NOT EXISTS `game_categories` (
430 `category_id` bigint(20) NOT NULL auto_increment,
431 `category_name` varchar(255) NOT NULL default '',
432 `slug` varchar(120) NOT NULL default '',
433 `total_games` bigint(20) NOT NULL default '0',
434 `status` enum('1','0') NOT NULL default '1',
435 PRIMARY KEY (`category_id`),
436 KEY `status` (`status`)
437) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
438
439
440
441--
442-- Table structure for table `game_comments`
443--
444
445CREATE TABLE IF NOT EXISTS `game_comments` (
446 `CID` bigint(20) NOT NULL auto_increment,
447 `GID` bigint(20) NOT NULL default '0',
448 `UID` bigint(20) NOT NULL default '0',
449 `comment` text NOT NULL,
450 `addtime` bigint(20) NOT NULL default '0',
451 `status` enum('1','0') NOT NULL default '1',
452 PRIMARY KEY (`CID`),
453 KEY `GID` (`GID`),
454 KEY `UID` (`UID`),
455 KEY `status` (`status`)
456) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
457
458
459
460--
461-- Table structure for table `game_favorites`
462--
463
464CREATE TABLE IF NOT EXISTS `game_favorites` (
465 `GID` bigint(20) NOT NULL default '0',
466 `UID` bigint(20) NOT NULL default '0',
467 KEY `GID` (`GID`),
468 KEY `UID` (`UID`)
469) ENGINE=MyISAM DEFAULT CHARSET=utf8;
470
471
472
473
474--
475-- Table structure for table `game_flags`
476--
477
478CREATE TABLE IF NOT EXISTS `game_flags` (
479 `FID` bigint(20) NOT NULL auto_increment,
480 `GID` bigint(20) NOT NULL default '0',
481 `UID` bigint(20) NOT NULL default '0',
482 `reason` tinyint(1) unsigned NOT NULL default '0',
483 `message` text NOT NULL,
484 `add_date` varchar(20) NOT NULL default '',
485 PRIMARY KEY (`FID`),
486 KEY `GID_UID` (`GID`,`UID`)
487) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
488
489
490-- --------------------------------------------------------
491
492--
493-- Table structure for table `game_rating_id`
494--
495
496CREATE TABLE IF NOT EXISTS `game_rating_id` (
497 `GID` bigint(20) NOT NULL default '0',
498 `UID` bigint(20) NOT NULL default '0',
499 KEY `GID` (`GID`),
500 KEY `UID` (`UID`)
501) ENGINE=MyISAM DEFAULT CHARSET=utf8;
502
503-- --------------------------------------------------------
504
505--
506-- Table structure for table `game_rating_ip`
507--
508
509CREATE TABLE IF NOT EXISTS `game_rating_ip` (
510 `GID` bigint(20) NOT NULL default '0',
511 `ip` int(9) NOT NULL default '0',
512 KEY `GID` (`GID`),
513 KEY `ip` (`ip`)
514) ENGINE=MyISAM DEFAULT CHARSET=utf8;
515
516
517
518
519--
520-- Table structure for table `grab`
521--
522
523CREATE TABLE IF NOT EXISTS `grab` (
524 `site` varchar(50) NOT NULL default '',
525 `id` varchar(255) NOT NULL default '',
526 KEY `site_id` (`site`),
527 KEY `id` (`id`)
528) ENGINE=MyISAM DEFAULT CHARSET=utf8;
529
530
531
532
533--
534-- Table structure for table `grab_cron`
535--
536
537CREATE TABLE IF NOT EXISTS `grab_cron` (
538 `grab_id` varchar(20) NOT NULL default '',
539 `grab_interval` varchar(7) NOT NULL default '',
540 `grab_number` tinyint(3) NOT NULL default '0',
541 `status` enum('0','1') NOT NULL default '1',
542 PRIMARY KEY (`grab_id`),
543 KEY `grab_interval` (`grab_interval`)
544) ENGINE=MyISAM DEFAULT CHARSET=utf8;
545
546--
547-- Dumping data for table `grab_cron`
548--
549
550INSERT INTO `grab_cron` (`grab_id`, `grab_interval`, `grab_number`, `status`) VALUES
551('youporn', '', 1, '1'),
552('pornhub', '', 1, '0'),
553('wanktube', '', 1, '0'),
554('snizzshare', '', 1, '0'),
555('nudevibes', '', 1, '0'),
556('tube8', '', 2, '0'),
557('haporn', '', 1, '0');
558
559-- --------------------------------------------------------
560
561--
562-- Table structure for table `guests`
563--
564
565CREATE TABLE IF NOT EXISTS `guests` (
566 `guest_id` bigint(20) NOT NULL auto_increment,
567 `guest_ip` int(9) NOT NULL default '0',
568 `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
569 `bandwidth` bigint(20) NOT NULL default '0',
570 PRIMARY KEY (`guest_id`),
571 KEY `guest_ip` (`guest_ip`)
572) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
573
574
575
576--
577-- Table structure for table `mail`
578--
579
580CREATE TABLE IF NOT EXISTS `mail` (
581 `mail_id` bigint(20) NOT NULL auto_increment,
582 `sender` varchar(15) NOT NULL default '',
583 `receiver` varchar(15) NOT NULL default '',
584 `subject` varchar(255) NOT NULL default '',
585 `body` text NOT NULL,
586 `inbox` enum('1','0') NOT NULL default '1',
587 `outbox` enum('1','0') NOT NULL default '0',
588 `send_date` datetime NOT NULL default '0000-00-00 00:00:00',
589 `status` enum('1','0') NOT NULL default '1',
590 `readed` enum('1','0') NOT NULL default '0',
591 PRIMARY KEY (`mail_id`),
592 KEY `sender` (`sender`),
593 KEY `receiver` (`receiver`),
594 KEY `inbox` (`inbox`),
595 KEY `outbox` (`outbox`),
596 KEY `status` (`status`)
597) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
598
599
600
601--
602-- Table structure for table `notice`
603--
604
605CREATE TABLE IF NOT EXISTS `notice` (
606 `NID` bigint(20) NOT NULL auto_increment,
607 `UID` bigint(20) NOT NULL default '0',
608 `category` tinyint(3) NOT NULL default '0',
609 `title` varchar(255) NOT NULL default '',
610 `content` text NOT NULL,
611 `total_views` bigint(20) NOT NULL default '0',
612 `total_comments` bigint(20) NOT NULL default '0',
613 `total_links` bigint(20) NOT NULL default '0',
614 `addtime` bigint(20) NOT NULL default '0',
615 `adddate` date NOT NULL default '0000-00-00',
616 `status` enum('1','0') NOT NULL default '1',
617 PRIMARY KEY (`NID`),
618 KEY `UID` (`UID`),
619 KEY `status` (`status`)
620) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
621
622
623
624--
625-- Table structure for table `notice_categories`
626--
627
628CREATE TABLE IF NOT EXISTS `notice_categories` (
629 `category_id` bigint(20) NOT NULL auto_increment,
630 `name` varchar(255) NOT NULL default '',
631 `total_notices` bigint(20) NOT NULL default '0',
632 `status` enum('1','0') NOT NULL default '1',
633 PRIMARY KEY (`category_id`)
634) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
635
636
637
638
639--
640-- Table structure for table `notice_comments`
641--
642
643CREATE TABLE IF NOT EXISTS `notice_comments` (
644 `CID` bigint(20) NOT NULL auto_increment,
645 `NID` bigint(20) NOT NULL default '0',
646 `UID` bigint(20) NOT NULL default '0',
647 `comment` text NOT NULL,
648 `addtime` bigint(20) NOT NULL default '0',
649 `status` enum('1','0') NOT NULL default '1',
650 PRIMARY KEY (`CID`),
651 KEY `NID` (`NID`),
652 KEY `UID` (`UID`),
653 KEY `status` (`status`)
654) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
655
656
657
658--
659-- Table structure for table `notice_images`
660--
661
662CREATE TABLE IF NOT EXISTS `notice_images` (
663 `image_id` bigint(20) NOT NULL auto_increment,
664 `addtime` bigint(20) NOT NULL default '0',
665 `extension` varchar(5) NOT NULL default '',
666 PRIMARY KEY (`image_id`)
667) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
668
669
670
671--
672-- Table structure for table `photos`
673--
674
675CREATE TABLE IF NOT EXISTS `photos` (
676 `PID` bigint(20) NOT NULL auto_increment,
677 `AID` bigint(20) NOT NULL default '0',
678 `caption` varchar(100) NOT NULL default '',
679 `total_views` bigint(20) NOT NULL default '0',
680 `total_comments` bigint(20) NOT NULL default '0',
681 `status` enum('1','0') NOT NULL default '1',
682 `rate` float NOT NULL default '0',
683 `ratedby` bigint(20) NOT NULL default '0',
684 `total_favorites` bigint(20) NOT NULL default '0',
685 `type` enum('public','private') NOT NULL default 'public',
686 `likes` bigint(20) NOT NULL default '0',
687 `dislikes` bigint(20) NOT NULL default '0',
688 PRIMARY KEY (`PID`),
689 KEY `AID` (`AID`),
690 KEY `status` (`status`)
691) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
692
693
694
695--
696-- Table structure for table `photo_comments`
697--
698
699CREATE TABLE IF NOT EXISTS `photo_comments` (
700 `CID` bigint(20) NOT NULL auto_increment,
701 `PID` bigint(20) NOT NULL default '0',
702 `UID` bigint(20) NOT NULL default '0',
703 `comment` text NOT NULL,
704 `addtime` bigint(20) NOT NULL default '0',
705 `status` enum('1','0') NOT NULL default '1',
706 PRIMARY KEY (`CID`),
707 KEY `PID` (`PID`),
708 KEY `UID` (`UID`),
709 KEY `status` (`status`)
710) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
711
712
713
714--
715-- Table structure for table `photo_favorites`
716--
717
718CREATE TABLE IF NOT EXISTS `photo_favorites` (
719 `PID` bigint(20) NOT NULL default '0',
720 `UID` bigint(20) NOT NULL default '0',
721 KEY `PID` (`PID`),
722 KEY `UID` (`UID`)
723) ENGINE=MyISAM DEFAULT CHARSET=utf8;
724
725
726
727
728--
729-- Table structure for table `photo_flags`
730--
731
732CREATE TABLE IF NOT EXISTS `photo_flags` (
733 `FID` bigint(20) NOT NULL auto_increment,
734 `PID` bigint(20) NOT NULL default '0',
735 `UID` bigint(20) NOT NULL default '0',
736 `reason` varchar(15) NOT NULL default '',
737 `message` text NOT NULL,
738 `add_date` date NOT NULL default '0000-00-00',
739 PRIMARY KEY (`FID`),
740 KEY `PID` (`PID`),
741 KEY `UID` (`UID`)
742) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
743
744
745
746--
747-- Table structure for table `photo_rating_id`
748--
749
750CREATE TABLE IF NOT EXISTS `photo_rating_id` (
751 `PID` bigint(20) NOT NULL default '0',
752 `UID` bigint(20) NOT NULL default '0',
753 KEY `PID` (`PID`),
754 KEY `UID` (`UID`)
755) ENGINE=MyISAM DEFAULT CHARSET=utf8;
756
757
758
759
760--
761-- Table structure for table `photo_rating_ip`
762--
763
764CREATE TABLE IF NOT EXISTS `photo_rating_ip` (
765 `PID` bigint(20) NOT NULL default '0',
766 `ip` int(9) NOT NULL default '0',
767 KEY `PID` (`PID`),
768 KEY `ip` (`ip`)
769) ENGINE=MyISAM DEFAULT CHARSET=utf8;
770
771-- --------------------------------------------------------
772
773--
774-- Table structure for table `player`
775--
776
777CREATE TABLE IF NOT EXISTS `player` (
778 `id` bigint(20) unsigned NOT NULL auto_increment,
779 `profile` varchar(255) NOT NULL default '',
780 `autorun` enum('true','false') NOT NULL default 'false',
781 `buffertime` tinyint(2) unsigned NOT NULL default '5',
782 `buttons` enum('0','1') NOT NULL default '1',
783 `logo_url` varchar(255) NOT NULL default '',
784 `logo_position` varchar(2) NOT NULL default 'BR',
785 `logo_link` varchar(255) NOT NULL default '',
786 `logo_alpha` tinyint(2) unsigned NOT NULL default '10',
787 `text_adv` enum('0','1') NOT NULL default '1',
788 `text_adv_type` enum('global','video','channel') NOT NULL default 'global',
789 `text_adv_delay` tinyint(3) unsigned NOT NULL default '5',
790 `video_adv` enum('0','1') NOT NULL default '1',
791 `video_adv_type` enum('global','video','channel') NOT NULL default 'global',
792 `video_adv_position` enum('b','e','be') NOT NULL default 'be',
793 `skin` varchar(255) NOT NULL default 'default',
794 `embed` enum('0','1') NOT NULL default '1',
795 `related` enum('0','1') NOT NULL default '1',
796 `related_content` enum('related','featured','commented','rated','viewed') NOT NULL default 'related',
797 `share` enum('0','1') NOT NULL default '1',
798 `mail` enum('0','1') NOT NULL default '1',
799 `replay` enum('0','1') NOT NULL default '1',
800 `mail_color` varchar(8) NOT NULL default '0x999999',
801 `related_color` varchar(8) NOT NULL default '0x999999',
802 `replay_color` varchar(8) NOT NULL default '0x999999',
803 `embed_color` varchar(8) NOT NULL default '0x999999',
804 `copy_color` varchar(8) NOT NULL default '0x999999',
805 `time_color` varchar(8) NOT NULL default '0x999999',
806 `share_color` varchar(8) NOT NULL default '0x999999',
807 `adv_nav_color` varchar(8) NOT NULL default '0x999999',
808 `adv_title_color` varchar(8) NOT NULL default '0x999999',
809 `adv_body_color` varchar(8) NOT NULL default '0x999999',
810 `adv_link_color` varchar(8) NOT NULL default '0x999900',
811 `status` enum('0','1') NOT NULL default '0',
812 PRIMARY KEY (`id`),
813 KEY `profile` (`profile`),
814 KEY `status` (`status`)
815) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
816
817--
818-- Dumping data for table `player`
819--
820
821INSERT INTO `player` (`id`, `profile`, `autorun`, `buffertime`, `buttons`, `logo_url`, `logo_position`, `logo_link`, `logo_alpha`, `text_adv`, `text_adv_type`, `text_adv_delay`, `video_adv`, `video_adv_type`, `video_adv_position`, `skin`, `embed`, `related`, `related_content`, `share`, `mail`, `replay`, `mail_color`, `related_color`, `replay_color`, `embed_color`, `copy_color`, `time_color`, `share_color`, `adv_nav_color`, `adv_title_color`, `adv_body_color`, `adv_link_color`, `status`) VALUES
822(1, 'default', 'true', 3, '1', '', 'BR', '', 10, '1', 'global', 5, '1', 'global', 'b', 'default', '1', '1', 'related', '1', '1', '1', '0x999999', '0x999999', '0x999999', '0x999999', '0x000000', '0x999999', '0x999999', '0x999999', '0xffa200', '0xf1f1f1', '0x999999', '1');
823
824-- --------------------------------------------------------
825
826--
827-- Table structure for table `playlist`
828--
829
830CREATE TABLE IF NOT EXISTS `playlist` (
831 `UID` bigint(20) default NULL,
832 `VID` bigint(20) default NULL,
833 UNIQUE KEY `UID` (`UID`,`VID`)
834) ENGINE=MyISAM DEFAULT CHARSET=utf8;
835
836
837
838
839--
840-- Table structure for table `servers`
841--
842
843CREATE TABLE IF NOT EXISTS `servers` (
844 `server_id` int(11) NOT NULL auto_increment,
845 `url` varchar(255) NOT NULL default '',
846 `video_url` varchar(255) NOT NULL default '',
847 `server_ip` varchar(255) NOT NULL default '',
848 `ftp_username` varchar(255) NOT NULL default '',
849 `ftp_password` varchar(255) NOT NULL default '',
850 `ftp_root` varchar(255) NOT NULL default '',
851 `last_used` datetime NOT NULL default '0000-00-00 00:00:00',
852 `current_used` enum('0','1') NOT NULL default '0',
853 `status` enum('0','1') NOT NULL default '1',
854 PRIMARY KEY (`server_id`),
855 UNIQUE KEY `url` (`url`),
856 KEY `last_used` (`last_used`),
857 KEY `current_used` (`current_used`),
858 KEY `status` (`status`)
859) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
860
861-- --------------------------------------------------------
862
863--
864-- Table structure for table `sessions`
865--
866
867CREATE TABLE IF NOT EXISTS `sessions` (
868 `session_id` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
869 `session_expires` int(10) unsigned NOT NULL default '0',
870 `session_data` text collate utf8_unicode_ci,
871 PRIMARY KEY (`session_id`)
872) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
873
874
875
876
877--
878-- Table structure for table `signup`
879--
880
881CREATE TABLE IF NOT EXISTS `signup` (
882 `UID` bigint(20) NOT NULL auto_increment,
883 `FBID` varchar(100) NOT NULL default '',
884 `GID` varchar(100) NOT NULL default '',
885 `email` varchar(80) NOT NULL default '',
886 `username` varchar(80) NOT NULL default '',
887 `fname` varchar(40) NOT NULL default '',
888 `lname` varchar(40) NOT NULL default '',
889 `bdate` date NOT NULL default '0000-00-00',
890 `gender` varchar(6) NOT NULL default '',
891 `relation` varchar(8) NOT NULL default '',
892 `aboutme` text NOT NULL,
893 `website` varchar(120) NOT NULL default '',
894 `town` varchar(80) NOT NULL default '',
895 `city` varchar(80) NOT NULL default '',
896 `zip` varchar(30) NOT NULL default '',
897 `country` varchar(80) NOT NULL default '',
898 `occupation` text NOT NULL,
899 `company` text NOT NULL,
900 `school` text NOT NULL,
901 `interest_hobby` text NOT NULL,
902 `fav_movie_show` text NOT NULL,
903 `fav_music` text NOT NULL,
904 `fav_book` text NOT NULL,
905 `friends_type` varchar(255) NOT NULL default 'All|Family|Friends',
906 `video_viewed` int(10) NOT NULL default '0',
907 `profile_viewed` int(10) NOT NULL default '0',
908 `watched_video` int(10) NOT NULL default '0',
909 `addtime` varchar(20) NOT NULL default '',
910 `logintime` varchar(20) NOT NULL default '',
911 `emailverified` varchar(3) NOT NULL default 'no',
912 `account_status` enum('Active','Inactive') NOT NULL default 'Active',
913 `vote` varchar(5) NOT NULL default '',
914 `ratedby` varchar(5) NOT NULL default '0',
915 `rate` float NOT NULL default '0',
916 `parents_name` varchar(50) NOT NULL default '',
917 `parents_email` varchar(50) NOT NULL default '',
918 `friends_name` varchar(50) NOT NULL default '',
919 `friends_email` varchar(50) NOT NULL default '',
920 `photo` varchar(100) NOT NULL default '',
921 `playlist` enum('Public','Private') NOT NULL default 'Public',
922 `user_ip` varchar(16) NOT NULL default '',
923 `pwd` varchar(60) NOT NULL default '',
924 `interested` varchar(12) NOT NULL default '',
925 `turnon` text NOT NULL,
926 `turnoff` text NOT NULL,
927 `total_albums` bigint(20) NOT NULL default '0',
928 `total_blogs` bigint(20) NOT NULL default '0',
929 `total_videos` bigint(20) NOT NULL default '0',
930 `total_friends` bigint(20) NOT NULL default '0',
931 `popularity` bigint(20) NOT NULL default '0',
932 `total_games` bigint(20) NOT NULL default '0',
933 `points` bigint(20) NOT NULL default '0',
934 `premium` int(11) NOT NULL,
935 `premiumexpirytime` date NOT NULL,
936 `likes` bigint(20) NOT NULL default '0',
937 `dislikes` bigint(20) NOT NULL default '0',
938 PRIMARY KEY (`UID`),
939 UNIQUE KEY `email` (`email`),
940 UNIQUE KEY `username` (`username`)
941) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
942
943--
944-- Dumping data for table `signup`
945--
946
947INSERT INTO `signup` (`UID`, `email`, `username`, `fname`, `lname`, `bdate`, `gender`, `relation`, `aboutme`, `website`, `town`, `city`, `zip`, `country`, `occupation`, `company`, `school`, `interest_hobby`, `fav_movie_show`, `fav_music`, `fav_book`, `friends_type`, `video_viewed`, `profile_viewed`, `watched_video`, `addtime`, `logintime`, `emailverified`, `account_status`, `vote`, `ratedby`, `rate`, `parents_name`, `parents_email`, `friends_name`, `friends_email`, `photo`, `playlist`, `user_ip`, `pwd`, `interested`, `turnon`, `turnoff`, `total_albums`, `total_blogs`, `total_videos`, `total_friends`, `popularity`, `total_games`, `points`, `premium`, `premiumexpirytime`, `likes`, `dislikes`) VALUES
948(1, 'anonymous@yoursite.com', 'anonymous', '', '', '0000-00-00', 'Male', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'All|Family|Friends', 297, 37, 0, '1228326055', '1228326055', 'no', 'Active', '', '1', '100', '', '', '', '', '', 'Public', '', '$2a$08$/gSIczQwLZElwKTKZBVhCObjlFjEDi1bSsw4TIqkmzU.AGoHaO5r.', '', '', '', 5, 0, 11, 0, -2, 2, 30, 0, '0000-00-00', 1, 0);
949
950-- --------------------------------------------------------
951
952--
953-- Table structure for table `spam`
954--
955
956CREATE TABLE IF NOT EXISTS `spam` (
957 `spam_id` bigint(20) NOT NULL auto_increment,
958 `UID` bigint(20) NOT NULL default '0',
959 `type` enum('video','photo','wall','notice','blog','game') NOT NULL default 'video',
960 `parent_id` bigint(20) NOT NULL default '0',
961 `comment_id` bigint(20) NOT NULL default '0',
962 `addtime` bigint(20) NOT NULL default '0',
963 `adddate` date NOT NULL default '0000-00-00',
964 PRIMARY KEY (`spam_id`),
965 KEY `type` (`type`),
966 KEY `parent_id` (`parent_id`),
967 KEY `comment_id` (`comment_id`)
968) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
969
970--
971-- Table structure for table `users_blocks`
972--
973
974CREATE TABLE IF NOT EXISTS `users_blocks` (
975 `UID` bigint(20) NOT NULL default '0',
976 `BID` bigint(20) NOT NULL default '0',
977 KEY `UID` (`UID`),
978 KEY `BID` (`BID`)
979) ENGINE=MyISAM DEFAULT CHARSET=utf8;
980
981--
982-- Dumping data for table `users_blocks`
983--
984
985INSERT INTO `users_blocks` (`UID`, `BID`) VALUES
986(2, 11),
987(2, 3);
988
989-- --------------------------------------------------------
990
991--
992-- Table structure for table `users_flags`
993--
994
995CREATE TABLE IF NOT EXISTS `users_flags` (
996 `flag_id` bigint(20) NOT NULL auto_increment,
997 `UID` bigint(20) NOT NULL default '0',
998 `RID` bigint(20) NOT NULL default '0',
999 `reason` enum('offensive','underage','spammer','other') NOT NULL default 'offensive',
1000 `message` varchar(100) NOT NULL default '',
1001 `addtime` bigint(20) NOT NULL default '0',
1002 PRIMARY KEY (`flag_id`),
1003 KEY `UID` (`UID`),
1004 KEY `RID` (`RID`),
1005 KEY `reason` (`reason`)
1006) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1007
1008
1009
1010--
1011-- Table structure for table `users_online`
1012--
1013
1014CREATE TABLE IF NOT EXISTS `users_online` (
1015 `UID` bigint(20) NOT NULL default '0',
1016 `online` bigint(20) NOT NULL default '0',
1017 PRIMARY KEY (`UID`),
1018 KEY `online` (`online`)
1019) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1020
1021
1022
1023
1024--
1025-- Table structure for table `users_prefs`
1026--
1027
1028CREATE TABLE IF NOT EXISTS `users_prefs` (
1029 `UID` bigint(20) NOT NULL default '0',
1030 `show_playlist` enum('0','1','2') NOT NULL default '2',
1031 `show_favorites` enum('0','1','2') NOT NULL default '2',
1032 `show_friends` enum('0','1','2') NOT NULL default '2',
1033 `show_subscriptions` enum('0','1','2') NOT NULL default '2',
1034 `show_subscribers` enum('0','1','2') NOT NULL default '2',
1035 `friends_requests` enum('0','1') NOT NULL default '0',
1036 `wall_public` enum('0','1') NOT NULL default '1',
1037 `video_approve` enum('0','1') NOT NULL default '1',
1038 `album_approve` enum('0','1') NOT NULL default '1',
1039 `video_subscribe` enum('0','1') NOT NULL default '1',
1040 `friend_request` enum('0','1') NOT NULL default '1',
1041 `wall_write` enum('0','1') NOT NULL default '1',
1042 `video_comment` enum('0','1') NOT NULL default '1',
1043 `photo_comment` enum('0','1') NOT NULL default '1',
1044 `blog_comment` enum('0','1') NOT NULL default '1',
1045 `send_message` enum('0','1') NOT NULL default '1',
1046 `game_comment` enum('0','1') NOT NULL default '1',
1047 PRIMARY KEY (`UID`)
1048) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1049
1050--
1051-- Dumping data for table `users_prefs`
1052--
1053
1054INSERT INTO `users_prefs` (`UID`, `show_playlist`, `show_favorites`, `show_friends`, `show_subscriptions`, `show_subscribers`, `friends_requests`, `wall_public`, `video_approve`, `album_approve`, `video_subscribe`, `friend_request`, `wall_write`, `video_comment`, `photo_comment`, `blog_comment`, `send_message`, `game_comment`) VALUES
1055(1, '2', '2', '2', '2', '2', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1');
1056
1057-- --------------------------------------------------------
1058
1059--
1060-- Table structure for table `users_rating_id`
1061--
1062
1063CREATE TABLE IF NOT EXISTS `users_rating_id` (
1064 `UID` bigint(20) NOT NULL default '0',
1065 `RID` bigint(20) NOT NULL default '0',
1066 KEY `UID` (`UID`),
1067 KEY `RID` (`RID`)
1068) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1069
1070-- --------------------------------------------------------
1071
1072--
1073-- Table structure for table `users_rating_ip`
1074--
1075
1076CREATE TABLE IF NOT EXISTS `users_rating_ip` (
1077 `UID` bigint(20) NOT NULL default '0',
1078 `ip` int(9) NOT NULL default '0',
1079 KEY `UID` (`UID`),
1080 KEY `ip` (`ip`)
1081) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1082
1083
1084
1085
1086--
1087-- Table structure for table `video`
1088--
1089
1090CREATE TABLE IF NOT EXISTS `video` (
1091 `VID` bigint(20) NOT NULL auto_increment,
1092 `UID` bigint(20) NOT NULL default '0',
1093 `title` varchar(120) NOT NULL default '',
1094 `description` text NOT NULL,
1095 `featuredesc` text NOT NULL,
1096 `keyword` text NOT NULL,
1097 `channel` varchar(255) NOT NULL default '0|',
1098 `vdoname` varchar(40) NOT NULL default '',
1099 `flvdoname` varchar(40) default NULL,
1100 `duration` float NOT NULL default '0',
1101 `space` bigint(20) NOT NULL default '0',
1102 `type` varchar(7) NOT NULL default '',
1103 `addtime` varchar(20) default NULL,
1104 `adddate` date NOT NULL default '0000-00-00',
1105 `record_date` date NOT NULL default '0000-00-00',
1106 `location` text NOT NULL,
1107 `country` varchar(120) NOT NULL default '',
1108 `vkey` varchar(20) NOT NULL default '',
1109 `viewnumber` bigint(10) NOT NULL default '0',
1110 `viewtime` datetime NOT NULL default '0000-00-00 00:00:00',
1111 `com_num` int(8) NOT NULL default '0',
1112 `fav_num` int(8) NOT NULL default '0',
1113 `download_num` bigint(20) NOT NULL default '0',
1114 `featured` varchar(3) NOT NULL default 'no',
1115 `ratedby` bigint(10) NOT NULL default '0',
1116 `rate` float NOT NULL default '0',
1117 `filehome` varchar(120) NOT NULL default '',
1118 `be_comment` varchar(3) NOT NULL default 'yes',
1119 `be_rated` varchar(3) NOT NULL default 'yes',
1120 `embed` varchar(8) NOT NULL default 'enabled',
1121 `embed_code` text NOT NULL,
1122 `thumb` tinyint(1) unsigned NOT NULL default '1',
1123 `thumbs` tinyint(2) unsigned NOT NULL default '20',
1124 `voter_id` varchar(200) NOT NULL default '',
1125 `server` varchar(255) NOT NULL default '',
1126 `active` char(1) NOT NULL default '',
1127 `hd_filename` varchar(20) NOT NULL default '',
1128 `ipod_filename` varchar(20) NOT NULL default '',
1129 `aspect_hd` varchar(10) NOT NULL default '0',
1130 `width_hd` int(4) NOT NULL default '0',
1131 `height_hd` int(4) NOT NULL default '0',
1132 `aspect_sd` varchar(10) NOT NULL default '0',
1133 `width_sd` int(4) NOT NULL default '0',
1134 `height_sd` int(4) NOT NULL default '0',
1135 `iphone` int(1) NOT NULL default '0',
1136 `hd` int(1) NOT NULL default '0',
1137 `likes` bigint(20) NOT NULL default '0',
1138 `dislikes` bigint(20) NOT NULL default '0',
1139 PRIMARY KEY (`VID`),
1140 UNIQUE KEY `vkey` (`vkey`),
1141 KEY `viewnumber` (`viewnumber`),
1142 KEY `rate` (`rate`),
1143 KEY `fav_num` (`fav_num`),
1144 KEY `active` (`active`)
1145) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1146
1147
1148
1149--
1150-- Table structure for table `video_comments`
1151--
1152
1153CREATE TABLE IF NOT EXISTS `video_comments` (
1154 `CID` bigint(20) NOT NULL auto_increment,
1155 `VID` bigint(20) NOT NULL default '0',
1156 `UID` bigint(20) NOT NULL default '0',
1157 `comment` text NOT NULL,
1158 `addtime` bigint(20) NOT NULL default '0',
1159 `status` enum('1','0') NOT NULL default '1',
1160 PRIMARY KEY (`CID`),
1161 KEY `VID` (`VID`),
1162 KEY `UID` (`UID`),
1163 KEY `status` (`status`)
1164) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1165
1166
1167
1168--
1169-- Table structure for table `video_flags`
1170--
1171
1172CREATE TABLE IF NOT EXISTS `video_flags` (
1173 `FID` bigint(20) NOT NULL auto_increment,
1174 `VID` bigint(20) NOT NULL default '0',
1175 `UID` bigint(20) NOT NULL default '0',
1176 `reason` varchar(15) NOT NULL default '',
1177 `message` text NOT NULL,
1178 `add_date` date NOT NULL default '0000-00-00',
1179 PRIMARY KEY (`FID`),
1180 KEY `VID` (`VID`),
1181 KEY `UID` (`UID`)
1182) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1183
1184
1185
1186--
1187-- Table structure for table `video_subscribe`
1188--
1189
1190CREATE TABLE IF NOT EXISTS `video_subscribe` (
1191 `UID` bigint(20) NOT NULL default '0',
1192 `SUID` bigint(20) NOT NULL default '0',
1193 `subscribe_date` date NOT NULL default '0000-00-00',
1194 KEY `USUID` (`UID`,`SUID`)
1195) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1196
1197--
1198-- Table structure for table `video_vote_ip`
1199--
1200
1201CREATE TABLE IF NOT EXISTS `video_vote_ip` (
1202 `VID` bigint(20) NOT NULL default '0',
1203 `ip` int(9) NOT NULL default '0',
1204 UNIQUE KEY `vid_ip` (`VID`,`ip`)
1205) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1206
1207
1208
1209
1210--
1211-- Table structure for table `video_vote_users`
1212--
1213
1214CREATE TABLE IF NOT EXISTS `video_vote_users` (
1215 `VID` bigint(20) NOT NULL default '0',
1216 `UID` int(9) NOT NULL default '0',
1217 KEY `vid_uid` (`VID`,`UID`)
1218) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1219
1220--
1221-- Table structure for table `wall`
1222--
1223
1224CREATE TABLE IF NOT EXISTS `wall` (
1225 `wall_id` bigint(20) NOT NULL auto_increment,
1226 `OID` bigint(20) NOT NULL default '0',
1227 `UID` bigint(20) NOT NULL default '0',
1228 `message` text NOT NULL,
1229 `addtime` bigint(20) NOT NULL default '0',
1230 `status` enum('1','0') NOT NULL default '1',
1231 PRIMARY KEY (`wall_id`),
1232 KEY `OID` (`OID`),
1233 KEY `UID` (`UID`),
1234 KEY `status` (`status`)
1235) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1236
1237
1238/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1239/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1240/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;