1 ALTER TABLE custinfo ADD COLUMN cust_passwd CHARACTER VARYING(64) NOT NULL DEFAULT '';
3 CREATE INDEX cust_passwd_ix ON custinfo USING btree (cust_passwd);
5 ALTER TABLE custinfo ADD COLUMN cust_login_email CHARACTER VARYING(256) NOT NULL DEFAULT '';
7 CREATE INDEX cust_login_email_ix ON custinfo USING btree (cust_login_email);
9 ALTER TABLE custinfo ADD COLUMN cust_dob TEXT NOT NULL DEFAULT '';
11 CREATE INDEX cust_dob_ix ON custinfo USING btree (cust_dob);
13 ALTER TABLE custinfo ADD COLUMN cust_subscribed BOOLEAN NOT NULL DEFAULT TRUE;
15 CREATE INDEX cust_subscribed_ix ON custinfo USING btree (cust_subscribed);