· 7 years ago · Sep 10, 2018, 12:08 PM
1--creates clean database for Dice
2
3DROP DATABASE IF EXISTS `Dice`;
4CREATE DATABASE `Dice`;
5USE `Dice`;
6CREATE TABLE Results (
7 `id` INT(10) NOT NULL auto_increment PRIMARY KEY,
8 `kind` varchar(50) not null,
9 `roll` INT not null,
10 `created_at` timestamp not null
11);
12
13insert into Results (id, kind, roll) VALUES ('1', 'two', '1');