gistfile1.sql

-- -----------------------------------------------------
-- Table `users`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `users` (
  `UID` INT(25) NOT NULL ,
  `username` VARCHAR(60) NOT NULL ,
  `password` VARCHAR(100) NOT NULL ,
  `ownerFN` VARCHAR(50) NOT NULL ,
  `ownerLN` VARCHAR(100) NOT NULL ,
  `userstatus` TINYINT(1) NOT NULL ,
  `userregistertime` DATETIME NOT NULL ,
  `userlastonline` DATETIME NOT NULL ,
  PRIMARY KEY (`UID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `company`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `company` (
  `CID` INT(25) NOT NULL AUTO_INCREMENT ,
  `ownername` VARCHAR(60) NOT NULL ,
  `companyname` VARCHAR(255) NOT NULL ,
  `companyaddress` VARCHAR(255) NOT NULL ,
  `companyemail` VARCHAR(255) NULL DEFAULT NULL ,
  `companyphone` INT(20) NOT NULL ,
  `companyimage` VARCHAR(255) NULL DEFAULT NULL ,
  `partnership` TINYINT(1) NOT NULL DEFAULT '0' ,
  `type` TINYINT(1) NOT NULL DEFAULT '0' ,
  `introduction` TEXT NULL DEFAULT NULL ,
  `announcement` TEXT NULL DEFAULT NULL ,
  `template` TEXT NULL DEFAULT NULL ,
  PRIMARY KEY (`CID`) ,
  INDEX `username` (`ownername` ASC) ,
  CONSTRAINT `username`
    FOREIGN KEY (`ownername` )
    REFERENCES `users` (`username` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `content`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `content` (
  `PID` INT(25) NOT NULL AUTO_INCREMENT ,
  `username` VARCHAR(60) NOT NULL ,
  `introduction` TEXT NULL DEFAULT NULL ,
  `announcement` TEXT NULL DEFAULT NULL ,
  `template` TEXT NULL DEFAULT NULL ,
  PRIMARY KEY (`PID`) ,
  INDEX `username` (`username` ASC) ,
  CONSTRAINT `username`
    FOREIGN KEY (`username` )
    REFERENCES `company` (`ownername` )
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `product`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `product` (
  `RID` INT(25) NOT NULL AUTO_INCREMENT ,
  `companyname` VARCHAR(60) NOT NULL ,
  `productname` VARCHAR(60) NOT NULL ,
  `what` TEXT NOT NULL ,
  `image` VARCHAR(255) NOT NULL ,
  `price` DECIMAL(9,2) NOT NULL ,
  `tag` VARCHAR(60) NOT NULL ,
  PRIMARY KEY (`RID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `comments`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `comments` (
  `OID` INT(25) NOT NULL AUTO_INCREMENT ,
  `companyname` VARCHAR(60) NOT NULL ,
  `guestemail` VARCHAR(255) NOT NULL ,
  `comment` TEXT NOT NULL ,
  PRIMARY KEY (`OID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;