Файл: flexmovies/FlexMovies.sql
Строк: 76
-- phpMyAdmin SQL Dump
-- version 4.0.8
-- http://www.phpmyadmin.net
--
--
Host: localhost
-- Generation Time: Jun 24, 2014 at 08:51 AM
-- Server
version: 5.5.34-cll-lve
-- PHP Version: 5.3.17
SET SQL_MODE =
"NO_AUTO_VALUE_ON_ZERO";
SET time_zone =
"+00:00";
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;
--
-- Database: `FlexMovies`
--
--
--------------------------------------------------------
--
-- Table
structure for table `activity`
--
CREATE TABLE IF NOT EXISTS `activity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content_id` int(11) NOT NULL,
`title` varchar(255) COLLATE utf8_bin NOT NULL,
`img` varchar(255)
COLLATE utf8_bin NOT NULL,
`content` varchar(55) COLLATE utf8_bin NOT
NULL,
`add_time` varchar(55) COLLATE utf8_bin NOT NULL,
`user_id`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=145 ;
--
--------------------------------------------------------
--
-- Table
structure for table `settings`
--
CREATE TABLE IF NOT EXISTS `settings` (
`title` varchar(255) COLLATE utf8_bin NOT NULL,
`description` text
COLLATE utf8_bin NOT NULL,
`keywords` varchar(255) COLLATE utf8_bin NOT
NULL,
`language` varchar(255) COLLATE utf8_bin NOT NULL,
`TMDBAPIkey`
varchar(255) COLLATE utf8_bin NOT NULL,
`fb_appID` varchar(255) COLLATE
utf8_bin NOT NULL,
`fb_secret` varchar(255) COLLATE utf8_bin NOT NULL,
`template` varchar(100) COLLATE utf8_bin NOT NULL,
`admin_username`
varchar(255) COLLATE utf8_bin NOT NULL,
`admin_password` varchar(255)
COLLATE utf8_bin NOT NULL,
`ad_1` text COLLATE utf8_bin NOT NULL,
`ad_2` text COLLATE utf8_bin NOT NULL,
`ad_3` text COLLATE utf8_bin NOT
NULL,
`ad_4` text COLLATE utf8_bin NOT NULL,
`ad_5` text COLLATE
utf8_bin NOT NULL,
`ad_6` text COLLATE utf8_bin NOT NULL,
`ad_7` text
COLLATE utf8_bin NOT NULL,
`ad_8` text COLLATE utf8_bin NOT NULL,
`ad_9` text COLLATE utf8_bin NOT NULL,
`seo_urls` int(1) NOT NULL
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data
for table `settings`
--
INSERT INTO `settings` (`title`, `description`,
`keywords`, `language`, `TMDBAPIkey`, `fb_appID`, `fb_secret`, `template`,
`admin_username`, `admin_password`, `ad_1`, `ad_2`, `ad_3`, `ad_4`, `ad_5`,
`ad_6`, `ad_7`, `ad_8`, `ad_9`, `seo_urls`) VALUES
('FlexMovies', 'Movies',
'movies, tv, tv shows, people, celebrities, movies, stars, reviews,
discover everything ', 'english', '', '', '', 'templates/default', 'admin',
'21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', '', '', '', '',
1);
-- --------------------------------------------------------
--
--
Table structure for table `user`
--
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fb_id` varchar(255) COLLATE
utf8_bin NOT NULL,
`first_name` varchar(255) COLLATE utf8_bin NOT NULL,
`last_name` varchar(255) COLLATE utf8_bin NOT NULL,
`email` varchar(255)
COLLATE utf8_bin NOT NULL,
`gender` varchar(55) COLLATE utf8_bin NOT
NULL,
`reg_date` varchar(255) COLLATE utf8_bin NOT NULL,
`status`
int(11) NOT NULL,
`password` varchar(100) COLLATE utf8_bin NOT NULL,
`img` varchar(255) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=28
;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT
*/;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS
*/;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;