We need to convert the following SQL into a Schema structure.

-- -----------------------------------------------------
-- Table `pear`.`pear_channel`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pear`.`pear_channel` (
`cid` BIGINT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(255) NOT NULL ,
`suggestedalias` VARCHAR(255) NOT NULL ,
`summary` TEXT NOT NULL DEFAULT 'No summary was provided.' ,
PRIMARY KEY (`cid`) )
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `pear`.`pear_license`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pear`.`pear_license` (
`lid` BIGINT NOT NULL AUTO_INCREMENT ,
`license` VARCHAR(255) NOT NULL ,
`uri` VARCHAR(255) NOT NULL ,
PRIMARY KEY (`lid`) )
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `pear`.`pear_package`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pear`.`pear_package` (
`pid` BIGINT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(255) NOT NULL ,
`cid` BIGINT NOT NULL ,
`summary` TEXT NOT NULL DEFAULT 'No summary provided.' ,
`description` LONGTEXT NOT NULL DEFAULT 'No description provided.' ,
`date` DATETIME NOT NULL ,
`version` VARCHAR(45) NOT NULL ,
`stability` VARCHAR(45) NULL ,
`lid` BIGINT NOT NULL ,
PRIMARY KEY (`pid`) ,
INDEX cid (`cid` ASC) ,
INDEX lid (`lid` ASC) ,
CONSTRAINT `cid`
FOREIGN KEY (`cid` )
REFERENCES `pear`.`pear_channel` (`cid` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `lid`
FOREIGN KEY (`lid` )
REFERENCES `pear`.`pear_license` (`lid` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `pear`.`pear_settings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pear`.`pear_settings` (
`path` VARCHAR(255) NOT NULL ,
`stability` VARCHAR(45) NOT NULL DEFAULT 'stable' ,
PRIMARY KEY (`path`) )
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `pear`.`pear_server`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pear`.`pear_server` (
`sid` BIGINT NOT NULL AUTO_INCREMENT ,
`cid` BIGINT NOT NULL ,
`miror` BOOLEAN NOT NULL DEFAULT FALSE ,
`host` VARCHAR(255) NOT NULL ,
`port` INT NOT NULL DEFAULT 80 ,
`ssl` BOOLEAN NOT NULL DEFAULT FALSE ,
PRIMARY KEY (`sid`) ,
INDEX cid (`cid` ASC) ,
CONSTRAINT `cid`
FOREIGN KEY (`cid` )
REFERENCES `pear`.`pear_channel` (`cid` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `pear`.`pear_url`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pear`.`pear_url` (
`uid` BIGINT NOT NULL AUTO_INCREMENT ,
`sid` BIGINT NOT NULL ,
`type` VARCHAR(255) NOT NULL ,
`basurl` VARCHAR(255) NOT NULL ,
`preferred` BOOLEAN NOT NULL DEFAULT FALSE ,
PRIMARY KEY (`uid`) ,
INDEX sid (`sid` ASC) ,
CONSTRAINT `sid`
FOREIGN KEY (`sid` )
REFERENCES `pear`.`pear_server` (`sid` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `pear`.`pear_update`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pear`.`pear_update` (
`uid` BIGINT NOT NULL AUTO_INCREMENT ,
`pid` BIGINT NOT NULL ,
`version` VARCHAR(45) NOT NULL ,
`stability` VARCHAR(45) NOT NULL ,
PRIMARY KEY (`uid`) ,
INDEX pid (`pid` ASC) ,
CONSTRAINT `pid`
FOREIGN KEY (`pid` )
REFERENCES `pear`.`pear_package` (`pid` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

CommentFileSizeAuthor
peardb.png33.42 KBmepcotterell

Comments

mepcotterell’s picture

Assigned: Unassigned » mepcotterell
Status: Active » Closed (fixed)

Used the Schema module to easily do this.