File: database/tbl_article.sql
| Recommend this page to a friend! |
| Classes of Gjero Krsteski | > | Building an Identity Map in PHP | > | database/tbl_article.sql | > | Download |
|
|
||||||||||||||||||||
Contents
 Download |
CREATE TABLE IF NOT EXISTS tbl_article (
id INT NOT NULL AUTO_INCREMENT,
title VARCHAR(30) NOT NULL,
content VARCHAR(255) NOT NULL,
userId INT NOT NULL,
PRIMARY KEY (id),
INDEX (userId),
FOREIGN KEY (userId)
REFERENCES tbl_user (id)
ON DELETE CASCADE
ON UPDATE CASCADE
) TYPE=INNODB DEFAULT CHARSET=utf8;
|
