Файл: dump.sql
Строк: 168
-- phpMyAdmin SQL Dump
-- version 3.5.7
-- http://www.phpmyadmin.net
--
--
Host: localhost
-- Generation Time: Jul 18, 2013 at 08:33 PM
-- Server
version: 5.6.12
-- PHP Version: 5.3.15
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: `meme`
--
--
--------------------------------------------------------
--
-- Table
structure for table `meme`
--
DROP TABLE IF EXISTS `meme`;
CREATE TABLE IF
NOT EXISTS `meme` (
`meme_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_fk` int(10) unsigned DEFAULT '0',
`remix_id` int(10) unsigned NOT
NULL DEFAULT '0',
`title` varchar(255) CHARACTER SET utf8 COLLATE
utf8_bin DEFAULT NULL,
`file` varchar(100) DEFAULT NULL,
`is_published`
tinyint(1) unsigned DEFAULT '0',
`likes_count` int(11) DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`is_featured` int(10) unsigned
DEFAULT '0',
`is_active` int(10) unsigned DEFAULT '0',
PRIMARY KEY
(`meme_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_bin
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `meme_flag`
--
DROP TABLE IF EXISTS
`meme_flag`;
CREATE TABLE IF NOT EXISTS `meme_flag` (
`meme_flag_id`
int(10) unsigned NOT NULL AUTO_INCREMENT,
`meme_fk` int(10) unsigned NOT
NULL,
`user_fk` int(10) unsigned NOT NULL,
`created_at` datetime NOT
NULL,
PRIMARY KEY (`meme_flag_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET
utf8 COLLATE utf8_bin AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `meme_like`
--
DROP TABLE IF EXISTS
`meme_like`;
CREATE TABLE IF NOT EXISTS `meme_like` (
`meme_like_id`
int(10) unsigned NOT NULL AUTO_INCREMENT,
`meme_fk` int(10) unsigned
DEFAULT NULL,
`user_fk` int(10) unsigned DEFAULT NULL,
`created_at`
datetime DEFAULT NULL,
PRIMARY KEY (`meme_like_id`)
) ENGINE=InnoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `page`
--
DROP TABLE IF EXISTS `page`;
CREATE TABLE IF
NOT EXISTS `page` (
`page_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`page_position_fk` int(10) unsigned NOT NULL,
`title` varchar(255)
CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`slug` varchar(255)
CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`content` text CHARACTER
SET utf8 COLLATE utf8_bin NOT NULL,
`weight` int(11) NOT NULL DEFAULT
'0',
`parent_id` int(10) unsigned NOT NULL DEFAULT '0',
`updated_at`
datetime NOT NULL,
`created_at` datetime NOT NULL,
`is_active`
tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`page_id`)
)
ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_bin AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
-- Table
structure for table `page_position`
--
DROP TABLE IF EXISTS
`page_position`;
CREATE TABLE IF NOT EXISTS `page_position` (
`page_position_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`position`
varchar(255) NOT NULL,
PRIMARY KEY (`page_position_id`),
UNIQUE KEY
`page_position_id` (`page_position_id`)
) ENGINE=InnoDB DEFAULT CHARACTER
SET utf8 COLLATE utf8_bin AUTO_INCREMENT=3 ;
--
-- Dumping data for table
`page_position`
--
INSERT INTO `page_position` (`page_position_id`,
`position`) VALUES
(1, 'header'),
(2, 'footer');
--
--------------------------------------------------------
--
-- Table
structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
CREATE
TABLE IF NOT EXISTS `settings` (
`variable` char(32) NOT NULL,
`value`
text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`title` varchar(255)
NOT NULL,
PRIMARY KEY (`variable`)
) ENGINE=InnoDB DEFAULT CHARACTER SET
utf8 COLLATE utf8_bin;
--
-- Dumping data for table `settings`
--
INSERT
INTO `settings` (`variable`, `value`, `title`) VALUES
('ad1', '',
''),
('ad2', '', ''),
('ad3', '', ''),
('watermark_color', '#c8dce1',
''),
('watermark_enable', '0', ''),
('watermark_size', '18',
''),
('watermark_text', 'mememakerscript.com', '');
--
--------------------------------------------------------
--
-- Table
structure for table `social_login`
--
DROP TABLE IF EXISTS
`social_login`;
CREATE TABLE IF NOT EXISTS `social_login` (
`social_login_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_fk`
int(10) unsigned DEFAULT '0',
`provider` varchar(16) DEFAULT NULL,
`identifier` varchar(50) DEFAULT NULL,
PRIMARY KEY (`social_login_id`)
)
ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_bin AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
-- Table
structure for table `user`
--
DROP TABLE IF EXISTS `user`;
CREATE TABLE IF
NOT EXISTS `user` (
`user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(100) DEFAULT NULL,
`password` char(32) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`first_name` varchar(255) DEFAULT
NULL,
`last_name` varchar(255) DEFAULT NULL,
`token` char(32) DEFAULT
NULL,
`is_active` tinyint(1) unsigned DEFAULT '0',
`created_at`
datetime DEFAULT NULL,
`is_admin` tinyint(3) unsigned NOT NULL DEFAULT
'0',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8
COLLATE utf8_bin AUTO_INCREMENT=6 ;
--
-- Dumping data for table
`user`
--
INSERT INTO `user` (`user_id`, `username`, `password`, `email`,
`first_name`, `last_name`, `token`, `is_active`, `created_at`, `is_admin`)
VALUES
(1, 'admin', 'e10adc3949ba59abbe56e057f20f883e',
'mahadazad@gmail.com', 'Super', 'Admin',
'ebf01d16084e522003890244a9b391f8', 1, '2013-07-14 23:27:49', 1);
--
--------------------------------------------------------
--
-- Table
structure for table `user_follow`
--
DROP TABLE IF EXISTS
`user_follow`;
CREATE TABLE IF NOT EXISTS `user_follow` (
`user_follow_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_fk`
int(10) unsigned DEFAULT NULL,
`following_id` int(10) unsigned DEFAULT
NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY
(`user_follow_id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE
utf8_bin AUTO_INCREMENT=1 ;
/*!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 */;