https://bugzilla.wikimedia.org/show_bug.cgi?id=38311
Web browser: ---
Bug #: 38311
Summary: Implement the admin_tree table
Product: Monuments database
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: maar...@mdammers.nl
CC: platoni...@gmail.com
Classification: Unclassified
Mobile Platform: ---
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
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
