Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE kommentit (
- id INT(5) NOT NULL auto_increment,
- kommentoija_id INT(5) NOT NULL,
- sisalto TEXT NOT NULL,
- url VARCHAR(80) NOT NULL,
- alkaen DATETIME NOT NULL,
- paattyen DATETIME NOT NULL,
- avauskommentti TINYINT(1) NOT NULL,
- lisaysaika DATETIME NOT NULL,
- jarjestelma_id INT(5) NOT NULL,
- PRIMARY KEY (id)
- )
- CREATE TABLE kommentoijat (
- id INT(5) NOT NULL auto_increment,
- nimi VARCHAR(35) NOT NULL,
- organisaatio VARCHAR(35) NOT NULL,
- sahkoposti VARCHAR(35) NOT NULL,
- titteli VARCHAR(35) NOT NULL,
- jarjestelma_id INT(5) NOT NULL
- PRIMARY KEY (id)
- )
- CREATE TABLE jarjestelma (
- id INT(5) NOT NULL auto_increment,
- jarjestelma VARCHAR(35) NOT NULL
- PRIMARY KEY (id)
- )
Add Comment
Please, Sign In to add comment