Mercurial > genshi > mirror
comparison examples/trac/trac/upgrades/db4.py @ 39:93b4dcbafd7b trunk
Copy Trac to main branch.
| author | cmlenz |
|---|---|
| date | Mon, 03 Jul 2006 18:53:27 +0000 |
| parents | |
| children |
comparison
equal
deleted
inserted
replaced
| 38:ee669cb9cccc | 39:93b4dcbafd7b |
|---|---|
| 1 sql = [ | |
| 2 """CREATE TABLE session ( | |
| 3 sid text, | |
| 4 username text, | |
| 5 var_name text, | |
| 6 var_value text, | |
| 7 UNIQUE(sid,var_name) | |
| 8 );""", | |
| 9 """CREATE INDEX session_idx ON session(sid,var_name);""" | |
| 10 ] | |
| 11 | |
| 12 def do_upgrade(env, ver, cursor): | |
| 13 for s in sql: | |
| 14 cursor.execute(s) |