#
# Table structure for table 'tt_address'
#
CREATE TABLE tt_address (
  addressgroup int(11) DEFAULT '0',
    tx_wseils_record_type int(11) DEFAULT '0' NOT NULL,
    tx_wseils_type_personne int(11) DEFAULT '0' NOT NULL,
    tx_wseils_maire text,
    tx_wseils_commune tinytext,
    tx_wseils_idsig int(11) DEFAULT '0' NOT NULL,
    tx_wseils_urlsig text,
    tx_wseils_tel2 text,
    tx_wseils_miscellaneous text,
    tx_wseils_long_description text,
    tx_wseils_commission tinytext,
    tx_wseils_service_responsible text,
    tx_wseils_service_adjoint text,
    tx_wseils_service_assistant text,
    tx_wseils_contact_link tinytext,
    tx_wseils_more_link tinytext,
    tx_wseils_picto text,
    tx_wseils_files text,
    tx_wseils_equip_type tinytext,
    tx_wseils_equip_contact text,
  tx_wseils_equip_rayonnement text,
    tx_wseils_open_school text,
    tx_wseils_open_holiday text,
    tx_wseils_vocation text,
    tx_wseils_area tinytext,
    tx_wseils_serviced_area tinytext,
    tx_wseils_land_reserve tinytext,
    tx_wseils_employes text,
    tx_wseils_proximity text,
    tx_wseils_internal_equip text,
    tx_wseils_average_price tinytext,
    tx_wseils_photo1 text,
    tx_wseils_photo2 text,
    tx_wseils_photo3 text,
    tx_wseils_plan text,
  tx_wseils_plan_commercialisation text,
  tx_wseils_vue_aerienne text,
    tx_wseils_za_file text,
    tx_wseils_partner_type tinytext,
    tx_wseils_domain tinytext,
    tx_wseils_partner_resp text,
    tx_wseils_partner_contact text,
    tx_wseils_commi_vice_president text,
    tx_wseils_commi_titulars text,
    tx_wseils_commi_suppleants text,
    tx_wseils_commi_bur_maire text,
    tx_wseils_commi_president text,
    tx_wseils_permanences text,
    tx_wseils_nb_hab tinytext,
    tx_wseils_surface tinytext,
    tx_wseils_equipmt_commu text,
    tx_wseils_equipmt_school text,
    tx_wseils_equipmt_service text,
    tx_wseils_to_see text,
    tx_wseils_date_annonce_locaux int(11) DEFAULT '0' NOT NULL,
    tx_wseils_type_bat1_locaux tinytext,
    tx_wseils_type_bat2_locaux tinytext,
    tx_wseils_situation_locaux text,
    tx_wseils_location_vente1_locaux text,
    tx_wseils_location_vente2_locaux text,
    tx_wseils_prix_locaux tinytext,
    tx_wseils_act_ant_locaux text,
    tx_wseils_date_dispo1_locaux int(11) DEFAULT '0' NOT NULL,
    tx_wseils_date_dispo2_locaux int(11) DEFAULT '0' NOT NULL,
    tx_wseils_comment_locaux text,
    tx_wseils_latitude_locaux tinytext,
    tx_wseils_longitude_locaux tinytext,
    tx_wseils_adjoint_maire text,
    tx_wseils_conseillers_municipaux text,
    tx_wseils_conseillers_delegues text,
    tx_wseils_function tinytext,
    tx_wseils_manager tinytext,
    tx_wseils_pericentre text,
  tx_tcdirectmail_bounce int(11) DEFAULT '0',
  address_number text,
  tx_multishop_customer_id int(11) DEFAULT '0',
  tx_multishop_default int(11) DEFAULT '0',
  address_ext text,
  module_sys_dmail_category int(11) DEFAULT '0',
  module_sys_dmail_html int(11) DEFAULT '0',
  tx_directmailsubscription_localgender text,
  externalid varchar(255) DEFAULT '' NOT NULL
);

#
# Table structure for table 'tx_wseils_equipementtype'
#
CREATE TABLE tx_wseils_equipementtype (
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    starttime int(11) DEFAULT '0' NOT NULL,
    endtime int(11) DEFAULT '0' NOT NULL,
    name tinytext,
    
    PRIMARY KEY (uid),
    KEY parent (pid)
);

--
-- Table structure for table `tx_wseilsdev_guide_tri`
--

CREATE TABLE `tx_wseilsdev_guide_tri` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `crdate` int(11) NOT NULL DEFAULT '0',
  `cruser_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  `hidden` tinyint(4) NOT NULL DEFAULT '0',
  `dechet` tinytext,
  `famille` tinytext,
  `destination` tinytext,
  PRIMARY KEY (`uid`),
  KEY `parent` (`pid`)
);


--
-- Table structure for table `tx_wseilsdev_guide_tri_icone`
--

CREATE TABLE `tx_wseilsdev_guide_tri_icone` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0',
  `tstamp` int(11) NOT NULL DEFAULT '0',
  `crdate` int(11) NOT NULL DEFAULT '0',
  `cruser_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  `hidden` tinyint(4) NOT NULL DEFAULT '0',
  `libelle` tinytext,
  `icone` tinytext,
  PRIMARY KEY (`uid`),
  KEY `parent` (`pid`)
);


--
-- Table structure for table 'tx_news_domain_model_news '
--
CREATE TABLE tx_news_domain_model_news (
  duration text,
  price_full text,
  price_reduced text,
  price_young text,
  price_subscriber text,
  price_subscriber_regular text,
  ticketing text,
  traineeship text,
  distribution text,
  event_start int(11) unsigned DEFAULT '0',
  age_min text,
);

--
-- Table structure for table 'sys_file_reference '
--
CREATE TABLE sys_file_reference (
  showinpreview varchar(1) NOT NULL DEFAULT '1',
);