⌈⌋ ⎇ branch:  freshcode


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: 0eec3072b686b265687a43a330657c1d4bf47015
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to db.sql.

1
2
3
4
5
6
7
8
9
10
11
#
# title: freshcode database schema
# version: 0.6
#

CREATE TABLE [release] ( 
    name              VARCHAR( 100 )     NOT NULL,
    title             TEXT               NOT NULL,
    homepage          TEXT,
    description       TEXT               NOT NULL,
    license           VARCHAR( 100 ),
<
|
|
<








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
67
68
69
70
71
72
        ORDER BY t_published DESC,
                  t_changed DESC;

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









|





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;