-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 31, 2013 at 12:04 PM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `web-school`
--

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

--
-- Table structure for table `admin_users`
--

CREATE TABLE IF NOT EXISTS `admin_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `date_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` int(11) NOT NULL,
  `user_type` int(11) NOT NULL,
  `user_key` varchar(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `admin_users`
--

INSERT INTO `admin_users` (`id`, `first_name`, `last_name`, `username`, `password`, `email`, `date_updated`, `type`, `user_type`, `user_key`) VALUES
(1, 'Administrator', 'Webschool', 'admin', '0192023a7bbd73250516f069df18b500', 'it@aristosems.com', '2013-12-30 13:10:34', 0, 0, 'k$web*'),
(7, '', '', 'ashwini', 'ff0eef605a66301097c87d2724025384', 'ashwinipradeep8@gmail.com', '2013-12-31 11:30:44', 0, 0, '');

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

--
-- Table structure for table `client_org`
--

CREATE TABLE IF NOT EXISTS `client_org` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL,
  `school_name` varchar(100) NOT NULL,
  `contact_person` varchar(100) NOT NULL,
  `contact_email` varchar(100) NOT NULL,
  `phone_number` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `pb_no` int(11) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `fax` varchar(100) NOT NULL,
  `sms_credict` int(11) NOT NULL,
  `email_credict` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `updated_date` datetime NOT NULL,
  `package_start_date` datetime NOT NULL,
  `daily_agenda` int(11) NOT NULL,
  `user_key` varchar(100) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=97 ;

--
-- Dumping data for table `client_org`
--

INSERT INTO `client_org` (`id`, `admin_id`, `school_name`, `contact_person`, `contact_email`, `phone_number`, `address`, `pb_no`, `mobile`, `fax`, `sms_credict`, `email_credict`, `created_date`, `updated_date`, `package_start_date`, `daily_agenda`, `user_key`, `status`) VALUES
(96, 0, 'ashwini', '', 'ashwinipradeep8@gmail.com', '', '', 0, '', '', 0, 0, '2013-12-31 11:30:44', '0000-00-00 00:00:00', '2013-12-31 11:30:44', 0, '', 1);

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

--
-- Table structure for table `login_attempt`
--

CREATE TABLE IF NOT EXISTS `login_attempt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `user_key` int(11) NOT NULL,
  `date_time` datetime NOT NULL,
  `ip` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `login_attempt`
--

INSERT INTO `login_attempt` (`id`, `userid`, `user_key`, `date_time`, `ip`) VALUES
(1, 1, 0, '2013-12-31 11:49:30', '127.0.0.1'),
(2, 7, 0, '2013-12-31 11:50:12', '127.0.0.1'),
(3, 1, 0, '2013-12-31 11:51:21', '127.0.0.1'),
(4, 1, 0, '2013-12-31 11:52:49', '127.0.0.1'),
(5, 7, 0, '2013-12-31 11:53:17', '127.0.0.1'),
(6, 7, 0, '2013-12-31 11:54:22', '127.0.0.1'),
(7, 7, 0, '2013-12-31 11:54:45', '127.0.0.1'),
(8, 7, 0, '2013-12-31 11:55:23', '127.0.0.1'),
(9, 0, 0, '2013-12-31 11:56:33', '127.0.0.1'),
(10, 0, 0, '2013-12-31 11:56:55', '127.0.0.1'),
(11, 0, 0, '2013-12-31 11:57:33', '127.0.0.1'),
(12, 0, 0, '2013-12-31 11:57:58', '127.0.0.1'),
(13, 0, 0, '2013-12-31 11:58:40', '127.0.0.1'),
(14, 0, 0, '2013-12-31 11:58:53', '127.0.0.1');
