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

[Pavol Mederly]

Hello Chris,

finally I have just committed migration scripts for all the databases 
(on master branch).

There's one additional change: m_generic_object is now FocusType (not 
ObjectType). The migration script changes DB structure but does *not* 
modify actual data. I assume that virtually no one uses generic objects. 
If you do, it would be perhaps the best to export them, delete them, 
migrate the DB, and re-import them. (I think that 4.0 will ship with 
more elaborate migration procedure ... btw, most probably there will be 
more DB changes there.)

m_global_metadata is interesting ... it was already present in 3.9. Have 
you switched from 3.8?

Best regards,

Pavol Mederly
Software developer
evolveum.com

On 10.12.2018 14:12, Chris Woods wrote:
>
> Hallo Pavol,
>
> I know it’s very unsupported J. 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
>
>
> _______________________________________________
> midPoint mailing list
> 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/20181212/7dac48f8/attachment.htm>