PHP Classes

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

Recommend this page to a friend!
  Classes of Slavko Srakocic  >  B12 PHP FW  >  fwphp/glomodul/z_examples/book_video/03steinmetz_2008/ch12_Projects/card_mktable  >  Download  
File: fwphp/glomodul/z_examples/book_video/03steinmetz_2008/ch12_Projects/card_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: 910 bytes
 

Contents

Class file image Download
DROP TABLE IF EXISTS card_list;
DROP TABLE IF EXISTS cards_sent;

CREATE TABLE `card_list` (
`ID` INT NOT NULL AUTO_INCREMENT ,
`description` MEDIUMTEXT NOT NULL ,
`content` VARCHAR( 500 ) NOT NULL ,
`category` VARCHAR(20) NOT NULL ,
`width` INT NOT NULL ,
`height` INT NOT NULL ,
`thumbnail` VARCHAR(120),
PRIMARY KEY (`ID`)
) TYPE = MYISAM ;

CREATE TABLE `cards_sent` (
`sent_ID` INT NOT NULL AUTO_INCREMENT ,
`sender_email` VARCHAR( 50 ) NOT NULL ,
`sender_name` VARCHAR( 50 ) NOT NULL ,
`recip_email` VARCHAR( 50 ) NOT NULL ,
`recip_name` VARCHAR( 50 ) NOT NULL ,
`message` MEDIUMTEXT NOT NULL ,
`token` VARCHAR (32) NOT NULL ,
`ID` INT NOT NULL ,
`notified` TINYINT NULL ,
PRIMARY KEY ( `sent_ID` )
) TYPE = MYISAM ;

INSERT INTO card_list
    (description, content, category, width, height, thumbnail)
    VALUES
    ("birthday card 1", "<b>Happy Birthday!</b> (1)", "birthday",
     600, 300, NULL );

For more information send a message to info at phpclasses dot org.