|
1102
by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs |
1 |
/*
|
|
8687.15.9
by Karl Fogel
Add the copyright header block to more files (everything under database/). |
2 |
CREATE SAMPLE PROJECTS AND PRODUCTS
|
3 |
||
4 |
Copyright 2009 Canonical Ltd. This software is licensed under the
|
|
5 |
GNU Affero General Public License version 3 (see the file LICENSE).
|
|
|
1102
by Canonical.com Patch Queue Manager
Lucille had some XXXs which should have been NOTEs |
6 |
*/
|
7 |
INSERT INTO Project (owner, name, displayname, title, shortdesc, |
|
8 |
description, homepageurl) |
|
9 |
VALUES ( |
|
10 |
(SELECT id FROM Person WHERE displayname='Sample Person'), |
|
11 |
'mozilla', 'The Mozilla Project', 'The Mozilla Project', |
|
12 |
'The Mozilla Project is the largest open source web browser collaborative project.', |
|
13 |
'The Mozilla Project is the largest open source web browser '
|
|
14 |
|| 'collaborative project. The Mozilla Project produces several internet ' |
|
15 |
|| 'applications that are very widely used, and is also a center for ' |
|
16 |
|| 'collaboration on internet standards work by open source groups.', |
|
17 |
'http://www.mozilla.org/'
|
|
18 |
);
|
|
19 |
||
20 |
-- Mozilla Firefox
|
|
21 |
INSERT INTO Product (project, owner, name, displayname, title, shortdesc, |
|
22 |
description) |
|
23 |
VALUES ( |
|
24 |
(SELECT id FROM Project WHERE name='mozilla'), |
|
25 |
(SELECT id FROM Person WHERE displayname='Sample Person'), |
|
26 |
'firefox', 'Mozilla Firefox', 'Mozilla Firefox', |
|
27 |
'The Mozilla Firefox web browser', |
|
28 |
'The Mozilla Firefox web browser'
|
|
29 |
);
|
|
30 |
INSERT INTO ProductRelease (product, datereleased, version, owner) |
|
31 |
VALUES ( |
|
32 |
(SELECT id FROM Product WHERE name='firefox'), |
|
33 |
timestamp '2004-06-28 00:00', 'mozilla-firefox-0.9.1', |
|
34 |
(SELECT id FROM Person WHERE displayname='Sample Person') |
|
35 |
);
|
|
36 |
||
37 |
INSERT INTO Project ( owner, name, displayname, title, shortdesc, description, homepageurl ) |
|
38 |
VALUES ((SELECT id FROM Person WHERE displayname='Sample Person'), |
|
39 |
'gnome', 'GNOME', 'The GNOME Project', 'foo', 'bar', 'http://www.gnome.org/' ); |
|
40 |
INSERT INTO Project ( owner, name, displayname, title, shortdesc, description, homepageurl ) |
|
41 |
VALUES ((SELECT id FROM Person WHERE displayname='Sample Person'), |
|
42 |
'iso-codes', 'iso-codes', 'iso-codes', 'foo', 'bar', 'http://www.gnome.org/' ); |
|
43 |
INSERT INTO Product ( project, owner, name, displayname, title, shortdesc, description, homepageurl ) |
|
44 |
VALUES ((SELECT id FROM Project WHERE name='gnome'), |
|
45 |
(SELECT id FROM Person WHERE displayname='Sample Person'), |
|
46 |
'evolution', 'Evolution', 'The Evolution Groupware', 'foo', 'bar', 'http://www.novell.com/' ); |
|
47 |
INSERT INTO Product ( project, owner, name, displayname, title, shortdesc, description, homepageurl ) |
|
48 |
VALUES ((SELECT id FROM Project WHERE name='gnome'), |
|
49 |
(SELECT id FROM Person WHERE displayname='Sample Person'), |
|
50 |
'gnome-terminal', 'GNOME Terminal', 'The GNOME terminal emulator', 'foo', 'bar', 'http://www.gnome.org/' ); |
|
51 |
INSERT INTO Product ( project, owner, name, displayname, title, shortdesc, description, homepageurl ) |
|
52 |
VALUES ((SELECT id FROM Project WHERE name='iso-codes'), |
|
53 |
(SELECT id FROM Person WHERE displayname='Sample Person'), |
|
54 |
'iso-codes', 'iso-codes', 'The iso-codes', 'foo', 'bar', 'http://www.novell.com/' ); |
|
55 |