Changeset 17 for mymrc

Show
Ignore:
Timestamp:
07/03/07 17:49:10 (5 years ago)
Author:
ciro
Message:

added tables for video support.
therefore created "namespace" by changing pre-existing tables to
audio_<old name>.
note, the samples are only half way updated to support the audio_ prefix

Location:
mymrc/trunk/mymrc/temp
Files:
4 modified

Legend:

Unmodified
Added
Removed

  • mymrc/trunk/mymrc/temp/db_creates.sql

    r11 r17  
    11-- 
    22--  tables create statements 
    3 --  refer to the notes below 
    4 -- 
    5  
    6  
    7 CREATE TABLE artist( 
    8         id integer not null primary key autoincrement, 
    9         name varchar(100) not null 
    10 ); 
    11  
    12  
    13 CREATE TABLE album( 
    14         id integer not null primary key autoincrement, 
    15         title varchar(50) not null 
    16 ); 
    17  
    18 CREATE TABLE genre( 
    19         id integer unique, 
    20         name varchar(30) not null 
    21 ); 
    22  
    23 CREATE TABLE song( 
    24         id integer not null primary key autoincrement, 
    25         artist_id integer not null references artist default -1, 
    26         title varchar(100) not null, 
    27         path varchar(255) not null, 
    28         album_id integer not null references album default -1, 
    29         track_no integer, 
    30         genre_id integer not null references genre default -1, 
    31         time integer 
    32 ); 
    33  
    34 CREATE TABLE playlist( 
    35         id integer not null primary key autoincrement, 
    36         name varchar(30) not null 
    37 ); 
    38  
    39 CREATE TABLE playlist_data( 
    40         id integer not null primary key autoincrement, 
    41         playlist_id integer not null references playlist, 
    42         song_id integer not null references song 
     3-- 
     4 
     5-- 
     6-- audio 
     7--  
     8CREATE TABLE audio_artist( 
     9        id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
     10        name VARCHAR(100) NOT NULL 
     11); 
     12 
     13 
     14CREATE TABLE audio_album( 
     15        id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
     16        title VARCHAR(50) NOT NULL 
     17); 
     18 
     19CREATE TABLE audio_genre( 
     20        id INTEGER UNIQUE, 
     21        name VARCHAR(30) NOT NULL 
     22); 
     23 
     24CREATE TABLE audio_song( 
     25        id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
     26        artist_id INTEGER NOT NULL REFERENCES audio_artist DEFAULT -1, 
     27        title VARCHAR(100) NOT NULL, 
     28        path VARCHAR(255) NOT NULL, 
     29        album_id INTEGER NOT NULL REFERENCES audio_album DEFAULT -1, 
     30        track_no INTEGER, 
     31        genre_id INTEGER NOT NULL REFERENCES audio_genre DEFAULT -1, 
     32        time INTEGER 
     33); 
     34 
     35CREATE TABLE audio_playlist( 
     36        id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
     37        name VARCHAR(30) NOT NULL 
     38); 
     39 
     40CREATE TABLE audio_playlist_data( 
     41        id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
     42        playlist_id INTEGER NOT NULL REFERENCES audio_playlist, 
     43        song_id INTEGER NOT NULL REFERENCES audio_song 
    4344); 
    4445 
    … …  
    5051-- 
    5152 
    52 INSERT INTO artist(id, name) VALUES(-1, 'Unknown'); 
    53 INSERT INTO album(id, title) VALUES(-1, 'Unknown'); 
    54  
    55 INSERT INTO genre(id, name) VALUES(-1, 'Unknown'); 
    56 INSERT INTO genre(id, name) VALUES(0, 'Blues'); 
    57 INSERT INTO genre(id, name) VALUES(1, 'Classic Rock'); 
    58 INSERT INTO genre(id, name) VALUES(2, 'Country'); 
    59 INSERT INTO genre(id, name) VALUES(3, 'Dance'); 
    60 INSERT INTO genre(id, name) VALUES(4, 'Disco'); 
    61 INSERT INTO genre(id, name) VALUES(5, 'Funk'); 
    62 INSERT INTO genre(id, name) VALUES(6, 'Grunge'); 
    63 INSERT INTO genre(id, name) VALUES(7, 'Hip-Hop'); 
    64 INSERT INTO genre(id, name) VALUES(8, 'Jazz'); 
    65 INSERT INTO genre(id, name) VALUES(9, 'Metal'); 
    66 INSERT INTO genre(id, name) VALUES(10, 'New Age'); 
    67 INSERT INTO genre(id, name) VALUES(11, 'Oldies'); 
    68 INSERT INTO genre(id, name) VALUES(12, 'Other'); 
    69 INSERT INTO genre(id, name) VALUES(13, 'Pop'); 
    70 INSERT INTO genre(id, name) VALUES(14, 'R&B'); 
    71 INSERT INTO genre(id, name) VALUES(15, 'Rap'); 
    72 INSERT INTO genre(id, name) VALUES(16, 'Reggae'); 
    73 INSERT INTO genre(id, name) VALUES(17, 'Rock'); 
    74 INSERT INTO genre(id, name) VALUES(18, 'Techno'); 
    75 INSERT INTO genre(id, name) VALUES(19, 'Industrial'); 
    76 INSERT INTO genre(id, name) VALUES(20, 'Alternative'); 
    77 INSERT INTO genre(id, name) VALUES(21, 'Ska'); 
    78 INSERT INTO genre(id, name) VALUES(22, 'Death Metal'); 
    79 INSERT INTO genre(id, name) VALUES(23, 'Pranks'); 
    80 INSERT INTO genre(id, name) VALUES(24, 'Soundtrack'); 
    81 INSERT INTO genre(id, name) VALUES(25, 'Euro-Techno'); 
    82 INSERT INTO genre(id, name) VALUES(26, 'Ambient'); 
    83 INSERT INTO genre(id, name) VALUES(27, 'Trip-Hop'); 
    84 INSERT INTO genre(id, name) VALUES(28, 'Vocal'); 
    85 INSERT INTO genre(id, name) VALUES(29, 'Jazz+Funk'); 
    86 INSERT INTO genre(id, name) VALUES(30, 'Fusion'); 
    87 INSERT INTO genre(id, name) VALUES(31, 'Trance'); 
    88 INSERT INTO genre(id, name) VALUES(32, 'Classical'); 
    89 INSERT INTO genre(id, name) VALUES(33, 'Instrumental'); 
    90 INSERT INTO genre(id, name) VALUES(34, 'Acid'); 
    91 INSERT INTO genre(id, name) VALUES(35, 'House'); 
    92 INSERT INTO genre(id, name) VALUES(36, 'Game'); 
    93 INSERT INTO genre(id, name) VALUES(37, 'Sound Clip'); 
    94 INSERT INTO genre(id, name) VALUES(38, 'Gospel'); 
    95 INSERT INTO genre(id, name) VALUES(39, 'Noise'); 
    96 INSERT INTO genre(id, name) VALUES(40, 'AlternRock'); 
    97 INSERT INTO genre(id, name) VALUES(41, 'Bass'); 
    98 INSERT INTO genre(id, name) VALUES(42, 'Soul'); 
    99 INSERT INTO genre(id, name) VALUES(43, 'Punk'); 
    100 INSERT INTO genre(id, name) VALUES(44, 'Space'); 
    101 INSERT INTO genre(id, name) VALUES(45, 'Meditative'); 
    102 INSERT INTO genre(id, name) VALUES(46, 'Instrumental Pop'); 
    103 INSERT INTO genre(id, name) VALUES(47, 'Instrumental Rock'); 
    104 INSERT INTO genre(id, name) VALUES(48, 'Ethnic'); 
    105 INSERT INTO genre(id, name) VALUES(49, 'Gothic'); 
    106 INSERT INTO genre(id, name) VALUES(50, 'Darkwave'); 
    107 INSERT INTO genre(id, name) VALUES(51, 'Techno-Industrial'); 
    108 INSERT INTO genre(id, name) VALUES(52, 'Electronic'); 
    109 INSERT INTO genre(id, name) VALUES(53, 'Pop-Folk'); 
    110 INSERT INTO genre(id, name) VALUES(54, 'Eurodance'); 
    111 INSERT INTO genre(id, name) VALUES(55, 'Dream'); 
    112 INSERT INTO genre(id, name) VALUES(56, 'Southern Rock'); 
    113 INSERT INTO genre(id, name) VALUES(57, 'Comedy'); 
    114 INSERT INTO genre(id, name) VALUES(58, 'Cult'); 
    115 INSERT INTO genre(id, name) VALUES(59, 'Gangsta'); 
    116 INSERT INTO genre(id, name) VALUES(60, 'Top 40'); 
    117 INSERT INTO genre(id, name) VALUES(61, 'Christian Rap'); 
    118 INSERT INTO genre(id, name) VALUES(62, 'Pop/Funk'); 
    119 INSERT INTO genre(id, name) VALUES(63, 'Jungle'); 
    120 INSERT INTO genre(id, name) VALUES(64, 'Native American'); 
    121 INSERT INTO genre(id, name) VALUES(65, 'Cabaret'); 
    122 INSERT INTO genre(id, name) VALUES(66, 'New Wave'); 
    123 INSERT INTO genre(id, name) VALUES(67, 'Psychadelic'); 
    124 INSERT INTO genre(id, name) VALUES(68, 'Rave'); 
    125 INSERT INTO genre(id, name) VALUES(69, 'Showtunes'); 
    126 INSERT INTO genre(id, name) VALUES(70, 'Trailer'); 
    127 INSERT INTO genre(id, name) VALUES(71, 'Lo-Fi'); 
    128 INSERT INTO genre(id, name) VALUES(72, 'Tribal'); 
    129 INSERT INTO genre(id, name) VALUES(73, 'Acid Punk'); 
    130 INSERT INTO genre(id, name) VALUES(74, 'Acid Jazz'); 
    131 INSERT INTO genre(id, name) VALUES(75, 'Polka'); 
    132 INSERT INTO genre(id, name) VALUES(76, 'Retro'); 
    133 INSERT INTO genre(id, name) VALUES(77, 'Musical'); 
    134 INSERT INTO genre(id, name) VALUES(78, 'Rock & Roll'); 
    135 INSERT INTO genre(id, name) VALUES(79, 'Hard Rock'); 
    136 INSERT INTO genre(id, name) VALUES(80, 'Folk'); 
    137 INSERT INTO genre(id, name) VALUES(81, 'Folk-Rock'); 
    138 INSERT INTO genre(id, name) VALUES(82, 'National Folk'); 
    139 INSERT INTO genre(id, name) VALUES(83, 'Swing'); 
    140 INSERT INTO genre(id, name) VALUES(84, 'Fast Fusion'); 
    141 INSERT INTO genre(id, name) VALUES(85, 'Bebob'); 
    142 INSERT INTO genre(id, name) VALUES(86, 'Latin'); 
    143 INSERT INTO genre(id, name) VALUES(87, 'Revival'); 
    144 INSERT INTO genre(id, name) VALUES(88, 'Celtic'); 
    145 INSERT INTO genre(id, name) VALUES(89, 'Bluegrass'); 
    146 INSERT INTO genre(id, name) VALUES(90, 'Avantgarde'); 
    147 INSERT INTO genre(id, name) VALUES(91, 'Gothic Rock'); 
    148 INSERT INTO genre(id, name) VALUES(92, 'Progressive Rock'); 
    149 INSERT INTO genre(id, name) VALUES(93, 'Psychedelic Rock'); 
    150 INSERT INTO genre(id, name) VALUES(94, 'Symphonic Rock'); 
    151 INSERT INTO genre(id, name) VALUES(95, 'Slow Rock'); 
    152 INSERT INTO genre(id, name) VALUES(96, 'Big Band'); 
    153 INSERT INTO genre(id, name) VALUES(97, 'Chorus'); 
    154 INSERT INTO genre(id, name) VALUES(98, 'Easy Listening'); 
    155 INSERT INTO genre(id, name) VALUES(99, 'Acoustic'); 
    156 INSERT INTO genre(id, name) VALUES(100, 'Humour'); 
    157 INSERT INTO genre(id, name) VALUES(101, 'Speech'); 
    158 INSERT INTO genre(id, name) VALUES(102, 'Chanson'); 
    159 INSERT INTO genre(id, name) VALUES(103, 'Opera'); 
    160 INSERT INTO genre(id, name) VALUES(104, 'Chamber Music'); 
    161 INSERT INTO genre(id, name) VALUES(105, 'Sonata'); 
    162 INSERT INTO genre(id, name) VALUES(106, 'Symphony'); 
    163 INSERT INTO genre(id, name) VALUES(107, 'Booty Bass'); 
    164 INSERT INTO genre(id, name) VALUES(108, 'Primus'); 
    165 INSERT INTO genre(id, name) VALUES(109, 'Porn Groove'); 
    166 INSERT INTO genre(id, name) VALUES(110, 'Satire'); 
    167 INSERT INTO genre(id, name) VALUES(111, 'Slow Jam'); 
    168 INSERT INTO genre(id, name) VALUES(112, 'Club'); 
    169 INSERT INTO genre(id, name) VALUES(113, 'Tango'); 
    170 INSERT INTO genre(id, name) VALUES(114, 'Samba'); 
    171 INSERT INTO genre(id, name) VALUES(115, 'Folklore'); 
    172 INSERT INTO genre(id, name) VALUES(116, 'Ballad'); 
    173 INSERT INTO genre(id, name) VALUES(117, 'Power Ballad'); 
    174 INSERT INTO genre(id, name) VALUES(118, 'Rhythmic Soul'); 
    175 INSERT INTO genre(id, name) VALUES(119, 'Freestyle'); 
    176 INSERT INTO genre(id, name) VALUES(120, 'Duet'); 
    177 INSERT INTO genre(id, name) VALUES(121, 'Punk Rock'); 
    178 INSERT INTO genre(id, name) VALUES(122, 'Drum Solo'); 
    179 INSERT INTO genre(id, name) VALUES(123, 'A capella'); 
    180 INSERT INTO genre(id, name) VALUES(124, 'Euro-House'); 
    181 INSERT INTO genre(id, name) VALUES(125, 'Dance Hall'); 
    182  
    183  
     53INSERT INTO audio_artist(id, name) VALUES(-1, 'Unknown'); 
     54INSERT INTO audio_album(id, title) VALUES(-1, 'Unknown'); 
     55 
     56INSERT INTO audio_genre(id, name) VALUES(-1, 'Unknown'); 
     57INSERT INTO audio_genre(id, name) VALUES(0, 'Blues'); 
     58INSERT INTO audio_genre(id, name) VALUES(1, 'Classic Rock'); 
     59INSERT INTO audio_genre(id, name) VALUES(2, 'Country'); 
     60INSERT INTO audio_genre(id, name) VALUES(3, 'Dance'); 
     61INSERT INTO audio_genre(id, name) VALUES(4, 'Disco'); 
     62INSERT INTO audio_genre(id, name) VALUES(5, 'Funk'); 
     63INSERT INTO audio_genre(id, name) VALUES(6, 'Grunge'); 
     64INSERT INTO audio_genre(id, name) VALUES(7, 'Hip-Hop'); 
     65INSERT INTO audio_genre(id, name) VALUES(8, 'Jazz'); 
     66INSERT INTO audio_genre(id, name) VALUES(9, 'Metal'); 
     67INSERT INTO audio_genre(id, name) VALUES(10, 'New Age'); 
     68INSERT INTO audio_genre(id, name) VALUES(11, 'Oldies'); 
     69INSERT INTO audio_genre(id, name) VALUES(12, 'Other'); 
     70INSERT INTO audio_genre(id, name) VALUES(13, 'Pop'); 
     71INSERT INTO audio_genre(id, name) VALUES(14, 'R&B'); 
     72INSERT INTO audio_genre(id, name) VALUES(15, 'Rap'); 
     73INSERT INTO audio_genre(id, name) VALUES(16, 'Reggae'); 
     74INSERT INTO audio_genre(id, name) VALUES(17, 'Rock'); 
     75INSERT INTO audio_genre(id, name) VALUES(18, 'Techno'); 
     76INSERT INTO audio_genre(id, name) VALUES(19, 'Industrial'); 
     77INSERT INTO audio_genre(id, name) VALUES(20, 'Alternative'); 
     78INSERT INTO audio_genre(id, name) VALUES(21, 'Ska'); 
     79INSERT INTO audio_genre(id, name) VALUES(22, 'Death Metal'); 
     80INSERT INTO audio_genre(id, name) VALUES(23, 'Pranks'); 
     81INSERT INTO audio_genre(id, name) VALUES(24, 'Soundtrack'); 
     82INSERT INTO audio_genre(id, name) VALUES(25, 'Euro-Techno'); 
     83INSERT INTO audio_genre(id, name) VALUES(26, 'Ambient'); 
     84INSERT INTO audio_genre(id, name) VALUES(27, 'Trip-Hop'); 
     85INSERT INTO audio_genre(id, name) VALUES(28, 'Vocal'); 
     86INSERT INTO audio_genre(id, name) VALUES(29, 'Jazz+Funk'); 
     87INSERT INTO audio_genre(id, name) VALUES(30, 'Fusion'); 
     88INSERT INTO audio_genre(id, name) VALUES(31, 'Trance'); 
     89INSERT INTO audio_genre(id, name) VALUES(32, 'Classical'); 
     90INSERT INTO audio_genre(id, name) VALUES(33, 'Instrumental'); 
     91INSERT INTO audio_genre(id, name) VALUES(34, 'Acid'); 
     92INSERT INTO audio_genre(id, name) VALUES(35, 'House'); 
     93INSERT INTO audio_genre(id, name) VALUES(36, 'Game'); 
     94INSERT INTO audio_genre(id, name) VALUES(37, 'Sound Clip'); 
     95INSERT INTO audio_genre(id, name) VALUES(38, 'Gospel'); 
     96INSERT INTO audio_genre(id, name) VALUES(39, 'Noise'); 
     97INSERT INTO audio_genre(id, name) VALUES(40, 'AlternRock'); 
     98INSERT INTO audio_genre(id, name) VALUES(41, 'Bass'); 
     99INSERT INTO audio_genre(id, name) VALUES(42, 'Soul'); 
     100INSERT INTO audio_genre(id, name) VALUES(43, 'Punk'); 
     101INSERT INTO audio_genre(id, name) VALUES(44, 'Space'); 
     102INSERT INTO audio_genre(id, name) VALUES(45, 'Meditative'); 
     103INSERT INTO audio_genre(id, name) VALUES(46, 'Instrumental Pop'); 
     104INSERT INTO audio_genre(id, name) VALUES(47, 'Instrumental Rock'); 
     105INSERT INTO audio_genre(id, name) VALUES(48, 'Ethnic'); 
     106INSERT INTO audio_genre(id, name) VALUES(49, 'Gothic'); 
     107INSERT INTO audio_genre(id, name) VALUES(50, 'Darkwave'); 
     108INSERT INTO audio_genre(id, name) VALUES(51, 'Techno-Industrial'); 
     109INSERT INTO audio_genre(id, name) VALUES(52, 'Electronic'); 
     110INSERT INTO audio_genre(id, name) VALUES(53, 'Pop-Folk'); 
     111INSERT INTO audio_genre(id, name) VALUES(54, 'Eurodance'); 
     112INSERT INTO audio_genre(id, name) VALUES(55, 'Dream'); 
     113INSERT INTO audio_genre(id, name) VALUES(56, 'Southern Rock'); 
     114INSERT INTO audio_genre(id, name) VALUES(57, 'Comedy'); 
     115INSERT INTO audio_genre(id, name) VALUES(58, 'Cult'); 
     116INSERT INTO audio_genre(id, name) VALUES(59, 'Gangsta'); 
     117INSERT INTO audio_genre(id, name) VALUES(60, 'Top 40'); 
     118INSERT INTO audio_genre(id, name) VALUES(61, 'Christian Rap'); 
     119INSERT INTO audio_genre(id, name) VALUES(62, 'Pop/Funk'); 
     120INSERT INTO audio_genre(id, name) VALUES(63, 'Jungle'); 
     121INSERT INTO audio_genre(id, name) VALUES(64, 'Native American'); 
     122INSERT INTO audio_genre(id, name) VALUES(65, 'Cabaret'); 
     123INSERT INTO audio_genre(id, name) VALUES(66, 'New Wave'); 
     124INSERT INTO audio_genre(id, name) VALUES(67, 'Psychadelic'); 
     125INSERT INTO audio_genre(id, name) VALUES(68, 'Rave'); 
     126INSERT INTO audio_genre(id, name) VALUES(69, 'Showtunes'); 
     127INSERT INTO audio_genre(id, name) VALUES(70, 'Trailer'); 
     128INSERT INTO audio_genre(id, name) VALUES(71, 'Lo-Fi'); 
     129INSERT INTO audio_genre(id, name) VALUES(72, 'Tribal'); 
     130INSERT INTO audio_genre(id, name) VALUES(73, 'Acid Punk'); 
     131INSERT INTO audio_genre(id, name) VALUES(74, 'Acid Jazz'); 
     132INSERT INTO audio_genre(id, name) VALUES(75, 'Polka'); 
     133INSERT INTO audio_genre(id, name) VALUES(76, 'Retro'); 
     134INSERT INTO audio_genre(id, name) VALUES(77, 'Musical'); 
     135INSERT INTO audio_genre(id, name) VALUES(78, 'Rock & Roll'); 
     136INSERT INTO audio_genre(id, name) VALUES(79, 'Hard Rock'); 
     137INSERT INTO audio_genre(id, name) VALUES(80, 'Folk'); 
     138INSERT INTO audio_genre(id, name) VALUES(81, 'Folk-Rock'); 
     139INSERT INTO audio_genre(id, name) VALUES(82, 'National Folk'); 
     140INSERT INTO audio_genre(id, name) VALUES(83, 'Swing'); 
     141INSERT INTO audio_genre(id, name) VALUES(84, 'Fast Fusion'); 
     142INSERT INTO audio_genre(id, name) VALUES(85, 'Bebob'); 
     143INSERT INTO audio_genre(id, name) VALUES(86, 'Latin'); 
     144INSERT INTO audio_genre(id, name) VALUES(87, 'Revival'); 
     145INSERT INTO audio_genre(id, name) VALUES(88, 'Celtic'); 
     146INSERT INTO audio_genre(id, name) VALUES(89, 'Bluegrass'); 
     147INSERT INTO audio_genre(id, name) VALUES(90, 'Avantgarde'); 
     148INSERT INTO audio_genre(id, name) VALUES(91, 'Gothic Rock'); 
     149INSERT INTO audio_genre(id, name) VALUES(92, 'Progressive Rock'); 
     150INSERT INTO audio_genre(id, name) VALUES(93, 'Psychedelic Rock'); 
     151INSERT INTO audio_genre(id, name) VALUES(94, 'Symphonic Rock'); 
     152INSERT INTO audio_genre(id, name) VALUES(95, 'Slow Rock'); 
     153INSERT INTO audio_genre(id, name) VALUES(96, 'Big Band'); 
     154INSERT INTO audio_genre(id, name) VALUES(97, 'Chorus'); 
     155INSERT INTO audio_genre(id, name) VALUES(98, 'Easy Listening'); 
     156INSERT INTO audio_genre(id, name) VALUES(99, 'Acoustic'); 
     157INSERT INTO audio_genre(id, name) VALUES(100, 'Humour'); 
     158INSERT INTO audio_genre(id, name) VALUES(101, 'Speech'); 
     159INSERT INTO audio_genre(id, name) VALUES(102, 'Chanson'); 
     160INSERT INTO audio_genre(id, name) VALUES(103, 'Opera'); 
     161INSERT INTO audio_genre(id, name) VALUES(104, 'Chamber Music'); 
     162INSERT INTO audio_genre(id, name) VALUES(105, 'Sonata'); 
     163INSERT INTO audio_genre(id, name) VALUES(106, 'Symphony'); 
     164INSERT INTO audio_genre(id, name) VALUES(107, 'Booty Bass'); 
     165INSERT INTO audio_genre(id, name) VALUES(108, 'Primus'); 
     166INSERT INTO audio_genre(id, name) VALUES(109, 'Porn Groove'); 
     167INSERT INTO audio_genre(id, name) VALUES(110, 'Satire'); 
     168INSERT INTO audio_genre(id, name) VALUES(111, 'Slow Jam'); 
     169INSERT INTO audio_genre(id, name) VALUES(112, 'Club'); 
     170INSERT INTO audio_genre(id, name) VALUES(113, 'Tango'); 
     171INSERT INTO audio_genre(id, name) VALUES(114, 'Samba'); 
     172INSERT INTO audio_genre(id, name) VALUES(115, 'Folklore'); 
     173INSERT INTO audio_genre(id, name) VALUES(116, 'Ballad'); 
     174INSERT INTO audio_genre(id, name) VALUES(117, 'Power Ballad'); 
     175INSERT INTO audio_genre(id, name) VALUES(118, 'Rhythmic Soul'); 
     176INSERT INTO audio_genre(id, name) VALUES(119, 'Freestyle'); 
     177INSERT INTO audio_genre(id, name) VALUES(120, 'Duet'); 
     178INSERT INTO audio_genre(id, name) VALUES(121, 'Punk Rock'); 
     179INSERT INTO audio_genre(id, name) VALUES(122, 'Drum Solo'); 
     180INSERT INTO audio_genre(id, name) VALUES(123, 'A capella'); 
     181INSERT INTO audio_genre(id, name) VALUES(124, 'Euro-House'); 
     182INSERT INTO audio_genre(id, name) VALUES(125, 'Dance Hall'); 
     183 
     184 
     185 
     186 
     187-- 
     188-- video 
     189-- 
     190CREATE TABLE video_movie( 
     191        id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
     192        path VARCHAR(255) NOT NULL; 
     193        title VARCHAR(100) NOT NULL 
     194); 
     195 
     196CREATE TABLE video_playlist( 
     197        id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
     198        name VARCHAR(30) NOT NULL 
     199); 
     200 
     201CREATE TABLE video_playlist_data( 
     202        id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
     203        playlist_id INTEGER NOT NULL REFERENCES video_playlist, 
     204        movie_id INTEGER NOT NULL REFERENCES video_movie 
     205); 
     206 

  • mymrc/trunk/mymrc/temp/db_creates.sql.html

    r11 r17  
    22<html> 
    33<head> 
    4 <title>~/stud/cn7_ay0607/mobile_programming/myMRC/db_creates.sql.html</title> 
     4<title>~/stud/cn7_ay0607/mobile_programming/myMRC/temp/db_creates.sql.html</title> 
    55<meta name="Generator" content="Vim/7.1"> 
    66<meta http-equiv="content-type" content="text/html; charset=UTF-8"> 
    … …  
    99<font color="#00ffff"><b>--</b></font><br> 
    1010<font color="#00ffff"><b>--&nbsp;&nbsp;tables create statements</b></font><br> 
    11 <font color="#00ffff"><b>--&nbsp;&nbsp;refer to the notes below</b></font><br> 
    12 <font color="#00ffff"><b>--</b></font><br> 
    13 <br> 
    14 <br> 
    15 <font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;artist(<br> 
    16 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>&nbsp;primary key autoincrement,<br> 
    17 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>100</b></font>) <font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font><br> 
    18 );<br> 
    19 <br> 
    20 <br> 
    21 <font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;album(<br> 
    22 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>&nbsp;primary key autoincrement,<br> 
    23 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;title <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>50</b></font>) <font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font><br> 
    24 );<br> 
    25 <br> 
    26 <font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;genre(<br> 
    27 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ff6060"><b>unique</b></font>,<br> 
    28 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>30</b></font>) <font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font><br> 
    29 );<br> 
    30 <br> 
    31 <font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;song(<br> 
    32 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>&nbsp;primary key autoincrement,<br> 
    33 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;artist_id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>&nbsp;references artist <font color="#ff6060"><b>default</b></font>&nbsp;<font color="#ff40ff"><b>-1</b></font>,<br> 
    34 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;title <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>100</b></font>) <font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>,<br> 
    35 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;path <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>255</b></font>) <font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>,<br> 
    36 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;album_id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>&nbsp;references album <font color="#ff6060"><b>default</b></font>&nbsp;<font color="#ff40ff"><b>-1</b></font>,<br> 
    37 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;track_no <font color="#00ff00"><b>integer</b></font>,<br> 
    38 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;genre_id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>&nbsp;references genre <font color="#ff6060"><b>default</b></font>&nbsp;<font color="#ff40ff"><b>-1</b></font>,<br> 
    39 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;time <font color="#00ff00"><b>integer</b></font><br> 
    40 );<br> 
    41 <br> 
    42 <font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;playlist(<br> 
    43 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>&nbsp;primary key autoincrement,<br> 
    44 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>30</b></font>) <font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font><br> 
    45 );<br> 
    46 <br> 
    47 <font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;playlist_data(<br> 
    48 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>&nbsp;primary key autoincrement,<br> 
    49 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;playlist_id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>&nbsp;references playlist,<br> 
    50 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;song_id <font color="#00ff00"><b>integer</b></font>&nbsp;<font color="#ffff00"><b>not</b></font>&nbsp;<font color="#ff6060"><b>null</b></font>&nbsp;references song<br> 
     11<font color="#00ffff"><b>--</b></font><br> 
     12<br> 
     13<font color="#00ffff"><b>--</b></font><br> 
     14<font color="#00ffff"><b>-- audio</b></font><br> 
     15<font color="#00ffff"><b>-- </b></font><br> 
     16<font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;audio_artist(<br> 
     17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;PRIMARY KEY AUTOINCREMENT,<br> 
     18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name <font color="#00ff00"><b>VARCHAR</b></font>(<font color="#ff40ff"><b>100</b></font>) <font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font><br> 
     19);<br> 
     20<br> 
     21<br> 
     22<font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;audio_album(<br> 
     23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;PRIMARY KEY AUTOINCREMENT,<br> 
     24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;title <font color="#00ff00"><b>VARCHAR</b></font>(<font color="#ff40ff"><b>50</b></font>) <font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font><br> 
     25);<br> 
     26<br> 
     27<font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;audio_genre(<br> 
     28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ff6060"><b>UNIQUE</b></font>,<br> 
     29&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name <font color="#00ff00"><b>VARCHAR</b></font>(<font color="#ff40ff"><b>30</b></font>) <font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font><br> 
     30);<br> 
     31<br> 
     32<font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;audio_song(<br> 
     33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;PRIMARY KEY AUTOINCREMENT,<br> 
     34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;artist_id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;REFERENCES audio_artist <font color="#ff6060"><b>DEFAULT</b></font>&nbsp;<font color="#ff40ff"><b>-1</b></font>,<br> 
     35&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;title <font color="#00ff00"><b>VARCHAR</b></font>(<font color="#ff40ff"><b>100</b></font>) <font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>,<br> 
     36&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;path <font color="#00ff00"><b>VARCHAR</b></font>(<font color="#ff40ff"><b>255</b></font>) <font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>,<br> 
     37&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;album_id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;REFERENCES audio_album <font color="#ff6060"><b>DEFAULT</b></font>&nbsp;<font color="#ff40ff"><b>-1</b></font>,<br> 
     38&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;track_no <font color="#00ff00"><b>INTEGER</b></font>,<br> 
     39&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;genre_id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;REFERENCES audio_genre <font color="#ff6060"><b>DEFAULT</b></font>&nbsp;<font color="#ff40ff"><b>-1</b></font>,<br> 
     40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;time <font color="#00ff00"><b>INTEGER</b></font><br> 
     41);<br> 
     42<br> 
     43<font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;audio_playlist(<br> 
     44&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;PRIMARY KEY AUTOINCREMENT,<br> 
     45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name <font color="#00ff00"><b>VARCHAR</b></font>(<font color="#ff40ff"><b>30</b></font>) <font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font><br> 
     46);<br> 
     47<br> 
     48<font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;audio_playlist_data(<br> 
     49&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;PRIMARY KEY AUTOINCREMENT,<br> 
     50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;playlist_id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;REFERENCES audio_playlist,<br> 
     51&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;song_id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;REFERENCES audio_song<br> 
    5152);<br> 
    5253<br> 
    … …  
    5859<font color="#00ffff"><b>--</b></font><br> 
    5960<br> 
    60 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;artist(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>-1</b></font>, <font color="#ff40ff"><b>'Unknown'</b></font>);<br> 
    61 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;album(id, title) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>-1</b></font>, <font color="#ff40ff"><b>'Unknown'</b></font>);<br> 
    62 <br> 
    63 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>-1</b></font>, <font color="#ff40ff"><b>'Unknown'</b></font>);<br> 
    64 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>0</b></font>, <font color="#ff40ff"><b>'Blues'</b></font>);<br> 
    65 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>1</b></font>, <font color="#ff40ff"><b>'Classic Rock'</b></font>);<br> 
    66 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>2</b></font>, <font color="#ff40ff"><b>'Country'</b></font>);<br> 
    67 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>3</b></font>, <font color="#ff40ff"><b>'Dance'</b></font>);<br> 
    68 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>4</b></font>, <font color="#ff40ff"><b>'Disco'</b></font>);<br> 
    69 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>5</b></font>, <font color="#ff40ff"><b>'Funk'</b></font>);<br> 
    70 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>6</b></font>, <font color="#ff40ff"><b>'Grunge'</b></font>);<br> 
    71 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>7</b></font>, <font color="#ff40ff"><b>'Hip-Hop'</b></font>);<br> 
    72 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>8</b></font>, <font color="#ff40ff"><b>'Jazz'</b></font>);<br> 
    73 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>9</b></font>, <font color="#ff40ff"><b>'Metal'</b></font>);<br> 
    74 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>10</b></font>, <font color="#ff40ff"><b>'New Age'</b></font>);<br> 
    75 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>11</b></font>, <font color="#ff40ff"><b>'Oldies'</b></font>);<br> 
    76 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>12</b></font>, <font color="#ff40ff"><b>'Other'</b></font>);<br> 
    77 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>13</b></font>, <font color="#ff40ff"><b>'Pop'</b></font>);<br> 
    78 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>14</b></font>, <font color="#ff40ff"><b>'R&amp;B'</b></font>);<br> 
    79 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>15</b></font>, <font color="#ff40ff"><b>'Rap'</b></font>);<br> 
    80 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>16</b></font>, <font color="#ff40ff"><b>'Reggae'</b></font>);<br> 
    81 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>17</b></font>, <font color="#ff40ff"><b>'Rock'</b></font>);<br> 
    82 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>18</b></font>, <font color="#ff40ff"><b>'Techno'</b></font>);<br> 
    83 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>19</b></font>, <font color="#ff40ff"><b>'Industrial'</b></font>);<br> 
    84 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>20</b></font>, <font color="#ff40ff"><b>'Alternative'</b></font>);<br> 
    85 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>21</b></font>, <font color="#ff40ff"><b>'Ska'</b></font>);<br> 
    86 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>22</b></font>, <font color="#ff40ff"><b>'Death Metal'</b></font>);<br> 
    87 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>23</b></font>, <font color="#ff40ff"><b>'Pranks'</b></font>);<br> 
    88 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>24</b></font>, <font color="#ff40ff"><b>'Soundtrack'</b></font>);<br> 
    89 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>25</b></font>, <font color="#ff40ff"><b>'Euro-Techno'</b></font>);<br> 
    90 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>26</b></font>, <font color="#ff40ff"><b>'Ambient'</b></font>);<br> 
    91 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>27</b></font>, <font color="#ff40ff"><b>'Trip-Hop'</b></font>);<br> 
    92 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>28</b></font>, <font color="#ff40ff"><b>'Vocal'</b></font>);<br> 
    93 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>29</b></font>, <font color="#ff40ff"><b>'Jazz+Funk'</b></font>);<br> 
    94 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>30</b></font>, <font color="#ff40ff"><b>'Fusion'</b></font>);<br> 
    95 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>31</b></font>, <font color="#ff40ff"><b>'Trance'</b></font>);<br> 
    96 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>32</b></font>, <font color="#ff40ff"><b>'Classical'</b></font>);<br> 
    97 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>33</b></font>, <font color="#ff40ff"><b>'Instrumental'</b></font>);<br> 
    98 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>34</b></font>, <font color="#ff40ff"><b>'Acid'</b></font>);<br> 
    99 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>35</b></font>, <font color="#ff40ff"><b>'House'</b></font>);<br> 
    100 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>36</b></font>, <font color="#ff40ff"><b>'Game'</b></font>);<br> 
    101 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>37</b></font>, <font color="#ff40ff"><b>'Sound Clip'</b></font>);<br> 
    102 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>38</b></font>, <font color="#ff40ff"><b>'Gospel'</b></font>);<br> 
    103 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>39</b></font>, <font color="#ff40ff"><b>'Noise'</b></font>);<br> 
    104 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>40</b></font>, <font color="#ff40ff"><b>'AlternRock'</b></font>);<br> 
    105 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>41</b></font>, <font color="#ff40ff"><b>'Bass'</b></font>);<br> 
    106 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>42</b></font>, <font color="#ff40ff"><b>'Soul'</b></font>);<br> 
    107 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>43</b></font>, <font color="#ff40ff"><b>'Punk'</b></font>);<br> 
    108 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>44</b></font>, <font color="#ff40ff"><b>'Space'</b></font>);<br> 
    109 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>45</b></font>, <font color="#ff40ff"><b>'Meditative'</b></font>);<br> 
    110 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>46</b></font>, <font color="#ff40ff"><b>'Instrumental Pop'</b></font>);<br> 
    111 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>47</b></font>, <font color="#ff40ff"><b>'Instrumental Rock'</b></font>);<br> 
    112 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>48</b></font>, <font color="#ff40ff"><b>'Ethnic'</b></font>);<br> 
    113 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>49</b></font>, <font color="#ff40ff"><b>'Gothic'</b></font>);<br> 
    114 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>50</b></font>, <font color="#ff40ff"><b>'Darkwave'</b></font>);<br> 
    115 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>51</b></font>, <font color="#ff40ff"><b>'Techno-Industrial'</b></font>);<br> 
    116 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>52</b></font>, <font color="#ff40ff"><b>'Electronic'</b></font>);<br> 
    117 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>53</b></font>, <font color="#ff40ff"><b>'Pop-Folk'</b></font>);<br> 
    118 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>54</b></font>, <font color="#ff40ff"><b>'Eurodance'</b></font>);<br> 
    119 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>55</b></font>, <font color="#ff40ff"><b>'Dream'</b></font>);<br> 
    120 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>56</b></font>, <font color="#ff40ff"><b>'Southern Rock'</b></font>);<br> 
    121 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>57</b></font>, <font color="#ff40ff"><b>'Comedy'</b></font>);<br> 
    122 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>58</b></font>, <font color="#ff40ff"><b>'Cult'</b></font>);<br> 
    123 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>59</b></font>, <font color="#ff40ff"><b>'Gangsta'</b></font>);<br> 
    124 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>60</b></font>, <font color="#ff40ff"><b>'Top 40'</b></font>);<br> 
    125 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>61</b></font>, <font color="#ff40ff"><b>'Christian Rap'</b></font>);<br> 
    126 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>62</b></font>, <font color="#ff40ff"><b>'Pop/Funk'</b></font>);<br> 
    127 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>63</b></font>, <font color="#ff40ff"><b>'Jungle'</b></font>);<br> 
    128 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>64</b></font>, <font color="#ff40ff"><b>'Native American'</b></font>);<br> 
    129 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>65</b></font>, <font color="#ff40ff"><b>'Cabaret'</b></font>);<br> 
    130 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>66</b></font>, <font color="#ff40ff"><b>'New Wave'</b></font>);<br> 
    131 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>67</b></font>, <font color="#ff40ff"><b>'Psychadelic'</b></font>);<br> 
    132 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>68</b></font>, <font color="#ff40ff"><b>'Rave'</b></font>);<br> 
    133 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>69</b></font>, <font color="#ff40ff"><b>'Showtunes'</b></font>);<br> 
    134 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>70</b></font>, <font color="#ff40ff"><b>'Trailer'</b></font>);<br> 
    135 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>71</b></font>, <font color="#ff40ff"><b>'Lo-Fi'</b></font>);<br> 
    136 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>72</b></font>, <font color="#ff40ff"><b>'Tribal'</b></font>);<br> 
    137 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>73</b></font>, <font color="#ff40ff"><b>'Acid Punk'</b></font>);<br> 
    138 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>74</b></font>, <font color="#ff40ff"><b>'Acid Jazz'</b></font>);<br> 
    139 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>75</b></font>, <font color="#ff40ff"><b>'Polka'</b></font>);<br> 
    140 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>76</b></font>, <font color="#ff40ff"><b>'Retro'</b></font>);<br> 
    141 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>77</b></font>, <font color="#ff40ff"><b>'Musical'</b></font>);<br> 
    142 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>78</b></font>, <font color="#ff40ff"><b>'Rock &amp; Roll'</b></font>);<br> 
    143 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>79</b></font>, <font color="#ff40ff"><b>'Hard Rock'</b></font>);<br> 
    144 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>80</b></font>, <font color="#ff40ff"><b>'Folk'</b></font>);<br> 
    145 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>81</b></font>, <font color="#ff40ff"><b>'Folk-Rock'</b></font>);<br> 
    146 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>82</b></font>, <font color="#ff40ff"><b>'National Folk'</b></font>);<br> 
    147 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>83</b></font>, <font color="#ff40ff"><b>'Swing'</b></font>);<br> 
    148 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>84</b></font>, <font color="#ff40ff"><b>'Fast Fusion'</b></font>);<br> 
    149 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>85</b></font>, <font color="#ff40ff"><b>'Bebob'</b></font>);<br> 
    150 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>86</b></font>, <font color="#ff40ff"><b>'Latin'</b></font>);<br> 
    151 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>87</b></font>, <font color="#ff40ff"><b>'Revival'</b></font>);<br> 
    152 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>88</b></font>, <font color="#ff40ff"><b>'Celtic'</b></font>);<br> 
    153 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>89</b></font>, <font color="#ff40ff"><b>'Bluegrass'</b></font>);<br> 
    154 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>90</b></font>, <font color="#ff40ff"><b>'Avantgarde'</b></font>);<br> 
    155 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>91</b></font>, <font color="#ff40ff"><b>'Gothic Rock'</b></font>);<br> 
    156 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>92</b></font>, <font color="#ff40ff"><b>'Progressive Rock'</b></font>);<br> 
    157 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>93</b></font>, <font color="#ff40ff"><b>'Psychedelic Rock'</b></font>);<br> 
    158 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>94</b></font>, <font color="#ff40ff"><b>'Symphonic Rock'</b></font>);<br> 
    159 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>95</b></font>, <font color="#ff40ff"><b>'Slow Rock'</b></font>);<br> 
    160 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>96</b></font>, <font color="#ff40ff"><b>'Big Band'</b></font>);<br> 
    161 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>97</b></font>, <font color="#ff40ff"><b>'Chorus'</b></font>);<br> 
    162 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>98</b></font>, <font color="#ff40ff"><b>'Easy Listening'</b></font>);<br> 
    163 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>99</b></font>, <font color="#ff40ff"><b>'Acoustic'</b></font>);<br> 
    164 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>100</b></font>, <font color="#ff40ff"><b>'Humour'</b></font>);<br> 
    165 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>101</b></font>, <font color="#ff40ff"><b>'Speech'</b></font>);<br> 
    166 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>102</b></font>, <font color="#ff40ff"><b>'Chanson'</b></font>);<br> 
    167 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>103</b></font>, <font color="#ff40ff"><b>'Opera'</b></font>);<br> 
    168 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>104</b></font>, <font color="#ff40ff"><b>'Chamber Music'</b></font>);<br> 
    169 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>105</b></font>, <font color="#ff40ff"><b>'Sonata'</b></font>);<br> 
    170 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>106</b></font>, <font color="#ff40ff"><b>'Symphony'</b></font>);<br> 
    171 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>107</b></font>, <font color="#ff40ff"><b>'Booty Bass'</b></font>);<br> 
    172 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>108</b></font>, <font color="#ff40ff"><b>'Primus'</b></font>);<br> 
    173 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>109</b></font>, <font color="#ff40ff"><b>'Porn Groove'</b></font>);<br> 
    174 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>110</b></font>, <font color="#ff40ff"><b>'Satire'</b></font>);<br> 
    175 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>111</b></font>, <font color="#ff40ff"><b>'Slow Jam'</b></font>);<br> 
    176 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>112</b></font>, <font color="#ff40ff"><b>'Club'</b></font>);<br> 
    177 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>113</b></font>, <font color="#ff40ff"><b>'Tango'</b></font>);<br> 
    178 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>114</b></font>, <font color="#ff40ff"><b>'Samba'</b></font>);<br> 
    179 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>115</b></font>, <font color="#ff40ff"><b>'Folklore'</b></font>);<br> 
    180 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>116</b></font>, <font color="#ff40ff"><b>'Ballad'</b></font>);<br> 
    181 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>117</b></font>, <font color="#ff40ff"><b>'Power Ballad'</b></font>);<br> 
    182 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>118</b></font>, <font color="#ff40ff"><b>'Rhythmic Soul'</b></font>);<br> 
    183 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>119</b></font>, <font color="#ff40ff"><b>'Freestyle'</b></font>);<br> 
    184 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>120</b></font>, <font color="#ff40ff"><b>'Duet'</b></font>);<br> 
    185 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>121</b></font>, <font color="#ff40ff"><b>'Punk Rock'</b></font>);<br> 
    186 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>122</b></font>, <font color="#ff40ff"><b>'Drum Solo'</b></font>);<br> 
    187 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>123</b></font>, <font color="#ff40ff"><b>'A capella'</b></font>);<br> 
    188 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>124</b></font>, <font color="#ff40ff"><b>'Euro-House'</b></font>);<br> 
    189 <font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>125</b></font>, <font color="#ff40ff"><b>'Dance Hall'</b></font>);<br> 
    190 <br> 
     61<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_artist(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>-1</b></font>, <font color="#ff40ff"><b>'Unknown'</b></font>);<br> 
     62<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_album(id, title) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>-1</b></font>, <font color="#ff40ff"><b>'Unknown'</b></font>);<br> 
     63<br> 
     64<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>-1</b></font>, <font color="#ff40ff"><b>'Unknown'</b></font>);<br> 
     65<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>0</b></font>, <font color="#ff40ff"><b>'Blues'</b></font>);<br> 
     66<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>1</b></font>, <font color="#ff40ff"><b>'Classic Rock'</b></font>);<br> 
     67<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>2</b></font>, <font color="#ff40ff"><b>'Country'</b></font>);<br> 
     68<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>3</b></font>, <font color="#ff40ff"><b>'Dance'</b></font>);<br> 
     69<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>4</b></font>, <font color="#ff40ff"><b>'Disco'</b></font>);<br> 
     70<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>5</b></font>, <font color="#ff40ff"><b>'Funk'</b></font>);<br> 
     71<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>6</b></font>, <font color="#ff40ff"><b>'Grunge'</b></font>);<br> 
     72<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>7</b></font>, <font color="#ff40ff"><b>'Hip-Hop'</b></font>);<br> 
     73<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>8</b></font>, <font color="#ff40ff"><b>'Jazz'</b></font>);<br> 
     74<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>9</b></font>, <font color="#ff40ff"><b>'Metal'</b></font>);<br> 
     75<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>10</b></font>, <font color="#ff40ff"><b>'New Age'</b></font>);<br> 
     76<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>11</b></font>, <font color="#ff40ff"><b>'Oldies'</b></font>);<br> 
     77<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>12</b></font>, <font color="#ff40ff"><b>'Other'</b></font>);<br> 
     78<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>13</b></font>, <font color="#ff40ff"><b>'Pop'</b></font>);<br> 
     79<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>14</b></font>, <font color="#ff40ff"><b>'R&amp;B'</b></font>);<br> 
     80<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>15</b></font>, <font color="#ff40ff"><b>'Rap'</b></font>);<br> 
     81<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>16</b></font>, <font color="#ff40ff"><b>'Reggae'</b></font>);<br> 
     82<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>17</b></font>, <font color="#ff40ff"><b>'Rock'</b></font>);<br> 
     83<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>18</b></font>, <font color="#ff40ff"><b>'Techno'</b></font>);<br> 
     84<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>19</b></font>, <font color="#ff40ff"><b>'Industrial'</b></font>);<br> 
     85<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>20</b></font>, <font color="#ff40ff"><b>'Alternative'</b></font>);<br> 
     86<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>21</b></font>, <font color="#ff40ff"><b>'Ska'</b></font>);<br> 
     87<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>22</b></font>, <font color="#ff40ff"><b>'Death Metal'</b></font>);<br> 
     88<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>23</b></font>, <font color="#ff40ff"><b>'Pranks'</b></font>);<br> 
     89<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>24</b></font>, <font color="#ff40ff"><b>'Soundtrack'</b></font>);<br> 
     90<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>25</b></font>, <font color="#ff40ff"><b>'Euro-Techno'</b></font>);<br> 
     91<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>26</b></font>, <font color="#ff40ff"><b>'Ambient'</b></font>);<br> 
     92<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>27</b></font>, <font color="#ff40ff"><b>'Trip-Hop'</b></font>);<br> 
     93<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>28</b></font>, <font color="#ff40ff"><b>'Vocal'</b></font>);<br> 
     94<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>29</b></font>, <font color="#ff40ff"><b>'Jazz+Funk'</b></font>);<br> 
     95<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>30</b></font>, <font color="#ff40ff"><b>'Fusion'</b></font>);<br> 
     96<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>31</b></font>, <font color="#ff40ff"><b>'Trance'</b></font>);<br> 
     97<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>32</b></font>, <font color="#ff40ff"><b>'Classical'</b></font>);<br> 
     98<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>33</b></font>, <font color="#ff40ff"><b>'Instrumental'</b></font>);<br> 
     99<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>34</b></font>, <font color="#ff40ff"><b>'Acid'</b></font>);<br> 
     100<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>35</b></font>, <font color="#ff40ff"><b>'House'</b></font>);<br> 
     101<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>36</b></font>, <font color="#ff40ff"><b>'Game'</b></font>);<br> 
     102<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>37</b></font>, <font color="#ff40ff"><b>'Sound Clip'</b></font>);<br> 
     103<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>38</b></font>, <font color="#ff40ff"><b>'Gospel'</b></font>);<br> 
     104<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>39</b></font>, <font color="#ff40ff"><b>'Noise'</b></font>);<br> 
     105<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>40</b></font>, <font color="#ff40ff"><b>'AlternRock'</b></font>);<br> 
     106<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>41</b></font>, <font color="#ff40ff"><b>'Bass'</b></font>);<br> 
     107<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>42</b></font>, <font color="#ff40ff"><b>'Soul'</b></font>);<br> 
     108<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>43</b></font>, <font color="#ff40ff"><b>'Punk'</b></font>);<br> 
     109<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>44</b></font>, <font color="#ff40ff"><b>'Space'</b></font>);<br> 
     110<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>45</b></font>, <font color="#ff40ff"><b>'Meditative'</b></font>);<br> 
     111<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>46</b></font>, <font color="#ff40ff"><b>'Instrumental Pop'</b></font>);<br> 
     112<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>47</b></font>, <font color="#ff40ff"><b>'Instrumental Rock'</b></font>);<br> 
     113<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>48</b></font>, <font color="#ff40ff"><b>'Ethnic'</b></font>);<br> 
     114<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>49</b></font>, <font color="#ff40ff"><b>'Gothic'</b></font>);<br> 
     115<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>50</b></font>, <font color="#ff40ff"><b>'Darkwave'</b></font>);<br> 
     116<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>51</b></font>, <font color="#ff40ff"><b>'Techno-Industrial'</b></font>);<br> 
     117<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>52</b></font>, <font color="#ff40ff"><b>'Electronic'</b></font>);<br> 
     118<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>53</b></font>, <font color="#ff40ff"><b>'Pop-Folk'</b></font>);<br> 
     119<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>54</b></font>, <font color="#ff40ff"><b>'Eurodance'</b></font>);<br> 
     120<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>55</b></font>, <font color="#ff40ff"><b>'Dream'</b></font>);<br> 
     121<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>56</b></font>, <font color="#ff40ff"><b>'Southern Rock'</b></font>);<br> 
     122<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>57</b></font>, <font color="#ff40ff"><b>'Comedy'</b></font>);<br> 
     123<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>58</b></font>, <font color="#ff40ff"><b>'Cult'</b></font>);<br> 
     124<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>59</b></font>, <font color="#ff40ff"><b>'Gangsta'</b></font>);<br> 
     125<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>60</b></font>, <font color="#ff40ff"><b>'Top 40'</b></font>);<br> 
     126<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>61</b></font>, <font color="#ff40ff"><b>'Christian Rap'</b></font>);<br> 
     127<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>62</b></font>, <font color="#ff40ff"><b>'Pop/Funk'</b></font>);<br> 
     128<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>63</b></font>, <font color="#ff40ff"><b>'Jungle'</b></font>);<br> 
     129<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>64</b></font>, <font color="#ff40ff"><b>'Native American'</b></font>);<br> 
     130<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>65</b></font>, <font color="#ff40ff"><b>'Cabaret'</b></font>);<br> 
     131<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>66</b></font>, <font color="#ff40ff"><b>'New Wave'</b></font>);<br> 
     132<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>67</b></font>, <font color="#ff40ff"><b>'Psychadelic'</b></font>);<br> 
     133<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>68</b></font>, <font color="#ff40ff"><b>'Rave'</b></font>);<br> 
     134<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>69</b></font>, <font color="#ff40ff"><b>'Showtunes'</b></font>);<br> 
     135<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>70</b></font>, <font color="#ff40ff"><b>'Trailer'</b></font>);<br> 
     136<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>71</b></font>, <font color="#ff40ff"><b>'Lo-Fi'</b></font>);<br> 
     137<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>72</b></font>, <font color="#ff40ff"><b>'Tribal'</b></font>);<br> 
     138<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>73</b></font>, <font color="#ff40ff"><b>'Acid Punk'</b></font>);<br> 
     139<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>74</b></font>, <font color="#ff40ff"><b>'Acid Jazz'</b></font>);<br> 
     140<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>75</b></font>, <font color="#ff40ff"><b>'Polka'</b></font>);<br> 
     141<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>76</b></font>, <font color="#ff40ff"><b>'Retro'</b></font>);<br> 
     142<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>77</b></font>, <font color="#ff40ff"><b>'Musical'</b></font>);<br> 
     143<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>78</b></font>, <font color="#ff40ff"><b>'Rock &amp; Roll'</b></font>);<br> 
     144<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>79</b></font>, <font color="#ff40ff"><b>'Hard Rock'</b></font>);<br> 
     145<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>80</b></font>, <font color="#ff40ff"><b>'Folk'</b></font>);<br> 
     146<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>81</b></font>, <font color="#ff40ff"><b>'Folk-Rock'</b></font>);<br> 
     147<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>82</b></font>, <font color="#ff40ff"><b>'National Folk'</b></font>);<br> 
     148<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>83</b></font>, <font color="#ff40ff"><b>'Swing'</b></font>);<br> 
     149<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>84</b></font>, <font color="#ff40ff"><b>'Fast Fusion'</b></font>);<br> 
     150<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>85</b></font>, <font color="#ff40ff"><b>'Bebob'</b></font>);<br> 
     151<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>86</b></font>, <font color="#ff40ff"><b>'Latin'</b></font>);<br> 
     152<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>87</b></font>, <font color="#ff40ff"><b>'Revival'</b></font>);<br> 
     153<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>88</b></font>, <font color="#ff40ff"><b>'Celtic'</b></font>);<br> 
     154<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>89</b></font>, <font color="#ff40ff"><b>'Bluegrass'</b></font>);<br> 
     155<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>90</b></font>, <font color="#ff40ff"><b>'Avantgarde'</b></font>);<br> 
     156<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>91</b></font>, <font color="#ff40ff"><b>'Gothic Rock'</b></font>);<br> 
     157<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>92</b></font>, <font color="#ff40ff"><b>'Progressive Rock'</b></font>);<br> 
     158<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>93</b></font>, <font color="#ff40ff"><b>'Psychedelic Rock'</b></font>);<br> 
     159<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>94</b></font>, <font color="#ff40ff"><b>'Symphonic Rock'</b></font>);<br> 
     160<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>95</b></font>, <font color="#ff40ff"><b>'Slow Rock'</b></font>);<br> 
     161<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>96</b></font>, <font color="#ff40ff"><b>'Big Band'</b></font>);<br> 
     162<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>97</b></font>, <font color="#ff40ff"><b>'Chorus'</b></font>);<br> 
     163<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>98</b></font>, <font color="#ff40ff"><b>'Easy Listening'</b></font>);<br> 
     164<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>99</b></font>, <font color="#ff40ff"><b>'Acoustic'</b></font>);<br> 
     165<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>100</b></font>, <font color="#ff40ff"><b>'Humour'</b></font>);<br> 
     166<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>101</b></font>, <font color="#ff40ff"><b>'Speech'</b></font>);<br> 
     167<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>102</b></font>, <font color="#ff40ff"><b>'Chanson'</b></font>);<br> 
     168<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>103</b></font>, <font color="#ff40ff"><b>'Opera'</b></font>);<br> 
     169<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>104</b></font>, <font color="#ff40ff"><b>'Chamber Music'</b></font>);<br> 
     170<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>105</b></font>, <font color="#ff40ff"><b>'Sonata'</b></font>);<br> 
     171<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>106</b></font>, <font color="#ff40ff"><b>'Symphony'</b></font>);<br> 
     172<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>107</b></font>, <font color="#ff40ff"><b>'Booty Bass'</b></font>);<br> 
     173<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>108</b></font>, <font color="#ff40ff"><b>'Primus'</b></font>);<br> 
     174<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>109</b></font>, <font color="#ff40ff"><b>'Porn Groove'</b></font>);<br> 
     175<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>110</b></font>, <font color="#ff40ff"><b>'Satire'</b></font>);<br> 
     176<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>111</b></font>, <font color="#ff40ff"><b>'Slow Jam'</b></font>);<br> 
     177<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>112</b></font>, <font color="#ff40ff"><b>'Club'</b></font>);<br> 
     178<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>113</b></font>, <font color="#ff40ff"><b>'Tango'</b></font>);<br> 
     179<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>114</b></font>, <font color="#ff40ff"><b>'Samba'</b></font>);<br> 
     180<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>115</b></font>, <font color="#ff40ff"><b>'Folklore'</b></font>);<br> 
     181<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>116</b></font>, <font color="#ff40ff"><b>'Ballad'</b></font>);<br> 
     182<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>117</b></font>, <font color="#ff40ff"><b>'Power Ballad'</b></font>);<br> 
     183<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>118</b></font>, <font color="#ff40ff"><b>'Rhythmic Soul'</b></font>);<br> 
     184<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>119</b></font>, <font color="#ff40ff"><b>'Freestyle'</b></font>);<br> 
     185<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>120</b></font>, <font color="#ff40ff"><b>'Duet'</b></font>);<br> 
     186<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>121</b></font>, <font color="#ff40ff"><b>'Punk Rock'</b></font>);<br> 
     187<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>122</b></font>, <font color="#ff40ff"><b>'Drum Solo'</b></font>);<br> 
     188<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>123</b></font>, <font color="#ff40ff"><b>'A capella'</b></font>);<br> 
     189<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>124</b></font>, <font color="#ff40ff"><b>'Euro-House'</b></font>);<br> 
     190<font color="#ffff00"><b>INSERT</b></font>&nbsp;<font color="#ff6060"><b>INTO</b></font>&nbsp;audio_genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>125</b></font>, <font color="#ff40ff"><b>'Dance Hall'</b></font>);<br> 
     191<br> 
     192<br> 
     193<br> 
     194<br> 
     195<font color="#00ffff"><b>--</b></font><br> 
     196<font color="#00ffff"><b>-- video</b></font><br> 
     197<font color="#00ffff"><b>--</b></font><br> 
     198<font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;video_movie(<br> 
     199&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;PRIMARY KEY AUTOINCREMENT,<br> 
     200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;path <font color="#00ff00"><b>VARCHAR</b></font>(<font color="#ff40ff"><b>255</b></font>) <font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>;<br> 
     201&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;title <font color="#00ff00"><b>VARCHAR</b></font>(<font color="#ff40ff"><b>100</b></font>) <font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font><br> 
     202);<br> 
     203<br> 
     204<font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;video_playlist(<br> 
     205&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;PRIMARY KEY AUTOINCREMENT,<br> 
     206&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name <font color="#00ff00"><b>VARCHAR</b></font>(<font color="#ff40ff"><b>30</b></font>) <font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font><br> 
     207);<br> 
     208<br> 
     209<font color="#ffff00"><b>CREATE</b></font>&nbsp;<font color="#ff6060"><b>TABLE</b></font>&nbsp;video_playlist_data(<br> 
     210&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;PRIMARY KEY AUTOINCREMENT,<br> 
     211&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;playlist_id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;REFERENCES video_playlist,<br> 
     212&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;movie_id <font color="#00ff00"><b>INTEGER</b></font>&nbsp;<font color="#ffff00"><b>NOT</b></font>&nbsp;<font color="#ff6060"><b>NULL</b></font>&nbsp;REFERENCES video_movie<br> 
     213);<br> 
    191214<br> 
    192215</font></body> 

  • mymrc/trunk/mymrc/temp/samples.sql

    r13 r17  
    99-- but well, shouldn't do any harm :) 
    1010-- 
    11 SELECT song.id AS id, 
    12        song.path AS path, 
    13        artist.name AS artist, 
    14        song.title AS title, 
    15        album.title AS album, 
    16        song.track_no AS track, 
    17        genre.name AS genre, 
    18        song.time AS time 
    19 FROM song, artist, album, genre 
    20 WHERE song.artist_id = artist.id AND 
    21       song.album_id = album.id AND 
    22       song.genre_id = genre.id 
    23 ORDER BY artist.name, album.title, song.title; 
     11SELECT audio_song.id AS id, 
     12       audio_song.path AS path, 
     13       audio_artist.name AS artist, 
     14       audio_song.title AS title, 
     15       audio_album.title AS album, 
     16       audio_song.track_no AS track, 
     17       audio_genre.name AS genre, 
     18       audio_song.time AS time 
     19FROM audio_song, 
     20     audio_artist, 
     21     audio_album, 
     22     audio_genre 
     23WHERE audio_song.artist_id = audio_artist.id AND 
     24      audio_song.album_id  = audio_album.id  AND 
     25      audio_song.genre_id  = audio_genre.id 
     26ORDER BY audio_artist.name, 
     27         audio_album.title, 
     28         audio_song.title; 
    2429 
    2530 
    … …  
    4247-- -> "Albums" 
    4348-- 
    44 SELECT DISTINCT title FROM album; -- in case several entries with the same 
    45                                   -- album title exist - still, I'd rather 
    46                                   -- chose the other option, where only one 
    47                                   -- entry (plus UNIQUE) exists. 
    48                                   -- in that case, it's a simple: 
    49 SELECT title FROM album; 
     49SELECT DISTINCT title FROM audio_album; -- in case several entries with the same 
     50                                        -- album title exist - still, I'd rather 
     51                                        -- chose the other option, where only 
     52                                        -- only entry (plus UNIQUE) exists. 
     53                                        -- in that case, it's a simple: 
     54SELECT title FROM audio_album; 
    5055-- same for artist list 
    5156 
    … …  
    5661-- -> "Artist/<list of Albums>" 
    5762-- 
    58 SELECT album.title AS album 
    59 FROM artist, album, song 
    60 WHERE song.album_id = album.id AND 
    61       song.artist_id = artist.id AND 
    62       song.artist_id = (SELECT id FROM artist WHERE name = '<artist name>') 
    63 ORDER BY album.title; 
     63SELECT audio_album.title AS album 
     64FROM audio_artist, 
     65     audio_album, 
     66     audio_song 
     67WHERE audio_song.album_id  = audio_album.id  AND 
     68      audio_song.artist_id = audio_artist.id AND 
     69      audio_song.artist_id = (SELECT id FROM audio_artist WHERE name = '<artist name>') 
     70ORDER BY audio_album.title; 
    6471 
    6572 
    … …  
    7077-- -> "Genres" 
    7178-- 
    72 SELECT genre.name AS genre 
    73 FROM genre 
    74 WHERE id IN (SELECT DISTINCT genre_id FROM song) 
    75 ORDER BY genre.name; 
     79SELECT audio_genre.name AS genre 
     80FROM audio_genre 
     81WHERE id IN (SELECT DISTINCT genre_id FROM audio_song) 
     82ORDER BY audio_genre.name; 
    7683 
    7784 
    … …  
    8188-- -> "Albums/<some album>" and "Artists/<some artist>/<some album>" 
    8289-- 
    83 SELECT song.id AS id, 
    84        song.path AS path, 
    85        artist.name AS artist, 
    86        song.title AS title, 
    87        album.title AS album, 
    88        song.track_no AS track, 
    89        genre.name AS genre, 
    90        song.time AS time 
    91 FROM song, artist, album, genre 
    92 WHERE song.artist_id = artist.id AND 
    93       song.album_id = album.id AND 
    94       song.album_id IN (SELECT id FROM album WHERE title = '<title>') AND 
    95       song.genre_id = genre.id 
    96 ORDER BY artist.name, album.title, song.title; 
     90SELECT audio_song.id AS id, 
     91       audio_song.path AS path, 
     92       audio_artist.name AS artist, 
     93       audio_song.title AS title, 
     94       audio_album.title AS album, 
     95       audio_song.track_no AS track, 
     96       audio_genre.name AS genre, 
     97       audio_song.time AS time 
     98FROM audio_song, 
     99     audio_artist, 
     100     audio_album, 
     101     audio_genre 
     102WHERE audio_song.artist_id = audio_artist.id AND 
     103      audio_song.album_id  = audio_album.id  AND 
     104      audio_song.album_id IN (SELECT id FROM audio_album WHERE title = '<title>') AND 
     105      audio_song.genre_id  = audio_genre.id 
     106ORDER BY audio_artist.name, 
     107         audio_album.title, 
     108         audio_song.title; 
     109 
     110 
     111 
     112------- 
     113-- NOTE: old format, I'm too lazy now to put the audio_ suffix everywhere, 
     114--       there are more important things to do right now. 
     115------- 
     116 
    97117 
    98118 

  • mymrc/trunk/mymrc/temp/samples.sql.html

    r13 r17  
    1717<font color="#00ffff"><b>-- but well, shouldn't do any harm :)</b></font><br> 
    1818<font color="#00ffff"><b>--</b></font><br> 
    19 <font color="#ffff00"><b>SELECT</b></font>&nbsp;song.id <font color="#ff6060"><b>AS</b></font>&nbsp;id,<br> 
    20 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; song.path <font color="#ff6060"><b>AS</b></font>&nbsp;path,<br> 
    21 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; artist.name <font color="#ff6060"><b>AS</b></font>&nbsp;artist,<br> 
    22 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; song.title <font color="#ff6060"><b>AS</b></font>&nbsp;title,<br> 
    23 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; album.title <font color="#ff6060"><b>AS</b></font>&nbsp;album,<br> 
    24 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; song.track_no <font color="#ff6060"><b>AS</b></font>&nbsp;track,<br> 
    25 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; genre.name <font color="#ff6060"><b>AS</b></font>&nbsp;genre,<br> 
    26 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; song.time <font color="#ff6060"><b>AS</b></font>&nbsp;time<br> 
    27 <font color="#ff6060"><b>FROM</b></font>&nbsp;song, artist, album, genre<br> 
    28 <font color="#ff6060"><b>WHERE</b></font>&nbsp;song.artist_id = artist.id <font color="#ffff00"><b>AND</b></font><br> 
    29 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;song.album_id = album.id <font color="#ffff00"><b>AND</b></font><br> 
    30 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;song.genre_id = genre.id<br> 
    31 <font color="#ff6060"><b>ORDER</b></font>&nbsp;<font color="#ff6060"><b>BY</b></font>&nbsp;artist.name, album.title, song.title;<br> 
     19<font color="#ffff00"><b>SELECT</b></font>&nbsp;audio_song.id <font color="#ff6060"><b>AS</b></font>&nbsp;id,<br> 
     20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_song.path <font color="#ff6060"><b>AS</b></font>&nbsp;path,<br> 
     21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_artist.name <font color="#ff6060"><b>AS</b></font>&nbsp;artist,<br> 
     22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_song.title <font color="#ff6060"><b>AS</b></font>&nbsp;title,<br> 
     23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_album.title <font color="#ff6060"><b>AS</b></font>&nbsp;album,<br> 
     24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_song.track_no <font color="#ff6060"><b>AS</b></font>&nbsp;track,<br> 
     25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_genre.name <font color="#ff6060"><b>AS</b></font>&nbsp;genre,<br> 
     26&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_song.time <font color="#ff6060"><b>AS</b></font>&nbsp;time<br> 
     27<font color="#ff6060"><b>FROM</b></font>&nbsp;audio_song,<br> 
     28&nbsp;&nbsp;&nbsp;&nbsp; audio_artist,<br> 
     29&nbsp;&nbsp;&nbsp;&nbsp; audio_album,<br> 
     30&nbsp;&nbsp;&nbsp;&nbsp; audio_genre<br> 
     31<font color="#ff6060"><b>WHERE</b></font>&nbsp;audio_song.artist_id = audio_artist.id <font color="#ffff00"><b>AND</b></font><br> 
     32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;audio_song.album_id&nbsp;&nbsp;= audio_album.id&nbsp;&nbsp;<font color="#ffff00"><b>AND</b></font><br> 
     33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;audio_song.genre_id&nbsp;&nbsp;= audio_genre.id<br> 
     34<font color="#ff6060"><b>ORDER</b></font>&nbsp;<font color="#ff6060"><b>BY</b></font>&nbsp;audio_artist.name,<br> 
     35&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_album.title,<br> 
     36&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_song.title;<br> 
    3237<br> 
    3338<br> 
    … …  
    5055<font color="#00ffff"><b>-- -&gt; &quot;Albums&quot;</b></font><br> 
    5156<font color="#00ffff"><b>--</b></font><br> 
    52 <font color="#ffff00"><b>SELECT</b></font>&nbsp;<font color="#ffff00"><b>DISTINCT</b></font>&nbsp;title <font color="#ff6060"><b>FROM</b></font>&nbsp;album; <font color="#00ffff"><b>-- in case several entries with the same</b></font><br> 
    53 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#00ffff"><b>-- album title exist - still, I'd rather</b></font><br> 
    54 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#00ffff"><b>-- chose the other option, where only one</b></font><br> 
    55 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#00ffff"><b>-- entry (plus UNIQUE) exists.</b></font><br> 
    56 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#00ffff"><b>-- in that case, it's a simple:</b></font><br> 
    57 <font color="#ffff00"><b>SELECT</b></font>&nbsp;title <font color="#ff6060"><b>FROM</b></font>&nbsp;album;<br> 
     57<font color="#ffff00"><b>SELECT</b></font>&nbsp;<font color="#ffff00"><b>DISTINCT</b></font>&nbsp;title <font color="#ff6060"><b>FROM</b></font>&nbsp;audio_album; <font color="#00ffff"><b>-- in case several entries with the same</b></font><br> 
     58&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#00ffff"><b>-- album title exist - still, I'd rather</b></font><br> 
     59&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#00ffff"><b>-- chose the other option, where only</b></font><br> 
     60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#00ffff"><b>-- only entry (plus UNIQUE) exists.</b></font><br> 
     61&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#00ffff"><b>-- in that case, it's a simple:</b></font><br> 
     62<font color="#ffff00"><b>SELECT</b></font>&nbsp;title <font color="#ff6060"><b>FROM</b></font>&nbsp;audio_album;<br> 
    5863<font color="#00ffff"><b>-- same for artist list</b></font><br> 
    5964<br> 
    … …  
    6469<font color="#00ffff"><b>-- -&gt; &quot;Artist/&lt;list of Albums&gt;&quot;</b></font><br> 
    6570<font color="#00ffff"><b>--</b></font><br> 
    66 <font color="#ffff00"><b>SELECT</b></font>&nbsp;album.title <font color="#ff6060"><b>AS</b></font>&nbsp;album<br> 
    67 <font color="#ff6060"><b>FROM</b></font>&nbsp;artist, album, song<br> 
    68 <font color="#ff6060"><b>WHERE</b></font>&nbsp;song.album_id = album.id <font color="#ffff00"><b>AND</b></font><br> 
    69 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;song.artist_id = artist.id <font color="#ffff00"><b>AND</b></font><br> 
    70 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;song.artist_id = (<font color="#ffff00"><b>SELECT</b></font>&nbsp;id <font color="#ff6060"><b>FROM</b></font>&nbsp;artist <font color="#ff6060"><b>WHERE</b></font>&nbsp;name = <font color="#ff40ff"><b>'&lt;artist name&gt;'</b></font>)<br> 
    71 <font color="#ff6060"><b>ORDER</b></font>&nbsp;<font color="#ff6060"><b>BY</b></font>&nbsp;album.title;<br> 
     71<font color="#ffff00"><b>SELECT</b></font>&nbsp;audio_album.title <font color="#ff6060"><b>AS</b></font>&nbsp;album<br> 
     72<font color="#ff6060"><b>FROM</b></font>&nbsp;audio_artist,<br> 
     73&nbsp;&nbsp;&nbsp;&nbsp; audio_album,<br> 
     74&nbsp;&nbsp;&nbsp;&nbsp; audio_song<br> 
     75<font color="#ff6060"><b>WHERE</b></font>&nbsp;audio_song.album_id&nbsp;&nbsp;= audio_album.id&nbsp;&nbsp;<font color="#ffff00"><b>AND</b></font><br> 
     76&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;audio_song.artist_id = audio_artist.id <font color="#ffff00"><b>AND</b></font><br> 
     77&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;audio_song.artist_id = (<font color="#ffff00"><b>SELECT</b></font>&nbsp;id <font color="#ff6060"><b>FROM</b></font>&nbsp;audio_artist <font color="#ff6060"><b>WHERE</b></font>&nbsp;name = <font color="#ff40ff"><b>'&lt;artist name&gt;'</b></font>)<br> 
     78<font color="#ff6060"><b>ORDER</b></font>&nbsp;<font color="#ff6060"><b>BY</b></font>&nbsp;audio_album.title;<br> 
    7279<br> 
    7380<br> 
    … …  
    7885<font color="#00ffff"><b>-- -&gt; &quot;Genres&quot;</b></font><br> 
    7986<font color="#00ffff"><b>--</b></font><br> 
    80 <font color="#ffff00"><b>SELECT</b></font>&nbsp;genre.name <font color="#ff6060"><b>AS</b></font>&nbsp;genre<br> 
    81 <font color="#ff6060"><b>FROM</b></font>&nbsp;genre<br> 
    82 <font color="#ff6060"><b>WHERE</b></font>&nbsp;id <font color="#ffff00"><b>IN</b></font>&nbsp;(<font color="#ffff00"><b>SELECT</b></font>&nbsp;<font color="#ffff00"><b>DISTINCT</b></font>&nbsp;genre_id <font color="#ff6060"><b>FROM</b></font>&nbsp;song)<br> 
    83 <font color="#ff6060"><b>ORDER</b></font>&nbsp;<font color="#ff6060"><b>BY</b></font>&nbsp;genre.name;<br> 
     87<font color="#ffff00"><b>SELECT</b></font>&nbsp;audio_genre.name <font color="#ff6060"><b>AS</b></font>&nbsp;genre<br> 
     88<font color="#ff6060"><b>FROM</b></font>&nbsp;audio_genre<br> 
     89<font color="#ff6060"><b>WHERE</b></font>&nbsp;id <font color="#ffff00"><b>IN</b></font>&nbsp;(<font color="#ffff00"><b>SELECT</b></font>&nbsp;<font color="#ffff00"><b>DISTINCT</b></font>&nbsp;genre_id <font color="#ff6060"><b>FROM</b></font>&nbsp;audio_song)<br> 
     90<font color="#ff6060"><b>ORDER</b></font>&nbsp;<font color="#ff6060"><b>BY</b></font>&nbsp;audio_genre.name;<br> 
    8491<br> 
    8592<br> 
    … …  
    8996<font color="#00ffff"><b>-- -&gt; &quot;Albums/&lt;some album&gt;&quot; and &quot;Artists/&lt;some artist&gt;/&lt;some album&gt;&quot;</b></font><br> 
    9097<font color="#00ffff"><b>--</b></font><br> 
    91 <font color="#ffff00"><b>SELECT</b></font>&nbsp;song.id <font color="#ff6060"><b>AS</b></font>&nbsp;id,<br> 
    92 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; song.path <font color="#ff6060"><b>AS</b></font>&nbsp;path,<br> 
    93 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; artist.name <font color="#ff6060"><b>AS</b></font>&nbsp;artist,<br> 
    94 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; song.title <font color="#ff6060"><b>AS</b></font>&nbsp;title,<br> 
    95 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; album.title <font color="#ff6060"><b>AS</b></font>&nbsp;album,<br> 
    96 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; song.track_no <font color="#ff6060"><b>AS</b></font>&nbsp;track,<br> 
    97 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; genre.name <font color="#ff6060"><b>AS</b></font>&nbsp;genre,<br> 
    98 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; song.time <font color="#ff6060"><b>AS</b></font>&nbsp;time<br> 
    99 <font color="#ff6060"><b>FROM</b></font>&nbsp;song, artist, album, genre<br> 
    100 <font color="#ff6060"><b>WHERE</b></font>&nbsp;song.artist_id = artist.id <font color="#ffff00"><b>AND</b></font><br> 
    101 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;song.album_id = album.id <font color="#ffff00"><b>AND</b></font><br> 
    102 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;song.album_id <font color="#ffff00"><b>IN</b></font>&nbsp;(<font color="#ffff00"><b>SELECT</b></font>&nbsp;id <font color="#ff6060"><b>FROM</b></font>&nbsp;album <font color="#ff6060"><b>WHERE</b></font>&nbsp;title = <font color="#ff40ff"><b>'&lt;title&gt;'</b></font>) <font color="#ffff00"><b>AND</b></font><br> 
    103 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;song.genre_id = genre.id<br> 
    104 <font color="#ff6060"><b>ORDER</b></font>&nbsp;<font color="#ff6060"><b>BY</b></font>&nbsp;artist.name, album.title, song.title;<br> 
     98<font color="#ffff00"><b>SELECT</b></font>&nbsp;audio_song.id <font color="#ff6060"><b>AS</b></font>&nbsp;id,<br> 
     99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_song.path <font color="#ff6060"><b>AS</b></font>&nbsp;path,<br> 
     100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_artist.name <font color="#ff6060"><b>AS</b></font>&nbsp;artist,<br> 
     101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_song.title <font color="#ff6060"><b>AS</b></font>&nbsp;title,<br> 
     102&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_album.title <font color="#ff6060"><b>AS</b></font>&nbsp;album,<br> 
     103&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_song.track_no <font color="#ff6060"><b>AS</b></font>&nbsp;track,<br> 
     104&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_genre.name <font color="#ff6060"><b>AS</b></font>&nbsp;genre,<br> 
     105&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_song.time <font color="#ff6060"><b>AS</b></font>&nbsp;time<br> 
     106<font color="#ff6060"><b>FROM</b></font>&nbsp;audio_song,<br> 
     107&nbsp;&nbsp;&nbsp;&nbsp; audio_artist,<br> 
     108&nbsp;&nbsp;&nbsp;&nbsp; audio_album,<br> 
     109&nbsp;&nbsp;&nbsp;&nbsp; audio_genre<br> 
     110<font color="#ff6060"><b>WHERE</b></font>&nbsp;audio_song.artist_id = audio_artist.id <font color="#ffff00"><b>AND</b></font><br> 
     111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;audio_song.album_id&nbsp;&nbsp;= audio_album.id&nbsp;&nbsp;<font color="#ffff00"><b>AND</b></font><br> 
     112&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;audio_song.album_id <font color="#ffff00"><b>IN</b></font>&nbsp;(<font color="#ffff00"><b>SELECT</b></font>&nbsp;id <font color="#ff6060"><b>FROM</b></font>&nbsp;audio_album <font color="#ff6060"><b>WHERE</b></font>&nbsp;title = <font color="#ff40ff"><b>'&lt;title&gt;'</b></font>) <font color="#ffff00"><b>AND</b></font><br> 
     113&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;audio_song.genre_id&nbsp;&nbsp;= audio_genre.id<br> 
     114<font color="#ff6060"><b>ORDER</b></font>&nbsp;<font color="#ff6060"><b>BY</b></font>&nbsp;audio_artist.name,<br> 
     115&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_album.title,<br> 
     116&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; audio_song.title;<br> 
     117<br> 
     118<br> 
     119<br> 
     120<font color="#00ffff"><b>-------</b></font><br> 
     121<font color="#00ffff"><b>-- </b></font><span style="background-color: #ffff00"><font color="#808080">NOTE</font></span><font color="#00ffff"><b>: old format, I'm too lazy now to put the audio_ suffix everywhere,</b></font><br> 
     122<font color="#00ffff"><b>--&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; there are more important things to do right now.</b></font><br> 
     123<font color="#00ffff"><b>-------</b></font><br> 
     124<br> 
    105125<br> 
    106126<br>