File: pg.sql

/* --------------------------------------------------------
  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";