diff options
author | Andrew Dolgov <[email protected]> | 2010-11-08 16:34:49 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2010-11-08 16:34:49 +0300 |
commit | 73fe13afd47d4e8d31ffd5f09fc602415e5f1207 (patch) | |
tree | 64af5a434bd6c5505c82ebe714d4026548d0e899 /schema/versions/mysql | |
parent | ed28d0fd454d5f2c15f492bfa02d3fe9a0e79e0c (diff) |
add ttrss_users.full_name; bump schema
Diffstat (limited to 'schema/versions/mysql')
-rw-r--r-- | schema/versions/mysql/70.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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; |