Last modified: 2012-07-19 20:46:38 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T40311, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 38311 - Implement the admin_tree table
Implement the admin_tree table
Status: RESOLVED FIXED
Product: Wiki Loves Monuments
Classification: Unclassified
Database (Other open bugs)
unspecified
All All
: Unprioritized enhancement
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: 38312 38313
  Show dependency tree / graph
 
Reported: 2012-07-11 16:06 UTC by Maarten Dammers
Modified: 2012-07-19 20:46 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Maarten Dammers 2012-07-11 16:06:24 UTC 
An admin_tree table should be created to be able to browse locations.

It should probably contain the following items:
* id - ID of the location, primkey
* level - level for the location (0=adm0=country, 1=adm1=state/province/, etc)
* name -  Name of the location. Can be a iso code or just a regular string.
* parent - The id of the parent to form the tree. NULL if top level (0 aka country)

Should have keys for browsing level 0 -> level 1, etc

/home/project/e/r/f/erfgoed/erfgoedbot/sql/create_table_admin_tree.sql can be modified
Comment 1 Platonides 2012-07-11 23:39:07 UTC 
I find admin:tree name misleading, it makes me think in administrators.

locations_tree, perhaps?
Comment 2 Maarten Dammers 2012-07-12 06:11:33 UTC 
I don't want to bikeshed so this is fine with me. If we decide this is the right name we should update some other bugs.
Comment 3 Arthur Richards 2012-07-19 20:46:38 UTC 
Resolved in r759 - although I did not see this bug until after I added the SQL file. The table is currently admin_tree. If this is unacceptable, I'm happy to change it.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links