s_accessoires

CREATE TABLE IF NOT EXISTS Accessoires (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    pseudo VARCHAR(25) NOT NULL,
    bandana1 INT,
    bandana2 INT,
    helmet INT,
    beret INT,
    casquette INT,
    cowboy INT,
    melon INT,
    ordinaire INT,
    accessoire INT,
    lunettes INT,
    montre INT,
    xobandana1 DOUBLE,
    yobandana1 DOUBLE,
    zobandana1 DOUBLE,
    xrbandana1 DOUBLE,
    yrbandana1 DOUBLE,
    zrbandana1 DOUBLE,
    xsbandana1 DOUBLE,
    ysbandana1 DOUBLE,
    zsbandana1 DOUBLE,
    xohelmet DOUBLE,
    yohelmet DOUBLE,
    zohelmet DOUBLE,
    xrhelmet DOUBLE,
    yrhelmet DOUBLE,
    zrhelmet DOUBLE,
    xshelmet DOUBLE,
    yshelmet DOUBLE,
    zshelmet DOUBLE,
    xoberet DOUBLE,
    yoberet DOUBLE,
    zoberet DOUBLE,
    xrberet DOUBLE,
    yrberet DOUBLE,
    zrberet DOUBLE,
    xsberet DOUBLE,
    ysberet DOUBLE,
    zsberet DOUBLE,
    xocasquette DOUBLE,
    yocasquette DOUBLE,
    zocasquette DOUBLE,
    xrcasquette DOUBLE,
    yrcasquette DOUBLE,
    zrcasquette DOUBLE,
    xscasquette DOUBLE,
    yscasquette DOUBLE,
    zscasquette DOUBLE,
    xocowboy DOUBLE,
    yocowboy DOUBLE,
    zocowboy DOUBLE,
    xrcowboy DOUBLE,
    yrcowboy DOUBLE,
    zrcowboy DOUBLE,
    xscowboy DOUBLE,
    yscowboy DOUBLE,
    zscowboy DOUBLE,
    xomelon DOUBLE,
    yomelon DOUBLE,
    zomelon DOUBLE,
    xrmelon DOUBLE,
    yrmelon DOUBLE,
    zrmelon DOUBLE,
    xsmelon DOUBLE,
    ysmelon DOUBLE,
    zsmelon DOUBLE,
    xoordinaire DOUBLE,
    yoordinaire DOUBLE,
    zoordinaire DOUBLE,
    xrordinaire DOUBLE,
    yrordinaire DOUBLE,
    zrordinaire DOUBLE,
    xsordinaire DOUBLE,
    ysordinaire DOUBLE,
    zsordinaire DOUBLE,
    xoaccessoire DOUBLE,
    yoaccessoire DOUBLE,
    zoaccessoire DOUBLE,
    xraccessoire DOUBLE,
    yraccessoire DOUBLE,
    zraccessoire DOUBLE,
    xsaccessoire DOUBLE,
    ysaccessoire DOUBLE,
    zsaccessoire DOUBLE,
    xolunettes DOUBLE,
    yolunettes DOUBLE,
    zolunettes DOUBLE,
    xrlunettes DOUBLE,
    yrlunettes DOUBLE,
    zrlunettes DOUBLE,
    xslunettes DOUBLE,
    yslunettes DOUBLE,
    zslunettes DOUBLE,
    xobandana2 DOUBLE,
    yobandana2 DOUBLE,
    zobandana2 DOUBLE,
    xrbandana2 DOUBLE,
    yrbandana2 DOUBLE,
    zrbandana2 DOUBLE,
    xsbandana2 DOUBLE,
    ysbandana2 DOUBLE,
    zsbandana2 DOUBLE,
    xomontre DOUBLE,
    yomontre DOUBLE,
    zomontre DOUBLE,
    xrmontre DOUBLE,
    yrmontre DOUBLE,
    zrmontre DOUBLE,
    xsmontre DOUBLE,
    ysmontre DOUBLE,
    zsmontre DOUBLE,
    PRIMARY KEY(id),
    )
ENGINE=INNODB;