Mercurial > genshi > mirror
view examples/trac/trac/upgrades/db7.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 readonly flag to 'wiki' """CREATE TEMPORARY TABLE wiki_old AS SELECT * FROM wiki;""", """DROP TABLE wiki;""", """CREATE TABLE wiki ( name text, version integer, time integer, author text, ipnr text, text text, comment text, readonly integer, UNIQUE(name,version) );""", """INSERT INTO wiki(name,version,time,author,ipnr,text,comment,readonly) SELECT name,version,time,author,ipnr,text,comment,0 FROM wiki_old;""" ] def do_upgrade(env, ver, cursor): for s in sql: cursor.execute(s)