| Server IP : 188.40.95.74 / Your IP : 216.73.216.205 Web Server : Apache System : Linux cp01.striminghost.net 3.10.0-1160.119.1.el7.tuxcare.els13.x86_64 #1 SMP Fri Nov 22 06:29:45 UTC 2024 x86_64 User : vlasotin ( 1054) PHP Version : 5.6.40 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/lib/python2.7/site-packages/leapp/utils/ |
Upload File : |
""" This file is auto-generated by res/schema/embed.py - DO NOT MODIFY THIS FILE MANUALLY """
CURRENT_SCHEMA = """BEGIN;
PRAGMA user_version = 4;
CREATE TABLE IF NOT EXISTS execution (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL UNIQUE,
stamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
configuration TEXT DEFAULT NULL,
kind VARCHAR(256) DEFAULT NULL
);
CREATE TABLE IF NOT EXISTS host (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL REFERENCES execution (context),
hostname VARCHAR(255) NOT NULL,
UNIQUE (context, hostname)
);
CREATE TABLE IF NOT EXISTS message_data (
hash VARCHAR(64) PRIMARY KEY NOT NULL,
data TEXT
);
CREATE TABLE IF NOT EXISTS data_source (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL REFERENCES execution (context),
host_id INTEGER NOT NULL REFERENCES host (id),
actor VARCHAR(1024) NOT NULL DEFAULT '',
phase VARCHAR(1024) NOT NULL DEFAULT '',
UNIQUE (context, host_id, actor, phase)
);
CREATE TABLE IF NOT EXISTS message (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL REFERENCES execution (context),
stamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
topic VARCHAR(1024) NOT NULL,
type VARCHAR(1024) NOT NULL,
data_source_id INTEGER NOT NULL REFERENCES data_source (id),
message_data_hash VARCHAR(64) NOT NULL REFERENCES message_data (hash)
);
CREATE TABLE IF NOT EXISTS metadata (
hash VARCHAR(64) PRIMARY KEY NOT NULL,
metadata TEXT
);
CREATE TABLE IF NOT EXISTS actor_config (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL REFERENCES execution (context),
actor_config_hash VARCHAR(64) NOT NULL REFERENCES actor_config_data (hash)
);
CREATE TABLE IF NOT EXISTS actor_config_data (
hash VARCHAR(64) PRIMARY KEY NOT NULL,
config TEXT
);
CREATE TABLE IF NOT EXISTS entity (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL REFERENCES execution (context),
kind VARCHAR(256) NOT NULL DEFAULT '',
name VARCHAR(1024) NOT NULL DEFAULT '',
metadata_hash VARCHAR(64) NOT NULL REFERENCES metadata (hash),
UNIQUE (context, kind, name)
);
CREATE TABLE IF NOT EXISTS dialog (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL REFERENCES execution (context),
scope VARCHAR(1024) NOT NULL DEFAULT '',
data TEXT DEFAULT NULL,
data_source_id INTEGER NOT NULL REFERENCES data_source (id)
);
CREATE TABLE IF NOT EXISTS audit (
id INTEGER PRIMARY KEY NOT NULL,
event VARCHAR(256) NOT NULL REFERENCES execution (context),
stamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
context VARCHAR(36) NOT NULL,
data_source_id INTEGER NOT NULL REFERENCES data_source (id),
message_id INTEGER DEFAULT NULL REFERENCES message (id),
data TEXT DEFAULT NULL
);
CREATE VIEW IF NOT EXISTS messages_data AS
SELECT
message.id AS id,
message.context AS context,
message.stamp AS stamp,
message.topic AS topic,
message.type AS type,
data_source.actor AS actor,
data_source.phase AS phase,
msg_data.hash AS message_hash,
msg_data.data AS message_data,
host.hostname AS hostname
FROM
message
JOIN
data_source ON data_source.id = message.data_source_id,
message_data AS msg_data ON message.message_data_hash = msg_data.hash,
host ON host.id = data_source.host_id
;
COMMIT;
"""
"""Current schema of the leapp database"""
MIGRATIONS = [
(0, """BEGIN;
ALTER TABLE message
RENAME TO message_0;
CREATE TABLE message (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL REFERENCES execution (context),
stamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
topic VARCHAR(1024) NOT NULL,
type VARCHAR(1024) NOT NULL,
data_source_id INTEGER NOT NULL REFERENCES data_source (id),
message_data_hash VARCHAR(64) NOT NULL REFERENCES message_data (hash)
);
INSERT INTO message (id, context, stamp, topic, type, data_source_id, message_data_hash)
SELECT
id,
context,
stamp,
channel,
type,
data_source_id,
message_data_hash
FROM message_0;
DROP TABLE message_0;
DROP VIEW messages_data;
CREATE VIEW IF NOT EXISTS messages_data AS
SELECT
message.id AS id,
message.context AS context,
message.stamp AS stamp,
message.topic AS topic,
message.type as type,
data_source.actor as actor,
data_source.phase as phase,
msg_data.hash as message_hash,
msg_data.data as message_data,
host.hostname as hostname
FROM
message
JOIN
data_source ON data_source.id = message.data_source_id
,
message_data as msg_data ON message.message_data_hash = msg_data.hash,
host ON host.id = data_source.host_id;
PRAGMA user_version = 1;
COMMIT;"""),
(1, """BEGIN;
ALTER TABLE execution
ADD COLUMN kind VARCHAR(256) DEFAULT NULL;
PRAGMA user_version = 2;
COMMIT;"""),
(2, """BEGIN;
CREATE TABLE IF NOT EXISTS metadata (
hash VARCHAR(64) PRIMARY KEY NOT NULL,
metadata TEXT
);
CREATE TABLE IF NOT EXISTS entity (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL REFERENCES execution (context),
kind VARCHAR(256) NOT NULL DEFAULT '',
name VARCHAR(1024) NOT NULL DEFAULT '',
metadata_hash VARCHAR(64) NOT NULL REFERENCES metadata (hash),
UNIQUE (context, kind, name)
);
CREATE TABLE IF NOT EXISTS dialog (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL REFERENCES execution (context),
scope VARCHAR(1024) NOT NULL DEFAULT '',
data TEXT DEFAULT NULL,
data_source_id INTEGER NOT NULL REFERENCES data_source (id)
);
PRAGMA user_version = 3;
COMMIT;
"""),
(3, """BEGIN;
CREATE TABLE IF NOT EXISTS actor_config (
id INTEGER PRIMARY KEY NOT NULL,
context VARCHAR(36) NOT NULL REFERENCES execution (context),
actor_config_hash VARCHAR(64) NOT NULL REFERENCES actor_config_data (hash)
);
CREATE TABLE IF NOT EXISTS actor_config_data (
hash VARCHAR(64) PRIMARY KEY NOT NULL,
config TEXT
);
PRAGMA user_version = 4;
COMMIT;
""")
]
"""Migrations for previous versions of the leapp database"""