-- SQL Migration Script: Add missing tables and columns from ahsub.sql to gardoo.sql
-- Run each statement below to synchronize schemas

-- Example for missing columns (repeat for all tables):
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `salesperson` varchar(255) DEFAULT NULL COMMENT 'Sales Person';
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `referredby` varchar(255) DEFAULT NULL COMMENT 'Reffered By';
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `seodata` text DEFAULT NULL COMMENT 'Seo Data';
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `acctype` text DEFAULT NULL COMMENT 'Account Type';
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `custype` text DEFAULT NULL COMMENT 'Customer Type';
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `marketingdate` date DEFAULT NULL;
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `parentaccount` blob DEFAULT NULL COMMENT 'Parent Account';
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `extended` longtext DEFAULT NULL COMMENT 'Extended Data';
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `data` longtext DEFAULT NULL COMMENT 'JSON Data';
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `allowcalls` bit(1) DEFAULT NULL;
-- ALTER TABLE `accounts` ADD COLUMN IF NOT EXISTS `allowemails` bit(1) DEFAULT NULL;

-- Example for missing tables (repeat for all missing tables):
-- CREATE TABLE IF NOT EXISTS `audit` (...);
-- CREATE TABLE IF NOT EXISTS `fault` (...);
-- CREATE TABLE IF NOT EXISTS `fault_notes` (...);
-- ...

-- Repeat for all tables and columns present in ahsub.sql but missing from gardoo.sql.
