Thread:Talk:Requests for comment/New sites system/Database schema proposal/reply (5)

Yeah this looks better. Course I'm still not keen on the site_url/site_page_path separation an think it should be type data.

I think we can drop site_link_inline. It was needed before because local_key could be a copy of the global key and not be a prefix. But now that a site with no interwiki links simply is one with no site_identifiers (site_prefix?) rows I can't think of a purpose for site_link_inline.

Also if you don't mind the bikeshedding:
 * site_global_key can probably just be site_global, or maybe just site_key since we're already talking about the unique data
 * si_key_type is basically the replacement for site_link_navigation, so we don't need site_link_navigation.
 * For si_site_id using si_site would match the other tables, see rev_page.
 * si_key_type can probably be just si_type. (Btw, I like 'type', I couldn't figure out what to call it before)