Skip to content

Instantly share code, notes, and snippets.

@curtiszimmerman

curtiszimmerman/sample.sql

Created August 15, 2016 19:57
Show Gist options
  • Save curtiszimmerman/6bc63d5a91b0ab9a0ccdce89ad5c63a0 to your computer and use it in GitHub Desktop.
Save curtiszimmerman/6bc63d5a91b0ab9a0ccdce89ad5c63a0 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. curtiszimmerman created this gist Aug 15, 2016.
    11 changes: 11 additions & 0 deletions sample.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,11 @@
    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;