[midPoint] [Newsletter] Re: Database Scripts for 4.0?

[Chris Woods]

Hallo Pavol,
I know it’s very unsupported ☺. Thanks for the script – I will generate it by hand. I already faked the entry for m_global_metadata ;-)
Cheers,
Chris.

From: midPoint <midpoint-bounces at lists.evolveum.com> On Behalf Of Pavol Mederly
Sent: Monday, December 10, 2018 1:05 PM
To: midPoint General Discussion <midpoint at lists.evolveum.com>
Subject: *EXT* [Newsletter] Re: [midPoint] Database Scripts for 4.0?

Hello Chris,

unfortunately, they are not written yet. We postponed their creation until the M_ARCHETYPE table structure is finished.

The workaround is either to set hibernateHbm2ddl parameter to "update" (not much tested for databases other than H2, though), or to use scripts for 3.9 and manually create M_ARCHETYPE table in a way similar e.g. to M_FUNCTION_LIBRARY (see below).

But I have not tested that yet.

Best regards,
Pavol Mederly


CREATE TABLE m_archetype (
  name_norm VARCHAR(255),
  name_orig VARCHAR(255),
  oid       VARCHAR(36) NOT NULL,
  PRIMARY KEY (oid)
)

CREATE INDEX iArchetypeNameOrig
  ON m_archetype (name_orig);



ALTER TABLE m_archetype
  ADD CONSTRAINT uc_archetype_name UNIQUE (name_norm);



ALTER TABLE m_archetype
  ADD CONSTRAINT fk_archetype FOREIGN KEY (oid) REFERENCES m_object (oid);


________________________________
From: "Chris Woods" <Chris.Woods at rohde-schwarz.com<mailto:Chris.Woods at rohde-schwarz.com>>
To: "midPoint General Discussion" <midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>>
Sent: Monday, December 10, 2018 12:18:29 PM
Subject: [midPoint] Database Scripts for 4.0?

Hi,
does anyone know where I can find the latest database scripts for the 4.0 development? I can’t seem to find them on github…
Many thanks in advance,
Chris.

_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com<mailto:midPoint at lists.evolveum.com>
http://lists.evolveum.com/mailman/listinfo/midpoint

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20181210/77bfdfe5/attachment.htm>