DROP TABLE IF EXISTS `ecommerceinfo`;
CREATE TABLE `ecommerceinfo` (
  `id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `channel`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
  `username`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
  `password`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
  `email`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
  `eBayExpire`  date DEFAULT '0001-01-01' ,
  `eBayUserId`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' ,
  `xeroExpire`  datetime DEFAULT '0001-01-01 00:00:00' ,
  `xeroTenantId`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' ,
  `xeroToken`  text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `active`  tinyint(1) NOT NULL DEFAULT 1 ,
  `created`  datetime NOT NULL DEFAULT '0001-01-01 00:00:00' ,
  `createdById`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
  `updated`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
  `updatedById`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `username` (`username`) USING BTREE ,
  UNIQUE INDEX `email` (`email`) USING BTREE ,
  UNIQUE INDEX `eBayUserId` (`eBayUserId`) USING BTREE ,
  INDEX `channel` (`channel`) USING BTREE ,
  INDEX `password` (`password`) USING BTREE ,
  INDEX `eBayExpire` (`eBayExpire`) USING BTREE,
  INDEX `xeroExpire` (`xeroExpire`) USING BTREE,
  INDEX `xeroTenantId` (`xeroTenantId`) USING BTREE
)
  ENGINE=InnoDB
  DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  ROW_FORMAT=Dynamic
;
