Subversion Repositories SmartDukaan

UPDATE auth.menu
SET display_text = 'Lead Visits'
WHERE action_class = 'visit-approvals';

ALTER TABLE user.beat
    ADD UNIQUE KEY uk_beat_user_name (auth_user_id, name);

INSERT INTO auth.menu (display_text, description, parent_menu_id, sequence, action_class)
VALUES ('Beat Day View', 'View all beats running for a user on a date', 175, 6, 'beat-plan-dayview');

INSERT INTO auth.menu (display_text, description, parent_menu_id, sequence, action_class)
VALUES ('Base Location', 'Manage auth user base/home locations', 175, 7, 'base-location');


ALTER TABLE user.auth_user_location
    ADD COLUMN is_default TINYINT(1) NOT NULL DEFAULT 0;

UPDATE user.auth_user_location ul
    INNER JOIN (SELECT auth_user_id, MAX(id) AS max_id
                FROM user.auth_user_location
                WHERE location_type = 'BASE'
                GROUP BY auth_user_id) latest ON ul.id = latest.max_id
SET ul.is_default = 1
WHERE ul.location_type = 'BASE';

-- Optional helper index
CREATE INDEX idx_aul_user_type_default
    ON user.auth_user_location (auth_user_id, location_type, is_default);


#new update 0n 27

ALTER TABLE user.beat_route
    ADD COLUMN distance_from_prev_km DOUBLE NULL AFTER active,
    ADD COLUMN time_from_prev_mins   INT    NULL AFTER distance_from_prev_km;