Login   Register  
PHP Classes
elePHPant
Icontem

File: sample_sql.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Saeed Ahmed  >  Simple login and database module  >  sample_sql.sql  >  Download  
File: sample_sql.sql
Role: Auxiliary data
Content type: text/plain
Description: sample sql files for testing
Class: Simple login and database module
Authenticate users with records in a MySQL table
Author: By
Last change:
Date: 2010-08-18 05:33
Size: 429 bytes
 

Contents

Class file image Download 
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');