From fdd2199d01c46416a9befb537d882d83836b6243 Mon Sep 17 00:00:00 2001
From: Guillaume Horel <guillaume.horel@gmail.com>
Date: Tue, 17 Sep 2013 21:44:00 -0400
Subject: Update schema of the database

since sqlite3 doesn't have support for alter besides renaming a table
we use some sed fu to fix the dump
---
 schema.sql | 32 ++++++++++++++++----------------
 1 file changed, 16 insertions(+), 16 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 0ce6e19..edf9a89 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,28 +1,28 @@
 drop table if exists users;
 create table users (
     id integer primary key autoincrement,
-    user_name string not null,
-    password string not null,
+    user_name text not null,
+    password text not null,
     last_seen timestamp default CURRENT_TIMESTAMP,
-    birthday string,
-    nameday string,
+    birthday text,
+    nameday text,
     notify boolean default 1,
-    email string,
-    phone string,
-    address_line1,
-    address_line2,
-    address_city_line,
-    timezone string,
-    kado string
+    email text,
+    phone text,
+    address_line1 text,
+    address_line2 text,
+    address_city_line text,
+    timezone text,
+    kado text
 );
 
 drop table if exists news;
 create table news (
     id integer primary key autoincrement,
-    title string not null,
+    title text not null,
     date timestamp default CURRENT_TIMESTAMP,
-    content string not null,
-    content_cache string not null,
+    content text not null,
+    content_cache text not null,
     user_id integer,
     FOREIGN KEY(user_id) REFERENCES users(id)
 );
@@ -31,8 +31,8 @@ drop table if exists comments;
 create table comments (
     id integer primary key autoincrement,
     date timestamp default CURRENT_TIMESTAMP,
-    content string,
-    content_cache string not null,
+    content text,
+    content_cache text not null,
     user_id integer,
     news_id integer,
     FOREIGN KEY(user_id) REFERENCES users(id),
-- 
cgit v1.2.3-70-g09d2

