Login   Register  
PHP Classes
elePHPant
Icontem

File: pg.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Thomas Uttenthaler  >  phpRealGallery  >  pg.sql  >  Download  
File: pg.sql
Role: ???
Content type: text/plain
Description: Dump file for Postgre
Class: phpRealGallery
Author: By
Last change:
Date: 13 years ago
Size: 1,269 bytes
 

Contents

Class file image Download
/* --------------------------------------------------------
  Sequences
-------------------------------------------------------- */
CREATE SEQUENCE "galleries_gid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
CREATE SEQUENCE "images_iid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; 
/* --------------------------------------------------------
  Table structure for table "galleries"
-------------------------------------------------------- */
CREATE TABLE "galleries" (
   "gid" int4 DEFAULT nextval('galleries_gid_seq'::text) NOT NULL,
   "title" varchar(256),
   "text" text,
   CONSTRAINT "galleries_pkey" PRIMARY KEY ("gid")
);
GRANT SELECT ON "galleries" TO "phpRealGallery"; 

/* --------------------------------------------------------
  Table structure for table "images"
-------------------------------------------------------- */
CREATE TABLE "images" (
   "iid" int4 DEFAULT nextval('images_iid_seq'::text) NOT NULL,
   "gid" int4,
   "file" varchar(256),
   "title" varchar(256),
   "text" text,
   "date" varchar(64),
   "tech" varchar(256),
   "size" varchar(64),
   "price" varchar(256),
   CONSTRAINT "images_pkey" PRIMARY KEY ("iid")
);
GRANT SELECT ON "images" TO "phpRealGallery";