PHP Classes

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  
File: database/tbl_article.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Building an Identity Map in PHP
Retrieve objects avoiding multiple instances
Author: By
Last change: Update of database/tbl_article.sql
Date: 1 month ago
Size: 343 bytes
 

Contents

Class file image 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;