-- phpMyAdmin SQL Dump
-- version 4.5.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Aug 20, 2016 at 09:11 AM
-- Server version: 5.7.11
-- PHP Version: 5.6.19

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

--
-- Database: `aesthetic-software`
--

-- --------------------------------------------------------

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) CHARACTER SET latin1 NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `timestamp` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `name`, `phone`, `email`, `is_active`, `is_delete`, `last_updated`, `timestamp`) VALUES
(4, 'Beverly Hills55555', 'Swrid', 'Kxgak', 1, 1, '2016-08-19 12:43:07', '2016-08-17 18:38:51'),
(5, 'Beverly Hillsssss', '3105551997ss', 'bhills_1997@mailinator.comsss', 1, 1, '2016-08-19 12:45:44', '2016-08-19 12:44:29'),
(6, 'Beverly Hills', '3105552564', 'bhills_2564@mailinator.com', 1, 0, '2016-08-19 12:46:47', '2016-08-19 12:46:47'),
(7, 'Beverly Hills', '3105553010', 'bhills_3010@mailinator.com', 1, 0, '2016-08-19 12:48:12', '2016-08-19 12:48:12'),
(8, 'Beverly Hills', '3105552082', 'bhills_2082@mailinator.com', 1, 0, '2016-08-20 08:53:41', '2016-08-20 08:53:41'),
(9, 'Beverly Hills', '3105552564', 'bhills_3225@mailinator.com', 1, 1, '2016-08-20 08:54:05', '2016-08-20 08:53:52');

-- --------------------------------------------------------

--
-- Table structure for table `emails`
--

CREATE TABLE `emails` (
  `id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `body` longtext NOT NULL,
  `is_sent` tinyint(1) NOT NULL DEFAULT '0',
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `site_info`
--

CREATE TABLE `site_info` (
  `id` int(1) NOT NULL,
  `name` varchar(255) CHARACTER SET latin1 NOT NULL,
  `slogan` varchar(255) CHARACTER SET latin1 NOT NULL,
  `about` varchar(255) CHARACTER SET latin1 NOT NULL,
  `favicon` varchar(255) CHARACTER SET latin1 NOT NULL,
  `cover_picture` varchar(255) CHARACTER SET latin1 NOT NULL,
  `logo` varchar(255) CHARACTER SET latin1 NOT NULL,
  `email` varchar(255) CHARACTER SET latin1 NOT NULL,
  `email2` varchar(255) CHARACTER SET latin1 NOT NULL,
  `phone` varchar(255) CHARACTER SET latin1 NOT NULL,
  `fax_no` varchar(255) CHARACTER SET latin1 NOT NULL,
  `address` varchar(255) CHARACTER SET latin1 NOT NULL,
  `zip` varchar(255) CHARACTER SET latin1 NOT NULL,
  `city` varchar(255) CHARACTER SET latin1 NOT NULL,
  `state` varchar(255) CHARACTER SET latin1 NOT NULL,
  `country` varchar(255) CHARACTER SET latin1 NOT NULL,
  `copyright` longtext CHARACTER SET latin1 NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `timestamp` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `site_info`
--

INSERT INTO `site_info` (`id`, `name`, `slogan`, `about`, `favicon`, `cover_picture`, `logo`, `email`, `email2`, `phone`, `fax_no`, `address`, `zip`, `city`, `state`, `country`, `copyright`, `last_updated`, `timestamp`) VALUES
(1, 'Aesthetic Software', 'For SMS and Email.', 'This software is used for sending sms and emails.', '34997785_aes.jpg', '', '34997785_aes.jpg', 'moinakbarali@gmail.com', 'moinakbarali@gmail.com', '03324124328', '03324124328', '609 A-1 Township', '54000', 'Lahore', 'Punjab', 'Pakistan', '2016 Aesthetic Software. All Rights Reserved.', '2016-08-19 12:24:53', '2016-07-03 19:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL,
  `username` varchar(255) CHARACTER SET latin1 NOT NULL,
  `first_name` varchar(25) CHARACTER SET latin1 NOT NULL,
  `last_name` varchar(25) CHARACTER SET latin1 NOT NULL,
  `email` varchar(255) CHARACTER SET latin1 NOT NULL,
  `phone` varchar(244) NOT NULL,
  `salt` varchar(3) CHARACTER SET latin1 NOT NULL,
  `password` varchar(255) CHARACTER SET latin1 NOT NULL,
  `password_updated` datetime DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_role` tinyint(1) NOT NULL DEFAULT '0',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_login` datetime DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `first_name`, `last_name`, `email`, `phone`, `salt`, `password`, `password_updated`, `is_active`, `is_role`, `is_delete`, `last_updated`, `last_login`, `timestamp`) VALUES
(1, 'superadmin', 'Super2', 'Admin', 'moinakbarali@gmail.com', '8769511100', '8ec', 'd3b7ef63adbaeb05d69c03a22e063598c2be8343a9adaedc5d5a8fd16e5a9017', '2016-05-17 18:07:04', 1, 0, 0, '2016-08-20 09:11:51', '2016-08-20 14:11:51', '2015-10-21 05:08:12'),
(2, 'user', 'User', 'Admin', 'moinakbarali@gmail.com', '8769511100', '8ec', 'd3b7ef63adbaeb05d69c03a22e063598c2be8343a9adaedc5d5a8fd16e5a9017', '2016-05-17 18:07:04', 1, 1, 0, '2016-08-19 12:54:52', '2016-08-19 17:54:52', '2015-10-21 05:08:12');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `emails`
--
ALTER TABLE `emails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `site_info`
--
ALTER TABLE `site_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `emails`
--
ALTER TABLE `emails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `site_info`
--
ALTER TABLE `site_info`
  MODIFY `id` int(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
/*!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 */;
