Advertisement
Guest User

Untitled

a guest
Feb 10th, 2018
257
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.13 KB | None | 0 0
  1. CREATE TABLE `bank` (
  2.     `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  3.     `name` VARCHAR(512) NOT NULL,
  4.     `slug` VARCHAR(255) NOT NULL,
  5.     `main_branch` INT(10) UNSIGNED NULL DEFAULT NULL,
  6.     `total_branches` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  7.     `fdic_insurance` DATE NULL DEFAULT NULL,
  8.     `fdic_certificate` INT(11) NULL DEFAULT NULL,
  9.     `holden_by` TINYTEXT NOT NULL,
  10.     `charter_class` TINYTEXT NOT NULL,
  11.     `website` VARCHAR(1024) NOT NULL,
  12.     `total_assets` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
  13.     `seo_title` TEXT NOT NULL,
  14.     `seo_description` TEXT NOT NULL,
  15.     `established` DATE NULL DEFAULT NULL,
  16.     `is_published` TINYINT(1) NOT NULL DEFAULT '0',
  17.     `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  18.     `updated_at` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  19.     PRIMARY KEY (`id`),
  20.     INDEX `bank_location_fk` (`main_branch`),
  21.     INDEX `total_branches` (`total_branches`),
  22.     INDEX `slug` (`slug`) USING HASH,
  23.     FULLTEXT INDEX `name` (`name`),
  24.     CONSTRAINT `bank_location_fk` FOREIGN KEY (`main_branch`) REFERENCES `branch` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
  25. )
  26. COLLATE='utf8_general_ci'
  27. ENGINE=InnoDB
  28. AUTO_INCREMENT=5709
  29. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement