Login   Register  
PHP Classes
elePHPant
Icontem

File: movieDB.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Nitesh Apte  >  Login System  >  movieDB.sql  >  Download  
File: movieDB.sql
Role: Auxiliary data
Content type: text/plain
Description: DB Back Up
Class: Login System
Authenticate users with records in a database
Author: By
Last change:
Date: 4 years ago
Size: 931 bytes
 

Contents

Class file image Download
-- 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);