gnue/appserver/samples setup-pgsql.sh

[Reinhard Mueller]

CVSROOT:        /cvsroot/gnue
Module name:    gnue
Changes by:     Reinhard Mueller <address@hidden>       03/02/01 10:00:48

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

Log message:
        Extended sample database by some system tables for the class repository,
        renamed _id_ column to gnue_id, prefixed all table and column names 
with module
        name.

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

Patches:
Index: gnue/appserver/samples/setup-pgsql.sh
diff -c gnue/appserver/samples/setup-pgsql.sh:1.5 
gnue/appserver/samples/setup-pgsql.sh:1.6
*** gnue/appserver/samples/setup-pgsql.sh:1.5   Fri Dec 27 17:58:38 2002
--- gnue/appserver/samples/setup-pgsql.sh       Sat Feb  1 10:00:48 2003
***************
*** 5,18 ****
  createdb gnue
  createuser gnue
  psql gnue << EOF
  create table appserver_users 
  ( 
    username varchar (20),
    password varchar (20),
    tablelist text
  );
! insert into appserver_users values ('test','test','person,state');
! insert into appserver_users values ('hacker','secret','person');
  
  create table appserver_pytrigger 
  (
--- 5,95 ----
  createdb gnue
  createuser gnue
  psql gnue << EOF
+ 
+ -- 
============================================================================
+ -- Class Repository
+ -- 
============================================================================
+ 
+ create table gnue_module
+ (
+   gnue_id      char    (32),
+   gnue_name    varchar (35),
+   gnue_comment varchar (70)
+ );
+ 
+ create table gnue_class
+ (
+   gnue_id      char    (32),
+   gnue_module  char    (32),
+   gnue_name    varchar (35),
+   gnue_comment varchar (70)
+ );
+ 
+ create table gnue_property
+ (
+   gnue_id      char    (32),
+   gnue_class   char    (32),
+   gnue_module  char    (32),
+   gnue_name    varchar (35),
+   gnue_type    varchar (35),
+   gnue_comment varchar (70)
+ );
+ 
+ insert into gnue_module values
+ (
+   '00000000000000000000000000000000',
+   'gnue',
+   'GNU Enterprise System Module'
+ );
+ 
+ -- 
----------------------------------------------------------------------------
+ -- Business Object Module
+ -- 
----------------------------------------------------------------------------
+ 
+ insert into gnue_class values
+ (
+   '00000000000000000000000000000010',
+   '00000000000000000000000000000000',
+   'module',
+   'GNU Enterprise Business Object Module'
+ );
+ 
+ -- 
----------------------------------------------------------------------------
+ -- Business Object Class
+ -- 
----------------------------------------------------------------------------
+ 
+ insert into gnue_class values
+ (
+   '00000000000000000000000000000020',
+   '00000000000000000000000000000000',
+   'class',
+   'GNU Enterprise Business Object Class'
+ );
+ 
+ -- 
----------------------------------------------------------------------------
+ -- Business Object Property
+ -- 
----------------------------------------------------------------------------
+ 
+ insert into gnue_class values
+ (
+   '00000000000000000000000000000030',
+   '00000000000000000000000000000000',
+   'property',
+   'GNU Enterprise Business Object Property'
+ );
+ 
+ -- 
============================================================================
+ -- Authentication and Trigger Test Stuff
+ -- 
============================================================================
+ 
  create table appserver_users 
  ( 
    username varchar (20),
    password varchar (20),
    tablelist text
  );
! insert into appserver_users values ('test','test','address_person');
! insert into appserver_users values ('hacker','secret','address_person');
  
  create table appserver_pytrigger 
  (
***************
*** 30,43 ****
  insert into appserver_pytrigger values ('person:checkAreaRichness',
  'person:checkAreaRichness','print "standard"');
  
! 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
--- 107,151 ----
  insert into appserver_pytrigger values ('person:checkAreaRichness',
  'person:checkAreaRichness','print "standard"');
  
! -- 
============================================================================
! -- Address Module
! -- 
============================================================================
! 
! insert into gnue_module values
  (
!   '00000000000000000000000000001000',
!   'address',
!   'Address Management'
  );
! 
! -- 
----------------------------------------------------------------------------
! -- Person
! -- 
----------------------------------------------------------------------------
! 
! insert into gnue_class values
! (
!   '00000000000000000000000000001010',
!   '00000000000000000000000000001000',
!   'person',
!   'Person'
! );
! 
! create table address_person
! (
!   gnue_id        char    (32),
!   address_name   varchar (35),
!   address_street varchar (35),
!   address_zip    varchar (17),
!   address_city   varchar (35)
! );
! 
! insert into address_person values
! (
!   '00000000000000000000000000001100',
!   'James T. Kirk',
!   'Enterprise Road 17',
!   '2002',
!   'Gnutown'
! );
! 
  EOF