Talk:Database Schema

From MythTV Official Wiki
Jump to: navigation, search

Group by plugin

The list of tables at the end of this page might benefit from being grouped by the plugin to which they belong. e.g. musicmetadata is Mythmusic, filemarkup is mythvideo. Thoughts? --GBee 14:59, 6 March 2006 (UTC)

Actually, I think there are too many categories regarding the plugins. There is only about one article per plugin mostly, and I am thinking about moving them all into Category:Plugins. That would kind of defeat what you were looking for. Another option is to put a link at the top of the DB table article, pointing at the main plugin article as well. --Gregturn 20:40, 6 March 2006 (UTC)
Didn't mean that we create more pages, just that we group the list of tables on that page by plugin.--GBee 23:07, 6 March 2006 (UTC)
Okay, so you mean listing them on Database Schema, you would sectionalize based on plugins, not "categorize" in the mediawiki sense? That sounds fine to me! --Gregturn 00:15, 7 March 2006 (UTC)
Sounds good. I just took a list of all of the current tables in my v1123 schema (0.19) DB. I'm using atrpms RPM packages so there are a few plugin-specific tables in there but I don't actually know which tables go with which plugin, apart from the obvious ones. If you know this info, feel free to go right ahead and group by plugin.--Mezzanine 13:17, 7 March 2006 (UTC)

We could create subcategory DB Table

If we create subcategory Category:DB Table underneath Category:Developer Documentation, then it will be easy to navigate to all the tables. I can write a bot-job to mod the existing pages. Sound interesting? --Gregturn 23:51, 28 February 2006 (UTC)

Good Idea. Ah, have all of the table articles accessible directly from the category pages? Yes, sounds good. --Mezzanine 10:41, 1 March 2006 (UTC)
Check it out now. Category:DB Table was based on the existing table links on this article. --Gregturn 17:40, 3 March 2006 (UTC)

Splitting off into Database article

If no one objects, I'll create a database page containing the non-schema related info from this page. Database appears to be a wanted page... --Mezzanine 16:09, 1 March 2006 (UTC)

Ok, I've now done this. Don't know what category to put the Database page into though...

Creating mediawiki tables from CSV table structures

CSV2WP looks interesting and may help the heavy-lifting --Mezzanine 16:53, 2 March 2006 (UTC)