Created
August 15, 2016 19:57
-
-
Save curtiszimmerman/6bc63d5a91b0ab9a0ccdce89ad5c63a0 to your computer and use it in GitHub Desktop.
Sample SQL Import
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE IF NOT EXISTS Testing; | |
CREATE USER 'testing'@'%' IDENTIFIED BY ''; | |
GRANT ALL PRIVILEGES ON Testing.* TO 'testing'@'%'; | |
CREATE TABLE `Testing`.`Test` ( | |
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
`Data` int(11) DEFAULT NULL, | |
`Url` varchar(255) DEFAULT NULL, | |
`Timestamp` int(11) DEFAULT NULL, | |
PRIMARY KEY (`Id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment