-
CREATE TABLE IF NOT EXISTS `category` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(100) NOT NULL,
  `status` varchar(5) NOT NULL DEFAULT 'y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;


--
-- Dumping data for table `category`
--


INSERT INTO `category` (`id`, `category_name`, `status`) VALUES
(1, 'Action', 'y'),
(2, 'Anime', 'y'),
(3, 'Dramas', 'y'),
(4, 'Horror', 'y'),
(5, 'Sports', 'y'),
(6, 'Thrillers', 'y'),
(7, 'TV', 'y');

--
-- Table structure for table `movies`
--


CREATE TABLE IF NOT EXISTS `movies` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `category_id` varchar(10) NOT NULL,
  `title` varchar(200) NOT NULL,
  `year` int(10) NOT NULL,
  `duration` varchar(10) NOT NULL,
  `rating` varchar(10) NOT NULL,
  `description` longtext NOT NULL,
  `product_image` longtext NOT NULL,
  `product_video` longtext NOT NULL,
  `product_trailer` longtext NOT NULL,
  `cast` longtext NOT NULL,
  `g_talen` longtext,
  `ondertitels` longtext NOT NULL,
  `status` varchar(5) NOT NULL DEFAULT 'y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;


--
-- Dumping data for table `movies`
--


INSERT INTO `movies` (`id`, `category_id`, `title`, `year`, `duration`, `rating`, `description`, `product_image`, `product_video`, `product_trailer`, `cast`, `g_talen`, `ondertitels`, `status`) VALUES
(1, '1', 'Red hill', 2004, '109', '6,0', 'Kweetnieeee', 'http://185.13.225.135/beta/images/movies/red-hill.jpg', 'http://185.13.225.135/Wrong.Turn.3.Left.For.Dead.UNRATED.2009.720p.BRrip.x264.YIFY.mp4', 'http://www.youtube.com/embed/Sw_9MBrqtQQ', 'naam1, naam2 ,naam3', 'Engels', 'Geen', 'y'),
(2, '2', 'Remember me', 2011, '91', '8,5', 'Hier komt nog meer informatie.', 'http://185.13.225.135/beta/images/movies/rememberme.jpg', '', 'http://www.youtube.com/embed/IMBfTdm9ALk', 'Robin patterson,', 'Engels', 'Geen', 'y');