#35 PostgreSQL - varchar max is 4096, not 8K

[Bradley Kieser]

The install script for postgreSQL creates 8k varchar fields. THe max is 4k (4096).

This is how the script SHOULD read (I've run it successfully):

CREATE TABLE calendar ( id int, title varchar(255), body varchar(4096), "user" int, date varchar(100),
time varchar(20), duration varchar(20), permissions varchar(4096), datetime int, special int default 0,
agenda varchar(255));

CREATE TABLE contacts ( id int NOT NULL, owner int NOT NULL, permissions varchar(4096),
lname varchar(255), fname varchar(255), title varchar(255), company varchar(255), "work" varchar(30),
home varchar(30), fax varchar(30), other varchar(30), email varchar(100),
address varchar(255), city varchar(100), state varchar(100), zip varchar(20), country varchar(100),
custom1 varchar(255), custom2 varchar(255), custom3 varchar(255), custom4 varchar(255),
note varchar(4096), type int, category varchar(255), PRIMARY KEY (id));

CREATE TABLE groups (id int NOT NULL, name varchar(255), "user" int, users varchar(4096),
PRIMARY KEY (id));

CREATE TABLE users ( id int NOT NULL, fname varchar(255), lname varchar(255), username varchar(255), password varchar(255), email varchar(255), permissions varchar(255));

CREATE TABLE sessions ( sess_id varchar(255), sess_vars varchar(4096), datetime int );