OpenPKG CVS Repository
http://cvs.openpkg.org/
____________________________________________________________________________
Server: cvs.openpkg.org Name: Thomas Lotterer
Root: /v/openpkg/cvs Email: [EMAIL PROTECTED]
Module: openpkg-registry Date: 12-May-2006 16:19:23
Branch: HEAD Handle: 2006051215192200
Modified files:
openpkg-registry registry-db.pl
Log:
add fullname column to registry database
Summary:
Revision Changes Path
1.21 +16 -0 openpkg-registry/registry-db.pl
____________________________________________________________________________
patch -p0 <<'@@ .'
Index: openpkg-registry/registry-db.pl
============================================================================
$ cvs diff -u -r1.20 -r1.21 registry-db.pl
--- openpkg-registry/registry-db.pl 7 Mar 2006 13:09:46 -0000 1.20
+++ openpkg-registry/registry-db.pl 12 May 2006 14:19:22 -0000 1.21
@@ -391,6 +391,19 @@
return 1;
}
+ # 0.3.x upgrade to 0.4.0
+ #
+ elsif ( $dbv->{version}->{major} == 0
+ and $dbv->{version}->{minor} == 3 ) {
+ $sql="";
+ $sql .= sprintf("ALTER TABLE reg_user ADD COLUMN fullname TEXT;\n");
+ $sql .= &funcregistry();
+ $sql .= sprintf("UPDATE reg_config SET value = '0.4.0';\n");
+ $rv = $dbh->do($sql);
+ print "$sql\nrv=".$rv." message=".$dbh->errstr."\n\n"; die if
($dbh->errstr =~ m|ERROR|);
+ return 1;
+ }
+
# program data version and database version only differ in patchlevel
- just uprev the number
#
elsif ( $dbv->{version}->{major} == $datavers->{major}
@@ -523,6 +536,9 @@
CHECK(username ~ '[EMAIL PROTECTED]'),
-- OSSP ase user
-- [EMAIL PROTECTED]
+ fullname TEXT,
+ -- OSSP ase name
+ -- [John Doe]
heartbeat TIMESTAMP (0) WITHOUT TIME ZONE
NOT NULL
DEFAULT CURRENT_TIMESTAMP,
@@ .
______________________________________________________________________
The OpenPKG Project www.openpkg.org
CVS Repository Commit List [email protected]
