SQL Tags mit und Verknüpfen

[arbu man]

Ok, ich denke du meinst den Tabellencode:

SQL-Code:

--
-- Tabellenstruktur für Tabelle `music__songs`
--

CREATE TABLE `music__songs` (
  `s_id` int(11) NOT NULL auto_increment,
  `s_title` varchar(255) collate latin1_general_ci NOT NULL,
  `s_artist` varchar(255) collate latin1_general_ci NOT NULL,
  `s_album` varchar(255) collate latin1_general_ci NOT NULL,
  `s_rating` int(11) NOT NULL,
  `s_desc` text collate latin1_general_ci NOT NULL,
  `s_genre` varchar(255) collate latin1_general_ci NOT NULL,
  `s_addtime` int(11) NOT NULL,
  PRIMARY KEY  (`s_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2370 ;

--
-- Tabellenstruktur für Tabelle `music__tag`
--

CREATE TABLE `music__tag` (
  `t_id` int(11) NOT NULL auto_increment,
  `t_name` varchar(255) collate latin1_general_ci NOT NULL,
  `t_count` int(11) NOT NULL,
  PRIMARY KEY  (`t_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1764 ;

--
-- Tabellenstruktur für Tabelle `music__tagsong`
--

CREATE TABLE `music__tagsong` (
  `ts_id` int(11) NOT NULL auto_increment,
  `ts_tag` int(11) NOT NULL,
  `ts_song` int(11) NOT NULL,
  `ts_uid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ts_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4674 ;