Code:
-- Community Auth - SQL Dump
-- Copyright (c) 2011 - 2012, Robert B Gottier. (http://brianswebdesign.com/)
-- http://community-auth.com
-- Licensed under the BSD license:
-- http://http://www.opensource.org/licenses/BSD-3-Clause
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT=0;
START TRANSACTION;
--
-- Database: `community_auth_ci_session`
--
-- --------------------------------------------------------
--
-- Table structure for table `ips_on_hold`
--
CREATE TABLE IF NOT EXISTS `ips_on_hold` (
`IP_address` int(4) NOT NULL,
`time` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `login_errors`
--
CREATE TABLE IF NOT EXISTS `login_errors` (
`username_or_email` varchar(255) NOT NULL,
`user_pass` varchar(60) NOT NULL,
`IP_address` int(4) NOT NULL,
`time` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `registration`
--
CREATE TABLE IF NOT EXISTS `registration` (
`reg_mode` int(1) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `registration` (`reg_mode`) VALUES
(0);
-- --------------------------------------------------------
--
-- Table structure for table `temp_registration_data`
--
CREATE TABLE IF NOT EXISTS `temp_registration_data` (
`reg_id` int(10) unsigned NOT NULL,
`reg_time` int(10) NOT NULL,
`user_name` varchar(12) NOT NULL,
`user_pass` varchar(255) NOT NULL,
`user_email` varchar(255) NOT NULL,
`first_name` varchar(40) NOT NULL,
`last_name` varchar(40) NOT NULL,
`license_number` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `username_or_email_on_hold`
--
CREATE TABLE IF NOT EXISTS `username_or_email_on_hold` (
`username_or_email` varchar(255) NOT NULL,
`time` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(10) unsigned NOT NULL,
`user_name` varchar(12) NOT NULL,
`user_email` varchar(255) NOT NULL,
`user_pass` varchar(60) NOT NULL,
`user_last_login` int(10) DEFAULT NULL,
`user_login_time` int(10) DEFAULT NULL,
`user_date` int(10) NOT NULL,
`user_modified` int(10) NOT NULL,
`user_agent_string` varchar(60) DEFAULT NULL,
`user_level` tinyint(1) unsigned NOT NULL,
`user_banned` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_name` (`user_name`),
UNIQUE KEY `user_email` (`user_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `user_profiles`
--
CREATE TABLE IF NOT EXISTS `user_profiles` (
`user_id` int(10) unsigned NOT NULL,
`first_name` varchar(20) NOT NULL,
`last_name` varchar(20) NOT NULL,
`license_number` varchar(30) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
COMMIT;