Sources

SQL source files

• ApplInfo.sql: general information (name, author, etc.).
• CreateTables.sql: definition of application-specific tables.
• CreateViews.sql: definition of application-specific views.
• CreateTriggers.sql: definition of application-specific triggers.
• CreateLaunchers.sql: application launchers (menu or button).
• InsertAppParams.sql: application-specific parameters.
• UpdateAppParams.sql: reset application-specific parameters after an application update.
• UpdateAppSchemaTables.sql: table properties.
• UpdateAppSchemaFields.sql: field properties.
• CreateBaseData.sql: application base data.
• TranslationKeys.sql: table names, field names and dialog messages to translate.
• Translations.sql: translations in English, Spanish, Esperanto and French.

All this files are executed when clicking Apply schema changes or File/New :

New db	Updating existing db
Create FADA tables (except fada_params), views and triggers. CreateTables.sql CreateBaseData.sql	Delete all triggers and views. Create FADA tables (except fada_params), views and triggers. Save user data into TEMP tables. CreateTables.sql Restore user data.
CreateViews.sql Create fada_params table and save user parameter values into TEMP table. Insert first FADAcore parametes. InsertAppParams.sql Insert last FADAcore parameters. Restore user parameter values. UpdateAppParams.sql CreateTriggers.sql Insert fada_t_schema and fada_f_schema empty reccords from SQLite schema. AppInfo.sql UpdateAppSchemaTables.sql UpdateAppSchemaFields.sql Update tv_type in fada_t_schema and fada_f_schema tables depending on the existence of triggers. Update field_type of view field in fada_f_schema table depending on field_type of table field. Update readonly in fada_f_schema table depending on the existence of triggers. Update color in fada_params with color of table or view found in Section. CreateLaunchers.sql Read scripts folder and insert SQLF files as script in fada_scripts. Insert FADAcore translations in fada_tr_keys and fada_translations tables. TranslationKeys.sql Translations.sql Update table record counts in fada_t_schema. Read ressources folder and insert files in fada_files.

AppInfo.sql

Updates the fada_app_info table with general information about your application.

This file is automatically generated by FADAcore when you modify this information in the Application info tab.

Menu Modify xxx/Application info

CreateTables.sql

Create the tables for your application. No need to DROP TABLE before.

: Tests the CREATE TABLE where the text cursor is located.

Menu Modify xxx/Schema/Tables

CreateViews.sql

Create the views for your application. No need to DROP VIEW before.

: Tests the CREATE VIEW where the text cursor is located.

Menu Modify xxx/Schema/Views

CreateTriggers.sql

Create the triggers for your application. No need to DROP TRIGGER before.

CREATE TRIGGER can't be tested from the editor.

Menu Modify xxx/Schema/Triggers

CreateLaunchers.sql

Fill the fada_launchers table.

This file is automatically generated by FADAcore when you modify in the Launchers tab.

Menu Modify xxx/Launchers

InsertAppParams.sql

Fill the fada_params table with the application-specific parameters. This table also contains FADAcore parameters (present in all applications).

Menu Modify xxx/Parameters/Parameters (INSERT)

UpdateAppParams.sql

Updates settings after an application update.

Menu Modify xxx/Parameters/Parameters (UPDATE)

UpdateAppSchemaTables.sql

Updates the fada_t_schema table with FADA table properties.

This file is automatically generated by FADAcore when you modify this information in the Table and view properties tab.

Menu Modify xxx/Table and view properties

UpdateAppSchemaFields.sql

Updates the fada_f_schema table with FADA field properties.

This file is automatically generated by FADAcore when you modify this information in the Field properties tab.

Menu Modify xxx/Field properties

CreateBaseData.sql

Fills application tables with base data (data present when the user creates a new database).

This file is automatically generated by FADAcore before you click Apply schema changes if you specify that the basic data is that of the application. If you specify 'CreateBaseData.sql' the file remains unchanged. If you select 'None' the file is recreated empty.

TranslationKeys.sql

Insert your translation keys in fada_tr_keys.

This file is automatically generated by FADAcore when you translate your application in the Translate tab. The entries in this tab are generated at runtime when you are in Modification mode.

Translations.sql

Insert your translations in fada_translations.

This file is automatically generated by FADAcore when you translate your application in the Translate tab. The entries in this tab are generated at runtime when you are in Modification mode.

Menu Modify xxx/Translation/Translate