PHP Classes

File: example.sql

Recommend this page to a friend!
  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: 17 years ago
Size: 737 bytes


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`) );