Changeset 1632 for branches

Show
Ignore:
Timestamp:
11/11/06 00:50:12 (2 years ago)
Author:
spetersen
Message:

Fix for #452

Location:
branches/postgresql
Files:
2 modified

Legend:

Unmodified
Added
Removed

  • branches/postgresql/dbstruct.pgsql.sql

    r1491 r1632  
    1818  mode integer NOT NULL default '1', 
    1919  itemsincache text NULL, 
    20   daterefreshed timestamp default NULL, 
     20  daterefreshed timestamp default now(), 
    2121  refreshinterval integer NOT NULL default '60', 
    2222  etag varchar(255) NULL, 
    … …  
    239239INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.usepermalinks','true','true','boolean','Display a permalink icon and allow linking a given item directly.',NULL); 
    240240INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.markreadonupdate','false','false','boolean','Mark all old unread feeds as read when updating if new unread feeds\n are found.',NULL); 
    241 INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.lang','en,es,fr,dk,it,pt_BR,se,0','en,es,fr,dk,it,pt_BR,se,0','enum','Language pack to use.',NULL); 
    242 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.absoluteordering','true','true','boolean','Allow ordering of channels and folders in the admin section. If false, channels and folders will be organized alphabetically by their titles.',NULL), 
     241INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.lang','en_US,zh_CN,de,da,es,fr,he,it,ja,pt_BR,pt,ru,sv,0','en_US,zh_CN,de,da,es,fr,he,it,ja,pt_BR,pt,ru,sv,0','enum','Language pack to use.'); 
     242INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.deadthreshhold', '24', '24', 'num', 'Sets the threshold for when a feed is marked as dead, in hours', NULL); 
     243INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.search.maxitems', 500, 500, 'num', 'Sets the maximum number of items returned on a search', NULL); 
     244INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.restrictrefresh', 'false','false','boolean','Restrict refresh to command line only (eg php -f update.php). Useful for busy sites with multiple users.',NULL); 
     245INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.absoluteordering','true','true','boolean','Allow ordering of channels and folders in the admin section. If false, channels and folders will be organized alphabetically by their titles.',NULL); 
    243246INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.robotsmeta','index,follow','index,follow','string','How should spiders crawl us?\n (see http://www.robotstxt.org/wc/meta-user.html for more info).',NULL); 
    244247INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.serverpush','true','true','boolean','Use server push on update.php for a more user-friendly experience.\n This is only supported by Mozilla browsers (Netscape, Mozilla, Firefox,...)\n and Opera. These browsers will be autodetected.\n If you\'re not using one of these (you should) you can as well turn this off.',NULL); 
    245248INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.refreshafter','45','45','num','If this option is set the feeds will be refreshed after x minutes of inactivity. Please respect the feed providers by not setting this value to anything lower than thirty minutes. \n\nSet this variable to 0 turn this option off.',NULL); 
    246249INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.input.allowed','a:21:{s:1:\"a\";a:2:{s:4:\"href\";i:1;s:5:\"title\";i:1;}s:1:\"b\";a:0:{}s:10:\"blockquote\";a:0:{}s:2:\"br\";a:0:{}s:4:\"code\";a:0:{}s:3:\"del\";a:0:{}s:2:\"em\";a:0:{}s:1:\"i\";a:0:{}s:3:\"img\";a:2:{s:3:\"src\";i:1;s:3:\"alt\";i:1;}s:3:\"ins\";a:0:{}s:2:\"li\";a:0:{}s:2:\"ol\";a:0:{}s:1:\"p\";a:0:{}s:3:\"pre\";a:0:{}s:3:\"sup\";a:0:{}s:5:\"table\";a:0:{}s:2:\"td\";a:0:{}s:2:\"th\";a:0:{}s:2:\"tr\";a:0:{}s:2:\"tt\";a:0:{}s:2:\"ul\";a:0:{}}','a:21:{s:1:\"a\";a:2:{s:4:\"href\";i:1;s:5:\"title\";i:1;}s:1:\"b\";a:0:{}s:10:\"blockquote\";a:0:{}s:2:\"br\";a:0:{}s:4:\"code\";a:0:{}s:3:\"del\";a:0:{}s:2:\"em\";a:0:{}s:1:\"i\";a:0:{}s:3:\"img\";a:2:{s:3:\"src\";i:1;s:3:\"alt\";i:1;}s:3:\"ins\";a:0:{}s:2:\"li\";a:0:{}s:2:\"ol\";a:0:{}s:1:\"p\";a:0:{}s:3:\"pre\";a:0:{}s:3:\"sup\";a:0:{}s:5:\"table\";a:0:{}s:2:\"td\";a:0:{}s:2:\"th\";a:0:{}s:2:\"tr\";a:0:{}s:2:\"tt\";a:0:{}s:2:\"ul\";a:0:{}}','array','This variable controls input filtering. HTML tags and their attributes, which are not in this list, get filtered out when new RSS items are imported.',NULL); 
    247 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.output.showfeedmeta','false','false','boolean','Display meta-information (like a web- and rss/rdf/xml url) about each feed in the feed side-column.',NULL); 
    248 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.output.frontpage.mixeditems','true','true','boolean','Show read items along with unread items on the front page?',NULL); 
    249 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.output.frontpage.numreaditems', -1 , -1, 'num','If there are no unread items then how many items to show on the front page. Set this to -1 if you want it to be the same as rss.output.frontpage.numitems',NULL); 
    250 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.output.theme','default','default','string','The theme to use. Download more themes from the <a href="http://themes.gregarius.net/">Gregarius Themes Repository</a>.',NULL); 
    251 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.output.cachecontrol','false','false','boolean','If true, Gregarius will negotiate with the browser and check whether it should get a fresh document or not.',NULL); 
    252 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.plugins','a:2:{i:0;s:13:"urlfilter.php";i:1;s:18:"roundedcorners.php";}','a:2:{i:0;s:13:"urlfilter.php";i:1;s:18:"roundedcorners.php";}','array','Plugins are third-party scripts that offer extended functionalities. More plugins can be found at the <a href="http://plugins.gregarius.net/">Plugin Repository</a>',NULL); 
    253 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.input.allowupdates','true','true','boolean','Allow Gregarius to look for updates in existing items.',NULL); 
    254 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.output.titleunreadcnt','false','false','boolean','Display unread count in the document title.',NULL); 
    255 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.tzoffset','0','0','num','Timezone offset, in hours, between your local time and server time. Valid range: "-12" through "12"',NULL); 
    256 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.timezone','0','0','num','Timezone offset, in hours, between your local time and server time. Valid range: "-12" through "12"',NULL); 
    257 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.output.frontpage.numitems','100','100','num','Maximum number of items displayed on the main page. Set this variable to 0 to show no items on the main page.',NULL); 
    258 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.feedgrouping','false','false','boolean','When true, Gregarius groups unread items per feed and sorts the feeds according to the <code>rss.config.absoluteordering</code> configuration switch. When false, unread items are not grouped by feed, but are sorted by date instead.',NULL); 
    259 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.datedesc.unread', 'true','true','boolean','When true, Gregarius displays newer <strong>unread</strong> items first. If false, Gregarius will display older unread items first.',NULL); 
    260 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.datedesc.read', 'true','true','boolean','When true, Gregarius displays newer <strong>read</strong> items first. If false, Gregarius will display older read items first.',NULL); 
    261 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.autologout','false','false','boolean','When true, Gregarius will automatically remove the "admin cookie" when the browser window is closed, effectively logging you out.',NULL); 
    262 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.publictagging', 'false','false','boolean','When true, every visitor to your Gregarius site will be allowed to tag items, when false only the Administrator (you) is allowed to tag.',NULL); 
    263 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.rating', 'true','true','boolean','Enable the item rating system.',NULL); 
    264 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.output.title','Gregarius','Gregarius','string','Sets the title of this feedreader.',NULL); 
    265 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.ajaxparallelsize','3','3','num','Sets the number of feeds to update in parallel. Remember to set rss.config.serverpush to false.',NULL); 
    266 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.ajaxbatchsize','3','3','num','Sets the number of feeds in a batch when using the ajax updater. Remember to set rss.config.serverpush to false.',NULL); 
    267 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.defaultdashboard', '1', '1','boolean','If the first page seen when entering the admin section should be the dashboard',NULL); 
    268 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.output.nav.unread', 'false', 'false','boolean','If the navigation hints on the feeds page should go to the next feed with unread items.  If false, it simply goes to the next feed.',NULL); 
    269 insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.output.channelcollapsedefault', 'false','false','boolean','Collapse the channels on the main page by default',NULL); 
     250INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.showfeedmeta','false','false','boolean','Display meta-information (like a web- and rss/rdf/xml url) about each feed in the feed side-column.',NULL); 
     251INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.frontpage.mixeditems','true','true','boolean','Show read items along with unread items on the front page?',NULL); 
     252INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.frontpage.numreaditems', -1 , -1, 'num','If there are no unread items then how many items to show on the front page. Set this to -1 if you want it to be the same as rss.output.frontpage.numitems',NULL); 
     253INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.theme','default','default','string','The theme to use. Download more themes from the <a href="http://themes.gregarius.net/">Gregarius Themes Repository</a>.',NULL); 
     254INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.cachecontrol','false','false','boolean','If true, Gregarius will negotiate with the browser and check whether it should get a fresh document or not.',NULL); 
     255INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.plugins','a:2:{i:0;s:13:"urlfilter.php";i:1;s:18:"roundedcorners.php";}','a:2:{i:0;s:13:"urlfilter.php";i:1;s:18:"roundedcorners.php";}','array','Plugins are third-party scripts that offer extended functionalities. More plugins can be found at the <a href="http://plugins.gregarius.net/">Plugin Repository</a>',NULL); 
     256INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.input.allowupdates','true','true','boolean','Allow Gregarius to look for updates in existing items.',NULL); 
     257INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.titleunreadcnt','false','false','boolean','Display unread count in the document title.',NULL); 
     258INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.tzoffset','0','0','num','Timezone offset, in hours, between your local time and server time. Valid range: "-12" through "12"',NULL); 
     259INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.timezone','0','0','num','Timezone offset, in hours, between your local time and server time. Valid range: "-12" through "12"',NULL); 
     260INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.frontpage.numitems','100','100','num','Maximum number of items displayed on the main page. Set this variable to 0 to show no items on the main page.',NULL); 
     261INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.feedgrouping','false','false','boolean','When true, Gregarius groups unread items per feed and sorts the feeds according to the <code>rss.config.absoluteordering</code> configuration switch. When false, unread items are not grouped by feed, but are sorted by date instead.',NULL); 
     262INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.datedesc.unread', 'true','true','boolean','When true, Gregarius displays newer <strong>unread</strong> items first. If false, Gregarius will display older unread items first.',NULL); 
     263INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.datedesc.read', 'true','true','boolean','When true, Gregarius displays newer <strong>read</strong> items first. If false, Gregarius will display older read items first.',NULL); 
     264INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.autologout','false','false','boolean','When true, Gregarius will automatically remove the "admin cookie" when the browser window is closed, effectively logging you out.',NULL); 
     265INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.publictagging', 'false','false','boolean','When true, every visitor to your Gregarius site will be allowed to tag items, when false only the Administrator (you) is allowed to tag.',NULL); 
     266INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.rating', 'true','true','boolean','Enable the item rating system.',NULL); 
     267INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.title','Gregarius','Gregarius','string','Sets the title of this feedreader.',NULL); 
     268INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.ajaxparallelsize','3','3','num','Sets the number of feeds to update in parallel. Remember to set rss.config.serverpush to false.',NULL); 
     269INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.ajaxbatchsize','3','3','num','Sets the number of feeds in a batch when using the ajax updater. Remember to set rss.config.serverpush to false.',NULL); 
     270INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.config.defaultdashboard', '1', '1','boolean','If the first page seen when entering the admin section should be the dashboard',NULL); 
     271INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.nav.unread', 'false', 'false','boolean','If the navigation hints on the feeds page should go to the next feed with unread items.  If false, it simply goes to the next feed.',NULL); 
     272INSERT INTO config (key_,value_,default_,type_,desc_,export_) VALUES ('rss.output.channelcollapsedefault', 'false','false','boolean','Collapse the channels on the main page by default',NULL); 
     273 
    270274 
    271275INSERT INTO  dashboard  (title, url, position, obj, daterefreshed, itemcount) VALUES  ('Latest Gregarius News', 'http://devlog.gregarius.net/feed/?db=', '0', '', null, 3); 

  • branches/postgresql/sql_updates/pgsql_svn1586.sql

    r1603 r1632  
    77,desc_='Language pack to use.' 
    88,export_=NULL 
    9 where key_='rss_output.lang'; 
     9where key_='rss.output.lang'; 
    1010 
    1111insert into config (key_,value_,default_,type_,desc_,export_) values ('rss.config.deadthreshhold', '24', '24', 'num', 'Sets the threshold for when a feed is marked as dead, in hours', NULL);