gnue/gnue-config drop_all_tables.sql base/compa...

[Neil Tiffin]

CVSROOT:        /home/cvs
Module name:    gnue
Changes by:     Neil Tiffin <address@hidden>    01/06/22 13:33:54

Modified files:
        gnue-config    : drop_all_tables.sql 
        gnue-config/base/company/classes: company.gcd 
        gnue-config/base/parameter/classes: parameter.gcd 
        gnue-config/sales/customer/classes: customer.gcd 
        gnue-config/supply-chain/purchasing/classes: purchasing.gcd 

Log message:
        Shorten up some names to eliminate truncation be postgresql.

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/drop_all_tables.sql.diff?cvsroot=OldCVS&tr1=1.2&tr2=1.3&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/company/classes/company.gcd.diff?cvsroot=OldCVS&tr1=1.5&tr2=1.6&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/parameter/classes/parameter.gcd.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/sales/customer/classes/customer.gcd.diff?cvsroot=OldCVS&tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/supply-chain/purchasing/classes/purchasing.gcd.diff?cvsroot=OldCVS&tr1=1.7&tr2=1.8&r1=text&r2=text

Patches:
Index: gnue/gnue-config/base/company/classes/company.gcd
diff -u gnue/gnue-config/base/company/classes/company.gcd:1.5 
gnue/gnue-config/base/company/classes/company.gcd:1.6
--- gnue/gnue-config/base/company/classes/company.gcd:1.5       Mon Jun  4 
06:56:24 2001
+++ gnue/gnue-config/base/company/classes/company.gcd   Fri Jun 22 13:33:54 2001
@@ -22,12 +22,12 @@
 #
 # This file originally written by Neil Tiffin (address@hidden).
 #
-# $Revision: 1.5 $ $Date: 2001/06/04 13:56:24 $ $Author: ntiffin $
+# $Revision: 1.6 $ $Date: 2001/06/22 20:33:54 $ $Author: ntiffin $
 #
 include "../../../base/person/classes/person.gcd"
 include "../../../base/location/classes/address.gcd"
 
-module organization
+module org
 {
   # -------------------------------------------------------------------------
   # base class for instantiating person type as a general contact
@@ -52,8 +52,8 @@
   class organization
   {
     char                     organization_name<80>; # NOT NULL
-    organization::address [] address;
-    organization::contact [] contact;
+    org::address          [] address;
+    org::contact          [] contact;
     person::comm          [] comm;      # co. telephone number, fax, email etc.
     char                     keyword<100>;    # keyword for searching
     
Index: gnue/gnue-config/base/parameter/classes/parameter.gcd
diff -u gnue/gnue-config/base/parameter/classes/parameter.gcd:1.1 
gnue/gnue-config/base/parameter/classes/parameter.gcd:1.2
--- gnue/gnue-config/base/parameter/classes/parameter.gcd:1.1   Sun May 27 
13:11:45 2001
+++ gnue/gnue-config/base/parameter/classes/parameter.gcd       Fri Jun 22 
13:33:54 2001
@@ -23,7 +23,7 @@
 #
 # This file originally written by Neil Tiffin (address@hidden).
 #
-# $Revision: 1.1 $ $Date: 2001/05/27 20:11:45 $ $Author: ntiffin $
+# $Revision: 1.2 $ $Date: 2001/06/22 20:33:54 $ $Author: ntiffin $
 #
 
 include "../../../base/company/classes/company.gcd"
@@ -31,7 +31,7 @@
 
 class parameter
 {
-  organization::organization * company;
+  org::organization          * company;
   currency::currency         * currency;  # base currency for company.
 
 };
Index: gnue/gnue-config/drop_all_tables.sql
diff -u gnue/gnue-config/drop_all_tables.sql:1.2 
gnue/gnue-config/drop_all_tables.sql:1.3
--- gnue/gnue-config/drop_all_tables.sql:1.2    Sun Jun  3 13:48:02 2001
+++ gnue/gnue-config/drop_all_tables.sql        Fri Jun 22 13:33:54 2001
@@ -1,10 +1,9 @@
-DROP TABLE ar__invoice_detail;
-DROP TABLE ar__invoice_head;
+DROP TABLE ar__adjustment;
+DROP TABLE ar__credit  ;
+DROP TABLE ar__invoice  ;
+DROP TABLE ar__payment   ;
 DROP TABLE base_item__item;
 DROP TABLE base_item__item_type;
-DROP TABLE company__address;
-DROP TABLE company__company;
-DROP TABLE company__contact;
 DROP TABLE currency__conversion;
 DROP TABLE currency__conversion_rule;
 DROP TABLE currency__currency;
@@ -22,12 +21,18 @@
 DROP TABLE language__language;
 DROP TABLE location__country;
 DROP TABLE location__region;
-DROP TABLE neil_order__detail;
-DROP TABLE neil_order__master;
-DROP TABLE organization__address;
-DROP TABLE organization__contact;
-DROP TABLE organization__organization;
-DROP TABLE parameter;
+DROP TABLE mod1__class1;
+DROP TABLE mod1__class2      ;
+DROP TABLE mod1__class3      ;
+DROP TABLE mod1__class3__class4;
+DROP TABLE mod1__class3__class4__class5      ;
+DROP TABLE mod2__class1;
+DROP TABLE neil_order__detail         ;
+DROP TABLE neil_order__master         ;
+DROP TABLE org__address;
+DROP TABLE org__contact;
+DROP TABLE org__organization;
+DROP TABLE parameter                  ;
 DROP TABLE person__address;
 DROP TABLE person__comm;
 DROP TABLE person__comm_type;
@@ -35,18 +40,18 @@
 DROP TABLE person__employee;
 DROP TABLE person__name_prefix;
 DROP TABLE person__name_suffix;
+DROP TABLE pur__buyer;
+DROP TABLE pur__item;
+DROP TABLE pur__order_detail;
+DROP TABLE pur__order_header;
+DROP TABLE pur__purchasing_text;
+DROP TABLE pur__recommended_vendor;
+DROP TABLE pur__vendor;
 DROP TABLE purchasing__buyer;
-DROP TABLE purchasing__purchase_order_deta;
-DROP TABLE purchasing__purchasing_item;
-DROP TABLE purchasing__purchasing_text;
-DROP TABLE purchasing__purchasing_vendor;
-DROP TABLE purchasing__recommended_vendor;
 DROP TABLE receiving__receiving;
-DROP TABLE sales_order__sales_order;
+DROP TABLE sales_order__detail;
+DROP TABLE sales_order__header;
 DROP TABLE shipping__shipping;
-DROP TABLE test_module_1__class2;
-DROP TABLE test_module_1__class3;
-DROP TABLE test_module_2__class1;
 DROP TABLE unit__conversion;
 DROP TABLE unit__conversion_unit;
 DROP TABLE unit__unit;
Index: gnue/gnue-config/sales/customer/classes/customer.gcd
diff -u gnue/gnue-config/sales/customer/classes/customer.gcd:1.3 
gnue/gnue-config/sales/customer/classes/customer.gcd:1.4
--- gnue/gnue-config/sales/customer/classes/customer.gcd:1.3    Sun Jun  3 
13:48:02 2001
+++ gnue/gnue-config/sales/customer/classes/customer.gcd        Fri Jun 22 
13:33:54 2001
@@ -22,7 +22,7 @@
 #
 # This file originally written by Neil Tiffin (address@hidden).
 #
-# $Id: customer.gcd,v 1.3 2001/06/03 20:48:02 ntiffin Exp $
+# $Id: customer.gcd,v 1.4 2001/06/22 20:33:54 ntiffin Exp $
 #
 
 include "../../../base/company/classes/company.gcd"
@@ -30,7 +30,7 @@
 
 module customer
 {
-  class customer : organization::organization
+  class customer : org::organization
   {
     currency::money   this_year_sales;
     currency::money   last_year_sales;
Index: gnue/gnue-config/supply-chain/purchasing/classes/purchasing.gcd
diff -u gnue/gnue-config/supply-chain/purchasing/classes/purchasing.gcd:1.7 
gnue/gnue-config/supply-chain/purchasing/classes/purchasing.gcd:1.8
--- gnue/gnue-config/supply-chain/purchasing/classes/purchasing.gcd:1.7 Thu May 
24 14:37:14 2001
+++ gnue/gnue-config/supply-chain/purchasing/classes/purchasing.gcd     Fri Jun 
22 13:33:54 2001
@@ -22,23 +22,23 @@
 #
 # This file originally written by Neil Tiffin (address@hidden).
 #
-# $Revision: 1.7 $ $Date: 2001/05/24 21:37:14 $ $Author: ntiffin $
+# $Revision: 1.8 $ $Date: 2001/06/22 20:33:54 $ $Author: ntiffin $
 #
 include "../../../base/units/classes/units.gcd"
 include "../../../supply-chain/vendor/classes/vendor.gcd"
 
-module purchasing
+module pur
 {
 
   # -------------------------------------------------------------------------
   # 
   # -------------------------------------------------------------------------
   # EXTEND vendor::vendor
-  class purchasing_vendor : vendor::vendor
+  class vendor : vendor::vendor
   {
-    text    purchasing_notes;
+    text    notes;
         
-    help en purchasing_notes  "These notes will show up in the purchasing form"
+    help en notes  "These notes will show up in the purchasing form"
                               "with an option to print on the purchase order.";
   };
     
@@ -46,7 +46,7 @@
   # 
   # -------------------------------------------------------------------------
   # EXTEND inventory::stock_item
-  class purchasing_item : inventory::stock_item
+  class item : inventory::stock_item
   {
     char    buyer_code<8>;
     text    purch_text;
@@ -72,7 +72,7 @@
   # -------------------------------------------------------------------------
   # this is standard text that can be referenced by id and copied to p.o.
   # ------------------------------------------------------------------------
-  class purchasing_text
+  class text
   {
     char      id<8>;     # is unique for id+buyer
     char      buyer<8>;  # buyer code
@@ -92,7 +92,7 @@
   # -------------------------------------------------------------------------
   # 
   # -------------------------------------------------------------------------
-  class purchase_order_detail
+  class order_detail
   {
     char             po_number<5>;
     int              line_number;      # the line on the po
@@ -108,7 +108,7 @@
   # -------------------------------------------------------------------------
   # 
   # -------------------------------------------------------------------------
-  class purchase_order_header
+  class order_header
   {
     char    po_number<5>;
     char    vendor_id<5>;