Mercurial > audlegacy
annotate audacious/library/schema.sqlite @ 1609:fb2ac7c9e096 trunk
[svn] - comment out some gtk_window_set_transient_for() which hide mainwin unexpectedly.
author | yaz |
---|---|
date | Tue, 29 Aug 2006 23:15:43 -0700 |
parents | 3cbe3d14ea68 |
children |
rev | line source |
---|---|
1432 | 1 --- (C) GPL 2006 Audacious Team |
1433
3cbe3d14ea68
[svn] - path to file would probably be essential, huh.
nenolod
parents:
1432
diff
changeset
|
2 --- $Id: schema.sqlite 1780 2006-07-28 05:14:12Z nenolod $ |
1432 | 3 |
4 --- Artists table | |
5 --- Albums (which songs belong to) belong to an Artist. | |
6 CREATE TABLE IF NOT EXISTS `artists` ( | |
7 `id` INT NOT NULL, | |
8 `artist_name` LONGTEXT NOT NULL | |
9 ); | |
10 | |
11 --- Album table | |
12 --- Albums belong to an Artist and contain Songs, as described | |
13 --- by the media table. | |
14 CREATE TABLE IF NOT EXISTS `albums` ( | |
15 `id` INT NOT NULL, | |
16 `artist_id` INT NOT NULL, | |
17 `album_name` LONGTEXT NOT NULL | |
18 ); | |
19 | |
20 --- Media table | |
21 --- Media belongs to both an Artist entry and an Album entry, | |
22 --- but the distinction of Artist::Song is indirect, via | |
23 --- the relation of Artist::Album, Album::Song. | |
24 --- | |
25 --- This theoretically results in a more tidied index being generated by | |
26 --- the SQLite engine. | |
27 CREATE TABLE IF NOT EXISTS `media` ( | |
28 `id` INT NOT NULL, | |
29 `album_id` INT NOT NULL, | |
30 `media_title` LONGTEXT NOT NULL, | |
31 `media_genre` LONGTEXT NOT NULL, | |
32 `media_length` INT NOT NULL, | |
1433
3cbe3d14ea68
[svn] - path to file would probably be essential, huh.
nenolod
parents:
1432
diff
changeset
|
33 `media_year` INT NOT NULL, |
3cbe3d14ea68
[svn] - path to file would probably be essential, huh.
nenolod
parents:
1432
diff
changeset
|
34 `media_filepath` LONGTEXT NOT NULL, |
3cbe3d14ea68
[svn] - path to file would probably be essential, huh.
nenolod
parents:
1432
diff
changeset
|
35 `media_filename` LONGTEXT NOT NULL |
1432 | 36 ); |
37 | |
38 --- Tags table | |
39 --- Associates keywords with media entries, via Media::id. | |
40 CREATE TABLE IF NOT EXISTS `tags` ( | |
41 `id` INT NOT NULL, | |
42 `media_id` INT NOT NULL, | |
43 `media_keyword` LONGTEXT NOT NULL | |
44 ); | |
45 | |
46 --- End of schema. |