Mercurial > genshi > mirror
view examples/trac/trac/upgrades/db10.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 = [ #-- Make the node_change table contain more information, and force a resync """DROP TABLE revision;""", """DROP TABLE node_change;""", """CREATE TABLE revision ( rev text PRIMARY KEY, time integer, author text, message text );""", """CREATE TABLE node_change ( rev text, path text, kind char(1), -- 'D' for directory, 'F' for file change char(1), base_path text, base_rev text, UNIQUE(rev, path, change) );""" ] def do_upgrade(env, ver, cursor): for s in sql: cursor.execute(s) print 'Please perform a "resync" after this upgrade.'