     image             TEXT,
     social_links      INT                DEFAULT ( 0 ),
     submitter_image   VARCHAR( 200 ),
+    via               VARCHAR( 16 ),
+    editor_note       TEXT,
+    autoupdate_delay  REAL,
     CONSTRAINT 'release_revisions' UNIQUE ( name, version COLLATE 'NOCASE', t_published, t_changed ) 
 );
 

       SELECT *,
              MAX( t_changed ) AS _order
         FROM release_ordered
        WHERE NOTdeleted
        GROUP BY name,
                 version
        ORDER BY t_published DESC;

--# title: freshcode database schema
--# version: 0.7

CREATE TABLE [release] ( 
    name              VARCHAR( 100 )     NOT NULL,
