File: example.sql

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