Advertisement
Guest User

Untitled

a guest
May 22nd, 2015
209
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.34 KB | None | 0 0
  1. CREATE TABLE event(
  2.     event_id INT AUTO_INCREMENT PRIMARY KEY,
  3.     creator INT,
  4.     name VARCHAR(150) NOT NULL,
  5.     location VARCHAR(150) NOT NULL,
  6.     start_date date NOT NULL,
  7.     description TEXT NOT NULL,
  8.     picture VARCHAR(500) NOT NULL DEFAULT 'http://simonbrix.dk/assets/event_placeholder.png',
  9.     FOREIGN KEY (creator) REFERENCES user(user_id)
  10.  );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement