Login   Register  
PHP Classes
elePHPant
Icontem

File: sql/table.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of johno dread  >  Yahoo MSN chat  >  sql/table.sql  >  Download  
File: sql/table.sql
Role: Auxiliary data
Content type: text/plain
Description: Create database
Class: Yahoo MSN chat
Determine if Yahoo or MSN users are online
Author: By
Last change:
Date: 4 years ago
Size: 668 bytes
 

Contents

Class file image Download
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(20) NOT NULL,
  `last_name` varchar(20) NOT NULL,
  `email` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

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

INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`) VALUES
(3, 'jono', 'dread', 'johnodread@yahoo.com'),
(4, 'goan', 'therun', 'goantherun@yahoo.com'),
(5, 'gaon', 'therun', 'gaontherun@yahoo.com'),
(6, 'ann', 'splashyy', 'splashyy@yahoo.com'),
(7, 'Nally', 'Artz', 'Nailrtzt@yahoo.com'),
(8, 'johno', 'dread', 'johnodread01@hotmail.com');