create table mp3s ( mp3_id integer primary key, the_music blob, submitting_user_id references users, playing_minutes number, musicians varchar(4000), composers varchar(4000), date_recorded date, -- user IDs separated by spaces -- (these are users who clicked "add to my personal list" personal_list_ids clob, -- user IDs separated by spaces -- (these are all the users who've played a song downloading_user_ids clob, -- ratings, separated by spaces -- each rating is a user ID,integer (between 1 and 10) ratings clob, original_lyrics clob, -- what language are the lyrics in (use codes) original_lyric_lang char(2), -- let users upload translations into other languages lyric_translation1 clob, lyric_translation1_lang clob, lyric_translation2 clob, lyric_translation2_lang clob, lyric_translation3 clob, lyric_translation3_lang clob, -- if this came from a Compact Disc, store disc info -- is this disc on file at cddb.com? If so, record key. cddb_key varchar(200), barcode_on_disc varchar(100), record_label varchar(200), catalog_number varchar(200), total_playing_minutes number );