Manual talk:Database layout/diagram instructions

About this board

Update for 1.36 and 1.37

2
Seb35 (talkcontribs)

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+.

Krinkle (talkcontribs)
Reply to "Update for 1.36 and 1.37"
Krinkle (talkcontribs)
DannyS712 (talkcontribs)

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

Krinkle (talkcontribs)

@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!

DannyS712 (talkcontribs)

I probably won't have time this week

Reply to "Update for 2019-2020"

Can the mwb schema files be stored somewhere?

3
Summary by Krinkle

They are published at mwDatabaseSchema

Rillke (talkcontribs)

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?

Rillke (talkcontribs)
Krinkle (talkcontribs)

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.

There are no older topics
Return to "Database layout/diagram instructions" page.