Add Settings at Head Office

SELECT * FROM system_settings
WHERE token_name = 'Web Bookings';

SELECT * FROM practice_settings
WHERE token_name = 'Web Bookings';

SELECT * FROM staff_settings
WHERE token_name = 'Web Bookings';

DESC practice_settings;

INSERT INTO practice_settings
VALUES
(
999, 999, ocu_Get_primary_key( 999, 'PRACTICE_SETTINGS'), 'Diary', 'Web Bookings',
NULL, 1, 22, 31040000, 0,
34359738368*999+1, 0, NULL
);

-- 34325378629633


SELECT MIN( STAFF_TYPE_ID )
        --INTO   StaffMemberID
        FROM   RL_STAFF_TYPES
        WHERE  PRACTICE_ID = 999;

DESC staff_settings;

INSERT INTO staff_settings
VALUES
(
999, 999, ocu_Get_primary_key( 999, 'STAFF_SETTINGS'), 34325378629633, 'Diary',
'Web Bookings', NULL, 1, 22, 31040000,
0, 34359738368*999+1, 0, NULL
);