-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 25, 2010 at 09:21 AM
-- Server version: 5.0.27
-- PHP Version: 5.2.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `logins`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`email_id` varchar(255) NOT NULL default '',
`passwd` varchar(50) NOT NULL default '',
`access_lvl` int(11) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `email_id` (`email_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `name`, `email_id`, `passwd`, `access_lvl`) VALUES
(1, 'User Name', 'user@user.com', 'user', 1); |