Changeset 342 for branches


Ignore:
Timestamp:
08/10/06 11:28:58 (18 years ago)
Author:
Kris Deugau
Message:

/trunk

Commit updates to initial SQL setup made "forever" ago.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/stable/cgi-bin/ipdb.psql

    r334 r342  
     1DROP DATABASE ipdb;
     2
     3CREATE USER ipdb WITH PASSWORD 'ipdbpwd';
     4
    15CREATE DATABASE ipdb;
     6
     7UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE usename='ipdb')
     8        WHERE datname='ipdb';
    29
    310\connect ipdb ipdb
     
    6471        "pool" cidr DEFAULT '255.255.255.255/32' NOT NULL,
    6572        "ip" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
    66         "custid" character varying(16) DEFAULT '' NOT NULL,
     73        "oldcustid" character varying(16) DEFAULT '' NOT NULL,
    6774        "city" character varying(30) DEFAULT '' NOT NULL,
    6875        "type" character(2) DEFAULT '' NOT NULL,
     
    7279        "circuitid" character varying(128) DEFAULT '' NOT NULL,
    7380        "privdata" text DEFAULT '' NOT NULL,
    74         "newcustid" character varying(16) DEFAULT '',
     81        "custid" character varying(16) DEFAULT '',
    7582        "createstamp" timestamp DEFAULT now(),
    7683        "modifystamp" timestamp DEFAULT now(),
     
    8390CREATE TABLE "allocations" (
    8491        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
    85         "custid" character varying(16) DEFAULT '',
     92        "oldcustid" character varying(16) DEFAULT '',
    8693        "type" character(2) DEFAULT '',
    8794        "city" character varying(30) DEFAULT '',
     
    93100        "modifystamp" timestamp DEFAULT now(),
    94101        "privdata" text DEFAULT '' NOT NULL,
    95         "newcustid" character varying(16) DEFAULT '',
     102        "custid" character varying(16) DEFAULT '',
    96103        swip character(1) DEFAULT 'n'
    97104);
     
    111118        "listorder" integer DEFAULT 0,
    112119        "def_custid" character varying(16) DEFAULT '',
    113         "arin_netname" character varying(20) DEFAILT 'ISP'
     120        "arin_netname" character varying(20) DEFAULT 'ISP'
    114121);
    115122
     
    189196);
    190197
     198-- Default password is admin
     199INSERT INTO users VALUES ('admin','luef5C4XumqIs','bacdsA');
     200
    191201CREATE TABLE "dns" (
    192202        "ip" inet NOT NULL PRIMARY KEY,
Note: See TracChangeset for help on using the changeset viewer.