Login   Register  
PHP Classes
elePHPant
Icontem

File: example.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Keven Ages  >  Auto-Gen CSS Forms  >  example.sql  >  Download  
File: example.sql
Role: Auxiliary data
Content type: text/plain
Description: Example SQL File
Class: Auto-Gen CSS Forms
Generate forms to edit MySQL table records
Author: By
Last change:
Date: 7 years ago
Size: 737 bytes
 

Contents

Class file image Download
-- Table structure for table `players`
-- 

CREATE TABLE `players` (
  `player_id` int(10) NOT NULL auto_increment,
  `user_name` varchar(25) NOT NULL,
  `password` varchar(75) NOT NULL,
  `last_login` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `created_on` timestamp NOT NULL default '0000-00-00 00:00:00',
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(40) NOT NULL,
  `email` varchar(200) NOT NULL,
  `sex` enum('m','f') NOT NULL,
  `home_phone` varchar(12) NOT NULL,
  `mobile_phone` varchar(12) NOT NULL,
  `fax` varchar(12) NOT NULL,
  `address` longtext NOT NULL,
  `team` int(7) NOT NULL COMMENT 'pk - teams',
  `group` int(3) NOT NULL COMMENT 'pk - groups',
  PRIMARY KEY  (`player_id`)
);