<feed xmlns='http://www.w3.org/2005/Atom'>
<title>FreshRSS (Customized)/app/SQL/install.sql.mysql.php, branch 1.13.1</title>
<subtitle>Customized version of FreshRSS, a self-hosted RSS feed aggregator</subtitle>
<id>https://git.rdnlsmith.com/fresh-rss-custom/atom?h=1.13.1</id>
<link rel='self' href='https://git.rdnlsmith.com/fresh-rss-custom/atom?h=1.13.1'/>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/'/>
<updated>2018-10-25T20:43:13+00:00</updated>
<entry>
<title>MySQL GUID case sensitive (#2078)</title>
<updated>2018-10-25T20:43:13+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2018-10-25T20:43:13+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=307e6995fec51d368beeada9e1b69c40c3e7d065'/>
<id>urn:sha1:307e6995fec51d368beeada9e1b69c40c3e7d065</id>
<content type='text'>
* MySQL GUID case sensitive

latin1_bin
https://github.com/FreshRSS/FreshRSS/issues/2077

* Prepare update for existing bases

* Perform DB update during actualize

* Reduce frequency slightly

* No optimize at the same time

* Take advantage of the SQL modifications in 1.12

* Move higher up

* Move to purge, which all users can manually call
</content>
</entry>
<entry>
<title>Allow dot in username (#2062)</title>
<updated>2018-10-24T11:07:39+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2018-10-24T11:07:39+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=6a686daafa526d4b0a247d6db407edca540e5083'/>
<id>urn:sha1:6a686daafa526d4b0a247d6db407edca540e5083</id>
<content type='text'>
* Allow dot in username

https://github.com/FreshRSS/FreshRSS/issues/2061

* Missing quotes for special chars in PostgreSQL
</content>
</entry>
<entry>
<title>Fix MySQL create table feeds (#2047)</title>
<updated>2018-10-14T11:48:59+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2018-10-14T11:48:59+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=c8b54ae807f583723748b5a8cebf9925fb288f9d'/>
<id>urn:sha1:c8b54ae807f583723748b5a8cebf9925fb288f9d</id>
<content type='text'>
https://github.com/FreshRSS/FreshRSS/issues/2042</content>
</entry>
<entry>
<title>Custom labels (#2027)</title>
<updated>2018-09-29T18:47:17+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2018-09-29T18:47:17+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=8ee8a573f1f7e9cc45f9b3c46627d15670f14f3a'/>
<id>urn:sha1:8ee8a573f1f7e9cc45f9b3c46627d15670f14f3a</id>
<content type='text'>
* First draft of custom tags

https://github.com/FreshRSS/FreshRSS/issues/928
https://github.com/FreshRSS/FreshRSS/issues/1367

* SMALLINT to BIGINT for id_entry

And uppercase SQL types

* Fix layout for unreads

* Start UI menu

* Change menu order

* Clean database helpers

https://github.com/FreshRSS/FreshRSS/pull/2027#discussion_r217971535

* Travis rules do not understand PostgreSQL constants

Grrr

* Tag controller + UI

* Add column attributes to tags

* Use only favicon for now, for label

* Fix styling for different themes

* Constant for maximum InnoDB index length in Unicode

https://github.com/FreshRSS/FreshRSS/pull/2027#discussion_r219052200
(I would have personnally prefered keeping the readability of a real
value instead of a constant, in this case of many SQL fields)

* Use FreshRSS_Factory::createCategoryDao

* Add view of all articles containing any tag

* Fix search in tags

* Mark as read tags

* Partial auto-update unread tags

* More auto update tag unreads

* Add tag deletion

* Do not purge tagged articles

* Minor comment

* Fix SQLite and UI bug

* Google Reader API support for user tags

Add SQL check that tag names must be distinct from category names

* whitespace

* Add missing API for EasyRSS

* Compatibility SQLite

Problematic parentheses

* Add SQL DISTINCT for cases with multiple tags

* Fix for PostgreSQL

PostgreSQL needs some additional type hint to avoid "could not determine
data type of parameter $1"

http://www.postgresql-archive.org/Could-not-determine-data-type-of-parameter-1-tp2171092p2171094.html
</content>
</entry>
<entry>
<title>JSON column for feeds (#1838)</title>
<updated>2018-05-01T15:02:11+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2018-05-01T15:02:11+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=b552abb3327f09baa1c0f4e821dc9f6bd6ef738e'/>
<id>urn:sha1:b552abb3327f09baa1c0f4e821dc9f6bd6ef738e</id>
<content type='text'>
* Draft of JSON column for feeds
https://github.com/FreshRSS/FreshRSS/issues/1654

* Add some per-feed options
  * Feed cURL timeout
  * Mark updated articles as read https://github.com/FreshRSS/FreshRSS/issues/891
  * Mark as read upon reception https://github.com/FreshRSS/FreshRSS/issues/1702
  * Ignore SSL (unsafe) https://github.com/FreshRSS/FreshRSS/issues/1811

* Try PHPCS workaround
While waiting for a better syntax support
</content>
</entry>
<entry>
<title>Add mute strategy configuration (#1750)</title>
<updated>2018-01-01T19:34:06+00:00</updated>
<author>
<name>Alexis Degrugillier</name>
<email>aledeg@users.noreply.github.com</email>
</author>
<published>2018-01-01T19:34:06+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=8c2113f9e6eb86b630a4e861513229d7abf219b8'/>
<id>urn:sha1:8c2113f9e6eb86b630a4e861513229d7abf219b8</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Fix DROP tables for deferred insertion</title>
<updated>2017-04-09T22:43:18+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2017-04-09T22:43:18+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=5d54e47ff4065167a07085df07a590372ac5d636'/>
<id>urn:sha1:5d54e47ff4065167a07085df07a590372ac5d636</id>
<content type='text'>
https://github.com/FreshRSS/FreshRSS/pull/1470
</content>
</entry>
<entry>
<title>SQL index auto added</title>
<updated>2017-03-26T20:08:17+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2017-03-26T20:08:17+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=bc580c5905522143cb3d73a37641f7bf21225545'/>
<id>urn:sha1:bc580c5905522143cb3d73a37641f7bf21225545</id>
<content type='text'>
At the same time as the new temp table
</content>
</entry>
<entry>
<title>More defered insertion. New SQL index</title>
<updated>2017-03-26T12:07:06+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2017-03-26T12:07:06+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=e956aee53d561fbdc11a78a50ad7cc041108e5b5'/>
<id>urn:sha1:e956aee53d561fbdc11a78a50ad7cc041108e5b5</id>
<content type='text'>
New index entry_feed_read_index
TODO: Auto add this index to existing version
</content>
</entry>
<entry>
<title>Defered insertion MySQL bug</title>
<updated>2017-03-26T00:41:08+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2017-03-26T00:41:08+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=a20fd9db9f0ed0e27c65671bb10402ced10587b1'/>
<id>urn:sha1:a20fd9db9f0ed0e27c65671bb10402ced10587b1</id>
<content type='text'>
The update of cached values remains to be optimized
</content>
</entry>
</feed>
