Sandbox: Difference between revisions
PavanChander (talk | contribs) mNo edit summary |
PavanChander (talk | contribs) No edit summary |
||
Line 4: | Line 4: | ||
[[Non-existant_page]] |
[[Non-existant_page]] |
||
[[MB:WikiDocs]] |
|||
== Tables (H2) == |
== Tables (H2) == |
||
Revision as of 01:38, 10 December 2011
This is a test of the emergency broadcast documentation caching system.
Tables (H2)
Release | Fôrmat | Tracks | Date | Country | Label | Catalog# | Barcode |
---|---|---|---|---|---|---|---|
Frances the Mute | CD | 12 | 2005-02-21 | XE | Universal Records | 075021039773 | 075021039773 |
Frances the Mute | CD | 12 | 2005-02-28 | AU | Universal Records | 2103977 | 075021039773 |
Frances the Mute | CD | 12 | 2005-03-01 | US | Gold Standard Laboratories |
Artists (H3)
The artist index contains the following fields you can search:
field | Description |
---|---|
arid | artist id |
artist | artist name |
sortname | artist sortname |
alias | the aliases/misspellings for this artist |
Artist search terms with no fields specified search the artist, sortname and alias fields.
Releases (H3)
The release index contains these fields:
field | Description |
---|---|
reid | release id |
release | release name |
arid | artist id |
catno | The catalog number for this release |
barcode | The barcode in a release event attached to a release |
Lists (H2)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim.
Ordered (H3)
- Foo
- Foobar
- Foobarbaz
- Foobarbaz
- Foobar
- FooBaz
- FooBaz
- Foobarbaz
- Foobarbaz
- FooBaz
- Foobar
- Foobar
- Foobar
- Bar
- Barfoo
- Barfoo
- Baz
- Bazbar
- Foobaz
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim.
Unordered (H4)
- Foo
- Foobar
- Foobar
- Foobarbaz
- Foobar
- Bar
- Barbaz
- Barfoobaz
- Barbaz
- Barbazfoo
- Barbazfoo
- Barbaz
Misc (H5)
- Baz
- Bazfoo
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim.
DTs and DDs (H2)
Artists (H3)
- tori amos
- search artist, sortname and alias fields
- comment electronic
- search for the word electronic in artist disambiguation (comment) fields
- begin:1984 AND type:group
- search for all groups formed in 1984
Releases (H3)
- café del mar
- search for all Café del Mar albums
- "the understanding" AND artist:royksopp
- search for the album The Understanding by the artist Röyksopp
- date:1999 AND country:de AND rock
- search for releases from Germany in 1999
- with the word rock in them
Pres & codes
In mbserver's home directory is a directory called svn
. This contains the latest MusicBrainz server code at the time of release. To make sure you have an up-to-date
copy:
mbserver@brainzvm:~/svn/mb_server$ su - Password: brainzvm:~# /etc/init.d/apache-perl stop Stopping web server: apache-perl. brainzvm:~# exit mbserver@brainzvm:~/svn/mb_server$ dropdb -U postgres musicbrainz_db DROP DATABASE mbserver@brainzvm:~/svn/mb_server$ dropdb -U postgres musicbrainz_db_raw DROP DATABASE mbserver@brainzvm:~/svn/mb_server$ ./admin/InitDb.pl --createdb --echo --import -- --tmp-dir=/mnt/data/tmp ~/mbdump*.tar.bz2 <snip> -- Go get some coffee and a book, cause this'll take at least an hour to run. Fri Oct 21 21:11:56 2005 : Initialized and imported data into the database. Fri Oct 21 21:11:56 2005 : InitDb.pl succeeded mbserver@brainzvm:~$ su - Password: brainzvm:~# /etc/init.d/apache-perl start Starting web server: apache-perl. brainzvm:~# exit