add ttrss_users.full_name; bump schema

4 files changed, 16 insertions, 2 deletions

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 33c1f3d95..03ea5e610 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -48,6 +48,7 @@ create table ttrss_users (id integer primary key not null auto_increment,
 	access_level integer not null default 0,
 	theme_id integer default null,
 	email varchar(250) not null default '',
+	full_name varchar(250) not null default '',
 	email_digest bool not null default false,
 	last_digest_sent datetime default null,
 	created datetime default null,
@@ -242,7 +243,7 @@ create table ttrss_tags (id integer primary key auto_increment,
 
 create table ttrss_version (schema_version int not null) TYPE=InnoDB DEFAULT CHARSET=UTF8;
 
-insert into ttrss_version values (69);
+insert into ttrss_version values (70);
 
 create table ttrss_enclosures (id integer primary key auto_increment,
 	content_url text not null,
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 69753aa3c..2d1f33c6f 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -45,6 +45,7 @@ create table ttrss_users (id serial not null primary key,
 	last_login timestamp default null,
 	access_level integer not null default 0,
 	email varchar(250) not null default '',
+	full_name varchar(250) not null default '',
 	email_digest boolean not null default false,
 	last_digest_sent timestamp default null,
 	created timestamp default null,
@@ -214,7 +215,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid);
 
 create table ttrss_version (schema_version int not null);
 
-insert into ttrss_version values (69);
+insert into ttrss_version values (70);
 
 create table ttrss_enclosures (id serial not null primary key,
 	content_url text not null,
diff --git a/schema/versions/mysql/70.sql b/schema/versions/mysql/70.sql
new file mode 100644
index 000000000..0c64336d4
--- /dev/null
+++ b/schema/versions/mysql/70.sql
@@ -0,0 +1,6 @@
+alter table ttrss_users add column full_name varchar(250);
+update ttrss_users set full_name = '';
+alter table ttrss_users change full_name full_name varchar(250) not null;
+alter table ttrss_users alter column full_name set default '';
+
+update ttrss_version set schema_version = 70;
diff --git a/schema/versions/pgsql/70.sql b/schema/versions/pgsql/70.sql
new file mode 100644
index 000000000..b970a861c
--- /dev/null
+++ b/schema/versions/pgsql/70.sql
@@ -0,0 +1,6 @@
+alter table ttrss_users add column full_name varchar(250);
+update ttrss_users set full_name = '';
+alter table ttrss_users alter column full_name set not null;
+alter table ttrss_users alter column full_name set default '';
+
+update ttrss_version set schema_version = 70;