Mercurial > genshi > mirror

diff examples/trac/trac/upgrades/db6.py @ 39:93b4dcbafd7b trunk
Copy Trac to main branch.
author: cmlenz
date: Mon, 03 Jul 2006 18:53:27 +0000
new file mode 100644
--- /dev/null
+++ b/examples/trac/trac/upgrades/db6.py
@@ -0,0 +1,12 @@
+sql = """
+CREATE TABLE ticket_custom (
+       ticket               integer,
+       name             text,
+       value            text,
+       UNIQUE(ticket,name)
+);
+"""
+
+def do_upgrade(env, ver, cursor):
+    cursor.execute(sql)
+