Issue SQL

CREATE TABLE `cities` (
  `ID` int(11) NOT NULL,
  `NAME` varchar(30) NOT NULL,
  `STATE_ID` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `countries` (
  `ID` int(11) NOT NULL,
  `SORTNAME` varchar(3) NOT NULL,
  `NAME` varchar(150) NOT NULL,
  `PHONECODE` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `country` (
  `ID` int(11) NOT NULL,
  `ISO` char(2) NOT NULL,
  `NAME` varchar(80) NOT NULL,
  `NICENAME` varchar(80) NOT NULL,
  `ISO3` char(3) DEFAULT NULL,
  `NUMCODE` smallint(6) DEFAULT NULL,
  `PHONECODE` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `accounts` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `USERNAME` TEXT NOT NULL,
  `FIRST_NAME` TEXT NOT NULL,
  `LAST_NAME` TEXT NOT NULL,
  `PASSWORD` CHAR(255) NOT NULL,
  `BIRTH_YEAR` TINYINT NOT NULL,
  `BIRTH_MONTH` TINYINT NOT NULL,
  `BIRTH_DAY` TINYINT NOT NULL,
  `STATUS` INT NOT NULL DEFAULT 1,
  `CREATION` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT PK_ACCOUNTS PRIMARY KEY(`ID`)
) ENGINE=InnoDB CHARSET=utf8;

CREATE TABLE `email` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `ACCOUNT` INT(11) NOT NULL,
  `PRIMARY` BOOLEAN NOT NULL DEFAULT FALSE,
  `EMAIL` TEXT NOT NULL,
  `STATUS` INT NOT NULL DEFAULT 1,
  `CREATION` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT PK_EMAIL PRIMARY KEY(`ID`),
  CONSTRAINT FK_EMAIL_ACCOUNT FOREIGN KEY(`ACCOUNT`) REFERENCES accounts(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB CHARSET=utf8;

CREATE TABLE `phone` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `PRIMARY` BOOLEAN NOT NULL DEFAULT FALSE,
  `ACCOUNT` INT(11) NOT NULL,
  `NUMBER_EXT` INT(11) NOT NULL,
  `NUMBER` VARCHAR(20) NOT NULL,
  `STATUS` INT NOT NULL DEFAULT 1,
  `CREATION` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT PK_PHONE PRIMARY KEY(`ID`),
  CONSTRAINT FK_PHONE_ACCOUNT FOREIGN KEY(`ACCOUNT`) REFERENCES accounts(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT FK_PHONE_COUNTRYCODE FOREIGN KEY(`NUMBER_EXT`) REFERENCES country(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB CHARSET=utf8;

CREATE TABLE `network` (
    `ID` INT(11) NOT NULL AUTO_INCREMENT,
    `ADDRESS` TEXT NOT NULL,
    `PROHIBITED` BOOLEAN NOT NULL DEFAULT FALSE,
    `CREATION` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT PK_NETWORK PRIMARY KEY(`ID`)
) ENGINE=InnoDB CHARSET=utf8;

CREATE TABLE `account_network` (
    `ID` INT(11) NOT NULL AUTO_INCREMENT,
    `ACCOUNT` INT(11) NOT NULL,
    `NETWORK` INT(11) NOT NULL,
    `CREATION` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT PK_ACCOUNT_NETWORK PRIMARY KEY(`ID`),
    CONSTRAINT FK_ACCOUNT_NETWORK_ACCOUNT FOREIGN KEY(`ACCOUNT`) REFERENCES account(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT,
    CONSTRAINT FK_ACCOUNT_NETWORK_NETWORK FOREIGN KEY(`NETWORK`) REFERENCES network(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB CHARSET=utf8;

CREATE TABLE `session_history` (
    `ID` INT(11) NOT NULL AUTO_INCREMENT,
    `ACCOUNT` INT(11) NOT NULL,
    `NETWORK` INT(11) NOT NULL,
    `SESSION` INT(11) NOT NULL,
    `TIME` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT PK_SESSION_HISTORY PRIMARY KEY(`ID`),
    CONSTRAINT FK_SESSION_HISTORY_ACCOUNT FOREIGN KEY(`ACCOUNT`) REFERENCES account(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT,
    CONSTRAINT FK_SESSION_HISTORY_SESSION FOREIGN KEY(`SESSION`) REFERENCES session(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB CHARSET=utf8;

CREATE TABLE `session` (
    `ID` INT(11) NOT NULL AUTO_INCREMENT,
    `ACCOUNT` INT(11) NOT NULL,
    `TOKEN` TEXT NOT NULL,
    `NETWORK` INT(11) NOT NULL,
    `STATUS` INT NOT NULL DEFAULT 1,
    `CREATION` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT PK_SESSION PRIMARY KEY(`ID`),
    CONSTRAINT FK_SESSION_NETWORK FOREIGN KEY(`NETWORK`) REFERENCES network(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT,
    CONSTRAINT FK_SESSION_ACCOUNT FOREIGN KEY(`ACCOUNT`) REFERENCES account(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB CHARSET=utf8;

CREATE TABLE `address` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `ACCOUNT` INT(11) NOT NULL,
  `PRIMARY` BOOLEAN NOT NULL DEFAULT FALSE,
  `ADDRESS` TEXT NOT NULL,
  `COUNTRY` INT(11) NOT NULL,
  `STATE` INT(11) NOT NULL,
  `CITY` INT(11) NOT NULL,
  `ZIP` VARCHAR(10) NOT NULL,
  `STATUS` INT NOT NULL DEFAULT 1,
  `CREATION` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT PK_ADDRESS PRIMARY KEY(`ID`),
  CONSTRAINT FK_ADDRESS_ACCOUNT FOREIGN KEY(`ACCOUNT`) REFERENCES accounts(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT FK_ADDRESS_COUNTRY FOREIGN KEY(`COUNTRY`) REFERENCES country(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT FK_ADDRESS_STATE FOREIGN KEY(`STATE`) REFERENCES states(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT FK_ADDRESS_CITY FOREIGN KEY(`CITY`) REFERENCES cities(`ID`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB CHARSET=utf8;