XKTsupXq

1-- phpMyAdmin SQL Dump
2-- version 4.1.6
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Jun 01, 2015 at 04:56 AM
7-- Server version: 5.6.16
8-- PHP Version: 5.5.9
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `db_video`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `tbl_category`
27--
28
29CREATE TABLE IF NOT EXISTS `tbl_category` (
30  `cid` int(11) NOT NULL AUTO_INCREMENT,
31  `category_name` varchar(255) CHARACTER SET utf8 NOT NULL,
32  `category_image` varchar(255) CHARACTER SET utf8 NOT NULL,
33  PRIMARY KEY (`cid`)
34) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
35
36--
37-- Dumping data for table `tbl_category`
38--
39
40INSERT INTO `tbl_category` (`cid`, `category_name`, `category_image`) VALUES
41(2, 'Movie', '9058-2015-05-12.png'),
42(3, 'Sports', '3264-2015-05-12.png');
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `tbl_gallery`
48--
49
50CREATE TABLE IF NOT EXISTS `tbl_gallery` (
51  `id` int(11) NOT NULL AUTO_INCREMENT,
52  `cat_id` int(11) NOT NULL,
53  `video_title` varchar(255) CHARACTER SET utf8 NOT NULL,
54  `video_url` text CHARACTER SET utf8 NOT NULL,
55  `video_id` varchar(255) CHARACTER SET utf8 NOT NULL,
56  `video_thumbnail` text CHARACTER SET utf8 NOT NULL,
57  `video_duration` varchar(255) CHARACTER SET utf8 NOT NULL,
58  `video_description` text CHARACTER SET utf8 NOT NULL,
59  `video_type` varchar(45) CHARACTER SET utf8 NOT NULL,
60  PRIMARY KEY (`id`)
61) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
62
63-- --------------------------------------------------------
64
65--
66-- Table structure for table `tbl_user`
67--
68
69CREATE TABLE IF NOT EXISTS `tbl_user` (
70  `ID` int(11) NOT NULL AUTO_INCREMENT,
71  `Username` varchar(15) NOT NULL,
72  `Password` text NOT NULL,
73  `Email` varchar(100) NOT NULL,
74  PRIMARY KEY (`ID`)
75) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
76
77--
78-- Dumping data for table `tbl_user`
79--
80
81INSERT INTO `tbl_user` (`ID`, `Username`, `Password`, `Email`) VALUES
82(1, 'admin', 'd82494f05d6917ba02f7aaa29689ccb444bb73f20380876cb05d1f37537b7892', 'email@website.com');
83
84/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
85/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
86/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;