From 57aac157c8824b972b5fcb5df894772e2d2389f7 Mon Sep 17 00:00:00 2001
From: Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>
Date: Sat, 16 Oct 2010 15:12:04 +0200
Subject: Changed the mana_accounts.email field length to 64 characters.

Reviewed-by: Crush.

Resolves: Mana-mantis #251.
---
 src/sql/sqlite/updates/update_11_to_12.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 src/sql/sqlite/updates/update_11_to_12.sql

(limited to 'src/sql/sqlite/updates')

diff --git a/src/sql/sqlite/updates/update_11_to_12.sql b/src/sql/sqlite/updates/update_11_to_12.sql
new file mode 100644
index 0000000..921bcf8
--- /dev/null
+++ b/src/sql/sqlite/updates/update_11_to_12.sql
@@ -0,0 +1,10 @@
+--
+-- SQLite - update 11 to 12 doesn't affect Sqlite,
+-- so we only change the database version number.
+--
+
+-- update the database version, and set date of update
+UPDATE mana_world_states
+   SET value      = '12',
+       moddate    = strftime('%s','now')
+ WHERE state_name = 'database_version';
-- 
cgit