CREATE TABLE affiliation_FLI_SCHEMA.clic
(
  clic_id serial NOT NULL,
  clic_internaute character varying(100) NOT NULL,
  clic_lien integer NOT NULL,
  clic_programme integer NOT NULL,
  clic_affilie integer,
  clic_optionnel character varying(50),
  clic_ip inet,
  clic_date timestamp without time zone NOT NULL DEFAULT now(),
  clic_optionnel_1 character varying(50),
  clic_optionnel_2 character varying(50),
  clic_optionnel_3 character varying(50),
  clic_optionnel_4 character varying(50),
  clic_optionnel_5 character varying(50),
  clic_optionnel_6 character varying(50),
  clic_optionnel_7 character varying(50),
  clic_optionnel_8 character varying(50),
  clic_optionnel_9 character varying(50),
  clic_site integer,
  clic_annonceur integer,
  clic_date_epoch bigint
)
WITH (
  OIDS=FALSE
);
ALTER TABLE affiliation_FLI_SCHEMA.clic
  OWNER TO FLI_USER;


CREATE TABLE affiliation_FLI_SCHEMA.affichage
(
  affichage_id serial NOT NULL,
  affichage_lien integer NOT NULL,
  affichage_affilie integer,
  affichage_date timestamp without time zone NOT NULL DEFAULT now(),
  affichage_ip inet,
  affichage_internaute character varying(100) NOT NULL,
  affichage_site integer NOT NULL,
  affichage_programme integer,
  affichage_annonceur integer,
  affichage_date_epoch bigint
)
WITH (
  OIDS=FALSE
);
ALTER TABLE affiliation_FLI_SCHEMA.affichage
  OWNER TO FLI_USER;


CREATE TABLE affiliation_FLI_SCHEMA.lead
(
  lead_id serial NOT NULL,
  lead_programme integer NOT NULL,
  lead_identifiant character varying(100),
  lead_etat smallint NOT NULL DEFAULT 0,
  lead_date_insertion timestamp without time zone NOT NULL DEFAULT now(),
  lead_clic integer NOT NULL DEFAULT 0,
  lead_affichage integer NOT NULL DEFAULT 0,
  lead_annonceur integer,
  lead_site integer,
  lead_affilie integer,
  lead_lien integer,
  lead_date_insertion_epoch bigint
)
WITH (
  OIDS=FALSE
);
ALTER TABLE affiliation_FLI_SCHEMA.lead
  OWNER TO FLI_USER;


CREATE TABLE affiliation_FLI_SCHEMA.vente
(
  vente_id serial NOT NULL,
  vente_etat integer NOT NULL DEFAULT 0,
  vente_identifiant character varying(150),
  vente_no_facture character varying(100),
  vente_libelle character varying(512),
  vente_date_insertion timestamp without time zone NOT NULL DEFAULT now(),
  vente_clic integer NOT NULL DEFAULT 0,
  vente_date_achat timestamp without time zone,
  vente_programme integer DEFAULT 0,
  "vente_montantTTC" numeric(10,4),
  "vente_montantHT" numeric(10,4),
  vente_affichage integer NOT NULL DEFAULT 0,
  vente_annonceur integer,
  vente_site integer,
  vente_affilie integer,
  vente_lien integer,
  vente_date_achat_epoch bigint
)
WITH (
  OIDS=FALSE
);
ALTER TABLE affiliation_FLI_SCHEMA.vente
  OWNER TO FLI_USER;