CREATE TABLE `llx_equipement_adresse` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_adresse` int(11) NOT NULL,
  `nom` varchar(100) DEFAULT NULL,
  `contrat` tinyint(4) NOT NULL DEFAULT 0,
  `fk_type` int(11) DEFAULT NULL,
  `num_serie` varchar(100) DEFAULT NULL,
  `date_achat` datetime DEFAULT NULL,
  `date_installation` datetime DEFAULT NULL,
  `ref` varchar(20) DEFAULT NULL,
  `fk_os` int(11) DEFAULT NULL,
  `detail` text DEFAULT NULL,
  `adeli` text DEFAULT NULL,
  `cps` text DEFAULT NULL,
  `last_modif` timestamp NOT NULL DEFAULT current_timestamp(),
  `fk_user_modif` int(11) DEFAULT NULL,
  `save` tinyint(4) NOT NULL DEFAULT 0,
  `lundi` tinyint(4) NOT NULL DEFAULT 0,
  `mardi` tinyint(4) NOT NULL DEFAULT 0,
  `mercredi` tinyint(4) NOT NULL DEFAULT 0,
  `jeudi` tinyint(4) NOT NULL DEFAULT 0,
  `vendredi` tinyint(4) NOT NULL DEFAULT 0,
  `samedi` tinyint(4) NOT NULL DEFAULT 0,
  `dimanche` tinyint(4) NOT NULL DEFAULT 0,
  `time_save` varchar(20) DEFAULT NULL,
  `folder_save` varchar(1000) DEFAULT NULL,
  `fk_backup` int(11) DEFAULT NULL,
  `marque` varchar(100) DEFAULT NULL,
  `modele` varchar(100) DEFAULT NULL,
  `cpu` varchar(100) DEFAULT NULL,
  `ram` varchar(100) DEFAULT NULL,
  `disque` varchar(100) DEFAULT NULL,
  `archived` int(11) NOT NULL DEFAULT 0,
  `date_end_archive` datetime DEFAULT NULL,
  `import_key` varchar(100) DEFAULT NULL,
  `typesauv` varchar(100) DEFAULT NULL,
  `archivage` int(11) DEFAULT 0,
  `microsoft` int(11) DEFAULT 0,
  PRIMARY KEY (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;