Cart

http://www.otimizebusca.com.br/10-erros-comuns-ao-se-promover-promocoes-e-sorteios-no-facebook/

– phpMyAdmin SQL Dump
— version 3.4.5deb1
— http://www.phpmyadmin.net

— Servidor: localhost
— Tempo de Geração: 13/05/2015 às 11h02min
— Versão do Servidor: 5.1.66
— Versão do PHP: 5.3.6-13ubuntu3.9

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 */;


— Banco de Dados: `mb_turismo`

— ——————————————————–


— Estrutura da tabela `agencies`

CREATE TABLE IF NOT EXISTS `clubs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`title` varchar(500) NOT NULL,
`description` mediumtext NOT NULL,
`address` varchar(300) NOT NULL,
`phones` varchar(300) NOT NULL,
`album_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


— Extraindo dados da tabela `agencies`

INSERT INTO `clubs` (`id`, `created`, `title`, `description`, `address`, `phones`, `album_id`) VALUES
(1, ‘2015-02-12 12:22:11’, ‘Jeep Clube RN’, ‘

\r\n

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sollicitudin fermentum aliquet. Donec nulla purus, pulvinar id sagittis blandit, interdum non enim. Morbi facilisis quam et consectetur rhoncus. Donec dapibus ipsum ac congue molestie. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed gravida finibus iaculis. Mauris et pulvinar justo. Nulla semper mauris id scelerisque rhoncus.

\r\n\r\n

Etiam varius iaculis sagittis. Fusce rhoncus ultricies nisl vitae sagittis. Donec convallis nisi in nunc pretium ultrices non quis dolor. Suspendisse aliquet urna sed sapien euismod ultrices. Nam ac eros sit amet turpis tristique fringilla ac id quam. In ultrices, ante eget tincidunt interdum, urna mauris aliquet erat, vitae porttitor risus felis nec augue. Quisque arcu metus, ullamcorper vel malesuada eu, euismod ultricies est. Duis convallis quis leo lobortis ultrices. Praesent ac orci vel ex venenatis maximus a et lacus.

\r\n

\r\n’, ‘Lorem ipsum dolor sit amet. ‘, ‘Lorem ipsum dolor sit amet. ‘, 16);

— ——————————————————–


— Estrutura da tabela `albums`

CREATE TABLE IF NOT EXISTS `albums` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`created` datetime NOT NULL,
`image` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`user_id` int(11) NOT NULL,
`description` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

— ——————————————————–


— Estrutura da tabela `alerts`

CREATE TABLE IF NOT EXISTS `alerts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`unique_id` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`message` varchar(255) NOT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

— ——————————————————–


— Estrutura da tabela `articles`

CREATE TABLE IF NOT EXISTS `articles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`created` datetime NOT NULL,
`image` varchar(255) NOT NULL,
`video` varchar(255) NOT NULL,
`description` mediumtext NOT NULL,
`archive` varchar(255) NOT NULL,
`visibility` varchar(20) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

— ——————————————————–


— Estrutura da tabela `associateds`

CREATE TABLE IF NOT EXISTS `jipeiros` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
`gender` varchar(20) NOT NULL,
`relationship` varchar(50) NOT NULL,
`rg` varchar(11) NOT NULL,
`cpf` varchar(14) NOT NULL,
`phone_celular` varchar(20) NOT NULL,
`phone_residence` varchar(20) NOT NULL,
`phone_hospital` varchar(20) NOT NULL,
`phone_office` varchar(20) NOT NULL,
`cadastre_type` varchar(20) NOT NULL,
`birthday` datetime NOT NULL,
`correspondence_address` varchar(255) NOT NULL,
`residencemed_place` varchar(255) NOT NULL,
`receive_emails` tinyint(1) NOT NULL DEFAULT ‘0’,
`address` varchar(200) NOT NULL,
`complement` varchar(255) NOT NULL,
`neighborhood` varchar(100) NOT NULL,
`city` varchar(100) NOT NULL,
`residence_state` varchar(255) NOT NULL,
`state` varchar(50) NOT NULL,
`office_address` varchar(255) NOT NULL,
`office_cep` varchar(20) NOT NULL,
`office_complement` varchar(255) NOT NULL,
`office_neighborhood` varchar(255) NOT NULL,
`office_city` varchar(255) NOT NULL,
`office_state` varchar(20) NOT NULL,
`graduation_college` varchar(255) NOT NULL,
`graduation_year` varchar(100) NOT NULL,
`cep` varchar(10) NOT NULL,
`email` varchar(50) DEFAULT NULL,
`crm` varchar(100) NOT NULL,
`active` tinyint(1) NOT NULL,
`active_reason` varchar(100) DEFAULT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;

— ——————————————————–


— Estrutura da tabela `corporatives`

CREATE TABLE IF NOT EXISTS `corporatives` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(30) NOT NULL,
`cnpj` varchar(30) NOT NULL,
`corporate_name` varchar(255) NOT NULL,
`address` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL,
`user_id` int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;

— ——————————————————–


— Estrutura da tabela `events`

CREATE TABLE IF NOT EXISTS `events` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`user_id` int(11) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`title` varchar(255) NOT NULL,
`event_date` date NOT NULL,
`description` mediumtext NOT NULL,
`image` varchar(255) NOT NULL,
`album_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

— ——————————————————–


— Estrutura da tabela `groups`

CREATE TABLE IF NOT EXISTS `groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`rules` text,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;


— Extraindo dados da tabela `groups`

INSERT INTO `groups` (`id`, `name`, `rules`, `active`, `created`, `modified`) VALUES
(1, ‘Grupo Administrador’, ”, 1, ‘2014-11-05 18:52:39’, ‘2014-11-05 18:52:39’),
(3, ‘Grupo Gerente’, ‘{“Users”:[“admin_index”,”admin_add”,”admin_edit”,”admin_delete”,”admin_passwordChange”]}’, 1, ‘2014-11-05 18:52:39’, ‘2014-11-05 18:52:39’),
(7, ‘Grupo Associado’, ‘[]’, 1, ‘2014-12-03 15:18:10’, ‘2014-12-03 15:18:10’);

— ——————————————————–


— Estrutura da tabela `informatives`

CREATE TABLE IF NOT EXISTS `informatives` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`email` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

— ——————————————————–


— Estrutura da tabela `itineraries`

CREATE TABLE IF NOT EXISTS `itineraries` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`user_id` int(11) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`title` varchar(500) NOT NULL,
`category_id` varchar(2) NOT NULL,
`description` mediumtext NOT NULL,
`observations` varchar(1000) NOT NULL,
`price` varchar(30) NOT NULL,
`aero` tinyint(1) NOT NULL DEFAULT ‘0’,
`diaries` varchar(10) NOT NULL,
`image` varchar(255) NOT NULL,
`album_id` int(11) NOT NULL,
`highlight` tinyint(1) NOT NULL DEFAULT ‘0’,
`localization` varchar(500) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;

— ——————————————————–


— Estrutura da tabela `menus`

CREATE TABLE IF NOT EXISTS `menus` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(45) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

— ——————————————————–


— Estrutura da tabela `monthly_payments`

CREATE TABLE IF NOT EXISTS `monthly_payments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`associated_id` int(11) NOT NULL,
`month` varchar(30) NOT NULL,
`value` varchar(30) NOT NULL,
`status` varchar(30) NOT NULL,
`maturity_date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

— ——————————————————–


— Estrutura da tabela `pages`

CREATE TABLE IF NOT EXISTS `pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

— ——————————————————–


— Estrutura da tabela `photos`

CREATE TABLE IF NOT EXISTS `photos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`created` datetime NOT NULL,
`archive` varchar(255) NOT NULL,
`album_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;


— Extraindo dados da tabela `photos`

INSERT INTO `photos` (`id`, `title`, `created`, `archive`, `album_id`) VALUES
(23, ‘awd’, ‘2015-02-23 19:07:55’, ‘sonic-4.jpg’, 14),
(24, ‘awdawd’, ‘2015-02-23 19:08:09’, ‘sonic-5.jpg’, 14),
(25, ‘awdawd’, ‘2015-02-23 19:08:18’, ‘sonic-6.jpg’, 14),
(40, ‘awdawd’, ‘2015-02-23 21:39:37’, ‘camaro-10.jpg’, 14),
(49, ‘foto 1’, ‘2015-03-25 13:29:44’, ‘copa-praiabonita.png’, 16),
(50, ‘foto 2’, ‘2015-03-25 13:29:57’, ‘copa-praiabonita-2.png’, 16),
(48, ‘foto 1’, ‘2015-03-24 21:04:05’, ‘img-20140930-wa0004.jpg’, 12),
(38, ‘awdawd’, ‘2015-02-23 21:37:37’, ‘camaro-8.jpg’, 14),
(39, ‘awdawd’, ‘2015-02-23 21:38:58’, ‘camaro-9.jpg’, 14);

— ——————————————————–


— Estrutura da tabela `rates`

CREATE TABLE IF NOT EXISTS `rates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`user_id` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`archive` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

— ——————————————————–


— Estrutura da tabela `settings`

CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`title` varchar(100) NOT NULL,
`description` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

— ——————————————————–


— Estrutura da tabela `slides`

CREATE TABLE IF NOT EXISTS `slides` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`user_id` int(11) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`title` varchar(255) NOT NULL,
`image` varchar(255) NOT NULL,
`link` varchar(255) NOT NULL,
`enter_date` datetime NOT NULL,
`exit_date` datetime NOT NULL,
`album_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

— ——————————————————–


— Estrutura da tabela `tips`

CREATE TABLE IF NOT EXISTS `tips` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`title` varchar(255) NOT NULL,
`description` mediumtext NOT NULL,
`image` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

— ——————————————————–


— Estrutura da tabela `users`

CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
`login` varchar(100) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`image` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT ‘0’,
`last_login` datetime DEFAULT NULL,
`password_recovery` varchar(255) DEFAULT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`group_id` int(11) NOT NULL,
`m3client_id` int(11) NOT NULL,
`store_id` int(11) NOT NULL,
`is_manager` int(11) NOT NULL DEFAULT ‘0’,
`cookie_hash` varchar(255) NOT NULL,
`cookie_time` int(11) NOT NULL DEFAULT ‘0’,
`associated_id` int(11) DEFAULT NULL,
`new_user` tinyint(1) NOT NULL DEFAULT ‘1’,
PRIMARY KEY (`id`),
UNIQUE KEY `login_UNIQUE` (`login`),
KEY `fk_users_groups_idx` (`group_id`),
KEY `fk_users_m3clients1_idx` (`m3client_id`),
KEY `fk_users_stores1_idx` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


— Extraindo dados da tabela `users`

INSERT INTO `users` (`id`, `name`, `login`, `email`, `password`, `image`, `active`, `last_login`, `password_recovery`, `created`, `modified`, `group_id`, `m3client_id`, `store_id`, `is_manager`, `cookie_hash`, `cookie_time`, `associated_id`, `new_user`) VALUES
(1, ‘Administrador M3’, ‘teste’, ‘atendimento@novam3.com.br’, ’25be3abe4593b4482adb7554762755e7d1a6c05f’, ‘Koala-0.jpg’, 1, ‘2015-03-27 21:23:27’, ”, ‘2014-10-29 00:00:00’, ‘2015-03-27 18:19:08’, 1, 1, 1, 1, ”, 0, NULL, 0);

/*!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 */;

Endereço

Rua Poeta Jorge Fernandes, 379 - Praia de Ponta Negra
Natal/RN - CEP: 59.090-450

Contato


WhatsApp: (84) 99229-1441
Email: reservas@praiaaparthotel.com.br