gnue/appserver/samples setup-pgsql.sh

[Reinhard Mueller]

CVSROOT:        /cvsroot/gnue
Module name:    gnue
Changes by:     Reinhard Mueller <address@hidden>       02/12/27 17:58:38

Modified files:
        appserver/samples: setup-pgsql.sh 

Log message:
        Insert _id_ field into test database for appserver, create user "gnue".

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/appserver/samples/setup-pgsql.sh.diff?tr1=1.4&tr2=1.5&r1=text&r2=text

Patches:
Index: gnue/appserver/samples/setup-pgsql.sh
diff -c gnue/appserver/samples/setup-pgsql.sh:1.4 
gnue/appserver/samples/setup-pgsql.sh:1.5
*** gnue/appserver/samples/setup-pgsql.sh:1.4   Wed Sep 18 10:07:45 2002
--- gnue/appserver/samples/setup-pgsql.sh       Fri Dec 27 17:58:38 2002
***************
*** 3,8 ****
--- 3,9 ----
  # The current user must have permission to create databases
  
  createdb gnue
+ createuser gnue
  psql gnue << EOF
  create table appserver_users 
  ( 
***************
*** 31,41 ****
  
  create table person
  (
    name varchar (35),
    street varchar (35),
    zip varchar (17),
    city varchar (35)
  );
! insert into person (name, street, zip, city)
!   values ('James T. Kirk', 'Enterprise Road 17', '2002', 'Gnutown')
  EOF
--- 32,43 ----
  
  create table person
  (
+   _id_ char (32),
    name varchar (35),
    street varchar (35),
    zip varchar (17),
    city varchar (35)
  );
! insert into person (_id_, name, street, zip, city)
!   values ('12345678901234567890123456789012', 'James T. Kirk', 'Enterprise 
Road 17', '2002', 'Gnutown')
  EOF