Login   Register  
PHP Classes
elePHPant
Icontem

File: DB.PostgreSQL81.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Richard Munroe  >  dm.DB  >  DB.PostgreSQL81.sql  >  Download  
File: DB.PostgreSQL81.sql
Role: Auxiliary data
Content type: text/plain
Description: Create PostgreSQL 8.x test database
Class: dm.DB
Generic database access wrapper
Author: By
Last change:
Date: 2006-07-02 06:30
Size: 2,044 bytes
 

Contents

Class file image Download
--
-- @author Dick Munroe <munroe@csworks.com>
-- @copyright copyright @ 2006 by Dick Munroe, Cottage Software Works, Inc.
-- @license http://www.csworks.com/publications/ModifiedNetBSD.html
-- @version 2.0.0
-- @package dm.DB
-- @example ./example.php
--
-- SQL procedure to create the test database and table for the examples
-- in the dm.DB project.
--
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2-Debian-1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 06, 2006 at 02:27 PM
-- Server version: 4.1.11
-- PHP Version: 4.4.0-4
--
-- Database: "DB"
--
-- The procedure for creating the test database is a little different for
-- PostgreSQL.  You must first connect to the server using any database,
-- then create DB, then connect to the DB database, then you can run this
-- SQL procedure.

--
-- Table structure for table "table"
--
DROP SEQUENCE "table_id_seq" ;
DROP TABLE "table";
CREATE TABLE "table" (
  "id" SERIAL,
  "fullname" varchar(255) default NULL,
  "user" varchar(255) default NULL,
  "password" varchar(255) default NULL,
  PRIMARY KEY  ("id")
) ;
ALTER SEQUENCE "table_id_seq" RESTART WITH 11 ;

--
-- Dumping data for table "table"
--

INSERT INTO "table" ("id", "fullname", "user", "password") VALUES (1, 'A', 'a', 'b');
INSERT INTO "table" ("id", "fullname", "user", "password") VALUES (2, 'B', 'b', 'c');
INSERT INTO "table" ("id", "fullname", "user", "password") VALUES (3, 'C', 'c', 'd');
INSERT INTO "table" ("id", "fullname", "user", "password") VALUES (4, 'D', 'd', 'e');
INSERT INTO "table" ("id", "fullname", "user", "password") VALUES (5, 'E', 'e', 'f');
INSERT INTO "table" ("id", "fullname", "user", "password") VALUES (6, 'F', 'f', 'g');
INSERT INTO "table" ("id", "fullname", "user", "password") VALUES (7, 'G', 'g', 'h');
INSERT INTO "table" ("id", "fullname", "user", "password") VALUES (8, 'H', 'h', 'i');
INSERT INTO "table" ("id", "fullname", "user", "password") VALUES (9, 'J', 'J', 'k');
INSERT INTO "table" ("id", "fullname", "user", "password") VALUES (10, 'K', 'k', 'l');