Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `bank` (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(512) NOT NULL,
- `slug` VARCHAR(255) NOT NULL,
- `main_branch` INT(10) UNSIGNED NULL DEFAULT NULL,
- `total_branches` INT(10) UNSIGNED NOT NULL DEFAULT '0',
- `fdic_insurance` DATE NULL DEFAULT NULL,
- `fdic_certificate` INT(11) NULL DEFAULT NULL,
- `holden_by` TINYTEXT NOT NULL,
- `charter_class` TINYTEXT NOT NULL,
- `website` VARCHAR(1024) NOT NULL,
- `total_assets` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
- `seo_title` TEXT NOT NULL,
- `seo_description` TEXT NOT NULL,
- `established` DATE NULL DEFAULT NULL,
- `is_published` TINYINT(1) NOT NULL DEFAULT '0',
- `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `updated_at` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- INDEX `bank_location_fk` (`main_branch`),
- INDEX `total_branches` (`total_branches`),
- INDEX `slug` (`slug`) USING HASH,
- FULLTEXT INDEX `name` (`name`),
- CONSTRAINT `bank_location_fk` FOREIGN KEY (`main_branch`) REFERENCES `branch` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
- )
- COLLATE='utf8_general_ci'
- ENGINE=InnoDB
- AUTO_INCREMENT=5709
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement