Login   Register  
PHP Classes
elePHPant
Icontem

File: create.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Marcos Pont  >  SmartGallery  >  create.sql  >  Download  
File: create.sql
Role: Auxiliary script
Content type: text/plain
Description: SQL script to create the required tables
Class: SmartGallery
Simple template & mySQL based photo gallery
Author: By
Last change: Create empty tables
Date: 11 years ago
Size: 565 bytes
 

Contents

Class file image Download
DROP TABLE IF EXISTS gallery;
CREATE TABLE `gallery` (
  `id_gallery` int(11) NOT NULL auto_increment,
  `description` varchar(150) default NULL,
  PRIMARY KEY  (`id_gallery`),
  UNIQUE KEY `UK_galeria` (`id_gallery`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS picture;
CREATE TABLE `picture` (
  `id_picture` int(11) NOT NULL auto_increment,
  `id_gallery` int(11) NOT NULL default '0',
  `file_name` varchar(100) default NULL,
  `description` varchar(150) default NULL,
  PRIMARY KEY  (`id_picture`),
  UNIQUE KEY `UK_foto` (`id_picture`)
) TYPE=MyISAM;