Check-in [0eec3072b6]
Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add 0.7 DB scheme extensions: via, editor_note, autoupdate_delay |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
0eec3072b686b265687a43a330657c1d |
User & Date: | mario 2014-11-16 23:15:10 |
Context
2014-11-19
| ||
21:53 | versioned_urls: Permit version-tuple access ("$version0-$version1-$version2") as well. check-in: 7ce2919fde user: mario tags: trunk | |
2014-11-16
| ||
23:15 | Add 0.7 DB scheme extensions: via, editor_note, autoupdate_delay check-in: 0eec3072b6 user: mario tags: trunk | |
2014-11-10
| ||
22:51 | New links to Linux Games DB, Gtk-Apps, openDesktop, Portable Linux Games, TuxArena, LinuxSoftNews.WP, and FOSSHUB. check-in: 82f1793122 user: mario tags: trunk | |
Changes
Changes to db.sql.
|
| < | | < | 1 2 3 4 5 6 7 8 9 | --# title: freshcode database schema --# version: 0.7 CREATE TABLE [release] ( name VARCHAR( 100 ) NOT NULL, title TEXT NOT NULL, homepage TEXT, description TEXT NOT NULL, license VARCHAR( 100 ), |
︙ | ︙ | |||
26 27 28 29 30 31 32 33 34 35 36 37 38 39 | submitter_openid TEXT, submitter VARCHAR( 0, 100 ), lock TEXT, hidden BOOLEAN DEFAULT ( 0 ), image TEXT, social_links INT DEFAULT ( 0 ), submitter_image VARCHAR( 200 ), CONSTRAINT 'release_revisions' UNIQUE ( name, version COLLATE 'NOCASE', t_published, t_changed ) ); CREATE TABLE flags ( name TEXT, reason TEXT, note TEXT, | > > > | 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | submitter_openid TEXT, submitter VARCHAR( 0, 100 ), lock TEXT, hidden BOOLEAN DEFAULT ( 0 ), 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 ) ); CREATE TABLE flags ( name TEXT, reason TEXT, note TEXT, |
︙ | ︙ | |||
60 61 62 63 64 65 66 | ORDER BY t_published DESC, t_changed DESC; CREATE VIEW release_versions AS SELECT *, MAX( t_changed ) AS _order FROM release_ordered | | | 61 62 63 64 65 66 67 68 69 70 71 72 73 | ORDER BY t_published DESC, t_changed DESC; CREATE VIEW release_versions AS SELECT *, MAX( t_changed ) AS _order FROM release_ordered WHERE NOT deleted GROUP BY name, version ORDER BY t_published DESC; |