albums

Field Type Null Key Default Extra
id int(5) PRI NULL auto_increment
Nom varchar(255)
Date decimal(10,1) 0.0
Prod varchar(255)
Cover varchar(50) Nocover.jpg
Tracklisting longtext
VoteCount int(8) 0
VoteTotal int(8) 0
idgroupe int(10) 0
idmembre int(5) 0
Lineup tinytext YES NULL
vues int(10) unsigned 0
kros tinyint(4) unsigned 0
coms tinyint(4) unsigned 0

user_votes
Field Type Null Key Default Extra
alb_id int(8) unsigned YES MUL NULL
user_id int(8) unsigned YES MUL NULL
vote tinyint(1) unsigned YES MUL NULL

rela_groupe_album
Field Type Null Key Default Extra
rel_id int(11) PRI NULL auto_increment
groupe_id int(11) MUL 0
album_id int(11) MUL 0
album_type tinyint(1) 0

groupes
Field Type Null Key Default Extra
id int(5) PRI NULL auto_increment
Groupe varchar(255)
Pays tinyint(4) unsigned 0
Style varchar(255)
Logo varchar(255)
Photo1 varchar(255)
Photo2 varchar(255)
Photo3 varchar(255)
Site varchar(255)
Comment longtext
idmembre int(5) 0
Lineup text YES NULL
Statut tinyint(1) unsigned 0
Label varchar(255)
MAJ int(11) unsigned 0
vues int(10) unsigned 0