Gii for advanced template not creating relationship

[ashunigam]

What steps will reproduce the problem?

• Set operating system Ubuntu 16.04.3 LTS
• mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper
• PHP 7.0.22-0ubuntu0.16.04.1 (cli) ( NTS )
• Server version: Apache/2.4.18 (Ubuntu) Server built: 2017-07-27T14:34:01
• create database using the sql at the end and setup relations as explained in the comments there.
• download yii from https://github.com/yiisoft/yii2/releases/download/2.0.12/yii-advanced-app-2.0.12.tgz and setup
• Follow this video tutorial to setup the model: https://www.youtube.com/watch?v=aSvxwwjaY2U&list=PLRd0zhQj3CBmusDbBzFgg3H20VxLx2mkF&index=9

What's expected?

A relationship code as happens in the video

What do you get instead?

no relationship function created for department and branches.

Additional info

sql to create database:
-- phpMyAdmin SQL Dump
-- version 4.5.4.1deb2ubuntu2
-- http://www.phpmyadmin.net

-- Host: localhost
-- Generation Time: Sep 13, 2017 at 10:20 AM
-- Server version: 5.7.19-0ubuntu0.16.04.1
-- PHP Version: 7.0.22-0ubuntu0.16.04.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!40101 SET NAMES utf8mb4 */;

--
-- Database: advanced_yii2

CREATE DATABASE IF NOT EXISTS advanced_yii2 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE advanced_yii2;

---

--
-- Table structure for table branches

CREATE TABLE IF NOT EXISTS branches (
branch_id int(11) NOT NULL AUTO_INCREMENT,
companies_company_id int(11) NOT NULL,
branch_name varchar(100) NOT NULL,
branch_address varchar(255) NOT NULL,
branch_created_date datetime NOT NULL,
branch_status enum('active','inactive') NOT NULL,
PRIMARY KEY (branch_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS FOR TABLE branches:
-- companies_company_id
-- companies -> company_id

---

--
-- Table structure for table companies

CREATE TABLE IF NOT EXISTS companies (
company_id int(11) NOT NULL AUTO_INCREMENT,
company_name varchar(100) NOT NULL,
company_email varchar(100) NOT NULL,
company_address varchar(255) NOT NULL,
company_created_date datetime NOT NULL,
company_status enum('active','inactive') NOT NULL,
PRIMARY KEY (company_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS FOR TABLE companies:

---

--
-- Table structure for table departments

CREATE TABLE IF NOT EXISTS departments (
department_id int(11) NOT NULL AUTO_INCREMENT,
branches_branch_id int(11) NOT NULL,
department_name varchar(100) NOT NULL,
companies_company_id int(11) NOT NULL,
department_created_date datetime NOT NULL,
department_status enum('active','inactive') NOT NULL,
PRIMARY KEY (department_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS FOR TABLE departments:
-- branches_branch_id
-- branches -> branch_id
-- companies_company_id
-- companies -> company_id

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

UPDATE

I used internal relation in place of foreign key in above case. Thats the reason in sql dump I am getting relation in commented form. So if internal relation is not supposed to be treated as foreign key then code is working as expected. Once I check it with foreign key, I will update the comment and close this ticket.

[samdark]

Good report. Thanks.

[Chi-G]

Kindly show how to write the script for RELATION BTW Branches and Departments table?

ALTER TABLE departments ADD FOREIGN KEY (branches_branch_id) REFERENCES advanced_yii2.branches (branch_id) ON DELETE RESTRICT ON UPDATE RESTRICT

I'm using the above script and it's throwing an SQL no database error