diff options
| author | Andrew Dolgov <[email protected]> | 2007-08-16 13:19:00 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2007-08-16 13:19:00 +0100 |
| commit | 0d276d67b0fff87809ac24dacdc7747aff0a8fd2 (patch) | |
| tree | 0facbca2d2a0343f52a3ff3b32f29261ab4e8ec5 /schema | |
| parent | 766d42aed5a6f51202598dfd9e9995b090609f5a (diff) | |
workaround against mysql refusing to have defaults for text values (closes #137)
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/ttrss_schema_mysql.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 2fd4abb66..f1a001db8 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -59,7 +59,7 @@ create table ttrss_feeds (id integer not null auto_increment primary key, update_interval integer not null default 0, purge_interval integer not null default 0, last_updated datetime default 0, - last_error text not null default '', + last_error varchar(250) not null default '', site_url varchar(250) not null default '', auth_login varchar(250) not null default '', auth_pass varchar(250) not null default '', @@ -213,7 +213,7 @@ create table ttrss_prefs (pref_name varchar(250) not null primary key, type_id integer not null, section_id integer not null default 1, short_desc text not null, - help_text text not null default '', + help_text varchar(300) not null default '', def_value text not null, index(type_id), foreign key (type_id) references ttrss_prefs_types(id), |