From f66ab8dae2f3d0418759f81a3a64dc9517a62449 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 14 Apr 2024 15:17:31 +0200 Subject: Adding upstream version 1.10.2. Signed-off-by: Daniel Baumann --- schema/pgsql-migrations/upgrade_167.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 schema/pgsql-migrations/upgrade_167.sql (limited to 'schema/pgsql-migrations/upgrade_167.sql') diff --git a/schema/pgsql-migrations/upgrade_167.sql b/schema/pgsql-migrations/upgrade_167.sql new file mode 100644 index 0000000..25599cc --- /dev/null +++ b/schema/pgsql-migrations/upgrade_167.sql @@ -0,0 +1,24 @@ +CREATE TABLE director_daemon_info ( + instance_uuid_hex character varying(32) NOT NULL, -- random by daemon + schema_version SMALLINT NOT NULL, + fqdn character varying(255) NOT NULL, + username character varying(64) NOT NULL, + pid integer NOT NULL, + binary_path character varying(128) NOT NULL, + binary_realpath character varying(128) NOT NULL, + php_binary_path character varying(128) NOT NULL, + php_binary_realpath character varying(128) NOT NULL, + php_version character varying(64) NOT NULL, + php_integer_size SMALLINT NOT NULL, + running_with_systemd enum_boolean DEFAULT NULL, + ts_started bigint NOT NULL, + ts_stopped bigint DEFAULT NULL, + ts_last_modification bigint DEFAULT NULL, + ts_last_update bigint NOT NULL, + process_info text NOT NULL, + PRIMARY KEY (instance_uuid_hex) +); + +INSERT INTO director_schema_migration + (schema_version, migration_time) + VALUES (167, NOW()); -- cgit v1.2.3