Manual talk:Database layout/diagram instructions

I just created the pages for 1.36 and 1.37 following the instructions, it’s very easy (congrats for the Lua module!).

Also:

1. I added the table "watchlist_expiry" in 1.35.0 and next,
2. Added the file maintenance/tables-generated.sql for 1.35.0 and in the instructions,
3. Modified a bit the Lua module to ignore the definitions of indexes inside a CREATE TABLE statement (diff) very used in tables-generated.sql

If someone has some time to fix a small issue in the Lua module: in tables-generated.sql, the PRIMARY key is defined inside the CREATE TABLE and this syntax is not recognised by the Lua module (search "PRIMARY" in the code): a few rules should be added to recognise this syntax and make the primary indexes reappear in 1.35+.

Thanks.

I've fixed the missing "primary" key detection by adding native support for JSON table declarations, and switching the 1.37 diagram to use a JSON subpage instead of a raw SQL subpage.

Result at Manual:Database layout/diagram/1.37.0.

See also:

• Wikitech-l thread fom April 2019.
• mediawiki.org talkpage thread from July 2019.

Who would like to help create the next version of the diagram? Ping me here or send me an e-mail.

I'd like to help. Trying using the process described

@DannyS712 I've created new automation which makes the process easier. See Diagram instructions#Wiki-based. I have done the first step (update sql and layout).

Can you try the second step? (Capture and upload screenshot to Commons.)

Thanks!

I probably won't have time this week

They are published at mwDatabaseSchema

Instead of re-layouting each time, wouldn't it be easier to have the mwb file available and just update the model from a live database / schema and layout the changes?

I see them stored in https://github.com/Krinkle/toolserver-misc/tree/master/public_html/mwDatabaseSchema/

So in Workbench, one could try Database -> Synchronize Model to avoid some work, maybe.

I've found it quicker to redo it then to do it this way. But anyone taking this on should feel free to re-use my files as they see fit. If and when someone does this, I'd be happy to keep publishing them in that same directory for discoverability.

FYI: Note that Doc Taxon has volunteered to try the next one.