Login   Register  
PHP Classes
elePHPant
Icontem

File: mktable.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Barton Phillips  >  MySQL Slideshow  >  mktable.sql  >  Download  
File: mktable.sql
Role: Auxiliary data
Content type: text/plain
Description: Sql script to make table
Class: MySQL Slideshow
Present slideshow from images listed in a database
Author: By
Last change:
Date: 4 years ago
Size: 458 bytes
 

Contents

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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;