software-tracker-db.yaml

primary:
  persistence:
    storageClass: "nfs-client"
  service:
    type: NodePort
    nodePort: 30098

auth:
  database: software_tracker

image:
  tag: 9.3.0

initdbScripts:
  extra_users_table.sql: |
    CREATE USER IF NOT EXISTS "tol"@"%";
    GRANT EXECUTE, LOCK TABLES, SELECT, SHOW VIEW ON *.* TO "tol"@"%";
    GRANT PROCESS, SHOW DATABASES ON *.* TO "tol"@"%";
    USE software_tracker;
    CREATE TABLE IF NOT EXISTS `logging_event` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `uuid` char(36) NOT NULL DEFAULT '',
    `user` varchar(16) NOT NULL DEFAULT '',
    `timestamp` datetime NOT NULL,
    `image` varchar(255) NOT NULL DEFAULT '',
    `executable` varchar(255) DEFAULT NULL,
    `path` varchar(255) DEFAULT NULL,
    `parameters` mediumtext,
    `origin` varchar(16) NOT NULL DEFAULT 'api',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uuid` (`uuid`),
    KEY `user` (`user`),
    KEY `image` (`image`),
    KEY `executable` (`executable`),
    KEY `timestamp` (`timestamp`),
    KEY `user_image` (`user`,`image`,`timestamp`),
    KEY `user_executable` (`user`,`executable`,`timestamp`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;