fixed that last 1 but says this now when i run the commands said before
Quote:
mysql> source doors_update.sql;
Query OK, 5249 rows affected (0.37 sec)
Records: 5249 Duplicates: 0 Warnings: 0
Query OK, 5249 rows affected (0.41 sec)
Records: 5249 Duplicates: 0 Warnings: 0
Query OK, 5249 rows affected (0.36 sec)
Records: 5249 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" N
OT NULL;
ERROR 1054: Unknown column 'liftheight' in 'doors'
mysql> ALTER TABLE `doors` ADD `size` SMALLINT(5) UNSIGNED DEFAULT "100" NOT NUL
L;
ERROR 1060: Duplicate column name 'size'
mysql>
|