◇ injected env (8) from .env // tip: ⌘ custom filepath { path: '/custom/path/.env' }
◇ injected env (0) from .env // tip: ◈ encrypted .env [www.dotenvx.com]
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'users' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `users`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'users' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): ALTER TABLE `users` CHANGE `name` `name` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `users` CHANGE `email` `email` VARCHAR(255) NOT NULL UNIQUE;
Executing (default): ALTER TABLE `users` CHANGE `password_hash` `password_hash` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `users` CHANGE `role` `role` ENUM('admin', 'sales', 'finance', 'legal', 'hr', 'partner') NOT NULL DEFAULT 'sales';
Executing (default): ALTER TABLE `users` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `users` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SHOW INDEX FROM `users`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'branches' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `branches`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'branches' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): ALTER TABLE `branches` CHANGE `name` `name` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `branches` CHANGE `code` `code` VARCHAR(255);
Executing (default): ALTER TABLE `branches` CHANGE `city` `city` VARCHAR(255);
Executing (default): ALTER TABLE `branches` CHANGE `state` `state` VARCHAR(255) DEFAULT 'Tamil Nadu';
Executing (default): ALTER TABLE `branches` CHANGE `manager` `manager` VARCHAR(255);
Executing (default): ALTER TABLE `branches` CHANGE `phone` `phone` VARCHAR(255);
Executing (default): ALTER TABLE `branches` CHANGE `address` `address` VARCHAR(255);
Executing (default): ALTER TABLE `branches` CHANGE `is_head_office` `is_head_office` TINYINT(1) DEFAULT false;
Executing (default): ALTER TABLE `branches` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `branches` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SHOW INDEX FROM `branches`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'projects' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `projects`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'projects' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): ALTER TABLE `projects` CHANGE `name` `name` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `projects` CHANGE `loc` `loc` VARCHAR(255);
Executing (default): ALTER TABLE `projects` CHANGE `approval` `approval` VARCHAR(255);
Executing (default): ALTER TABLE `projects` CHANGE `approval_expiry` `approval_expiry` DATE;
Executing (default): ALTER TABLE `projects` CHANGE `patta` `patta` VARCHAR(255);
Executing (default): ALTER TABLE `projects` CHANGE `ec` `ec` VARCHAR(255);
Executing (default): ALTER TABLE `projects` CHANGE `chitta` `chitta` VARCHAR(255);
Executing (default): ALTER TABLE `projects` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `projects` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `projects` CHANGE `zone` `zone` VARCHAR(255);
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='projects' AND constraint_name = 'projects_ibfk_1' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `projects` DROP FOREIGN KEY `projects_ibfk_1`;
Executing (default): ALTER TABLE `projects` ADD FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SHOW INDEX FROM `projects`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'brokers' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `brokers`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'brokers' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): ALTER TABLE `brokers` CHANGE `name` `name` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `brokers` CHANGE `type` `type` VARCHAR(255);
Executing (default): ALTER TABLE `brokers` CHANGE `commission_rate` `commission_rate` FLOAT;
Executing (default): ALTER TABLE `brokers` CHANGE `leads_referred` `leads_referred` INTEGER DEFAULT 0;
Executing (default): ALTER TABLE `brokers` CHANGE `converted` `converted` INTEGER DEFAULT 0;
Executing (default): ALTER TABLE `brokers` CHANGE `earnings` `earnings` BIGINT DEFAULT 0;
Executing (default): ALTER TABLE `brokers` CHANGE `pending` `pending` BIGINT DEFAULT 0;
Executing (default): ALTER TABLE `brokers` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `brokers` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='brokers' AND constraint_name = 'brokers_ibfk_1' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `brokers` DROP FOREIGN KEY `brokers_ibfk_1`;
Executing (default): ALTER TABLE `brokers` ADD FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SHOW INDEX FROM `brokers`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'leads' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `leads`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'leads' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): ALTER TABLE `leads` CHANGE `name` `name` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `leads` CHANGE `phone` `phone` VARCHAR(255);
Executing (default): ALTER TABLE `leads` CHANGE `budget` `budget` VARCHAR(255);
Executing (default): ALTER TABLE `leads` CHANGE `size` `size` VARCHAR(255);
Executing (default): ALTER TABLE `leads` CHANGE `temp` `temp` ENUM('Hot', 'Warm', 'Cold') DEFAULT 'Cold';
Executing (default): ALTER TABLE `leads` CHANGE `stage` `stage` VARCHAR(255);
Executing (default): ALTER TABLE `leads` CHANGE `allocated_agent` `allocated_agent` VARCHAR(255);
Executing (default): ALTER TABLE `leads` CHANGE `visit_agent` `visit_agent` VARCHAR(255);
Executing (default): ALTER TABLE `leads` CHANGE `finance_agent` `finance_agent` VARCHAR(255);
Executing (default): ALTER TABLE `leads` CHANGE `legal_agent` `legal_agent` VARCHAR(255);
Executing (default): ALTER TABLE `leads` CHANGE `lawyer_status` `lawyer_status` VARCHAR(255);
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='leads' AND constraint_name = 'leads_ibfk_89' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `leads` DROP FOREIGN KEY `leads_ibfk_89`;
Executing (default): ALTER TABLE `leads` ADD FOREIGN KEY (`broker_id`) REFERENCES `brokers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): ALTER TABLE `leads` CHANGE `kyc_aadhaar` `kyc_aadhaar` VARCHAR(255) DEFAULT 'missing';
Executing (default): ALTER TABLE `leads` CHANGE `kyc_pan` `kyc_pan` VARCHAR(255) DEFAULT 'missing';
Executing (default): ALTER TABLE `leads` CHANGE `kyc_photo` `kyc_photo` VARCHAR(255) DEFAULT 'missing';
Executing (default): ALTER TABLE `leads` CHANGE `agreement_draft` `agreement_draft` VARCHAR(255) DEFAULT 'missing';
Executing (default): ALTER TABLE `leads` CHANGE `agreement_signed` `agreement_signed` VARCHAR(255) DEFAULT 'missing';
Executing (default): ALTER TABLE `leads` CHANGE `reg_scheduled` `reg_scheduled` TINYINT(1) DEFAULT false;
Executing (default): ALTER TABLE `leads` CHANGE `reg_step` `reg_step` INTEGER DEFAULT 1;
Executing (default): ALTER TABLE `leads` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `leads` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='leads' AND constraint_name = 'leads_ibfk_90' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `leads` DROP FOREIGN KEY `leads_ibfk_90`;
Executing (default): ALTER TABLE `leads` ADD FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SHOW INDEX FROM `leads`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'plots' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `plots`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'plots' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='plots' AND constraint_name = 'plots_ibfk_141' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `plots` DROP FOREIGN KEY `plots_ibfk_141`;
Executing (default): ALTER TABLE `plots` ADD FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
Executing (default): ALTER TABLE `plots` CHANGE `no` `no` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `plots` CHANGE `status` `status` ENUM('available', 'blocked', 'booked', 'registered', 'hold') NOT NULL DEFAULT 'available';
Executing (default): ALTER TABLE `plots` CHANGE `size` `size` INTEGER;
Executing (default): ALTER TABLE `plots` CHANGE `facing` `facing` VARCHAR(255);
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='plots' AND constraint_name = 'plots_ibfk_142' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `plots` DROP FOREIGN KEY `plots_ibfk_142`;
Executing (default): ALTER TABLE `plots` ADD FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): ALTER TABLE `plots` CHANGE `total_value` `total_value` BIGINT;
Executing (default): ALTER TABLE `plots` CHANGE `reg_date` `reg_date` DATE;
Executing (default): ALTER TABLE `plots` CHANGE `legal_status` `legal_status` VARCHAR(255);
Executing (default): ALTER TABLE `plots` CHANGE `payment_scheme` `payment_scheme` VARCHAR(255);
Executing (default): ALTER TABLE `plots` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `plots` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='plots' AND constraint_name = 'plots_ibfk_143' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `plots` DROP FOREIGN KEY `plots_ibfk_143`;
Executing (default): ALTER TABLE `plots` ADD FOREIGN KEY (`broker_id`) REFERENCES `brokers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SHOW INDEX FROM `plots`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'payments' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `payments`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'payments' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='payments' AND constraint_name = 'payments_ibfk_5' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `payments` DROP FOREIGN KEY `payments_ibfk_5`;
Executing (default): ALTER TABLE `payments` ADD FOREIGN KEY (`plot_id`) REFERENCES `plots` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
Executing (default): ALTER TABLE `payments` CHANGE `milestone` `milestone` VARCHAR(255);
Executing (default): ALTER TABLE `payments` CHANGE `amount` `amount` BIGINT;
Executing (default): ALTER TABLE `payments` CHANGE `date` `date` DATE;
Executing (default): ALTER TABLE `payments` CHANGE `status` `status` ENUM('Paid', 'Pending') NOT NULL DEFAULT 'Pending';
Executing (default): ALTER TABLE `payments` CHANGE `mode` `mode` VARCHAR(255);
Executing (default): ALTER TABLE `payments` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `payments` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='payments' AND constraint_name = 'payments_ibfk_6' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `payments` DROP FOREIGN KEY `payments_ibfk_6`;
Executing (default): ALTER TABLE `payments` ADD FOREIGN KEY (`broker_id`) REFERENCES `brokers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): ALTER TABLE `payments` CHANGE `commission` `commission` BIGINT DEFAULT 0;
Executing (default): SHOW INDEX FROM `payments`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'prelaunch_projects' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `prelaunch_projects`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'prelaunch_projects' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `name` `name` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `loc` `loc` VARCHAR(255);
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `size_acres` `size_acres` FLOAT;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `acquisition_cost` `acquisition_cost` FLOAT;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `infra_budget` `infra_budget` FLOAT;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `marketing_budget` `marketing_budget` FLOAT;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `target_launch` `target_launch` DATE;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `feasibility_score` `feasibility_score` INTEGER;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `target_price_sqft` `target_price_sqft` INTEGER;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `total_planned_plots` `total_planned_plots` INTEGER;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `prelaunch_projects` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='prelaunch_projects' AND constraint_name = 'prelaunch_projects_ibfk_1' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `prelaunch_projects` DROP FOREIGN KEY `prelaunch_projects_ibfk_1`;
Executing (default): ALTER TABLE `prelaunch_projects` ADD FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SHOW INDEX FROM `prelaunch_projects`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'documents' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `documents`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'documents' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='documents' AND constraint_name = 'documents_ibfk_139' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `documents` DROP FOREIGN KEY `documents_ibfk_139`;
Executing (default): ALTER TABLE `documents` ADD FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='documents' AND constraint_name = 'documents_ibfk_140' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `documents` DROP FOREIGN KEY `documents_ibfk_140`;
Executing (default): ALTER TABLE `documents` ADD FOREIGN KEY (`prelaunch_id`) REFERENCES `prelaunch_projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
Executing (default): ALTER TABLE `documents` CHANGE `name` `name` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `documents` CHANGE `filename` `filename` VARCHAR(255);
Executing (default): ALTER TABLE `documents` CHANGE `size` `size` VARCHAR(255);
Executing (default): ALTER TABLE `documents` CHANGE `type` `type` VARCHAR(255);
Executing (default): ALTER TABLE `documents` CHANGE `status` `status` ENUM('verified', 'pending', 'missing');
Executing (default): ALTER TABLE `documents` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `documents` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SHOW INDEX FROM `documents`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'campaigns' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `campaigns`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'campaigns' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): ALTER TABLE `campaigns` CHANGE `name` `name` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `campaigns` CHANGE `spent` `spent` BIGINT DEFAULT 0;
Executing (default): ALTER TABLE `campaigns` CHANGE `leads` `leads` INTEGER DEFAULT 0;
Executing (default): ALTER TABLE `campaigns` CHANGE `site_visits` `site_visits` INTEGER DEFAULT 0;
Executing (default): ALTER TABLE `campaigns` CHANGE `conversions` `conversions` INTEGER DEFAULT 0;
Executing (default): ALTER TABLE `campaigns` CHANGE `cpl` `cpl` INTEGER DEFAULT 0;
Executing (default): ALTER TABLE `campaigns` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `campaigns` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='campaigns' AND constraint_name = 'campaigns_ibfk_1' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `campaigns` DROP FOREIGN KEY `campaigns_ibfk_1`;
Executing (default): ALTER TABLE `campaigns` ADD FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SHOW INDEX FROM `campaigns`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'employees' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `employees`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'employees' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): ALTER TABLE `employees` CHANGE `name` `name` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `employees` CHANGE `role` `role` VARCHAR(255);
Executing (default): ALTER TABLE `employees` CHANGE `phone` `phone` VARCHAR(255);
Executing (default): ALTER TABLE `employees` CHANGE `salary` `salary` BIGINT DEFAULT 0;
Executing (default): ALTER TABLE `employees` CHANGE `target` `target` BIGINT DEFAULT 0;
Executing (default): ALTER TABLE `employees` CHANGE `achieved` `achieved` BIGINT DEFAULT 0;
Executing (default): ALTER TABLE `employees` CHANGE `attendance` `attendance` VARCHAR(255) DEFAULT 'Present';
Executing (default): ALTER TABLE `employees` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `employees` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='employees' AND constraint_name = 'employees_ibfk_1' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `employees` DROP FOREIGN KEY `employees_ibfk_1`;
Executing (default): ALTER TABLE `employees` ADD FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SHOW INDEX FROM `employees`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'expenses' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `expenses`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'expenses' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): ALTER TABLE `expenses` CHANGE `title` `title` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `expenses` CHANGE `category` `category` VARCHAR(255);
Executing (default): ALTER TABLE `expenses` CHANGE `amount` `amount` BIGINT DEFAULT 0;
Executing (default): ALTER TABLE `expenses` CHANGE `date` `date` DATE;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='expenses' AND constraint_name = 'expenses_ibfk_37' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `expenses` DROP FOREIGN KEY `expenses_ibfk_37`;
Executing (default): ALTER TABLE `expenses` ADD FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): ALTER TABLE `expenses` CHANGE `vendor` `vendor` VARCHAR(255);
Executing (default): ALTER TABLE `expenses` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `expenses` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='expenses' AND constraint_name = 'expenses_ibfk_38' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `expenses` DROP FOREIGN KEY `expenses_ibfk_38`;
Executing (default): ALTER TABLE `expenses` ADD FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SHOW INDEX FROM `expenses`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'site_visits' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `site_visits`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'site_visits' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='site_visits' AND constraint_name = 'site_visits_ibfk_44' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `site_visits` DROP FOREIGN KEY `site_visits_ibfk_44`;
Executing (default): ALTER TABLE `site_visits` ADD FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='site_visits' AND constraint_name = 'site_visits_ibfk_45' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `site_visits` DROP FOREIGN KEY `site_visits_ibfk_45`;
Executing (default): ALTER TABLE `site_visits` ADD FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='site_visits' AND constraint_name = 'site_visits_ibfk_46' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `site_visits` DROP FOREIGN KEY `site_visits_ibfk_46`;
Executing (default): ALTER TABLE `site_visits` ADD FOREIGN KEY (`plot_id`) REFERENCES `plots` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='site_visits' AND constraint_name = 'site_visits_ibfk_47' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `site_visits` DROP FOREIGN KEY `site_visits_ibfk_47`;
Executing (default): ALTER TABLE `site_visits` ADD FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): ALTER TABLE `site_visits` CHANGE `scheduled_date` `scheduled_date` DATETIME NOT NULL;
Executing (default): ALTER TABLE `site_visits` CHANGE `escort` `escort` VARCHAR(255);
Executing (default): ALTER TABLE `site_visits` CHANGE `status` `status` ENUM('Scheduled', 'Completed', 'Cancelled', 'No-Show') DEFAULT 'Scheduled';
Executing (default): ALTER TABLE `site_visits` CHANGE `feedback` `feedback` TEXT;
Executing (default): ALTER TABLE `site_visits` CHANGE `rating` `rating` INTEGER;
Executing (default): ALTER TABLE `site_visits` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `site_visits` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='site_visits' AND constraint_name = 'site_visits_ibfk_48' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `site_visits` DROP FOREIGN KEY `site_visits_ibfk_48`;
Executing (default): ALTER TABLE `site_visits` ADD FOREIGN KEY (`broker_id`) REFERENCES `brokers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): SHOW INDEX FROM `site_visits`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'tasks' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `tasks`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'tasks' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): ALTER TABLE `tasks` CHANGE `title` `title` VARCHAR(255) NOT NULL;
Executing (default): ALTER TABLE `tasks` CHANGE `type` `type` ENUM('Call', 'Visit', 'Document', 'Payment', 'Other') DEFAULT 'Call';
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='tasks' AND constraint_name = 'tasks_ibfk_22' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `tasks` DROP FOREIGN KEY `tasks_ibfk_22`;
Executing (default): ALTER TABLE `tasks` ADD FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): ALTER TABLE `tasks` CHANGE `assigned_to` `assigned_to` VARCHAR(255);
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='tasks' AND constraint_name = 'tasks_ibfk_23' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `tasks` DROP FOREIGN KEY `tasks_ibfk_23`;
Executing (default): ALTER TABLE `tasks` ADD FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): ALTER TABLE `tasks` CHANGE `due_date` `due_date` DATE;
Executing (default): ALTER TABLE `tasks` CHANGE `priority` `priority` ENUM('High', 'Medium', 'Low') DEFAULT 'Medium';
Executing (default): ALTER TABLE `tasks` CHANGE `status` `status` ENUM('Open', 'Done') DEFAULT 'Open';
Executing (default): ALTER TABLE `tasks` CHANGE `notes` `notes` TEXT;
Executing (default): ALTER TABLE `tasks` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `tasks` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SHOW INDEX FROM `tasks`
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'attendance' AND TABLE_SCHEMA = 'real_estate'
Executing (default): SHOW FULL COLUMNS FROM `attendance`;
Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'attendance' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='real_estate' AND REFERENCED_TABLE_NAME IS NOT NULL;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='attendance' AND constraint_name = 'attendance_ibfk_5' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `attendance` DROP FOREIGN KEY `attendance_ibfk_5`;
Executing (default): ALTER TABLE `attendance` ADD FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
Executing (default): SELECT CONSTRAINT_CATALOG AS constraintCatalog, CONSTRAINT_NAME AS constraintName, CONSTRAINT_SCHEMA AS constraintSchema, CONSTRAINT_TYPE AS constraintType, TABLE_NAME AS tableName, TABLE_SCHEMA AS tableSchema from INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE table_name='attendance' AND constraint_name = 'attendance_ibfk_6' AND TABLE_SCHEMA = 'real_estate';
Executing (default): ALTER TABLE `attendance` DROP FOREIGN KEY `attendance_ibfk_6`;
Executing (default): ALTER TABLE `attendance` ADD FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
Executing (default): ALTER TABLE `attendance` CHANGE `date` `date` DATE NOT NULL;
Executing (default): ALTER TABLE `attendance` CHANGE `status` `status` ENUM('Present', 'Absent', 'Half-day', 'Leave', 'On-Site') DEFAULT 'Present';
Executing (default): ALTER TABLE `attendance` CHANGE `notes` `notes` VARCHAR(255);
Executing (default): ALTER TABLE `attendance` CHANGE `created_at` `created_at` DATETIME NOT NULL;
Executing (default): ALTER TABLE `attendance` CHANGE `updated_at` `updated_at` DATETIME NOT NULL;
Executing (default): SHOW INDEX FROM `attendance`
Database Synced
Server running on port 5000