CREATE TABLE Persons (
    ID int NOT NULL AUTO_INCREMENT,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (ID)
); 


CREATE TABLE IF NOT EXISTS gestion (
  id int(11) NOT NULL AUTO_INCREMENT,
  annee varchar(30) NOT NULL,
  mois varchar(30) NOT NULL,
  jour varchar(30) NOT NULL,
  date_inscription varchar(30) NOT NULL,
  client varchar(30) NOT NULL,
  mode varchar(30) NOT NULL,
  formule varchar(30) NOT NULL,
  seance varchar(30) NOT NULL,
  compteur varchar(30) NOT NULL,
  montant varchar(30) NOT NULL,
  statut varchar(30) NOT NULL,
  cheque varchar(30) NOT NULL,
  banque varchar(30) NOT NULL,
  PRIMARY KEY (id)
) 

DROP TABLE gestion