2 files changed, 9 insertions, 0 deletions
diff --git a/kittystore/storm/schema/__init__.py b/kittystore/storm/schema/__init__.py
index eebae1c..d73a49e 100644
--- a/kittystore/storm/schema/__init__.py
+++ b/kittystore/storm/schema/__init__.py
@@ -7,6 +7,7 @@ CREATES = {
         CREATE TABLE "list" (
             name VARCHAR(255) NOT NULL,
             display_name TEXT,
+            description TEXT,
             PRIMARY KEY (name)
         );""", """
         CREATE TABLE "thread" (
@@ -68,6 +69,7 @@ CREATES = {
         CREATE TABLE "list" (
             name VARCHAR(255) NOT NULL,
             display_name TEXT,
+            description TEXT,
             PRIMARY KEY (name)
         );""", """
         CREATE TABLE "thread" (
@@ -129,6 +131,7 @@ CREATES = {
         CREATE TABLE `list` (
             name VARCHAR(255) NOT NULL,
             display_name TEXT,
+            description TEXT,
             PRIMARY KEY (name)
         );""", """
         CREATE TABLE `thread` (
diff --git a/kittystore/storm/schema/patch_6.py b/kittystore/storm/schema/patch_6.py
new file mode 100644
index 0000000..180e731
--- /dev/null
+++ b/kittystore/storm/schema/patch_6.py
@@ -0,0 +1,6 @@
+# -*- coding: utf-8 -*-
+
+def apply(store):
+    """Add the description column"""
+    store.execute('ALTER TABLE "list" ADD COLUMN "description" TEXT;')
+    store.commit()