⌈⌋ branch:  freshcode


Check-in [0eec3072b6]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
SHA1 Hash:0eec3072b686b265687a43a330657c1d4bf47015
Date: 2014-11-16 23:15:10
User: mario
Comment:Add 0.7 DB scheme extensions: via, editor_note, autoupdate_delay
Tags And Properties
  • branch=trunk inherited from [82405bb421]
  • sym-trunk inherited from [82405bb421]
Context
2014-11-19
21:53
[7ce2919fde] versioned_urls: Permit version-tuple access ("$version0-$version1-$version2") as well. (user: mario, tags: trunk)
2014-11-16
23:15
[0eec3072b6] Add 0.7 DB scheme extensions: via, editor_note, autoupdate_delay (user: mario, tags: trunk)
2014-11-10
22:51
[82f1793122] New links to Linux Games DB, Gtk-Apps, openDesktop, Portable Linux Games, TuxArena, LinuxSoftNews.WP, and FOSSHUB. (user: mario, tags: trunk)
Changes

Changes to db.sql.

1
2
3
4
5
6
7
8
9
10
11
..
26
27
28
29
30
31
32



33
34
35
36
37
38
39
..
60
61
62
63
64
65
66
67
68
69
70
71
72
#
# 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 ),
................................................................................
    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,
................................................................................
        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;


<
|
|
<







 







>
>
>







 







|






1
2

3
4
5
6
7
8
9
..
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
..
61
62
63
64
65
66
67
68
69
70
71
72
73

--# 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 ),
................................................................................
    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,
................................................................................
        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;