[Gforge-commits] gforge/db 20040325.sql,NONE,1.1

[tperdue]

Update of /cvsroot/gforge/gforge/db
In directory db.perdue.net:/home/tperdue/share/dev.gforge.org/db

Added Files:
        20040325.sql 
Log Message:
changes for new fields in database

--- NEW FILE: 20040325.sql ---
ALTER TABLE users ADD COLUMN firstname varchar(60);
ALTER TABLE users ADD COLUMN lastname varchar(60);
ALTER TABLE users ADD COLUMN address2 text;
ALTER TABLE users ADD COLUMN ccode char(2);
ALTER TABLE users ALTER COLUMN ccode SET DEFAULT 'US';
UPDATE USERS SET ccode='US',firstname=realname WHERE firstname is null;

CREATE TABLE country_code (
country_name varchar(80),
ccode char(2) primary key
);

COPY country_code FROM '/tmp/ccodes.txt';