#617 Script sql files to create MySQL and Postgress databases updated

Script sql files to create MySQL and Postgress databases updated

HANDYMAN

*...\bin\SQL\scripts\genhandymanen.sql *

Deleted Colours – Not used in TurboCASH 4 and TurboCASH 5

INSERT INTO TYPES VALUES (40, 'Classic', 4);
INSERT INTO TYPES VALUES (41, 'Brilliant', 4);
INSERT INTO TYPES VALUES (42, 'Pastel', 4);
INSERT INTO TYPES VALUES (43, 'Keywest', 4);
INSERT INTO TYPES VALUES (44, 'NewSA', 4);
INSERT INTO TYPES VALUES (45, 'Windows Default', 4);

Added Missing records

INSERT INTO TYPES VALUES (19, 'Delivery note', 1);
INSERT INTO TYPES VALUES (56, 'New plain', 5);

Reconciliation of Records
59 Old total records
- 6 Deleted records (Colours)
+ 1 Added record - Document types - (19, 'Delivey note', 1)
+ 1 Added record - Paper types - (56, 'New plain', 5)
55 Total records

NOTE : Group - Workflow types (120, 'Workflow types', 2); not in Groups as the Workflow plugin is not activated. See HR-CROATIAN-CONTOH_INA, LT-LITHUANIA

Osf Netherlands

*...\bin\SQL\scripts\GENosfsqlnld.sql *

Deleted Colours – Not used in TurboCASH 4 and TurboCASH 5

INSERT INTO TYPES VALUES (40, 'Classic', 4);
INSERT INTO TYPES VALUES (41, 'Brilliant', 4);
INSERT INTO TYPES VALUES (42, 'Pastel', 4);
INSERT INTO TYPES VALUES (43, 'Keywest', 4);
INSERT INTO TYPES VALUES (44, 'NewSA', 4);
INSERT INTO TYPES VALUES (45, 'Windows Default', 4);

Added Missing records

INSERT INTO TYPES VALUES (56, 'New plain', 5);

Changed records

INSERT INTO TYPES VALUES (1000, 'Projecten', 2); was Status

Reconciliation of Records
61 Old total records
- 6 Deleted records - Colours
+ 1 Added record - Paper type (56, 'New plain', 5)
56 Total records

Fixed and tidied the Group names (Groups on the Setup ribbon) in all databases in the Repository and TUTORIALS folders

Changed the descriptions of Document types to the singular format – This will solve the document type on layout files when printing the following documents - https://sourceforge.net/p/turbocash/bugs/305/