Advertisement
GreMendes

SQL ToDoList

Oct 26th, 2015
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.38 KB | None | 0 0
  1. CREATE DATABASE ToDoList;
  2. USE ToDoList;
  3. CREATE TABLE users(
  4.     id INT AUTO_INCREMENT PRIMARY KEY,
  5.     email VARCHAR(255) NOT NULL,
  6.     password VARCHAR(255) NOT NULL,
  7.     admin BOOLEAN NOT NULL DEFAULT FALSE
  8. );
  9.  
  10. CREATE TABLE tarefas(
  11.     id INT AUTO_INCREMENT PRIMARY KEY,
  12.     user_id INT NOT NULL,
  13.     tarefa VARCHAR(255),
  14.     done BOOLEAN DEFAULT FALSE,
  15.     FOREIGN KEY (user_id) REFERENCES users(id)
  16. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement