diff options
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/COPYRIGHT | 16 | ||||
| -rwxr-xr-x | scripts/createdb.mysql | 14 | ||||
| -rwxr-xr-x | scripts/createtables.mysql | 239 | ||||
| -rwxr-xr-x | scripts/genres.txt | 224 | ||||
| -rwxr-xr-x | scripts/languages.txt | 466 | ||||
| -rwxr-xr-x | scripts/make-empty-db | 19 | ||||
| -rwxr-xr-x | scripts/musictypes.txt | 4 | ||||
| -rwxr-xr-x | scripts/sources.txt | 6 |
8 files changed, 988 insertions, 0 deletions
diff --git a/scripts/COPYRIGHT b/scripts/COPYRIGHT new file mode 100644 index 0000000..9b0e8cb --- /dev/null +++ b/scripts/COPYRIGHT @@ -0,0 +1,16 @@ +# the content of languages.txt is taken from the file +# iso_639.tab which contains this copyright: + + +## iso-639.tab +## +## Copyright (C) 2004 Alastair McKinstry <mckinstry@computer.org> +## Released under the GNU License; see file COPYING for details +## +## Last update: 2004-03-29 +## +## This file gives a list of all languages in the ISO-639 +## standard, and is used to provide translations (via gettext) +## +## Status: ISO 639-2:1998 + additions and changes until 2003-03-05 +## Source: http://lcweb.loc.gov/standards/iso639-2/englangn.html diff --git a/scripts/createdb.mysql b/scripts/createdb.mysql new file mode 100755 index 0000000..7ccdc89 --- /dev/null +++ b/scripts/createdb.mysql @@ -0,0 +1,14 @@ +/* Creates DB and opens it to any user */ +/* Run this mysql macro as root! */ + +DROP DATABASE IF EXISTS GiantDisc; +CREATE DATABASE GiantDisc; + +use GiantDisc; + +/* The first line is useful for granting access to user vdr on all computers in a network. */ +/* grant all privileges on GiantDisc.* to vdr@'%'; */ + +/* Grant access to user vdr on the local machine */ +grant all privileges on GiantDisc.* to vdr@localhost; + diff --git a/scripts/createtables.mysql b/scripts/createtables.mysql new file mode 100755 index 0000000..079b3bd --- /dev/null +++ b/scripts/createtables.mysql @@ -0,0 +1,239 @@ +-- MySQL dump 8.21 +-- +-- Host: localhost Database: GiantDisc +--------------------------------------------------------- +-- Server version 3.23.49 + +-- +-- Current Database: GiantDisc +-- + +--CREATE DATABASE /*!32312 IF NOT EXISTS*/ GiantDisc; + +USE GiantDisc; + +-- +-- Table structure for table 'album' +-- + +drop table if exists album; +CREATE TABLE album ( + artist varchar(255) default NULL, + title varchar(255) default NULL, + cddbid varchar(20) NOT NULL default '', + coverimg varchar(255) default NULL, + covertxt mediumtext, + modified date default NULL, + genre varchar(10) default NULL, + PRIMARY KEY (cddbid), + KEY artist (artist(10)), + KEY title (title(10)), + KEY genre (genre), + KEY modified (modified) +) TYPE=MyISAM; + +-- +-- Table structure for table 'genre' +-- + +drop table if exists genre; +CREATE TABLE genre ( + id varchar(10) NOT NULL default '', + id3genre smallint(6) default NULL, + genre varchar(255) default NULL, + freq int(11) default NULL, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'language' +-- + +drop table if exists language; +CREATE TABLE language ( + id varchar(4) NOT NULL default '', + language varchar(40) default NULL, + freq int(11) default NULL, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'musictype' +-- + +drop table if exists musictype; +CREATE TABLE musictype ( + musictype varchar(40) default NULL, + id tinyint(3) unsigned NOT NULL auto_increment, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'player' +-- + +drop table if exists player; +CREATE TABLE player ( + ipaddr varchar(255) NOT NULL default '', + uichannel varchar(255) NOT NULL default '', + logtarget int(11) default NULL, + cdripper varchar(255) default NULL, + mp3encoder varchar(255) default NULL, + cdromdev varchar(255) default NULL, + cdrwdev varchar(255) default NULL, + id int(11) NOT NULL default '0', + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'playerstate' +-- + +drop table if exists playerstate; +CREATE TABLE playerstate ( + playerid int(11) NOT NULL default '0', + playertype int(11) NOT NULL default '0', + snddevice varchar(255) default NULL, + playerapp varchar(255) default NULL, + playerparams varchar(255) default NULL, + ptlogger varchar(255) default NULL, + currtracknb int(11) default NULL, + state varchar(4) default NULL, + shufflepar varchar(255) default NULL, + shufflestat varchar(255) default NULL, + pauseframe int(11) default NULL, + framesplayed int(11) default NULL, + framestotal int(11) default NULL, + anchortime bigint(20) default NULL, + PRIMARY KEY (playerid,playertype) +) TYPE=HEAP; + +-- +-- Table structure for table 'playlist' +-- + +drop table if exists playlist; +CREATE TABLE playlist ( + title varchar(255) default NULL, + author varchar(255) default NULL, + note varchar(255) default NULL, + created timestamp(8) NOT NULL, + id int(10) unsigned NOT NULL auto_increment, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'playlistitem' +-- + +drop table if exists playlistitem; +CREATE TABLE playlistitem ( + playlist int(11) NOT NULL default '0', + tracknumber mediumint(9) NOT NULL default '0', + trackid int(11) default NULL, + PRIMARY KEY (playlist,tracknumber) +) TYPE=MyISAM; + +-- +-- Table structure for table 'playlog' +-- + +drop table if exists playlog; +CREATE TABLE playlog ( + trackid int(11) default NULL, + played date default NULL, + id tinyint(3) unsigned NOT NULL auto_increment, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'recordingitem' +-- + +drop table if exists recordingitem; +CREATE TABLE recordingitem ( + trackid int(11) default NULL, + recdate date default NULL, + rectime time default NULL, + reclength int(11) default NULL, + enddate date default NULL, + endtime time default NULL, + repeat varchar(10) default NULL, + initcmd varchar(255) default NULL, + parameters varchar(255) default NULL, + atqjob int(11) default NULL, + id int(11) NOT NULL default '0', + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'source' +-- + +drop table if exists source; +CREATE TABLE source ( + source varchar(40) default NULL, + id tinyint(3) unsigned NOT NULL auto_increment, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'tracklistitem' +-- + +drop table if exists tracklistitem; +CREATE TABLE tracklistitem ( + playerid int(11) NOT NULL default '0', + listtype smallint(6) NOT NULL default '0', + tracknb int(11) NOT NULL default '0', + trackid int(11) NOT NULL default '0', + PRIMARY KEY (playerid,listtype,tracknb) +) TYPE=MyISAM; + +-- +-- Table structure for table 'tracks' +-- + +drop table if exists tracks; +CREATE TABLE tracks ( + artist varchar(255) default NULL, + title varchar(255) default NULL, + genre1 varchar(10) default NULL, + genre2 varchar(10) default NULL, + year smallint(5) unsigned default NULL, + lang varchar(4) default NULL, + type tinyint(3) unsigned default NULL, + rating tinyint(3) unsigned default NULL, + length smallint(5) unsigned default NULL, + source tinyint(3) unsigned default NULL, + sourceid varchar(20) default NULL, + tracknb tinyint(3) unsigned default NULL, + mp3file varchar(255) default NULL, + condition tinyint(3) unsigned default NULL, + voladjust smallint(6) default '0', + lengthfrm mediumint(9) default '0', + startfrm mediumint(9) default '0', + bpm smallint(6) default '0', + lyrics mediumtext, + bitrate varchar(10) default NULL, + created date default NULL, + modified date default NULL, + backup tinyint(3) unsigned default NULL, + + samplerate int(7) unsigned default NULL, + channels tinyint(3) unsigned default NULL, + + id int(11) NOT NULL auto_increment, + PRIMARY KEY (id), + KEY title (title(10)), + KEY mp3file (mp3file(10)), + KEY genre1 (genre1), + KEY genre2 (genre2), + KEY year (year), + KEY lang (lang), + KEY type (type), + KEY rating (rating), + KEY sourceid (sourceid), + KEY artist (artist(10)) +) TYPE=MyISAM; + diff --git a/scripts/genres.txt b/scripts/genres.txt new file mode 100755 index 0000000..43124e9 --- /dev/null +++ b/scripts/genres.txt @@ -0,0 +1,224 @@ +b 20 Alternative +ba 40 Alternative General +bb \N Art Rock +bc 90 Avant Rock +be \N Experimental +bh 6 Grunge +bi \N Indie +bm 12 Unclassifiable +bn \N Crossover +c \N Books & Spoken +ca \N Short Stories +cb 57 Comedy +cc 77 Musicals/Broadway +cd \N Poetry +ce \N Cabaret / Satire +cf \N Religion +cg 101 Spoken Word +ch \N Stories/Fairytales +ci \N Radio Play +cia \N Literary Radio Play +cib \N Thriller +e 32 Classical +ea 104 Chamber Music +eaa 105 Sonata +eb \N Classical General +ec \N Contemporary +eca \N Contemp. Crossover +ecb \N Electronic Classical +ecc \N Experimental Classical +ecd \N Minimal Music +ed \N Film Music +ee 33 Instrumental +ef \N Period Music +efa \N Baroque +efb \N Medieval +efc \N Renaissance +efd \N Romantic +efda \N 19th Century +eg \N Solo Instruments +ega \N Guitar +egb \N Percussion +egc \N Piano +eh 106 Symphonic +ei 28 Classic Vocal +eia 97 Choral +eib \N Ensembles +eic 103 Opera +ej \N Baroque +f 2 Country +fa \N Alternative Country +fb 89 Bluegrass +fd \N Country Blues +fe \N Country General +fg \N Country and Western +fh 80 Folk +fha \N Irish Folk +fi \N Rockabilly +g 98 Easy Listening +gb \N Lounge +gc \N Love Songs +gca 116 Ballads +gd \N Mood Music +ge 10 New Age +gf \N Soft Rock +gfa \N Acoustic Rock +gg \N Schlager +gh \N Soft Pop +gi 45 Meditative +gj \N Pair Dance +gja \N Walz +gjb \N Tango +h 102 Songs/Chansons +ha \N Singer-Songwriter +hb 65 Children's Music +i 52 Electronic +ia 34 Acid +ib 26 Ambient +ic \N Breakbeat/Breaks +ica \N Breakbeat +icb \N Darkside +icc 63 Jungle +icd \N Ragga +ice 27 Trip Hop +id 3 Dance +ie \N Drum n' Bass +if \N Electronica +ig \N Envir. Soundscapes +ih \N Experimental Elect. +iha \N Minimal Experimental +ihb 39 Noise +ii 37 Game Soundtracks +ij 35 House +ija \N Acid House +ijb \N Funk House +ijc \N Hard House +ijd \N Progressive House +ik 19 Industrial +il 18 Techno +ilb \N Dub +ild \N Goa +ile \N Hardcore Techno +ilf \N Illbient +ilg \N Minimal +ilh 25 Old Skool Techno +ili 68 Rave +ilj 31 Trance +im 44 Space Music +j \N Hip Hop/Rap +ja 7 Hip Hop +jb 15 Rap +jbb 61 Christian Rap +jbd \N Hardcore Rap +jbf 59 Gangsta +k \N Blues/R&B +ka 0 Blues +kaa \N Acoustic Blues +kab \N Blues Rock +kac \N Blues Vocalist +kae \N Electric Blues +kag \N Jazz Blues +kb 38 Gospel +kc \N Improvised +kd 14 R&B +ke 42 Soul +kea \N Sweet Soul +l 8 Jazz +la 73 Acid Jazz +lb 85 Bebop +lc \N Dancefloor Jazz +lf 30 Jazz Fusion +lh \N Jazz Vocals +lj \N Ragtime +lk \N Smooth Jazz +ll 83 Swing +lla 96 Big Band +llb 76 Retro-Swing +lm \N Cool Jazz +ln \N Ethno Jazz +lna \N African Ethno Jazz +lnb \N Arab Ethno Jazz +lnc \N Cuban Jazz +lnd \N Latin Jazz +lne \N Far East Jazz +lo \N Modern Jazz +lp \N New Orleans Brass +m \N Pop & Rock +ma \N Country Rock +mb 5 Funk +mba \N Acid Funk +mc 9 Metal +mcc 22 Death Metal +mcd \N Doom Metal +mcf \N Hard Core Metal +mcg \N Heavy Metal +mck \N Thrash/Speed Metal +md 13 Pop +mda 99 Acoustic +mdb \N Synthesizer Pop +mdd \N Latin Pop +mdg 123 A capella/Pop Vocals +mdh \N Neue Deutsche Welle +mdi \N Disco +mdj \N Dance Pop +mdja \N Twist +mdk \N Doo-Wop +me 43 Punk +mea 121 Hardcore/Punk Rock +meb 71 Lo-Fi/Garage +mec \N Old School Punk +med 21 Ska +mf 17 Rock +mfb \N Acid Rock +mfe 81 Folk Rock +mfg \N Groove Rock +mfh \N Guitar Rock +mfha 1 Classic Rock +mfhb \N Improv Rock +mfhc 47 Instrumental Rock +mfhf \N Surf Rock +mfj 66 New Wave +mfk 67 Psychedelic +mfl 78 Rock & Roll +mfm 94 Symphonic Rock +mg \N Rock En Espanol +n \N World +na 16 Reggae +nb \N Steel Drums +nc \N World Popular +nca \N African Pop +ncb \N Oriental Pop +ncc \N Scandinavian Ethnopop +ncd \N Asian Pop +nce \N Arabian Pop +ncf \N European Ethnopop +ncg \N Latin Pop +nch \N Caribbean Pop +nd 82 World Traditions +nda \N African +ndaa \N Mali Blues +ndb \N Arabic +ndc \N Asian +ndd \N Bossa Nova +nde \N Caribbean +ndf 88 Celtic +ndg 53 European Folk/Pop +ndga \N Jodel +ndh \N France +ndi \N Germany +ndj \N India +ndk \N Ireland +ndl 86 Latin +ndlb \N Flamenco +ndlc \N Mambo +ndld \N Mariachi +ndle \N Meringue +ndlg \N Salsa +ndlh 114 Samba +ndm 64 Native American +ndn \N Quebecois +ndo \N Russian +ndp \N South/Cent. American +ndq \N Spain +ndr 113 Tango + NULL diff --git a/scripts/languages.txt b/scripts/languages.txt new file mode 100755 index 0000000..d623f6c --- /dev/null +++ b/scripts/languages.txt @@ -0,0 +1,466 @@ +aar Afar +abk Abkhazian +ace Achinese +ach Acoli +ada Adangme +ady Adyghe; Adygei +afa Afro-Asiatic (Other) +afh Afrihili +afr Afrikaans +aka Akan +akk Akkadian +alb Albanian +ale Aleut +alg Algonquian languages +amh Amharic +ang English, Old (ca.450-1100) +apa Apache languages +ara Arabic +arc Aramaic +arg Aragonese +arm Armenian +arn Araucanian +arp Arapaho +art Artificial (Other) +arw Arawak +asm Assamese +ast Asturian; Bable +ath Athapascan language +aus Australian languages +ava Avaric +ave Avestan +awa Awadhi +aym Aymara +aze Azerbaijani +bad Banda +bai Bamileke languages +bak Bashkir +bal Baluchi +bam Bambara +ban Balinese +baq Basque +bas Basa +bat Baltic (Other) +bej Beja +bel Belarusian +bem Bemba +ben Bengali +ber Berber (Other) +bho Bhojpuri +bih Bihari +bik Bikol +bin Bini +bis Bislama +bla Siksika +bnt Bantu (Other) +bos Bosnian +bra Braj +bre Breton +btk Batak (Indonesia) +bua Buriat +bug Buginese +bul Bulgarian +bur Burmese +byn Blin; Bilin +cad Caddo +cai Central American Indian (Other) +car Carib +cat Catalan +cau Caucasian (Other) +ceb Cebuano +cel Celtic (Other) +cha Chamorro +chb Chibcha +che Chechen +chg Chagatai +chi Chinese +chk Chukese +chm Mari +chn Chinook jargon +cho Choctaw +chp Chipewyan +chr Cherokee +chu Church Slavic +chv Chuvash +chy Cheyenne +cmc Chamic languages +cop Coptic +cor Cornish +cos Corsican +cpe English-based (Other) +cpf French-based (Other) +cpp Portuguese-based (Other) +cre Cree +crh Crimean Turkish; Crimean Tatar +crp Creoles and pidgins (Other) +csb Kashubian +cus Cushitic (Other) +cus Portuguese-based (Other) +cze Czech +dak Dakota +dan Danish +dar Dargwa +dsb Lower Sorbian +del Delaware +den Slave (Athapascan) +dgr Dogrib +din Dinka +div Divehi +doi Dogri +dra Dravidian (Other) +dua Duala +dum Dutch, Middle (ca. 1050-1350) +dut Dutch +dyu Dyula +dzo Dzongkha +efi Efik +egy Egyptian (Ancient) +eka Ekajuk +elx Elamite +eng English +enm English, Middle (1100-1500) +epo Esperanto +est Estonian +ewe Ewe +ewo Ewondo +fan Fang +fao Faroese +fat Fanti +fij Fijian +fin Finnish +fiu Finno-Ugrian (Other) +fon Fon +fre French +frm French, Middle (ca.1400-1600) +fro French, Old (842-ca.1400) +fry Frisian +ful Fulah +fur Friulian +gaa Ga +gay Gayo +gba Gbaya +gem Germanic (Other) +geo Georgian +ger German +gez Geez +gil Gilbertese +gla Gaelic; Scottish +gle Irish +glg Gallegan +glv Manx +gmh German, Middle High (ca.1050-1500) +goh German, Old High (ca.750-1050) +gon Gondi +gor Gorontalo +got Gothic +grb Grebo +grc Greek, Ancient (to 1453) +gre Greek, Modern (1453-) +grn Guarani +guj Gujarati +gwi Gwichin +hai Haida +hat Haitian; Haitian Creole +hau Hausa +haw Hawaiian +heb Hebrew +her Herero +hil Hiligaynon +him Himachali +hin Hindi +hit Hittite +hmn Hmong +hmo Hiri +hsb Upper Sorbian +hun Hungarian +hup Hupa +iba Iban +ibo Igbo +ice Icelandic +ido Ido +iii Sichuan Yi +ijo Ijo +iku Inuktitut +ile Interlingue +ilo Iloko +ina Interlingua +inc Indic (Other) +ind Indonesian +ine Indo-European (Other) +inh Ingush +ipk Inupiaq +ira Iranian (Other) +iro Iroquoian languages +ita Italian +jav Javanese +jbo Lojban +jpn Japanese +jpr Judeo-Persian +jrb Judeo-Arabic +kaa Kara-Kalpak +kab Kabyle +kac Kachin +kal Greenlandic (Kalaallisut) +kam Kamba +kan Kannada +kar Karen +kas Kashmiri +kau Kanuri +kaw Kawi +kaz Kazakh +kbd Kabardian +kha Khazi +khi Khoisan (Other) +khm Khmer +kho Khotanese +kik Kikuyu +kin Kinyarwanda +kir Kirghiz +kmb Kimbundu +kok Konkani +kom Komi +kon Kongo +kor Korean +kos Kosraean +kpe Kpelle +krc Karachay-Balkar +kro Kru +kru Kurukh +kua Kuanyama +kum Kumyk +kur Kurdish +kut Kutenai +lad Ladino +lah Lahnda +lam Lamba +lao Lao +lat Latin +lav Latvian +lez Lezghian +lim Limburgian +lin Lingala +lit Lithuanian +lol Mongo +loz Lozi +ltz Luxembourgish +lua Luba-Lulua +lub Luba-Katanga +lug Ganda +lui Luiseno +lun Lunda +luo Luo (Kenya and Tanzania) +lus Lushai +mac Macedonian +mad Madurese +mag Magahi +mah Marshallese +mai Maithili +mak Makasar +mal Malayalam +man Mandingo +mao Maori +map Austronesian (Other) +mar Marathi +mas Masai +mal Malay +mdf Moksha +mdr Mandar +men Mende +mga Irish, Middle (900-1200) +mic Micmac +min Minangkabau +mis Miscellaneous languages +mkh Mon-Khmer (Other) +mlg Malagasy +mlt Maltese +mnc Manchu +mno Manobo languages +moh Mohawk +mol Moldavian +mon Mongolian +mos Mossi +mul Multiple languages +mun Munda languages +mus Creek +mwr Marwari +myn Mayan languages +myv Erzya +nah Nahuatl +nai North American Indian (Other) +nap Neapolitan +nau Nauru +nav Navaho +nbl Ndebele, South +nde Ndebele, North +ndo Ndonga +nds German, Low +nep Nepali +new Newari +nia Nias +nic Niger-Kordofanian (Other) +niu Niuean +nno Norwegian Nynorsk +nob Bøkmal, Norwegian +nog Nogai +non Norse, Old +nor Norwegian +nso Sotho, Northern +nub Nubian languages +nwc Classical Newari; Old Newari +nya Chewa; Chichewa; Nyanja +nym Nyankole +nyo Nyoro +nzi Nzima +oci Occitan (post 1500) +oji Ojibwa +ori Oriya +orm Oromo +osa Osage +oss Ossetian +ota Turkish, Ottoman (1500-1928) +oto Otomian languages +paa Papuan (Other) +pag Pangasinan +pal Pahlavi +pam Pampanga +pan Punjabi +pap Papiamento +pau Palauan +peo Persian, Old (ca.600-400 B.C.) +per Persian +phi Philippine (Other) +phn Phoenician +pli Pali +pol Polish +por Portuguese +pon Pohnpeian +pra Prakrit languages +pro Proveçal, Old (to 1500) +pus Pushto +que Quechua +raj Rajasthani +rap Rapanui +rar Rarotongan +roa Romance (Other) +roh Raeto-Romance +rom Romany +rum Romanian +run Rundi +rus Russian +sad Sandawe +sag Sango +sah Yakut +sai South American Indian (Other) +sal Salishan languages +sam Samaritan Aramaic +san Sanskrit +sas Sasak +sat Santali +scc Serbian +sco Scots +scr Croatian +sel Selkup +sem Semitic (Other) +sga Irish, Old (to 900) +sgn Sign languages +shn Shan +sid Sidamo +sin Sinhalese +sio Siouan languages +sit Sino-Tibetan (Other) +sla Slavic (Other) +slo Slovak +slv Slovenian +sma Southern Sami +sme Northern Sami +smi Sami languages (Other) +smj Lule Sami +smn Inari Sami +smo Samoan +sms Skolt Sami +sna Shona +snd Sindhi +snk Soninke +sog Sogdian +som Somali +son Songhai +sot Sotho, Southern +spa Spanish (Castilian) +srd Sardinian +srr Serer +ssa Nilo-Saharan (Other) +ssw Swati +suk Sukuma +sun Sundanese +sus Susu +sux Sumerian +swa Swahili +swe Swedish +syr Syriac +tah Tahitian +tai Tai (Other) +tam Tamil +tso Tsonga +tat Tatar +tel Telugu +tem Timne +ter Tereno +tet Tetum +tgk Tajik +tgl Tagalog +tha Thai +tib Tibetan +tig Tigre +tir Tigrinya +tiv Tiv +tkl Tokelau +tlh Klingon; tlhIngan-Hol +tli Tlinglit +tmh Tamashek +tog Tonga (Nyasa) +ton Tonga (Tonga Islands) +tpi Tok Pisin +tsi Tsimshian +tsn Tswana +tuk Turkmen +tum Tumbuka +tup Tupi languages +tur Turkish +tut Altaic (Other) +tvl Tuvalu +twi Twi +tyv Tuvinian +udm Udmurt +uga Ugaritic +uig Uighur +ukr Ukrainian +umb Umbundu +und Undetermined +urd Urdu +uzb Uzbek +vai Vai +ven Venda +vie Vietnamese +vol Volapuk +vot Votic +wak Wakashan languages +wal Walamo +war Waray +was Washo +wel Welsh +wen Sorbian languages +wln Walloon +wol Wolof +xal Kalmyk +xho Xhosa +yao Yao +yap Yapese +yid Yiddish +yor Yoruba +ypk Yupik languages +zap Zapotec +zen Zenaga +zha Chuang; Zhuang +znd Zande +zul Zulu +zun Zuni diff --git a/scripts/make-empty-db b/scripts/make-empty-db new file mode 100755 index 0000000..92ccf75 --- /dev/null +++ b/scripts/make-empty-db @@ -0,0 +1,19 @@ +#!/bin/sh + +echo "creating db" +mysql -u root < createdb.mysql + +echo "creating tables" +mysql -u root < createtables.mysql + +echo "reading genres" +echo " use GiantDisc; load data local infile 'genres.txt' into table genre;"| mysql -u root --local-infile=1 + +echo "reading languages" +echo "use GiantDisc; load data local infile 'languages.txt' into table language;" | mysql -u root --local-infile=1 + +echo "reading musictypes" +echo "use GiantDisc; load data local infile 'musictypes.txt' into table musictype;" | mysql -u root --local-infile=1 + +echo "reading sources" +echo "use GiantDisc; load data local infile 'sources.txt' into table source;" | mysql -u root --local-infile=1 diff --git a/scripts/musictypes.txt b/scripts/musictypes.txt new file mode 100755 index 0000000..50ca2c3 --- /dev/null +++ b/scripts/musictypes.txt @@ -0,0 +1,4 @@ +soft/slow +medium +groovy +hard diff --git a/scripts/sources.txt b/scripts/sources.txt new file mode 100755 index 0000000..b900632 --- /dev/null +++ b/scripts/sources.txt @@ -0,0 +1,6 @@ +cd +radio +vinyl +tape +tv +video |