user language storage

3 files changed, 5 insertions, 3 deletions

diff --git a/boot.php b/boot.php
index f03487cb3..3dfd06bf1 100644
--- a/boot.php
+++ b/boot.php
@@ -4,7 +4,7 @@ set_time_limit(0);
 
 define ( 'FRIENDIKA_VERSION',      '2.1.936' );
 define ( 'DFRN_PROTOCOL_VERSION',  '2.2'  );
-define ( 'DB_UPDATE_VERSION',      1045   );
+define ( 'DB_UPDATE_VERSION',      1046   );
 
 define ( 'EOL',                    "<br />\r\n"     );
 define ( 'ATOM_TIME',              'Y-m-d\TH:i:s\Z' );
diff --git a/database.sql b/database.sql
index 114f0d3d9..5e5d3eefa 100644
--- a/database.sql
+++ b/database.sql
@@ -366,6 +366,7 @@ CREATE TABLE IF NOT EXISTS `user` (
   `email` char(255) NOT NULL,
   `openid` char(255) NOT NULL,
   `timezone` char(128) NOT NULL,
+  `language` char(32) NOT NULL DEFAULT 'en',
   `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `default-location` char(255) NOT NULL,
diff --git a/update.php b/update.php
index 3672b2bfe..62aea86bb 100644
--- a/update.php
+++ b/update.php
@@ -416,5 +416,6 @@ function update_1044() {
 	q("ALTER TABLE `profile` ADD FULLTEXT ( `prv_keywords` ) ");
 }
 
-
-	
\ No newline at end of file
+function update_1045() {
+	q("ALTER TABLE `user` ADD `language` CHAR( 16 ) NOT NULL DEFAULT 'en' AFTER `timezone` ");
+}