ALTER TABLE `lg_users` ADD `login_token` varchar(32) COLLATE latin1_general_ci DEFAULT NULL; ALTER TABLE `lg_users` CHANGE `password` `password` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE ...

Unlike data manipulation language (DML) commands that are used for data modification purposes, DDL commands are used for altering the database structure such as creating new tables or objects along ...

ALTER TABLE `lg_users` ADD `date_last_rename` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `date_last_game` ; -- Rev 1472 (Some SQL optimizations concerning game list) ALTER TABLE `lg_games` ADD ...