CREATE TABLE IF NOT EXISTS `AssoMemberType` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`Name` TEXT  NOT NULL,
`Description` TEXT  NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 


CREATE TABLE IF NOT EXISTS `AssoMember` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`FirstName` TEXT  NOT NULL,
`Name` TEXT  NOT NULL,
`Email` TEXT NULL,
`Phone` TEXT NULL,
`Adress` TEXT  NULL,
`ZipCode` TEXT  NULL,
`City` TEXT  NULL,
`BirthDate` Date NULL,
`MemberTypeId` INT  NOT NULL,
`UserId` INT NULL,
`DateCreated` Date  NOT NULL,
`Status` INT  NULL,
PRIMARY KEY (`Id`),
CONSTRAINT `AssoMemberType_AssoMember` FOREIGN KEY (`MemberTypeId`) REFERENCES `AssoMemberType`(`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 

CREATE TABLE IF NOT EXISTS `AssoMemberShip` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`MemberId` INT  NOT NULL,
`Mount` TEXT  NOT NULL,
`DateCreated` Date  NOT NULL,
PRIMARY KEY (`Id`),
CONSTRAINT `AssoMember_AssoMemberShip` FOREIGN KEY (`MemberId`) REFERENCES `AssoMember`(`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 

CREATE TABLE IF NOT EXISTS `AssoReceipt` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`Libelle` TEXT  NOT NULL,
`Mount` TEXT  NOT NULL,
`DateCreated` DATE  NOT NULL,
`Data` TEXT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 

CREATE TABLE IF NOT EXISTS `AssoExpense` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`Libelle` TEXT  NOT NULL,
`Mount` VARCHAR(200)  NOT NULL,
`DateCreated` DATE  NOT NULL,
`Data` TEXT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 

CREATE TABLE IF NOT EXISTS `AssoEquipment` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`Libelle` TEXT  NOT NULL,
`Description` TEXT  NOT NULL,
`Price` TEXT  NOT NULL,
`Quantity` INT  NOT NULL,
`DateCreated` DATE  NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 