new file mode 100644
--- /dev/null
+++ b/examples/trac/trac/upgrades/db10.py
@@ -0,0 +1,25 @@
+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.'