rpJ98WV9

1DROP PROCEDURE IF EXISTS ALIASCOLUMN;
2DELIMITER //
3CREATE PROCEDURE ALIASCOLUMN()
4BEGIN
5DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
6ALTER TABLE 'human_api_procedure' ADD COLUMN 'alias' varchar(255);
7END //
8DELIMITER;
9CALL ALIASCOLUMN();
10DROP PROCEDURE ALIASCOLUMN;
11	
12IF NOT EXISTS( SELECT NULL
13            FROM INFORMATION_SCHEMA.COLUMNS
14           WHERE table_name = 'tablename'
15             AND table_schema = 'db_name'
16             AND column_name = 'columnname')  THEN
17
18  ALTER TABLE `human_api_procedure` ADD `ColumnName` int(1) NOT NULL default '0';
19
20END IF;