PHP Classes

File: examples/mktable.sql

Recommend this page to a friend!
  Classes of Barton Phillips  >  MySQL Slideshow  >  examples/mktable.sql  >  Download  
File: examples/mktable.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: MySQL Slideshow
Present slideshow from images listed in a database
Author: By
Last change:
Date: 7 years ago
Size: 458 bytes


Class file image Download
-- Main slide show table

CREATE TABLE `mysqlslideshow` (
 `id` int(11) NOT NULL auto_increment,
 `type` enum('link', 'data') default 'link', /* if link then data is a link address, if data then image. */
 `imageinfo` varchar(255) NOT NULL, /* return from getimagesize(img, extrinfo) serialized */
 `subject` varchar(255) default NULL,
 `description` text,
 `data` blob,
 `created` datetime,
  PRIMARY KEY  (`id`)
For more information send a message to info at phpclasses dot org.