catalog varchar(64), t_schema varchar(64),
   t_name varchar(64), geometry_column varchar(64), t_srid int

begin
  set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end

catalog varchar(64), t_schema varchar(64),
   t_name varchar(64), geometry_column varchar(64)

begin
  set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end

BEGIN
    DECLARE done INT DEFAULT 0;
    DECLARE v_table VARCHAR(255);
    DECLARE v_columns TEXT;
    DECLARE v_condition LONGTEXT;
    DECLARE v_sql LONGTEXT;

    DECLARE cur CURSOR FOR
        SELECT DISTINCT TABLE_NAME
        FROM information_schema.COLUMNS
        WHERE TABLE_SCHEMA = 'proxima_database_two'
          AND DATA_TYPE IN ('date','datetime','timestamp')
          AND TABLE_NAME NOT IN (
              'usertable',
              'usertable_emp',
              'usermanagement',
              'user_priv',
              'user_order_owner',
              'userapitab'
          )
        ORDER BY TABLE_NAME;

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

    OPEN cur;

    read_loop: LOOP

        FETCH cur INTO v_table;

        IF done = 1 THEN
            LEAVE read_loop;
        END IF;

        SELECT GROUP_CONCAT(
            CONCAT('`', COLUMN_NAME, '`')
            ORDER BY ORDINAL_POSITION
            SEPARATOR ', '
        )
        INTO v_columns
        FROM information_schema.COLUMNS
        WHERE TABLE_SCHEMA = 'proxima_database_two'
          AND TABLE_NAME = v_table
          AND DATA_TYPE IN ('date','datetime','timestamp');

        SELECT GROUP_CONCAT(
            CONCAT(
                'COALESCE(`',
                COLUMN_NAME,
                '` >= ''2025-01-01'' AND `',
                COLUMN_NAME,
                '` < ''2027-01-01'', 0)'
            )
            ORDER BY ORDINAL_POSITION
            SEPARATOR ' OR '
        )
        INTO v_condition
        FROM information_schema.COLUMNS
        WHERE TABLE_SCHEMA = 'proxima_database_two'
          AND TABLE_NAME = v_table
          AND DATA_TYPE IN ('date','datetime','timestamp');

        SET v_sql = CONCAT(
            'INSERT INTO cleanup_preview ',
            '(table_name,date_columns,total_rows,keep_rows,delete_rows) ',
            'SELECT ',
            QUOTE(v_table), ', ',
            QUOTE(v_columns), ', ',
            'COUNT(*), ',
            'SUM(CASE WHEN (', v_condition,
            ') THEN 1 ELSE 0 END), ',
            'SUM(CASE WHEN NOT (', v_condition,
            ') THEN 1 ELSE 0 END) ',
            'FROM `', v_table, '`'
        );

        PREPARE stmt FROM v_sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;

    END LOOP;

    CLOSE cur;
END