summaryrefslogtreecommitdiff
path: root/src/sql/sqlite
diff options
context:
space:
mode:
authorYohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>2010-10-16 15:12:04 +0200
committerYohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>2010-10-17 17:54:02 +0200
commit57aac157c8824b972b5fcb5df894772e2d2389f7 (patch)
treee7d1db433d26a2cd0715f300dd1dfc9560bca245 /src/sql/sqlite
parenta500c675a87bf11e7d5980d208555002149d8ccc (diff)
downloadmanaserv-57aac157c8824b972b5fcb5df894772e2d2389f7.tar.gz
manaserv-57aac157c8824b972b5fcb5df894772e2d2389f7.tar.bz2
manaserv-57aac157c8824b972b5fcb5df894772e2d2389f7.tar.xz
manaserv-57aac157c8824b972b5fcb5df894772e2d2389f7.zip
Changed the mana_accounts.email field length to 64 characters.
Reviewed-by: Crush. Resolves: Mana-mantis #251.
Diffstat (limited to 'src/sql/sqlite')
-rw-r--r--src/sql/sqlite/updates/update_11_to_12.sql10
1 files changed, 10 insertions, 0 deletions
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 00000000..921bcf82
--- /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';