Please take our Survey
logo       
<prev   next>

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

[mb-commits] r8610 - in mb_server/branches/labels: admin/sql htdocs/comp/ar: msg#00026

audio.musicbrainz.cvs

Subject: [mb-commits] r8610 - in mb_server/branches/labels: admin/sql htdocs/comp/ar htdocs/comp/relationship htdocs/show/label

Author: luks
Date: 2006-11-03 16:54:19 +0000 (Fri, 03 Nov 2006)
New Revision: 8610

Added:
mb_server/branches/labels/htdocs/show/label/relationships.html
Modified:
mb_server/branches/labels/admin/sql/CreateTables.sql
mb_server/branches/labels/htdocs/comp/ar/ShowEntityLink
mb_server/branches/labels/htdocs/comp/relationship/outputentity
mb_server/branches/labels/htdocs/show/label/index.html
Log:
Label ARs.

Modified: mb_server/branches/labels/admin/sql/CreateTables.sql
===================================================================
--- mb_server/branches/labels/admin/sql/CreateTables.sql 2006-11-03
13:08:59 UTC (rev 8609)
+++ mb_server/branches/labels/admin/sql/CreateTables.sql 2006-11-03
16:54:19 UTC (rev 8610)
@@ -237,6 +237,17 @@
modpending INTEGER NOT NULL DEFAULT 0
);

+CREATE TABLE l_album_label
+(
+ id SERIAL,
+ link0 INTEGER NOT NULL DEFAULT 0, -- references album
+ link1 INTEGER NOT NULL DEFAULT 0, -- references label
+ link_type INTEGER NOT NULL DEFAULT 0, -- references
lt_album_label
+ begindate CHAR(10) NOT NULL DEFAULT '',
+ enddate CHAR(10) NOT NULL DEFAULT '',
+ modpending INTEGER NOT NULL DEFAULT 0
+);
+
CREATE TABLE l_album_track
(
id SERIAL,
@@ -270,6 +281,17 @@
modpending INTEGER NOT NULL DEFAULT 0
);

+CREATE TABLE l_artist_label
+(
+ id SERIAL,
+ link0 INTEGER NOT NULL DEFAULT 0, -- references artist
+ link1 INTEGER NOT NULL DEFAULT 0, -- references label
+ link_type INTEGER NOT NULL DEFAULT 0, -- references
lt_artist_label
+ begindate CHAR(10) NOT NULL DEFAULT '',
+ enddate CHAR(10) NOT NULL DEFAULT '',
+ modpending INTEGER NOT NULL DEFAULT 0
+);
+
CREATE TABLE l_artist_track
(
id SERIAL,
@@ -292,6 +314,39 @@
modpending INTEGER NOT NULL DEFAULT 0
);

+CREATE TABLE l_label_label
+(
+ id SERIAL,
+ link0 INTEGER NOT NULL DEFAULT 0, -- references label
+ link1 INTEGER NOT NULL DEFAULT 0, -- references label
+ link_type INTEGER NOT NULL DEFAULT 0, -- references
lt_label_label
+ begindate CHAR(10) NOT NULL DEFAULT '',
+ enddate CHAR(10) NOT NULL DEFAULT '',
+ modpending INTEGER NOT NULL DEFAULT 0
+);
+
+CREATE TABLE l_label_track
+(
+ id SERIAL,
+ link0 INTEGER NOT NULL DEFAULT 0, -- references label
+ link1 INTEGER NOT NULL DEFAULT 0, -- references track
+ link_type INTEGER NOT NULL DEFAULT 0, -- references
lt_label_track
+ begindate CHAR(10) NOT NULL DEFAULT '',
+ enddate CHAR(10) NOT NULL DEFAULT '',
+ modpending INTEGER NOT NULL DEFAULT 0
+);
+
+CREATE TABLE l_label_url
+(
+ id SERIAL,
+ link0 INTEGER NOT NULL DEFAULT 0, -- references label
+ link1 INTEGER NOT NULL DEFAULT 0, -- references url
+ link_type INTEGER NOT NULL DEFAULT 0, -- references lt_label_url
+ begindate CHAR(10) NOT NULL DEFAULT '',
+ enddate CHAR(10) NOT NULL DEFAULT '',
+ modpending INTEGER NOT NULL DEFAULT 0
+);
+
CREATE TABLE l_track_track
(
id SERIAL,
@@ -383,6 +438,20 @@
modpending INTEGER NOT NULL DEFAULT 0
);

+CREATE TABLE lt_album_label
+(
+ id SERIAL,
+ parent INTEGER NOT NULL, -- references self
+ childorder INTEGER NOT NULL DEFAULT 0,
+ mbid CHAR(36) NOT NULL,
+ name VARCHAR(255) NOT NULL,
+ description TEXT NOT NULL,
+ linkphrase VARCHAR(255) NOT NULL,
+ rlinkphrase VARCHAR(255) NOT NULL,
+ attribute VARCHAR(255) DEFAULT '',
+ modpending INTEGER NOT NULL DEFAULT 0
+);
+
CREATE TABLE lt_album_track
(
id SERIAL,
@@ -425,6 +494,20 @@
modpending INTEGER NOT NULL DEFAULT 0
);

+CREATE TABLE lt_artist_label
+(
+ id SERIAL,
+ parent INTEGER NOT NULL, -- references self
+ childorder INTEGER NOT NULL DEFAULT 0,
+ mbid CHAR(36) NOT NULL,
+ name VARCHAR(255) NOT NULL,
+ description TEXT NOT NULL,
+ linkphrase VARCHAR(255) NOT NULL,
+ rlinkphrase VARCHAR(255) NOT NULL,
+ attribute VARCHAR(255) DEFAULT '',
+ modpending INTEGER NOT NULL DEFAULT 0
+);
+
CREATE TABLE lt_artist_track
(
id SERIAL,
@@ -453,6 +536,48 @@
modpending INTEGER NOT NULL DEFAULT 0
);

+CREATE TABLE lt_label_label
+(
+ id SERIAL,
+ parent INTEGER NOT NULL, -- references self
+ childorder INTEGER NOT NULL DEFAULT 0,
+ mbid CHAR(36) NOT NULL,
+ name VARCHAR(255) NOT NULL,
+ description TEXT NOT NULL,
+ linkphrase VARCHAR(255) NOT NULL,
+ rlinkphrase VARCHAR(255) NOT NULL,
+ attribute VARCHAR(255) DEFAULT '',
+ modpending INTEGER NOT NULL DEFAULT 0
+);
+
+CREATE TABLE lt_label_track
+(
+ id SERIAL,
+ parent INTEGER NOT NULL, -- references self
+ childorder INTEGER NOT NULL DEFAULT 0,
+ mbid CHAR(36) NOT NULL,
+ name VARCHAR(255) NOT NULL,
+ description TEXT NOT NULL,
+ linkphrase VARCHAR(255) NOT NULL,
+ rlinkphrase VARCHAR(255) NOT NULL,
+ attribute VARCHAR(255) DEFAULT '',
+ modpending INTEGER NOT NULL DEFAULT 0
+);
+
+CREATE TABLE lt_label_url
+(
+ id SERIAL,
+ parent INTEGER NOT NULL, -- references self
+ childorder INTEGER NOT NULL DEFAULT 0,
+ mbid CHAR(36) NOT NULL,
+ name VARCHAR(255) NOT NULL,
+ description TEXT NOT NULL,
+ linkphrase VARCHAR(255) NOT NULL,
+ rlinkphrase VARCHAR(255) NOT NULL,
+ attribute VARCHAR(255) DEFAULT '',
+ modpending INTEGER NOT NULL DEFAULT 0
+);
+
CREATE TABLE lt_track_track
(
id SERIAL,
@@ -777,7 +902,7 @@
word VARCHAR(255) NOT NULL,
artistusecount SMALLINT NOT NULL DEFAULT 0,
albumusecount SMALLINT NOT NULL DEFAULT 0,
- trackusecount SMALLINT NOT NULL DEFAULT 0
+ trackusecount SMALLINT NOT NULL DEFAULT 0,
labelusecount SMALLINT NOT NULL DEFAULT 0
);


Modified: mb_server/branches/labels/htdocs/comp/ar/ShowEntityLink
===================================================================
--- mb_server/branches/labels/htdocs/comp/ar/ShowEntityLink 2006-11-03
13:08:59 UTC (rev 8609)
+++ mb_server/branches/labels/htdocs/comp/ar/ShowEntityLink 2006-11-03
16:54:19 UTC (rev 8610)
@@ -43,6 +43,7 @@

if ($typeshow eq "artist" or
$typeshow eq "release" or
+ $typeshow eq "label" or
$typeshow eq "track")
{
$m->comp("/comp/link$typeshow", id => $id, name => $name);

Modified: mb_server/branches/labels/htdocs/comp/relationship/outputentity
===================================================================
--- mb_server/branches/labels/htdocs/comp/relationship/outputentity
2006-11-03 13:08:59 UTC (rev 8609)
+++ mb_server/branches/labels/htdocs/comp/relationship/outputentity
2006-11-03 16:54:19 UTC (rev 8610)
@@ -57,6 +57,11 @@
my ($sortname, $resolution) = ($item->{$prefix . "sortname"},
$item->{$prefix . "resolution"});
$m->comp("/comp/linkartist", id => $e_id, name => $e_name,
sortname => $sortname, resolution => $resolution);
}
+ elsif ($e_inttype eq "label")
+ {
+ my ($sortname, $resolution) = ($item->{$prefix . "sortname"},
$item->{$prefix . "resolution"});
+ $m->comp("/comp/linklabel", id => $e_id, name => $e_name,
sortname => $sortname, resolution => $resolution);
+ }
elsif ($e_inttype eq "release" or
$e_inttype eq "track")
{

Modified: mb_server/branches/labels/htdocs/show/label/index.html
===================================================================
--- mb_server/branches/labels/htdocs/show/label/index.html 2006-11-03
13:08:59 UTC (rev 8609)
+++ mb_server/branches/labels/htdocs/show/label/index.html 2006-11-03
16:54:19 UTC (rev 8610)
@@ -147,6 +147,17 @@
explain => 1,
), $m->out("<br>");

+ $m->comp("/comp/ar/AddRelationship", id => $label->GetId, type => 'label',
name => $label->GetName)
+ if ($addrel);
+ $m->comp("/comp/ar/ClearRelationships")
+ if ($arcancel);
+
+ $m->comp("/comp/ar/RemoveRelationship", id => $remrel, type => $remtype)
+ if ($remrel >= 0);
+
+ $m->comp("/comp/ar/RelationshipBox", id => $label->GetId, type => 'label',
+ name => $label->GetName);
+
</%perl>

% if (@albums)

Copied: mb_server/branches/labels/htdocs/show/label/relationships.html (from
rev 8594, mb_server/branches/labels/htdocs/show/artist/relationships.html)
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  [mb-commits] r8609 - in mb_server/branches/labels: cgi-bin htdocs/comp/layout htdocs/css htdocs/show/label, root
Next by Date:  [mb-commits] r8611 - in mb_server/branches/labels: admin/sql cgi-bin cgi-bin/MusicBrainz/Server cgi-bin/MusicBrainz/Server/Moderation htdocs/comp htdocs/edit/label, root
Previous by Thread:  [mb-commits] r8609 - in mb_server/branches/labels: cgi-bin htdocs/comp/layout htdocs/css htdocs/show/label, root
Next by Thread:  [mb-commits] r8611 - in mb_server/branches/labels: admin/sql cgi-bin cgi-bin/MusicBrainz/Server cgi-bin/MusicBrainz/Server/Moderation htdocs/comp htdocs/edit/label, root
Indexes:  [Date] [Thread] [Top] [All Lists]

Google Custom Search
Recently Viewed:
solaris.opensol...    editors.vim/200...    web.turbogears....    jakarta.ant.dev...    mathematics.max...    text.unicode.ge...    lang.ruby.core/...    xfce.announce/2...    network.centeri...    php.cvs.pear/20...    user-groups.lin...    kde.devel.quant...    file-systems.ar...    redhat.fedora.t...    apple.fink.auto...    gnome.orbit.gen...    qplus.devel/200...    culture.transpo...    video.dri.user/...    operators.nanog...   
Home | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation