export class AppParam {
    readonly driverapp = {
        app: {
            APPID: "DriverAPP",
            DBName: "DriverAPP",
            Version: "1.0",
            isBeta: "y"
        }
    }
}

export class ADSysConfig {
    readonly sysConfig = [
        {
            "ad_sysconfig_uu": "120",
            "name": "driverapp.app.LogLevel",
            "description": '[{"name":"ALL","value":"ALL"},{"name":"INFO","value":"INFO"},{"name":"WARN","value":"WARN"},{"name":"ERROR","value":"ERROR"},{"name":"OFF","value":"OFF"}]',
            "value": "ALL",
            "datatype": "select",
            "configtype": "AC"
        }, {
            "ad_sysconfig_uu": "113",
            "name": "driverapp.app.AppServerWSURL",
            "description": "driverapp.app.AppServerWSURL",
            "value": "/ADInterface/services/rest/model_adservice",
            "datatype": "text",
            "configtype": "AC"
        }, {
            "ad_sysconfig_uu": "143",
            "name": "driverapp.app.Role",
            "description": "driverapp.app.Role",
            "value": "1000000",
            "datatype": "number",
            "configtype": "AC"
        }, {
            "ad_sysconfig_uu": "193",
            "name": "driverapp.app.Lang",
            "description": "driverapp.app.Lang",
            "value": "en_US",
            "datatype": "text",
            "configtype": "AU"
        }, {
            "ad_sysconfig_uu": "163",
            "name": "driverapp.app.Client",
            "description": "driverapp.app.Client",
            "value": "11",
            "datatype": "number",
            "configtype": "AC"
        }, {
            "ad_sysconfig_uu": "183",
            "name": "driverapp.app.Warehouse",
            "description": "driverapp.app.Warehouse",
            "value": "50002",
            "datatype": "number",
            "configtype": "AC"
        }, {
            "ad_sysconfig_uu": "783",
            "name": "driverapp.app.Org",
            "description": "driverapp.app.Org",
            "value": "50001",
            "datatype": "number",
            "configtype": "AC"
        }, {
            "ad_sysconfig_uu": "3213",
            "name": "driverapp.app.Stage",
            "description": "driverapp.app.Stage",
            "value": "9",
            "datatype": "number",
            "configtype": "AU"
        }, {
            "ad_sysconfig_uu": "154",
            "name": "driverapp.app.AppServerUrl",
            "description": "driverapp.app.AppServerUrl",
            "value": "http://192.168.1.57",
            "datatype": "text",
            "configtype": "AC"
        }, {
            "ad_sysconfig_uu": "256",
            "name": "driverapp.app.AppServerPort",
            "description": "driverapp.app.AppServerPort",
            "value": "8041",
            "datatype": "number",
            "configtype": "AC"
        }, {
            "ad_sysconfig_uu": "145256",
            "name": "driverapp.app.NodeServerUrl",
            "description": "driverapp.app.AppServerPort",
            "value": "http://192.168.1.57",
            "datatype": "text",
            "configtype": "AC"
        }, {
            "ad_sysconfig_uu": "25689",
            "name": "driverapp.app.NodeServerPort",
            "description": "driverapp.app.AppServerPort",
            "value": "4001",
            "datatype": "number",
            "configtype": "AC"
        }
    ]
}

export class DB_CONFIG {
    readonly tables = [
        "CREATE TABLE IF NOT EXISTS APP_Migration(app_migration_uu TEXT(36) NOT NULL, version TEXT(10), isbeta BOOLEAN, 'app_updated' timestamp , 'app_synced' timestamp)",
        "CREATE TABLE IF NOT EXISTS APP_MigrationSql(app_migration_uu NUMERIC(10,0), app_migrationsql_uu TEXT(36) NOT NULL, seqno NUMERIC(22,0), sql TEXT, result TEXT, isapplied BOOLEAN, 'app_updated' timestamp , 'app_synced' timestamp)",
        "CREATE TABLE IF NOT EXISTS AD_SysConfig(ad_sysconfig_uu TEXT(36) UNIQUE NOT NULL, name TEXT, description TEXT, value TEXT, datatype TEXT, configtype TEXT(2), 'app_updated' timestamp , 'app_synced' timestamp)"
    ]
}