Posted By

pdswan on 07/29/09

Tagged

Versions (?)

Last Edited at 07/29/09 01:43pm

Statistics

Viewed 845 times

Favorited by 1 user(s)

Related snippets

Redux Auth Table SQL

/ Published in: SQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

-- phpMyAdmin SQL Dump
-- version 2.11.9.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 02, 2009 at 12:09 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.6
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
--
-- Database: `redux`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `groups`
--
 
CREATE TABLE IF NOT EXISTS `groups` (
  `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(20) NOT NULL,
  `description` VARCHAR(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `meta`
--
 
CREATE TABLE IF NOT EXISTS `meta` (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) UNSIGNED NOT NULL,
  `first_name` VARCHAR(50) NOT NULL,
  `last_name` VARCHAR(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `users`
--
 
CREATE TABLE IF NOT EXISTS `users` (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `group_id` mediumint(8) UNSIGNED NOT NULL,
  `ip_address` CHAR(16) NOT NULL,
  `username` VARCHAR(15) NOT NULL,
  `password` VARCHAR(40) NOT NULL,
  `email` VARCHAR(40) NOT NULL,
  `activation_code` VARCHAR(40) NOT NULL DEFAULT '0',
  `forgotten_password_code` VARCHAR(40) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;