Code:
// Tabelle fuer die Art der CD (Album, Sampler, Split, etc)
CREATE TABLE msk_t_art (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
dateadd INT(14) NOT NULL);
// Tabelle fuer die CD an sich
CREATE TABLE msk_t_cd (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
labelid INT(14),
genreid INT(14),
artid INT(14) NOT NULL,
cdnr INT(5) NOT NULL,
cdanz INT(5) NOT NULL,
trackanz INT(5) NOT NULL,
release INT(4),
info TEXT,
dateadd INT(14) NOT NULL);
// Tabelle fuers Genre
CREATE TABLE msk_t_genre (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
dateadd INT(14) NOT NULL);
// Tabelle fuer den Interpreten
CREATE TABLE msk_t_interpret (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
email VARCHAR(255),
homepage VARCHAR(255),
info TEXT,
dateadd INT(14) NOT NULL);
// Tabelle fuers Label
CREATE TABLE msk_t_label (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
email VARCHAR(255),
homepage VARCHAR(255),
info TEXT,
dateadd INT(14) NOT NULL);
// Tabelle fuer die Tracks
CREATE TABLE msk_t_track (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
interpretid INT(14) NOT NULL,
albumid INT(14),
cdnr INT(5) NOT NULL,
tracknr INT(5) NOT NULL,
laenge INT(5) NOT NULL,
lyric TEXT,
info TEXT,
dateadd INT(14) NOT NULL);
So richtig zufrieden war ich damit von anfang an nicht. Naja, heut kam die Aenderung...
Code:
// Tabelle fuer die Alben
CREATE TABLE msk_t_album (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
interpretid INT(14) NOT NULL,
labelid INT(14) NOT NULL,
genreid INT(14) NOT NULL,
cdnr INT(5) NOT NULL,
cdanz INT(5) NOT NULL,
trackanz INT(5) NOT NULL,
release INT(5),
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer die Titel der Alben
CREATE TABLE msk_t_albumtracks (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
albumid INT(14) NOT NULL,
cdnr INT(5) NOT NULL,
tracknr INT(5) NOT NULL,
laenge INT(5) NOT NULL,
lyric TEXT,
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer die Sampler
CREATE TABLE msk_t_sampler (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
labelid INT(14) NOT NULL,
genreid INT(14) NOT NULL,
cdnr INT(5) NOT NULL,
cdanz INT(5) NOT NULL,
trackanz INT(5) NOT NULL,
release INT(5),
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer die Tracks der Sampler
CREATE TABLE msk_t_samplertracks (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
interpretid INT(14) NOT NULL,
samplerid INT(14) NOT NULL,
cdnr INT(5) NOT NULL,
tracknr INT(5) NOT NULL,
laenge INT(5),
lyric TEXT,
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer die Split-CDs
CREATE TABLE msk_t_split (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
labelid INT(14) NOT NULL,
genreid INT(14) NOT NULL,
cdnr INT(5) NOT NULL,
cdanz INT(5) NOT NULL,
trackanz INT(5) NOT NULL,
release INT(5),
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer die Tracks der Split-CDs
CREATE TABLE msk_t_splittracks (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
interpretid INT(14) NOT NULL,
splitid INT(14) NOT NULL,
cdnr INT(5) NOT NULL,
tracknr INT(5) NOT NULL,
laenge INT(5),
lyric TEXT,
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer die Maxi-CDs
CREATE TABLE msk_t_maxi (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
interpretid INT(14) NOT NULL,
labelid INT(14) NOT NULL,
genreid INT(14) NOT NULL,
cdnr INT(5) NOT NULL,
cdanz INT(5) NOT NULL,
trackanz INT(5) NOT NULL,
release INT(5),
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer die Tracks der Maxi-CDs
CREATE TABLE msk_t_maxitracks (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
maxiid INT(14) NOT NULL,
cdnr INT(5) NOT NULL,
tracknr INT(5) NOT NULL,
laenge INT(5),
lyric TEXT,
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer einzelne Tracks
CREATE TABLE msk_t_tracks (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
interpretid INT(14) NOT NULL,
laenge INT(5),
lyric TEXT,
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer die Interpreten
CREATE TABLE msk_t_interpret (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
email VARCHAR(255),
homepage VARCHAR(255),
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer die Label
CREATE TABLE msk_t_label (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
email VARCHAR(255),
homepage VARCHAR(255),
info TEXT,
dateadd TIMESTAMP NOT NULL);
// Tabelle fuer die Genres
CREATE TABLE msk_t_genre (
id INT(14) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
dateadd TIMESTAMP NOT NULL);
Damit bin ich aber immer noch lange nicht zufrieden.
Lesezeichen