-- phpMyAdmin SQL Dump
-- version 2.8.2-Debian-0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 15, 2007 at 12:41 PM
-- Server version: 5.0.24
-- PHP Version: 5.1.6
--
-- Database: `user`
--
CREATE DATABASE `user` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `user`;
-- --------------------------------------------------------
--
-- Table structure for table `config`
--
CREATE TABLE `config` (
`id` int(4) NOT NULL auto_increment,
`cfg` varchar(15) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `config`
--
INSERT DELAYED INTO `config` (`id`, `cfg`, `value`) VALUES (1, 'group_names', 'a:4:{i:1;s:5:"Admin";i:2;s:4:"User";}');
-- --------------------------------------------------------
--
-- Table structure for table `identity`
--
CREATE TABLE `identity` (
`uid` int(255) NOT NULL default '0',
`Company` varchar(50) NOT NULL default '',
`Street` varchar(65) NOT NULL default '',
`City` varchar(20) NOT NULL default '',
`State` char(2) NOT NULL default '',
`Country` char(2) NOT NULL default '',
`ZIP` varchar(10) NOT NULL,
`ZIP4` varchar(5) NOT NULL,
`Phone` varchar(20) NOT NULL default '',
`Cell` varchar(20) NOT NULL default '',
`Fax` varchar(20) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`Yahoo` varchar(255) NOT NULL default '',
`MSN` varchar(255) NOT NULL default '',
`ICQ` int(11) NOT NULL,
`AIM` varchar(255) NOT NULL default '',
`url` varchar(65) NOT NULL default '',
`Birthday` date NOT NULL default '0000-00-00',
`Notes` text NOT NULL,
`last_db_change` datetime NOT NULL default '0000-00-00 00:00:00',
`date_joined` date NOT NULL default '0000-00-00',
`newemail` varchar(40) NOT NULL default '',
`confirmkey` varchar(255) NOT NULL default '',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `identity`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`uid` int(255) NOT NULL auto_increment,
`alias` varchar(40) NOT NULL,
`pass` varchar(40) NOT NULL default '',
`default_group` tinyint(4) NOT NULL default '2',
`groups` varchar(255) NOT NULL default '2',
`First_Name` varchar(20) NOT NULL default '',
`Last_Name` varchar(20) NOT NULL default '',
`GMT_Offset` tinyint(3) default NULL,
`DTS` enum('Yes','No') default NULL,
`IP` varchar(20) NOT NULL default '',
`last_login` datetime NOT NULL default '0000-00-00 00:00:00',
`login_count` int(255) NOT NULL default '0',
`status` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `users`
--
|