Context Navigation

← Previous Change
Next Change →

Changeset 11 for mymrc

Timestamp:

07/02/07 00:00:16 (5 years ago)

Author:

ciro

Message:

updated table structure and added default entries

Location:

mymrc/trunk/mymrc/temp

Files:

: 2 modified

db_creates.sql (modified) (4 diffs)
db_creates.sql.html (modified) (5 diffs)

Legend:

: Unmodified
: Added
: Removed

mymrc/trunk/mymrc/temp/db_creates.sql

r8	r11
7	7	CREATE TABLE artist(
8	8	id integer not null primary key autoincrement,
9		name varchar(100)
	9	name varchar(100) not null
10	10	);
11	11
…	…
13	13	CREATE TABLE album(
14	14	id integer not null primary key autoincrement,
15		artist_id integer not null references artist,
16		title varchar(50)
	15	title varchar(50) not null
17	16	);
18	17
19	18	CREATE TABLE genre(
20		id integer unique, ~~-- 1)~~
21		name varchar(30)
	19	id integer unique,
	20	name varchar(30) not null
22	21	);
23	22
24	23	CREATE TABLE song(
25	24	id integer not null primary key autoincrement,
26		artist_id integer not null references artist,
27		title varchar(100),
28		path varchar(255),
29		album_id integer not null references album~~, -- 2)~~
	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,
30	29	track_no integer,
31		genre_id integer not null references genre~~, -- 3)~~
	30	genre_id integer not null references genre default -1,
32	31	time integer
33	32	);
…	…
35	34	CREATE TABLE playlist(
36	35	id integer not null primary key autoincrement,
37		name varchar(30)
	36	name varchar(30) not null
38	37	);
39	38
40	39	CREATE TABLE playlist_data(
41		id integer not null primary key autoincrement, ~~-- 4)~~
	40	id integer not null primary key autoincrement,
42	41	playlist_id integer not null references playlist,
43	42	song_id integer not null references song
…	…
46	45
47	46	--
48		-- ~~Not~~es
	47	-- fill default values
49	48	--
50		-- 1) Genre doesn't really need the id as a primary key, it's just the
51		-- official ID of the genres
52		--
53		-- 2) album ID COULD actually be null - not every song is actually stored in
54		-- a album structure, or the tag isn't set
55		--
56		-- 3) the same, could be the tag isn't set, so the data IS null, therefore
57		-- maye both shouldn't have the "not null" statement
58		--
59		-- 4) I'm not quite sure if we need a primary key on the playlist assignments
	49	-- Genres, see http://www.linuxselfhelp.com/HOWTO/MP3-HOWTO-13.html#ss13.3
60	50	--
61	51
	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');
62	182
63	183
64

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

r8	r11
1	1	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
2		<html><head><title>~/stud/cn7_ay0607/mobile_programming/myMRC/db_creates.sql.html</title>
3
4
5
	2	<html>
	3	<head>
	4	<title>~/stud/cn7_ay0607/mobile_programming/myMRC/db_creates.sql.html</title>
6	5	<meta name="Generator" content="Vim/7.1">
7		<meta http-equiv="content-type" content="text/html; charset=UTF-8"></head><body bgcolor="#000000" text="#ffffff"><font face="monospace">
	6	<meta http-equiv="content-type" content="text/html; charset=UTF-8">
	7	</head>
	8	<body bgcolor="#000000" text="#ffffff"><font face="monospace">
8	9	<font color="#00ffff"><b>--</b></font><br>
9	10	<font color="#00ffff"><b>--  tables create statements</b></font><br>
…	…
14	15	<font color="#ffff00"><b>CREATE</b></font> <font color="#ff6060"><b>TABLE</b></font> artist(<br>
15	16	id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> primary key autoincrement,<br>
16		name <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>100</b></font>)<br>
	17	name <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>100</b></font>) <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font><br>
17	18	);<br>
18	19	<br>
…	…
20	21	<font color="#ffff00"><b>CREATE</b></font> <font color="#ff6060"><b>TABLE</b></font> album(<br>
21	22	id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> primary key autoincrement,<br>
22		artist_id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> references artist,<br>
23		title <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>50</b></font>)<br>
	23	title <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>50</b></font>) <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font><br>
24	24	);<br>
25	25	<br>
26	26	<font color="#ffff00"><b>CREATE</b></font> <font color="#ff6060"><b>TABLE</b></font> genre(<br>
27		id <font color="#00ff00"><b>integer</b></font> <font color="#ff6060"><b>unique</b></font>, ~~<font color="#00ffff"><b>-- 1)</b></font>~~<br>
28		name <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>30</b></font>)<br>
	27	id <font color="#00ff00"><b>integer</b></font> <font color="#ff6060"><b>unique</b></font>,<br>
	28	name <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>30</b></font>) <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font><br>
29	29	);<br>
30	30	<br>
31	31	<font color="#ffff00"><b>CREATE</b></font> <font color="#ff6060"><b>TABLE</b></font> song(<br>
32	32	id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> primary key autoincrement,<br>
33		artist_id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> references artist,<br>
34		title <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>100</b></font>),<br>
35		path <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>255</b></font>),<br>
36		album_id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> references album~~, <font color="#00ffff"><b>-- 2)</b></font>~~<br>
	33	artist_id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> references artist <font color="#ff6060"><b>default</b></font> <font color="#ff40ff"><b>-1</b></font>,<br>
	34	title <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>100</b></font>) <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font>,<br>
	35	path <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>255</b></font>) <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font>,<br>
	36	album_id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> references album <font color="#ff6060"><b>default</b></font> <font color="#ff40ff"><b>-1</b></font>,<br>
37	37	track_no <font color="#00ff00"><b>integer</b></font>,<br>
38		genre_id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> references genre~~, <font color="#00ffff"><b>-- 3)</b></font>~~<br>
	38	genre_id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> references genre <font color="#ff6060"><b>default</b></font> <font color="#ff40ff"><b>-1</b></font>,<br>
39	39	time <font color="#00ff00"><b>integer</b></font><br>
40	40	);<br>
…	…
42	42	<font color="#ffff00"><b>CREATE</b></font> <font color="#ff6060"><b>TABLE</b></font> playlist(<br>
43	43	id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> primary key autoincrement,<br>
44		name <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>30</b></font>)<br>
	44	name <font color="#00ff00"><b>varchar</b></font>(<font color="#ff40ff"><b>30</b></font>) <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font><br>
45	45	);<br>
46	46	<br>
47	47	<font color="#ffff00"><b>CREATE</b></font> <font color="#ff6060"><b>TABLE</b></font> playlist_data(<br>
48		id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> primary key autoincrement, ~~<font color="#00ffff"><b>-- 4)</b></font>~~<br>
	48	id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> primary key autoincrement,<br>
49	49	playlist_id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> references playlist,<br>
50	50	song_id <font color="#00ff00"><b>integer</b></font> <font color="#ffff00"><b>not</b></font> <font color="#ff6060"><b>null</b></font> references song<br>
…	…
53	53	<br>
54	54	<font color="#00ffff"><b>--</b></font><br>
55		<font color="#00ffff"><b>--~~  Not~~es</b></font><br>
	55	<font color="#00ffff"><b>-- fill default values</b></font><br>
56	56	<font color="#00ffff"><b>--</b></font><br>
57		<font color="#00ffff"><b>--  1) Genre doesn't really need the id as a primary key, it's just the</b></font><br>
58		<font color="#00ffff"><b>--     official ID of the genres</b></font><br>
59		<font color="#00ffff"><b>--</b></font><br>
60		<font color="#00ffff"><b>--  2) album ID COULD actually be null - not every song is actually stored in</b></font><br>
61		<font color="#00ffff"><b>--     a album structure, or the tag isn't set</b></font><br>
62		<font color="#00ffff"><b>--</b></font><br>
63		<font color="#00ffff"><b>--  3) the same, could be the tag isn't set, so the data IS null, therefore</b></font><br>
64		<font color="#00ffff"><b>--     maye both shouldn't have the "not null" statement</b></font><br>
65		<font color="#00ffff"><b>--</b></font><br>
66		<font color="#00ffff"><b>--  4) I'm not quite sure if we need a primary key on the playlist assignments</b></font><br>
	57	<font color="#00ffff"><b>-- Genres, see <a href="http://www.linuxselfhelp.com/HOWTO/MP3-HOWTO-13.html#ss13.3">http://www.linuxselfhelp.com/HOWTO/MP3-HOWTO-13.html#ss13.3</a></b></font><br>
67	58	<font color="#00ffff"><b>--</b></font><br>
68	59	<br>
	60	<font color="#ffff00"><b>INSERT</b></font> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>14</b></font>, <font color="#ff40ff"><b>'R&B'</b></font>);<br>
	79	<font color="#ffff00"><b>INSERT</b></font> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> genre(id, name) <font color="#ff6060"><b>VALUES</b></font>(<font color="#ff40ff"><b>78</b></font>, <font color="#ff40ff"><b>'Rock & Roll'</b></font>);<br>
	143	<font color="#ffff00"><b>INSERT</b></font> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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> <font color="#ff6060"><b>INTO</b></font> 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>
69	190	<br>
70	191	<br>
71		<br>
72		</font>
73		</body></html>
	192	</font></body>
	193	</html>

Context Navigation

Changeset 11 for mymrc

Legend:

mymrc/trunk/mymrc/temp/db_creates.sql

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

Download in other formats: