1 2 3 4 5 6
BEGIN; ALTER TABLE `regions` ADD COLUMN `flags` integer NOT NULL DEFAULT 0; CREATE INDEX flags ON regions(flags); COMMIT;