[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue/appserver/samples setup-pgsql.sh
From: |
Reinhard Mueller |
Subject: |
gnue/appserver/samples setup-pgsql.sh |
Date: |
Fri, 27 Dec 2002 17:58:38 -0500 |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- gnue/appserver/samples setup-pgsql.sh,
Reinhard Mueller <=