[Trac-tickets] [The Trac Project] #2429: "trac-admin priority add foo" should honor order of execution/insersion

[The Trac Project]

#2429: "trac-admin priority add foo" should honor order of execution/insersion
---------------------------------+------------------------------------------
 Reporter:  mdaniel at scdi.com     |       Owner:  daniel
     Type:  defect               |      Status:  new   
 Priority:  normal               |   Milestone:        
Component:  trac-admin           |     Version:        
 Severity:  normal               |   Keywords:  trac-admin priority  |  
---------------------------------+------------------------------------------
 In my situation, I wanted more than 10 priorities ''(because we're all
 corporate and stuff here)''.
 {{{
 #!sh
 for i in `seq 1 15`; do
     trac-admin /path/to priority add P$i
 done
 }}}
 results in their order appearing as P1,P10,P2, etc.

 Pleaese reference:

 source:/trunk/trac/scripts/admin.py at latest#L853

 to see that it uses a numerically increasing "value" field, but "value" is
 a text field, so if you do a
 {{{
 #!sql
 select * from enum
 where type='priority'
 order by value
 }}}
 it will not do as one wishes above ten items, since (lexically) 1 and 10
 appear next to one another.

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/2429>
The Trac Project <http://trac.edgewall.com/>