public
anonymous / gist:2160968
Created

  • Download Gist
gistfile1.sql
SQL
1 2 3 4 5 6 7 8 9 10 11 12 13
CREATE TABLE `teams` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`status` varchar(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
INSERT INTO `teams` (`id`, `name`, `start_date`, `end_date`, `status`)
VALUES
(1,'TEST','2012-03-24','2012-03-31','WAITING'),
(2,'TEST2','2012-03-27','2012-03-30','START');

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.