[
http://opencast.jira.com/browse/MH-9407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=33013#comment-33013
]
Lukas Rohner commented on MH-9407:
----------------------------------
Has been fixed as part of MH-9202.
CREATE TABLE mh_service_registration (
id BIGINT NOT NULL,
path VARCHAR(255) NOT NULL,
job_producer TINYINT(1) DEFAULT 0 NOT NULL,
service_type VARCHAR(255) NOT NULL,
online TINYINT(1) DEFAULT 1 NOT NULL,
active TINYINT(1) DEFAULT 1 NOT NULL,
online_from DATETIME,
service_state VARCHAR(32) NOT NULL,
state_changed DATETIME,
warning_state_trigger BIGINT,
error_state_trigger BIGINT,
host_registration BIGINT,
PRIMARY KEY (id),
CONSTRAINT UNQ_mh_service_registration_0 UNIQUE (host_registration,
service_type),
CONSTRAINT FK_service_registration_host_registration FOREIGN KEY
(host_registration) REFERENCES mh_host_registration (id)
);
CREATE TABLE mh_host_registration (
id BIGINT NOT NULL,
host VARCHAR(255) NOT NULL,
maintenance TINYINT(1) DEFAULT 0 NOT NULL,
online TINYINT(1) DEFAULT 1 NOT NULL,
active TINYINT(1) DEFAULT 1 NOT NULL,
max_jobs INTEGER NOT NULL,
PRIMARY KEY (id),
CONSTRAINT UNQ_mh_host_registration_0 UNIQUE (host)
);
> mysql ddl misses active field for host_registration and service_registration
> ----------------------------------------------------------------------------
>
> Key: MH-9407
> URL: http://opencast.jira.com/browse/MH-9407
> Project: Matterhorn Project
> Issue Type: Bug
> Components: Administrative Tools
> Affects Versions: 1.4
> Reporter: Kristof Keppens
> Priority: Release Blocker
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://opencast.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Matterhorn mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn
To unsubscribe please email
[email protected]
_______________________________________________
