PHP Classes

File: fwphp/glomodul/z_examples/book_video/03steinmetz_2008/ch12_Projects/blog_mktable

Recommend this page to a friend!
  Classes of Slavko Srakocic  >  B12 PHP FW  >  fwphp/glomodul/z_examples/book_video/03steinmetz_2008/ch12_Projects/blog_mktable  >  Download  
File: fwphp/glomodul/z_examples/book_video/03steinmetz_2008/ch12_Projects/blog_mktable
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: B12 PHP FW
Manage database records with a PDO CRUD interface
Author: By
Last change:
Date: 3 months ago
Size: 551 bytes
 

Contents

Class file image Download
DROP TABLE IF EXISTS blog_entries;
DROP TABLE IF EXISTS blog_comments;

CREATE TABLE `blog_entries` (
`ID` INT NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 120 ) NOT NULL ,
`content` TEXT NOT NULL ,
`teaser` TINYTEXT NOT NULL ,
`entry_time` DATETIME NOT NULL ,
`category` VARCHAR( 12 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) TYPE = MYISAM ;

CREATE TABLE `blog_comments` (
`comment_ID` INT AUTO_INCREMENT ,
`name` VARCHAR( 50 ) NOT NULL ,
`comment` TEXT NOT NULL ,
`comment_time` timestamp,
`ID` INT NOT NULL ,
PRIMARY KEY ( `comment_ID` )
) TYPE = MYISAM ;
For more information send a message to info at phpclasses dot org.