Subversion Repositories SmartDukaan

-- Contact-Us directory: backs both the main contact list and the escalations list.
-- Run against the `fofo` schema.
-- The INSERTs below seed the table with the rows currently hard-coded in contact-us.vm.
-- Safe to run once; the CREATE is idempotent but the INSERTs are not (run them only on a fresh table).

CREATE TABLE IF NOT EXISTS fofo.contact_us (
    id           INT AUTO_INCREMENT PRIMARY KEY,
    section      VARCHAR(20)  NOT NULL,                  -- MAIN | ESCALATION
    area         VARCHAR(500),
    base_area    VARCHAR(255),                           -- "Base Area" for MAIN, "Region" for ESCALATION
    name         VARCHAR(255),
    designation  VARCHAR(255),
    mobile       VARCHAR(50),
    email        VARCHAR(255),
    sort_order   INT          NOT NULL DEFAULT 0,
    active       TINYINT(1)   NOT NULL DEFAULT 1,
    created_date DATETIME,
    updated_date DATETIME,
    INDEX idx_contact_us_section_active (section, active, sort_order)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ---------- MAIN contact list ----------
INSERT INTO fofo.contact_us (section, area, base_area, name, designation, mobile, email, sort_order, active, created_date, updated_date) VALUES
('MAIN', 'Haryana', 'Karnal', 'Mohinder Mutreja', 'Branch Manager', '9068018601', 'mohinder.mutreja@smartdukaan.com', 10, 1, NOW(), NOW()),
('MAIN', 'Haryana', 'Jind', 'Mandeep', 'Area Business Manager', '7206032196', 'mandeep@smartdukaan.com', 20, 1, NOW(), NOW()),
('MAIN', 'Punjab', 'Noida', 'Mohit Gulati', 'Branch Manager', '9899500075', 'mohit.gulati@smartdukaan.com', 30, 1, NOW(), NOW()),
('MAIN', 'Punjab', 'Malerkotla', 'Ram Singh', 'Area Sales Manager', '8000005944', 'ram.singh@smartdukaan.com', 40, 1, NOW(), NOW()),
('MAIN', 'Rajasthan, Uttar Pradesh-West, Delhi, Uttarakhand', 'Noida', 'Vishal Chugh', 'Regional Sales Manager', '9799112000', 'vishal.chugh@smartdukaan.com', 50, 1, NOW(), NOW()),
('MAIN', 'Rajasthan', 'Jaipur', 'Ravi Badgujar', 'Dy Branch Manager', '9829828004', 'ravi.badgujar@smartdukaan.com', 60, 1, NOW(), NOW()),
('MAIN', 'Rajasthan', 'Bandikui', 'Manish Kumar Sharma', 'Circle Manager', '9828048849', 'manish.sharma@smartdukaan.com', 70, 1, NOW(), NOW()),
('MAIN', 'Rajasthan', 'Jodhpur', 'Rajneesh Pal', 'Area Sales Manager', '9024776360', 'rajneesh.pal@smartdukaan.com', 80, 1, NOW(), NOW()),
('MAIN', 'Rajasthan', 'Ganganagar', 'Mohit Sharma', 'Area Sales Manager', '7999992151', 'mohit.sharma@smartdukaan.com', 90, 1, NOW(), NOW()),
('MAIN', 'Rajasthan', 'Ajmer', 'Vishal Sharma', 'Circle Manager', '8058000012', 'vishal.sharma@smartdukaan.com', 100, 1, NOW(), NOW()),
('MAIN', 'Uttar Pradesh - West', 'Saharanpur', 'Rahul Bansal', 'Circle Manager', '6398790152', 'rahul.bansal@smartdukaan.com', 110, 1, NOW(), NOW()),
('MAIN', 'Uttar Pradesh - West', 'Bareilly', 'Imran Raza Khan', 'Area Sales Manager', '9358777773', 'imran.khan@smartdukaan.com', 120, 1, NOW(), NOW()),
('MAIN', 'Uttar Pradesh - West', 'Agra', 'Rakesh Kumar', 'Area Sales Manager', '6397753947', 'rakesh.kumar@smartdukaan.com', 130, 1, NOW(), NOW()),
('MAIN', 'Uttar Pradesh - West', 'Meerut', 'Varnit Vashistha', 'Area Sales Manager', '7417000858', 'varnit.vashistha@smartdukaan.com', 140, 1, NOW(), NOW()),
('MAIN', 'Delhi NCR', 'Delhi', 'Mohit', 'Area Sales Manager', '9990999833', 'mohit.meheroliya@smartdukaan.com', 150, 1, NOW(), NOW()),
('MAIN', 'Uttarakhand, Uttar Pradesh-West', 'Dehradun', 'Anoop Kumar', 'Sr Branch Manager', '9056868686', 'anoop.kumar@smartdukaan.com', 160, 1, NOW(), NOW()),
('MAIN', 'Uttarakhand', 'Rudrapur', 'Kapil Rastogi', 'Area Sales Manager', '9719226691', 'kapil.rastogi@smartdukaan.com', 170, 1, NOW(), NOW()),
('MAIN', 'Uttarakhand', 'Roorkee', 'Vinay Kumar Pathak', 'Area Business Manager', '8899299700', 'vinay.pathak@smartdukaan.com', 180, 1, NOW(), NOW()),
('MAIN', 'Uttar Pradesh - East', 'Lucknow', 'Ashish Singh', 'Branch Manager', '7007110092', 'ashish.singh@smartdukaan.com', 190, 1, NOW(), NOW()),
('MAIN', 'Uttar Pradesh - East', 'Gorakhpur', 'Nitesh Jaiswal', 'Area Business Officer', '8924022956', 'nitesh.jaiswal@smartdukaan.com', 200, 1, NOW(), NOW()),
('MAIN', 'Uttar Pradesh - East', 'Lucknow', 'Mohsin Khan', 'Area Business Manager', '9616056596', 'mohsin.khan@smartdukaan.com', 210, 1, NOW(), NOW()),
('MAIN', 'Uttar Pradesh - East', 'Varanasi', 'Anudeep Prakash Anand', 'Area Sales Manager', '8400099000', 'anudeep.anand@smartdukaan.com', 220, 1, NOW(), NOW()),
('MAIN', 'Uttar Pradesh - East', 'Kanpur', 'Ajit Shukla', 'Area Sales Manager', '9935546400', 'ajit.shukla@smartdukaan.com', 230, 1, NOW(), NOW()),
('MAIN', 'Uttar Pradesh - East', 'Prayagraj', 'Himanshu Vishwakarma', 'Area Sales Manager', '9651800400', 'himanshu.vishwakarma@smartdukaan.com', 240, 1, NOW(), NOW());

-- ---------- ESCALATIONS ----------
INSERT INTO fofo.contact_us (section, area, base_area, name, designation, mobile, email, sort_order, active, created_date, updated_date) VALUES
('ESCALATION', 'Delhi NCR, Uttar Pradesh-West, Uttar Pradesh-East, Uttarakhand, Rajasthan, Punjab, Haryana', 'Noida Head Office', 'Aquil Ahmad', 'Business Unit Head', '9030050121', 'aquil.ahmad@smartdukaan.com', 10, 1, NOW(), NOW()),
('ESCALATION', 'Rajasthan', 'Noida Head Office', 'Shikha Sharma', 'RBM', '9582747411', 'shikha.sharma@smartdukaan.com', 20, 1, NOW(), NOW()),
('ESCALATION', 'Haryana, Punjab', 'Noida Head Office', 'Vinay Gupta', 'RBM', '9999809026', 'vinay.gupta@smartdukaan.com', 30, 1, NOW(), NOW()),
('ESCALATION', 'Rajasthan', 'Noida Head Office', 'HariOm Sharma', 'RBM', '9013190101', 'hariom.sharma1@smartdukaan.com', 40, 1, NOW(), NOW()),
('ESCALATION', 'Delhi, NCR, Uttar Pradesh-West', 'Noida Head Office', 'Neha Dubey', 'RBM', '9582889403', 'neha.dubey@smartdukaan.com', 50, 1, NOW(), NOW()),
('ESCALATION', 'Uttar Pradesh-East', 'Noida Head Office', 'Gurmeet Singh', 'RBM', '7011946090', 'gurmeet.singh@smartdukaan.com', 60, 1, NOW(), NOW()),
('ESCALATION', 'Uttar Pradesh-West, Uttarakhand', 'Noida Head Office', 'Nikita Kumari', 'RBM', '8700602893', 'nikita.kumari@smartdukaan.com', 70, 1, NOW(), NOW()),
('ESCALATION', 'Uttar Pradesh-West', 'Noida Head Office', 'Ebadullah Ahmad', 'RBM', '7303819400', 'ebadullah.ahmad@smartdukaan.com', 80, 1, NOW(), NOW()),
('ESCALATION', 'Pan India', 'Noida Head Office', 'Alok Divedi', 'Affordability Operations Manager', '9625392942', 'alok.divedi@smartdukaan.com', 90, 1, NOW(), NOW()),
('ESCALATION', 'Pan India', 'Noida Head Office', 'Charu Sharma', 'Training Manager', '-', 'charu.sharma@smartdukaan.com', 100, 1, NOW(), NOW()),
('ESCALATION', 'North India', 'Noida Head Office', 'Siddharth Chaturvedi', 'Head Of Sales', '-', 'siddharth.chaturvedi@smartdukaan.com', 110, 1, NOW(), NOW()),
('ESCALATION', 'Pan India', 'Noida Head Office', 'Niranjan Kala', 'Chief Procurement Officer', '-', 'niranjan.kala@smartdukaan.com', 120, 1, NOW(), NOW()),
('ESCALATION', 'Pan India', 'Noida Head Office', 'Shankar Mushran', 'Chief-Development and BI', '-', 'sm@smartdukaan.com', 130, 1, NOW(), NOW()),
('ESCALATION', 'Pan India', 'Noida Head Office', 'Santosh Giri', 'VP Finance', '-', 'santosh.giri@smartdukaan.com', 140, 1, NOW(), NOW()),
('ESCALATION', 'Pan India', 'Noida Head Office', 'Rajat Bhardwaj', 'Marketing Manager', '-', 'rajat.bharadwaj@smartdukaan.com', 150, 1, NOW(), NOW()),
('ESCALATION', 'Pan India', 'Noida Head Office', 'Gaurav Mathur', 'Senior Vice President - People & Performance', '-', 'gaurav.mathur1@smartdukaan.com', 160, 1, NOW(), NOW());