gnue/gnue-config/base/person/defaults insert-en...

[Derek Neighbors]

CVSROOT:        /home/cvs
Module name:    gnue
Changes by:     Derek Neighbors <address@hidden>        01/06/16 19:41:53

Modified files:
        gnue-config/base/person/defaults: insert-en-person-type.sql 
                                          insert-en-salutations.sql 

Log message:
        ** Fixed SQL statements to be compliant.  However, they still will
        not work as they need ObjectID's.  Decision will be made about
        how to handle this.  Also, please note that names are not consistent
        with object names.  This should also be fixed.

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/person/defaults/insert-en-person-type.sql.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/person/defaults/insert-en-salutations.sql.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text

Patches:
Index: gnue/gnue-config/base/person/defaults/insert-en-person-type.sql
diff -u gnue/gnue-config/base/person/defaults/insert-en-person-type.sql:1.1 
gnue/gnue-config/base/person/defaults/insert-en-person-type.sql:1.2
--- gnue/gnue-config/base/person/defaults/insert-en-person-type.sql:1.1 Sat Mar 
 3 16:42:13 2001
+++ gnue/gnue-config/base/person/defaults/insert-en-person-type.sql     Sat Jun 
16 19:41:53 2001
@@ -1,7 +1,5 @@
-INSERT INTO PersonType (type_code, type_description) VALUES
-       ("EM", "Employee"),
-       ("CO", "Contractor"),
-       ("CU", "Customer"),
-       ("VE", "Vendor"),
-       ("SL", "Sales Lead")
-;      
\ No newline at end of file
+INSERT INTO person__comm_type (code, "desc") VALUES ('EM', 'Employee');
+INSERT INTO person__comm_type (code, "desc") VALUES ('CO', 'Contractor');
+INSERT INTO person__comm_type (code, "desc") VALUES ('CU', 'Customer');
+INSERT INTO person__comm_type (code, "desc") VALUES ('VE', 'Vendor');
+INSERT INTO person__comm_type (code, "desc") VALUES ('SL', 'Sales Lead');
Index: gnue/gnue-config/base/person/defaults/insert-en-salutations.sql
diff -u gnue/gnue-config/base/person/defaults/insert-en-salutations.sql:1.1 
gnue/gnue-config/base/person/defaults/insert-en-salutations.sql:1.2
--- gnue/gnue-config/base/person/defaults/insert-en-salutations.sql:1.1 Sat Mar 
 3 16:42:13 2001
+++ gnue/gnue-config/base/person/defaults/insert-en-salutations.sql     Sat Jun 
16 19:41:53 2001
@@ -1,14 +1,12 @@
-INSERT INTO ValidSalutations (salutation) VALUES
-       ("Doctor"),
-       ("Dr"),
-       ("Heer"),
-       ("Herr"),
-       ("Miss")
-       ("Mister"),
-       ("Monsieur"),
-       ("Mr"),
-       ("Mrs"),
-       ("Ms"),
-       ("Professor"),
-       ("Sir"),
-;
+INSERT INTO person__name_prefix (prefix) VALUES ('Doctor');
+INSERT INTO person__name_prefix (prefix) VALUES ('Dr');
+INSERT INTO person__name_prefix (prefix) VALUES ('Heer');
+INSERT INTO person__name_prefix (prefix) VALUES ('Herr');
+INSERT INTO person__name_prefix (prefix) VALUES ('Miss')
+INSERT INTO person__name_prefix (prefix) VALUES ('Mister');
+INSERT INTO person__name_prefix (prefix) VALUES ('Monsieur');
+INSERT INTO person__name_prefix (prefix) VALUES ('Mr');
+INSERT INTO person__name_prefix (prefix) VALUES ('Mrs');
+INSERT INTO person__name_prefix (prefix) VALUES ('Ms');
+INSERT INTO person__name_prefix (prefix) VALUES ('Professor');
+INSERT INTO person__name_prefix (prefix) VALUES ('Sir');