gnue/packages drop_all_tables.sql hr/personnel/...

[Neil Tiffin]

CVSROOT:        /home/cvs
Module name:    gnue
Changes by:     Neil Tiffin <address@hidden>    01/12/09 12:29:01

Modified files:
        packages       : drop_all_tables.sql 
        packages/hr/personnel/classes: ps.gcd 

Log message:
        Update drop all tables for new tables.

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/packages/drop_all_tables.sql.diff?cvsroot=OldCVS&tr1=1.7&tr2=1.8&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/packages/hr/personnel/classes/ps.gcd.diff?cvsroot=OldCVS&tr1=1.2&tr2=1.3&r1=text&r2=text

Patches:
Index: gnue/packages/drop_all_tables.sql
diff -c gnue/packages/drop_all_tables.sql:1.7 
gnue/packages/drop_all_tables.sql:1.8
*** gnue/packages/drop_all_tables.sql:1.7       Sun Sep 16 14:04:44 2001
--- gnue/packages/drop_all_tables.sql   Sun Dec  9 12:29:01 2001
***************
*** 3,13 ****
  DROP TABLE ar__cash_receipt;
  DROP TABLE ar__cr_status;
  DROP TABLE ar__credit;
  DROP TABLE ar__invoice;
  DROP TABLE ar__sales_journal;
  DROP TABLE base__parameter;
! DROP TABLE base_item__item;
  DROP TABLE base_item__i_type;
  DROP TABLE currency__conversion;
  DROP TABLE currency__conversion_rule;
  DROP TABLE currency__currency;
--- 3,17 ----
  DROP TABLE ar__cash_receipt;
  DROP TABLE ar__cr_status;
  DROP TABLE ar__credit;
+ DROP TABLE ar__detail;
+ DROP TABLE ar__header;
  DROP TABLE ar__invoice;
  DROP TABLE ar__sales_journal;
+ DROP TABLE ar__sales_tx;
  DROP TABLE base__parameter;
! DROP TABLE base_acct__trans_def;
  DROP TABLE base_item__i_type;
+ DROP TABLE base_item__item;
  DROP TABLE currency__conversion;
  DROP TABLE currency__conversion_rule;
  DROP TABLE currency__currency;
***************
*** 18,44 ****
  DROP TABLE geas__searchfield;
  DROP TABLE geas__transaction;
  DROP TABLE geas__user;
  DROP TABLE gl_acct__account;
  DROP TABLE gl_acct__gvt_code;
  DROP TABLE gl_acct__segment;
  DROP TABLE gl_acct__status;
- DROP TABLE gl_acct__gl_type;
  DROP TABLE gl_post__entry_stage;
  DROP TABLE gl_post__gen_jour_det;
  DROP TABLE gl_post__gen_jour_head;
  DROP TABLE gl_post__gen_journal;
  DROP TABLE gl_post__parameters;
  DROP TABLE gl_post__period;
  DROP TABLE gl_post__recurring;
! DROP TABLE gl_post__gl_type;
  DROP TABLE inv__stock_item;
  DROP TABLE inv__stock_quantity;
- DROP TABLE inv__i_type;
  DROP TABLE language__help;
  DROP TABLE language__language;
  DROP TABLE location__country;
- DROP TABLE location__region;
  DROP TABLE location__post_code;
  DROP TABLE mod1__class1;
  DROP TABLE mod1__class2;
  DROP TABLE mod1__class3;
--- 22,55 ----
  DROP TABLE geas__searchfield;
  DROP TABLE geas__transaction;
  DROP TABLE geas__user;
+ DROP TABLE gl__account;
+ DROP TABLE gl__entry;
+ DROP TABLE gl__journal;
+ DROP TABLE gl__period;
+ DROP TABLE gl__trans;
+ DROP TABLE gl__year;
  DROP TABLE gl_acct__account;
+ DROP TABLE gl_acct__gl_type;
  DROP TABLE gl_acct__gvt_code;
  DROP TABLE gl_acct__segment;
  DROP TABLE gl_acct__status;
  DROP TABLE gl_post__entry_stage;
  DROP TABLE gl_post__gen_jour_det;
  DROP TABLE gl_post__gen_jour_head;
  DROP TABLE gl_post__gen_journal;
+ DROP TABLE gl_post__gl_type;
  DROP TABLE gl_post__parameters;
  DROP TABLE gl_post__period;
  DROP TABLE gl_post__recurring;
! DROP TABLE inv__i_type;
  DROP TABLE inv__stock_item;
  DROP TABLE inv__stock_quantity;
  DROP TABLE language__help;
  DROP TABLE language__language;
  DROP TABLE location__country;
  DROP TABLE location__post_code;
+ DROP TABLE location__region;
+ DROP TABLE mod1__c;
  DROP TABLE mod1__class1;
  DROP TABLE mod1__class2;
  DROP TABLE mod1__class3;
***************
*** 49,54 ****
--- 60,67 ----
  DROP TABLE neil_order__master;
  DROP TABLE org__address;
  DROP TABLE org__contact;
+ DROP TABLE org__line_status;
+ DROP TABLE org__line_type;
  DROP TABLE org__organization;
  DROP TABLE person__address;
  DROP TABLE person__comm;
***************
*** 57,62 ****
--- 70,81 ----
  DROP TABLE person__employee;
  DROP TABLE person__name_prefix;
  DROP TABLE person__name_suffix;
+ DROP TABLE ps__contract;
+ DROP TABLE ps__former_emp;
+ DROP TABLE ps__hire;
+ DROP TABLE ps__nok;
+ DROP TABLE ps__relationship;
+ DROP TABLE ps__status;
  DROP TABLE pur__approval;
  DROP TABLE pur__approval_list;
  DROP TABLE pur__buyer;
***************
*** 65,70 ****
--- 84,90 ----
  DROP TABLE pur__item;
  DROP TABLE pur__status;
  DROP TABLE pur__text;
+ DROP TABLE pur__use_vendor;
  DROP TABLE receiving__receiving;
  DROP TABLE shipping__detail;
  DROP TABLE shipping__journal;
***************
*** 82,97 ****
  DROP TABLE whse__site;
  DROP TABLE whse__stock_room;
  DROP TABLE whse__storage;
- DROP TABLE gl__account;
- DROP TABLE gl__entry;
- DROP TABLE gl__journal;
- DROP TABLE gl__period;
- DROP TABLE gl__trans;
- DROP TABLE gl__year;
- DROP TABLE pur__use_vendor;
- DROP TABLE ar__detail;
- DROP TABLE ar__header;
- DROP TABLE ar__sales_tx;
- DROP TABLE base_acct__trans_def;
- DROP TABLE org__line_status;
- DROP TABLE org__line_type;
--- 102,104 ----
Index: gnue/packages/hr/personnel/classes/ps.gcd
diff -c gnue/packages/hr/personnel/classes/ps.gcd:1.2 
gnue/packages/hr/personnel/classes/ps.gcd:1.3
*** gnue/packages/hr/personnel/classes/ps.gcd:1.2       Sat Dec  8 17:18:43 2001
--- gnue/packages/hr/personnel/classes/ps.gcd   Sun Dec  9 12:29:01 2001
***************
*** 22,28 ****
  #
  # This file originally written by Neil Tiffin (address@hidden).
  #
! # $Revision: 1.2 $ $Date: 2001/12/08 22:18:43 $ $Author: ntiffin $
  #
  
  include "../../../base/currency/classes/currency.gcd"
--- 22,28 ----
  #
  # This file originally written by Neil Tiffin (address@hidden).
  #
! # $Revision: 1.3 $ $Date: 2001/12/09 17:29:01 $ $Author: ntiffin $
  #
  
  include "../../../base/currency/classes/currency.gcd"
***************
*** 31,41 ****
  module ps
  {
  
-   extend person::employee
-   {
-     ps::hire  *hire;    # add reference to hr data in base
-   };
- 
    #--------------------------------------------
    # status of employee
    #--------------------------------------------
--- 31,36 ----
***************
*** 85,90 ****
--- 80,90 ----
      ps::former_emp [] former_emplyer;
    };
    
+   extend person::employee
+   {
+     ps::hire  *hire;    # add reference to hr data in base
+   };
+ 
    #--------------------------------------------
    # contract - employment contract details
    #--------------------------------------------
***************
*** 137,142 ****
      date    started;
      date    left;
    };
- 
-   
  };
--- 137,140 ----