SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

DROP SCHEMA IF EXISTS `OSI_Normalized` ;
CREATE SCHEMA IF NOT EXISTS `OSI_Normalized` DEFAULT CHARACTER SET utf8 ;
SHOW WARNINGS;

-- -----------------------------------------------------
-- Table `OSI_Normalized`.`os_billing_reasons`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `OSI_Normalized`.`os_billing_reasons` ;

SHOW WARNINGS;
CREATE  TABLE IF NOT EXISTS `OSI_Normalized`.`os_billing_reasons` (
  `id` INT(10) NOT NULL AUTO_INCREMENT ,
  `BillingReason` VARCHAR(50) NOT NULL DEFAULT NULL ,
  `BillingReason_French` VARCHAR(50) NOT NULL ,
  `ArchivedRecord` TINYINT(1)  NOT NULL DEFAULT FALSE ,
  PRIMARY KEY (`id`) ,
  INDEX `id` (`id` ASC) ,
  UNIQUE INDEX `BillingReasons_UNIQUE` (`BillingReason` ASC) ,
  UNIQUE INDEX `BillingReason_French_UNIQUE` (`BillingReason_French` ASC) )
ENGINE = InnoDB
AUTO_INCREMENT = 123;

SHOW WARNINGS;

-- -----------------------------------------------------
-- Table `OSI_Normalized`.`os_billing_methods`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `OSI_Normalized`.`os_billing_methods` ;

SHOW WARNINGS;
CREATE  TABLE IF NOT EXISTS `OSI_Normalized`.`os_billing_methods` (
  `id` INT(10) NOT NULL AUTO_INCREMENT ,
  `BillingMethod` VARCHAR(50) NOT NULL DEFAULT NULL ,
  `BillingMethod_French` VARCHAR(50) NOT NULL ,
  `ArchivedRecord` TINYINT(1)  NOT NULL DEFAULT FALSE ,
  PRIMARY KEY (`id`) ,
  INDEX `ContactCode` (`BillingMethod` ASC) ,
  INDEX `id` (`id` ASC) ,
  UNIQUE INDEX `BillingMethod_UNIQUE` (`BillingMethod` ASC) ,
  UNIQUE INDEX `BillingMethod_French_UNIQUE` (`BillingMethod_French` ASC) )
ENGINE = InnoDB
AUTO_INCREMENT = 17;

SHOW WARNINGS;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;