SQLite format 3@ `) m`.,P#* %f656e56dfdc8 % f656e56dfdc8  ConfigDB#   ConfigDB /UserpgAdmin User Role+'AAdministratorpgAdmin Administrator Role   User' Administrator    Servers    Servers         Tf  d )  AvH ` ` `D5--tableuser_preferencesuser_preferencesCREATE TABLE user_preferences ( pid INTEGER NOT NULL, uid INTEGER NOT NULL, value VARCHAR(1024) NOT NULL, PRIMARY KEY (pid, uid), FOREIGN KEY(pid) REFERENCES preferences (id) ON DELETE CASCADE, FOREIGN KEY(uid) REFERENCES "user" (id) ON DELETE CASCADE )c ## tableroles_usersroles_users CREATE TABLE roles_users ( user_id INTEGER, role_id INTEGER, FOREIGN KEY(role_id) REFERENCES role (id) ON DELETE CASCADE, FOREIGN KEY(user_id) REFERENCES "user" (id) ON DELETE CASCADE ) `UiCindexsqlite_autoindex_debugger_function_arguments_1debugger_function_argumentsJCCtabledebugger_function_argumentsdebugger_function_argumentsCREATE TABLE debugger_function_arguments ( server_id INTEGER NOT NULL, database_id INTEGER NOT NULL, schema_id INTEGER NOT NULL, function_id INTEGER NOT NULL, arg_id INTEGER NOT NULL, is_null INTEGER NOT NULL, is_expression INTEGER NOT NULL, use_default INTEGER, value VARCHAR NOT NULL, PRIMARY KEY (server_id, database_id, schema_id, function_id, arg_id), CHECK (is_null >= 0 AND is_null <= 1), CHECK (is_expression >= 0 AND is_expression <= 1), CHECK (use_default >= 0 AND use_default <= 1) )?S-indexsqlite_autoindex_user_preferences_1user_preferencesV##stablepreferencespreferencesCREATE TABLE preferences ( id INTEGER NOT NULL, cid INTEGER NOT NULL, name VARCHAR(256) NOT NULL, PRIMARY KEY (id), FOREIGN KEY(cid) REFERENCES preference_category (id) )c33mtablepreference_categorypreference_categoryCREATE TABLE preference_category ( id INTEGER NOT NULL, mid INTEGER, name VARCHAR(256) NOT NULL, PRIMARY KEY (id), FOREIGN KEY(mid) REFERENCES module_preference (id) )//_tablemodule_preferencemodule_preferenceCREATE TABLE module_preference ( id INTEGER NOT NULL, name VARCHAR(256) NOT NULL, PRIMARY KEY (id) )5I#indexsqlite_autoindex_servergroup_1servergroup d} ##Atableservergroupservergroup CREATE TABLE servergroup ( id INTEGER NOT NULL, user_id INTEGER NOT NULL, name VARCHAR(128) NOT NULL, PRIMARY KEY (id), FOREIGN KEY(user_id) REFERENCES "user" (id) ON DELETE CASCADE, UNIQUE (user_id, name) )/' ;indexsqlite_autoindex_role_1role '1tableroleroleCREATE TABLE role ( id INTEGER NOT NULL, name VARCHAR(128) NOT NULL, description VARCHAR(256) NOT NULL, PRIMARY KEY (id), UNIQUE (name) )-Aindexsqlite_autoindex_version_1version~StableversionversionCREATE TABLE version ( name VARCHAR(32) NOT NULL, value INTEGER NOT NULL, PRIMARY KEY (name) )=Q+indexsqlite_autoindex_alembic_version_1alembic_version)++ tablealembic_versionalembic_versionCREATE TABLE alembic_version ( version_num VARCHAR(32) NOT NULL, CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num) )  M7 h M5)I#indexsqlite_autoindex_user_macros_1user_macros% /(##%tableuser_macrosuser_macros$CREATE TABLE user_macros ( mid INTEGER NOT NULL, uid INTEGER NOT NULL, name VARCHAR(1024) NOT NULL, sql VARCHAR, PRIMARY KEY (mid, uid), FOREIGN KEY(mid) REFERENCES macros (id) ON DELETE CASCADE, FOREIGN KEY(uid) REFERENCES "user" (id) ON DELETE CASCADE )I'mtablemacrosmacros!CREATE TABLE macros ( id INTEGER NOT NULL, alt BOOLEAN NOT NULL, control BOOLEAN NOT NULL, "key" VARCHAR(128) NOT NULL, key_code INTEGER NOT NULL, PRIMARY KEY (id) )/$Cindexsqlite_autoindex_database_1database\# tabledatabasedatabaseCREATE TABLE "database" ( id INTEGER NOT NULL, schema_res VARCHAR, server INTEGER NOT NULL, PRIMARY KEY (id, server), FOREIGN KEY(server) REFERENCES "server" (id) ON DELETE CASCADE )9M'indexsqlite_autoindex_query_history_1query_history3''_tablequery_historyquery_historyCREATE TABLE query_history ( srno INTEGER NOT NULL, uid INTEGER NOT NULL, sid INTEGER NOT NULL, dbname VARCHAR NOT NULL, query_info VARCHAR NOT NULL, last_updated_flag VARCHAR NOT NULL, PRIMARY KEY (srno, uid, sid, dbname), FOREIGN KEY(sid) REFERENCES "server" (id) ON DELETE CASCADE, FOREIGN KEY(uid) REFERENCES "user" (id) ON DELETE CASCADE )';indexsqlite_autoindex_keys_1keysqEtablekeyskeysCREATE TABLE keys ( name VARCHAR NOT NULL, value VARCHAR NOT NULL, PRIMARY KEY (name) )-Aindexsqlite_autoindex_process_1processFctableprocessprocessCREATE TABLE process ( user_id INTEGER NOT NULL, pid VARCHAR NOT NULL, "desc" VARCHAR NOT NULL, command VARCHAR NOT NULL, arguments VARCHAR, start_time VARCHAR, end_time VARCHAR, logdir VARCHAR, exit_code INTEGER, acknowledge VARCHAR, utility_pid INTEGER, process_state INTEGER DEFAULT '0', server_id INTEGER DEFAULT '0', PRIMARY KEY (pid), FOREIGN KEY(user_id) REFERENCES "user" (id) ON DELETE CASCADE )   ==E9eSECURITY_PASSWORD_SALTiFgzIhiXVr6TMSgnuRTWmk6Z0KxAzSEZnS4cFIf6DH4=9!eSECRET_KEY8B2MOha1Wn5ccuA06ctNEiYKXxtvWhIbb6scSTbTPqQ=?-eCSRF_SESSION_KEYWq8UCPF0MeEZTXsCbsyopCbTBlFzCw2busEJXNfhuX8= 9SECURITY_PASSWORD_SALT!SECRET_KEY- CSRF_SESSION_KEY     {peZOD9-!  F12{  F11z  F10y  F9x  F8w  F7v  F6u  F5t  F4s  F3r  F2q  F1p  00  99 88 77 66 55 44 33 22 11 m E EMc155fj0w@c155fj0w.mwprem.net$pbkdf2-sha512$25000$JYRQSgnhvJdyznnvfY/x/g$5tK.z40HdQ8YZ3MInq47uQYbyFX49ai/cfb4dd1saRlzIIxEg327Ejld1KzF.uB5qhkGmrt5OphOkf2/0cycLAc155fj0w@c155fj0w.mwprem.netinternal70f4abf12a8946ad8f5c519a4f675970 Zy) !y ? W WZZZ-1%%tablesharedserversharedserver(CREATE TABLE "sharedserver" ( id INTEGER NOT NULL, user_id INTEGER NOT NULL, server_owner VARCHAR(64), servergroup_id INTEGER NOT NULL, name VARCHAR(128) NOT NULL, host VARCHAR(128), port INTEGER, maintenance_db VARCHAR(64), username VARCHAR(64), password VARCHAR, role VARCHAR(64), comment VARCHAR(1024), discovery_id VARCHAR(128), db_res VARCHAR, bgcolor VARCHAR(10), fgcolor VARCHAR(10), service VARCHAR, use_ssh_tunnel INTEGER DEFAULT '0', tunnel_host VARCHAR, tunnel_port VARCHAR, tunnel_username VARCHAR, tunnel_authentication INTEGER DEFAULT '0', tunnel_identity_file VARCHAR, shared BOOLEAN NOT NULL, save_password INTEGER DEFAULT '0', tunnel_password VARCHAR, osid INTEGER, connection_params JSON, PRIMARY KEY (id), FOREIGN KEY(user_id) REFERENCES user (id) ON DELETE CASCADE, FOREIGN KEY(servergroup_id) REFERENCES servergroup (id) )/.Cindexsqlite_autoindex_user_mfa_1user_mfa h-3Aindexsqlite_autoindex_setting_1setting)',;indexsqlite_autoindex_user_1user'e+-tableuseruser"CREATE TABLE "user" ( id INTEGER NOT NULL, email VARCHAR(256), password VARCHAR, active BOOLEAN NOT NULL, confirmed_at DATETIME, masterpass_check VARCHAR(256), username VARCHAR(256) DEFAULT ('') NOT NULL, auth_source VARCHAR(256) DEFAULT 'internal' NOT NULL, fs_uniquifier VARCHAR NOT NULL, locked BOOLEAN DEFAULT 'false', login_attempts INTEGER DEFAULT '0', PRIMARY KEY (id), CONSTRAINT user_unique_constraint UNIQUE (username, auth_source) )=_2tablesettingsetting&CREATE TABLE "setting" ( user_id INTEGER NOT NULL, setting VARCHAR(256) NOT NULL, value TEXT, PRIMARY KEY (user_id, setting), FOREIGN KEY(user_id) REFERENCES user (id) ON DELETE CASCADE )p0;tableserverserverCREATE TABLE "server" ( id INTEGER NOT NULL, user_id INTEGER NOT NULL, servergroup_id INTEGER NOT NULL, name VARCHAR(128) NOT NULL, host VARCHAR(128), port INTEGER, maintenance_db VARCHAR(64), username VARCHAR(64), comment VARCHAR(1024), password VARCHAR, role VARCHAR(64), discovery_id VARCHAR, db_res VARCHAR, bgcolor VARCHAR(10), fgcolor VARCHAR(10), service VARCHAR, use_ssh_tunnel INTEGER DEFAULT '0', tunnel_host VARCHAR, tunnel_port VARCHAR, tunnel_username VARCHAR, tunnel_authentication INTEGER DEFAULT '0', tunnel_identity_file VARCHAR, tunnel_password VARCHAR(64), save_password INTEGER DEFAULT '0', shared BOOLEAN, kerberos_conn BOOLEAN DEFAULT 'false', cloud_status INTEGER DEFAULT '0', passexec_cmd VARCHAR(256), passexec_expiration INTEGER, connection_params JSON, PRIMARY KEY (id), FOREIGN KEY(servergroup_id) REFERENCES servergroup (id), FOREIGN KEY(user_id) REFERENCES "user" (id) ON DELETE CASCADE )i-%tableuser_mfauser_mfaCREATE TABLE user_mfa ( user_id INTEGER NOT NULL, mfa_auth VARCHAR(256) NOT NULL, options VARCHAR, PRIMARY KEY (user_id, mfa_auth), FOREIGN KEY(user_id) REFERENCES "user" (id) ON DELETE CASCADE )    (E c155fj0w@c155fj0w.mwprem.netinternal