.scratchpad

####################################3

Running the sample database resulted to the following:

mysql> sampleDatabase/database_content.sql
    -> ;
;
^C
mysql> source sampleDatabase/database_content.sql;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1264 (22003): Out of range value for column 'iVersion' at row 1
ERROR 1264 (22003): Out of range value for column 'iVersion' at row 1
Query OK, 14 rows affected (0.00 sec)
Records: 14  Duplicates: 0  Warnings: 0

ERROR 1264 (22003): Out of range value for column 'iVersion' at row 1
ERROR 1264 (22003): Out of range value for column 'iVersion' at row 1
Query OK, 1 row affected (0.01 sec)

ERROR 1264 (22003): Out of range value for column 'iVersion' at row 1
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `algorea_registration` (`ID`, `firstName`, `lastName`, `genre`, `ema' at line 5
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT' at line 3


Todo: find out what the hell is happening and fix it.

##########

fix the rtl of the contest interface for Farsi language.


###

DELIMITER //
CREATE PROCEDURE UpdateColumn5()
BEGIN
  DECLARE done INT DEFAULT 0;
  DECLARE tableName CHAR(64);
  DECLARE cur CURSOR FOR 
    SELECT table_name 
    FROM information_schema.tables 
    WHERE table_schema = 'beaver_contest' 
    AND table_type = 'BASE TABLE'; -- Only include base tables
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

  OPEN cur;

  read_loop: LOOP
    FETCH cur INTO tableName;

    IF done THEN
      LEAVE read_loop;
    END IF;

    IF EXISTS (SELECT * 
              FROM information_schema.COLUMNS 
              WHERE TABLE_SCHEMA = 'beaver_contest' 
              AND TABLE_NAME = tableName 
              AND COLUMN_NAME = 'iVersion') THEN
      SET @s = CONCAT('ALTER TABLE `', tableName, '` MODIFY iVersion BIGINT;'); -- Changed INT(32) to BIGINT
      PREPARE stmt FROM @s;
      EXECUTE stmt;
      DEALLOCATE PREPARE stmt;
    END IF;

  END LOOP;

  CLOSE cur;
  
END//
DELIMITER ;
###