<?php defined('BASEPATH') OR exit('No direct script access allowed'); class Migration_Add_referrers extends CI_Migration { public function up() { $this->db->query(" CREATE TABLE `invitations` ( `user` int(8) unsigned NOT NULL, `key` varchar(16) CHARACTER SET ascii NOT NULL, `date` int(11) unsigned NOT NULL, PRIMARY KEY (`key`), KEY `user` (`user`), KEY `date` (`date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin "); $this->db->query(" ALTER TABLE `users` ADD `referrer` INT(8) UNSIGNED NOT NULL DEFAULT '0' "); } public function down() { $this->db->query(" ALTER TABLE `users` DROP `referrer` "); $this->dbforge->drop_table('invitations'); } }