Recommend this page to a friend! |
Classes of Gjero Krsteski | > | Building an Identity Map in PHP | > | database/tbl_article.sql | > | 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; |