GF
Erro ao rodar script sql (permission.ini) no Mysql Workbench!
Boa tarde !
preciso da solução! estou rodando no Mysql Workbench o sql de permissão so que esta dando erro !
Algum pode me ajudar ?
-- Creator: MySQL Workbench 5.2.37/ExportPostgres plugin 2009.12.02
-- Author: Administrador
-- Caption: New Model
-- Project: Name of the project
-- Changed: 2014-03-15 23:44
-- Created: 2014-03-15 23:37
-- Schema: mydb
BEGIN;
CREATE TABLE system_group(
id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100)
);
CREATE TABLE system_program(
id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100),
controller VARCHAR(100)
);
CREATE TABLE system_user(
id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100),
login VARCHAR(100),
password VARCHAR(100),
email VARCHAR(100),
frontpage_id INTEGER NOT NULL,
CONSTRAINT fk_system_user_system_program1
FOREIGN KEY(frontpage_id)
REFERENCES system_program(id)
);
CREATE INDEX system_user_fk_system_user_system_program1 ON system_user(frontpage_id);
CREATE TABLE system_user_group(
id INTEGER PRIMARY KEY NOT NULL,
system_user_id INTEGER NOT NULL,
system_group_id INTEGER NOT NULL,
CONSTRAINT fk_system_user_has_system_group_system_user
FOREIGN KEY(system_user_id)
REFERENCES system_user(id),
CONSTRAINT fk_system_user_has_system_group_system_group1
FOREIGN KEY(system_group_id)
REFERENCES system_group(id)
);
CREATE INDEX system_user_group_fk_system_user_has_system_group_system_group1 ON system_user_group(system_group_id);
CREATE INDEX system_user_group_fk_system_user_has_system_group_system_user ON system_user_group(system_user_id);
CREATE TABLE system_group_program(
id INTEGER PRIMARY KEY NOT NULL,
system_group_id INTEGER NOT NULL,
system_program_id INTEGER NOT NULL,
CONSTRAINT fk_system_group_has_system_program_system_group1
FOREIGN KEY(system_group_id)
REFERENCES system_group(id),
CONSTRAINT fk_system_group_has_system_program_system
FOREIGN KEY(system_program_id)
REFERENCES system_program(id)
);
CREATE INDEX system_group_program_fk_system_group_has_system ON system_group_program(system_program_id);
CREATE INDEX system_group_program_fk_system_group_has_system_group1 ON system_group_program(system_group_id);
CREATE TABLE system_user_program(
id INTEGER PRIMARY KEY NOT NULL,
system_user_id INTEGER NOT NULL,
system_program_id INTEGER NOT NULL,
CONSTRAINT fk_system_user_has_system_program_system_user1
FOREIGN KEY(system_user_id)
REFERENCES system_user(id),
CONSTRAINT fk_system_user_has_system_program_system_program1
FOREIGN KEY(system_program_id)
REFERENCES system_program(id)
);
CREATE INDEX system_user_program_fk_system_user_has_system_program_system ON system_user_program(system_program_id);
CREATE INDEX system_user_program_fk_system_user_has_system_program_system_user1 ON system_user_program(system_user_id);
preciso da solução! estou rodando no Mysql Workbench o sql de permissão so que esta dando erro !
Algum pode me ajudar ?
-- Creator: MySQL Workbench 5.2.37/ExportPostgres plugin 2009.12.02
-- Author: Administrador
-- Caption: New Model
-- Project: Name of the project
-- Changed: 2014-03-15 23:44
-- Created: 2014-03-15 23:37
-- Schema: mydb
BEGIN;
CREATE TABLE system_group(
id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100)
);
CREATE TABLE system_program(
id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100),
controller VARCHAR(100)
);
CREATE TABLE system_user(
id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100),
login VARCHAR(100),
password VARCHAR(100),
email VARCHAR(100),
frontpage_id INTEGER NOT NULL,
CONSTRAINT fk_system_user_system_program1
FOREIGN KEY(frontpage_id)
REFERENCES system_program(id)
);
CREATE INDEX system_user_fk_system_user_system_program1 ON system_user(frontpage_id);
CREATE TABLE system_user_group(
id INTEGER PRIMARY KEY NOT NULL,
system_user_id INTEGER NOT NULL,
system_group_id INTEGER NOT NULL,
CONSTRAINT fk_system_user_has_system_group_system_user
FOREIGN KEY(system_user_id)
REFERENCES system_user(id),
CONSTRAINT fk_system_user_has_system_group_system_group1
FOREIGN KEY(system_group_id)
REFERENCES system_group(id)
);
CREATE INDEX system_user_group_fk_system_user_has_system_group_system_group1 ON system_user_group(system_group_id);
CREATE INDEX system_user_group_fk_system_user_has_system_group_system_user ON system_user_group(system_user_id);
CREATE TABLE system_group_program(
id INTEGER PRIMARY KEY NOT NULL,
system_group_id INTEGER NOT NULL,
system_program_id INTEGER NOT NULL,
CONSTRAINT fk_system_group_has_system_program_system_group1
FOREIGN KEY(system_group_id)
REFERENCES system_group(id),
CONSTRAINT fk_system_group_has_system_program_system
FOREIGN KEY(system_program_id)
REFERENCES system_program(id)
);
CREATE INDEX system_group_program_fk_system_group_has_system ON system_group_program(system_program_id);
CREATE INDEX system_group_program_fk_system_group_has_system_group1 ON system_group_program(system_group_id);
CREATE TABLE system_user_program(
id INTEGER PRIMARY KEY NOT NULL,
system_user_id INTEGER NOT NULL,
system_program_id INTEGER NOT NULL,
CONSTRAINT fk_system_user_has_system_program_system_user1
FOREIGN KEY(system_user_id)
REFERENCES system_user(id),
CONSTRAINT fk_system_user_has_system_program_system_program1
FOREIGN KEY(system_program_id)
REFERENCES system_program(id)
);
CREATE INDEX system_user_program_fk_system_user_has_system_program_system ON system_user_program(system_program_id);
CREATE INDEX system_user_program_fk_system_user_has_system_program_system_user1 ON system_user_program(system_user_id);
Veja este link
www.adianti.com.br/forum/pt/view_1960?script-mysql-
Jovem tenta com este scritp:
-- MySQL Workbench Forward Engineering
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,ALLOW_INVALID_DATES';
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
USE `mydb` ;
-- -----------------------------------------------------
-- Table `mydb`.`system_access_log`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`system_access_log` (
`id` INT(11) NOT NULL,
`sessionid` TEXT NULL DEFAULT NULL,
`login` TEXT NULL DEFAULT NULL,
`login_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`logout_time` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `mydb`.`system_change_log`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`system_change_log` (
`id` INT(11) NOT NULL,
`logdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`login` TEXT NULL DEFAULT NULL,
`tablename` TEXT NULL DEFAULT NULL,
`primarykey` TEXT NULL DEFAULT NULL,
`pkvalue` TEXT NULL DEFAULT NULL,
`operation` TEXT NULL DEFAULT NULL,
`columnname` TEXT NULL DEFAULT NULL,
`oldvalue` TEXT NULL DEFAULT NULL,
`newvalue` TEXT NULL DEFAULT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `mydb`.`system_group`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`system_group` (
`id` INT(11) NOT NULL,
`name` VARCHAR(100) NULL DEFAULT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `mydb`.`system_program`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`system_program` (
`id` INT(11) NOT NULL,
`name` VARCHAR(100) NULL DEFAULT NULL,
`controller` VARCHAR(100) NULL DEFAULT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `mydb`.`system_group_program`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`system_group_program` (
`id` INT(11) NOT NULL,
`system_group_id` INT(11) NULL DEFAULT NULL,
`system_program_id` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `system_group_id` (`system_group_id` ASC),
INDEX `system_program_id` (`system_program_id` ASC),
CONSTRAINT `system_group_program_ibfk_1`
FOREIGN KEY (`system_group_id`)
REFERENCES `mydb`.`system_group` (`id`),
CONSTRAINT `system_group_program_ibfk_2`
FOREIGN KEY (`system_program_id`)
REFERENCES `mydb`.`system_program` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `mydb`.`system_sql_log`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`system_sql_log` (
`id` INT(11) NOT NULL,
`logdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`login` TEXT NULL DEFAULT NULL,
`database_name` TEXT NULL DEFAULT NULL,
`sql_command` TEXT NULL DEFAULT NULL,
`statement_type` TEXT NULL DEFAULT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `mydb`.`system_user`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`system_user` (
`id` INT(11) NOT NULL,
`name` VARCHAR(100) NULL DEFAULT NULL,
`login` VARCHAR(100) NULL DEFAULT NULL,
`password` VARCHAR(100) NULL DEFAULT NULL,
`email` VARCHAR(100) NULL DEFAULT NULL,
`frontpage_id` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `frontpage_id` (`frontpage_id` ASC),
CONSTRAINT `system_user_ibfk_1`
FOREIGN KEY (`frontpage_id`)
REFERENCES `mydb`.`system_program` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `mydb`.`system_user_group`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`system_user_group` (
`id` INT(11) NOT NULL,
`system_user_id` INT(11) NULL DEFAULT NULL,
`system_group_id` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `system_user_id` (`system_user_id` ASC),
INDEX `system_group_id` (`system_group_id` ASC),
CONSTRAINT `system_user_group_ibfk_1`
FOREIGN KEY (`system_user_id`)
REFERENCES `mydb`.`system_user` (`id`),
CONSTRAINT `system_user_group_ibfk_2`
FOREIGN KEY (`system_group_id`)
REFERENCES `mydb`.`system_group` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `mydb`.`system_user_program`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`system_user_program` (
`id` INT(11) NOT NULL,
`system_user_id` INT(11) NULL DEFAULT NULL,
`system_program_id` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `system_user_id` (`system_user_id` ASC),
INDEX `system_program_id` (`system_program_id` ASC),
CONSTRAINT `system_user_program_ibfk_1`
FOREIGN KEY (`system_user_id`)
REFERENCES `mydb`.`system_user` (`id`),
CONSTRAINT `system_user_program_ibfk_2`
FOREIGN KEY (`system_program_id`)
REFERENCES `mydb`.`system_program` (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
onde tem mydb mude para o nome do teu banco
Para quem desejar no link o script para o banco de dados "permission" em MySQL, funcionando para o Template do Adianti 7.1
https://github.com/bjverde/adianti-template/blob/master/documents/changelog_fork.md