Skip to content

Instantly share code, notes, and snippets.

@PEKTOP

PEKTOP/create_tables.sql

Created June 1, 2017 20:36
Show Gist options
  • Save PEKTOP/faa2270eec380d5995584517faa03c2f to your computer and use it in GitHub Desktop.
Save PEKTOP/faa2270eec380d5995584517faa03c2f to your computer and use it in GitHub Desktop.
Download ZIP
coin32
Raw
create_tables.sql
CREATE TABLE `users` (
`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` varchar(100) NOT NULL
);
CREATE TABLE `transactions` (
`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`user_id` int(11) NOT NULL,
`created` datetime NOT NULL,
`amount` decimal(8,2) NOT NULL,
FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment