samaj_data.sql

CREATE TABLE `test`.`samaj_data` (
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `name` VARCHAR(100) NOT NULL,
    `address` TEXT NULL,
    `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
    `state_id` INT UNSIGNED NOT NULL DEFAULT '0',
    `dist_id` INT UNSIGNED NOT NULL DEFAULT '0',
    `sub_dist_id` INT UNSIGNED NOT NULL DEFAULT '0',
    `city_id` INT UNSIGNED NOT NULL DEFAULT '0',
    `pin_code` VARCHAR(6) NULL DEFAULT NULL,
    `digipin`  VARCHAR(10) NULL DEFAULT NULL,
    `google_map_url` VARCHAR(255) NULL DEFAULT NULL,
    `created_by` INT UNSIGNED NOT NULL DEFAULT '0',
    `updated_by` INT UNSIGNED NOT NULL DEFAULT '0',
    `created_at` DATETIME NOT NULL,
    `updated_at` DATETIME NULL DEFAULT NULL,
    `deleted_at` DATETIME NULL DEFAULT NULL,

    INDEX `idx_status` (`status`),
    INDEX `idx_state_id` (`state_id`),
    INDEX `idx_dist_id` (`dist_id`),
    INDEX `idx_sub_dist_id` (`sub_dist_id`),
    INDEX `idx_city_id` (`city_id`),
    INDEX `idx_pin_code` (`pin_code`),
    INDEX `idx_status_location` (`status`, `state_id`, `dist_id`, `city_id`),
    INDEX `idx_created_by` (`created_by`),
    INDEX `idx_updated_by` (`updated_by`),
    INDEX `idx_created_at` (`created_at`),
    INDEX `idx_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE gotras (
    id INT AUTO_INCREMENT PRIMARY KEY,
    gotra_name VARCHAR(100) NOT NULL,
    gotra_name_guj VARCHAR(100),
    gotra_name_hin VARCHAR(100),
    created_at TIMESTAMP NULL DEFAULT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO gotras (gotra_name, gotra_name_guj, gotra_name_hin) VALUES
('Bharadwaj', 'ભારદ્વાજ', 'भारद्वाज'),
('Kashyap', 'કશ્યપ', 'कश्यप'),
('Vashishtha', 'વશિષ્ઠ', 'वशिष्ठ'),
('Gautam', 'ગૌતમ', 'गौतम'),
('Atri', 'અત્રિ', 'अत्रि'),
('Agastya', 'અગસ્ત્ય', 'अगस्त्य'),
('Shandilya', 'શાંદિલ્ય', 'शांदिल्य');