[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gforge-commits] gforge/db 20040325.sql,NONE,1.1
From: |
tperdue |
Subject: |
[Gforge-commits] gforge/db 20040325.sql,NONE,1.1 |
Date: |
Thu, 25 Mar 2004 11:20:01 -0600 |
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';
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gforge-commits] gforge/db 20040325.sql,NONE,1.1,
tperdue <=