/[simile]/sql/mt.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /sql/mt.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 49 by dpavlin, Sat Oct 25 16:39:22 2008 UTC revision 50 by dpavlin, Mon Nov 3 15:33:52 2008 UTC
# Line 2  Line 2 
2  -- Movable Type  -- Movable Type
3    
4  select  select
5          entry_atom_id as id,          coalesce(entry_atom_id,entry_basename) as id,
6          'http://blog.rot13.org/' || date_part('year', entry_authored_on) || '/' || lpad(date_part('month', entry_authored_on)::text,2,'0') || '/' || entry_basename || '.html' as uri,          'http://blog.rot13.org/' || date_part('year', entry_authored_on) || '/' || lpad(date_part('month', entry_authored_on)::text,2,'0') || '/' || entry_basename || '.html' as uri,
7          entry_title as label,          entry_title as label,
8          entry_authored_on as date,          entry_authored_on as date,

Legend:
Removed from v.49  
changed lines
  Added in v.50

  ViewVC Help
Powered by ViewVC 1.1.26