mysql - Error #1215 - Cannot add foreign key constraint -


i have generated sql script mysql workbench.

when try create database have "error 1215 1215 - cannot add foreign key constraint".

the problem seems last foreign key in last create table : 

constraint `fk_tb_animation_option_col_debut` foreign key (`dt_ano_debut`) references `brest2016`.`tb_animation_option` (`dt_ano_debut`) on delete no action on update no action)

this entire script:

-- mysql script generated mysql workbench -- 01/16/16 00:46:22 -- model: new model    version: 1.0 -- 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 brest2016 -- ----------------------------------------------------- create schema if not exists `brest2016` default character set utf8 ; use `brest2016` ;  -- ----------------------------------------------------- -- table `brest2016`.`tb_visiteur` -- ----------------------------------------------------- create table if not exists `brest2016`.`tb_visiteur` (   `d_vi_code` int(3) not null auto_increment,   `v_vi_nom` varchar(45) not null,   `v_vi_prenom` varchar(45) not null,   `v_vi_email` varchar(45) not null,   `v_vi_telephone` varchar(45) null,   `dt_vi_debut` datetime not null,   `dt_vi_fin` datetime not null,   primary key (`d_vi_code`),   unique index `idvisiteur_unique` (`d_vi_code` asc),   unique index `email_unique` (`v_vi_email` asc)) engine = innodb;   -- ----------------------------------------------------- -- table `brest2016`.`tb_type_animation` -- ----------------------------------------------------- create table if not exists `brest2016`.`tb_type_animation` (   `d_ty_code` int(3) not null auto_increment,   `v_ty_libelle` varchar(45) null,   primary key (`d_ty_code`)) engine = innodb;   -- ----------------------------------------------------- -- table `brest2016`.`tb_animation` -- ----------------------------------------------------- create table if not exists `brest2016`.`tb_animation` (   `d_an_code` int(3) not null auto_increment,   `v_an_libelle` varchar(45) not null,   `v_an_lieu` varchar(45) not null,   `v_an_image` varchar(45) null,   `v_an_descriptif` varchar(45) null,   `d_an_priorite` varchar(45) not null,   `d_ty_code` int(3) null,   primary key (`d_an_code`),   unique index `idanimation_unique` (`d_an_code` asc),   index `fk_tb_type_animation_col_code_1_idx` (`d_ty_code` asc),   constraint `fk_tb_type_animation_col_code`     foreign key (`d_ty_code`)     references `brest2016`.`tb_type_animation` (`d_ty_code`)     on delete no action     on update no action) engine = innodb;   -- ----------------------------------------------------- -- table `brest2016`.`tb_option` -- ----------------------------------------------------- create table if not exists `brest2016`.`tb_option` (   `d_op_code` int(3) not null auto_increment,   `v_op_libelle` varchar(45) not null,   primary key (`d_op_code`),   unique index `idoption_unique` (`d_op_code` asc)) engine = innodb;   -- ----------------------------------------------------- -- table `brest2016`.`tb_animation_option` -- ----------------------------------------------------- create table if not exists `brest2016`.`tb_animation_option` (   `d_an_code` int(3) not null,   `d_op_code` int(3) not null,   `dt_ano_debut` datetime not null,   `dt_ano_fin` datetime not null,   `d_ano_places_max` int(3) not null,   `d_ano_duree` int(3) not null,   primary key (`d_an_code`, `d_op_code`, `dt_ano_debut`),   index `fk_tb_option_idx` (`d_op_code` asc),   constraint `fk_tb_animation_col_code`     foreign key (`d_an_code`)     references `brest2016`.`tb_animation` (`d_an_code`)     on delete no action     on update no action,   constraint `fk_tb_option_col_code`     foreign key (`d_op_code`)     references `brest2016`.`tb_option` (`d_op_code`)     on delete no action     on update no action) engine = innodb comment = 'association entre une animation et une option';   -- ----------------------------------------------------- -- table `brest2016`.`tb_administrateur` -- ----------------------------------------------------- create table if not exists `brest2016`.`tb_administrateur` (   `d_ad_code` int(3) not null,   `v_ad_id` varchar(12) not null,   `v_ad_mdp` varchar(12) not null,   primary key (`d_ad_code`),   unique index `idadministrateur_unique` (`d_ad_code` asc),   unique index `v_ut_login_unique` (`v_ad_id` asc)) engine = innodb;   -- ----------------------------------------------------- -- table `brest2016`.`tb_reservation` -- ----------------------------------------------------- create table if not exists `brest2016`.`tb_reservation` (   `d_vi_code` int(3) not null,   `d_an_code` int(3) not null,   `d_op_code` int(3) not null,   `dt_ano_debut` datetime not null,   primary key (`d_vi_code`, `d_an_code`, `d_op_code`, `dt_ano_debut`),   index `fk_tb_animation_option_col_code_animation_idx` (`d_an_code` asc),   index `fk_tb_animation_option_col_code_option_idx` (`d_op_code` asc),   index `fk_tb_animation_option_col_debut_idx` (`dt_ano_debut` asc),   constraint `fk_tb_visiteur_col_code`     foreign key (`d_vi_code`)     references `brest2016`.`tb_visiteur` (`d_vi_code`)     on delete no action     on update no action,   constraint `fk_tb_animation_option_col_code_animation`     foreign key (`d_an_code`)     references `brest2016`.`tb_animation_option` (`d_an_code`)     on delete no action     on update no action,   constraint `fk_tb_animation_option_col_code_option`     foreign key (`d_op_code`)     references `brest2016`.`tb_animation_option` (`d_op_code`)     on delete no action     on update no action,   constraint `fk_tb_animation_option_col_debut`     foreign key (`dt_ano_debut`)     references `brest2016`.`tb_animation_option` (`dt_ano_debut`)     on delete no action     on update no action) engine = innodb;   set sql_mode=@old_sql_mode; set foreign_key_checks=@old_foreign_key_checks; set unique_checks=@old_unique_checks;

the column named in foreign key must indexed.

create table if not exists `brest2016`.`tb_animation_option` (   `d_an_code` int(3) not null,   `d_op_code` int(3) not null,   `dt_ano_debut` datetime not null,   `dt_ano_fin` datetime not null,   `d_ano_places_max` int(3) not null,   `d_ano_duree` int(3) not null,   primary key (`d_an_code`, `d_op_code`, `dt_ano_debut`),   index `fk_tb_option_idx` (`d_op_code` asc),   index `dt_ano_debut_idx` (`t_ano_debut`), -- add line   constraint `fk_tb_animation_col_code`     foreign key (`d_an_code`)     references `brest2016`.`tb_animation` (`d_an_code`)     on delete no action     on update no action,   constraint `fk_tb_option_col_code`     foreign key (`d_op_code`)     references `brest2016`.`tb_option` (`d_op_code`)     on delete no action     on update no action) engine = innodb comment = 'association entre une animation et une option';

Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more