Mercurial > genshi > mirror
view examples/trac/trac/upgrades/db5.py @ 39:93b4dcbafd7b trunk
Copy Trac to main branch.
author | cmlenz |
---|---|
date | Mon, 03 Jul 2006 18:53:27 +0000 |
parents | |
children |
line wrap: on
line source
sql = [ #-- Add unique id, descr to 'milestone' """CREATE TEMPORARY TABLE milestone_old AS SELECT * FROM milestone;""", """DROP TABLE milestone;""", """CREATE TABLE milestone ( id integer PRIMARY KEY, name text, time integer, descr text, UNIQUE(name) );""", """ INSERT INTO milestone(name,time, descr) SELECT name,time,'' FROM milestone_old;""", """DROP TABLE milestone_old;""", ] def do_upgrade(env, ver, cursor): for s in sql: cursor.execute(s)