-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The following was not included in the latest versions of dbmail as of yet, so provided here are what I composed, that follow proper field types as what dbmail's pgsql driver uses:
CREATE SEQUENCE "pbsp_idnr_seq" START 1 INCREMENT 1 MAXVALUE
9223372036854775807 MINVALUE 1 CACHE 1;
CREATE TABLE "pbsp" (
"idnr" int8 DEFAULT nextval('"pbsp_idnr_seq"'::text) NOT NULL,
"since" timestamptz DEFAULT '1979-11-03 22:05:58',
"ipnumber" varchar(40) NOT NULL,
CONSTRAINT "idnr_pkey" PRIMARY KEY ("idnr")
);
CREATE UNIQUE INDEX "ipnumber_idx" ON "pbsp" ("ipnumber");
CREATE INDEX "since_idx" ON "pbsp" ("since");
- --
Eric Renfro
Myrddin Computers & Designs - CEO/President
Sales: [EMAIL PROTECTED]
Fax: (775) 243-4535
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9uED8EqLImjXJeUURAkqhAJ90oUMKgCLwcpj/y1IUWUBtZWulFwCguSUO
rCeYu06KN1ePjXTCWoMdBcI=
=unnF
-----END PGP SIGNATURE-----
0x35C97945.asc
Description: application/pgp-keys
