Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `branch` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `bank_id` int(10) unsigned NOT NULL,
- `city_id` bigint(20) unsigned NOT NULL,
- `slug` varchar(255) NOT NULL,
- `name` varchar(512) NOT NULL,
- `location` varchar(512) DEFAULT NULL,
- `postal_code` varchar(10) DEFAULT NULL,
- `phone` varchar(512) DEFAULT NULL,
- `seo_title` text NOT NULL,
- `seo_description` text NOT NULL,
- `branch_deposit` bigint(20) unsigned DEFAULT NULL,
- `established` date DEFAULT NULL,
- `working_hours` tinytext DEFAULT NULL,
- `is_published` bit(1) NOT NULL DEFAULT b'0',
- `created_at` datetime NOT NULL DEFAULT current_timestamp(),
- `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp(),
- PRIMARY KEY (`id`),
- KEY `location_city_fk_idx` (`city_id`),
- KEY `branch_deposit` (`branch_deposit`),
- KEY `index_slug` (`slug`) USING HASH,
- KEY `name_idx` (`name`) USING BTREE,
- KEY `location_bank_fk_idx` (`bank_id`) USING HASH,
- KEY `postal_code` (`postal_code`) USING HASH,
- CONSTRAINT `location_bank_fk` FOREIGN KEY (`bank_id`) REFERENCES `bank` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT `location_city_fk` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=163981 DEFAULT CHARSET=utf8
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement