Skip to content

Instantly share code, notes, and snippets.

@prule
Created September 10, 2014 23:33
Show Gist options
  • Save prule/ab5db506ee42926a42db to your computer and use it in GitHub Desktop.
Save prule/ab5db506ee42926a42db to your computer and use it in GitHub Desktop.
Create spike database with Projects table and test data
create database spike;
grant all privileges on spike.* to 'anon'@'localhost' identified by 'password';
flush privileges;
use spike;
CREATE TABLE `projects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`createdAt` datetime DEFAULT NULL,
`updatedAt` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
INSERT INTO `spike`.`projects` (`id`, `name`, `status`) VALUES ('1', 'test', 'active');
INSERT INTO `spike`.`projects` (`id`, `name`, `status`) VALUES ('2', 'me', 'active');
INSERT INTO `spike`.`projects` (`id`, `name`, `status`) VALUES ('3', '1,2,3,4,5,6', 'active');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment