diff options
author | Florian Pritz <bluewind@xinu.at> | 2012-04-09 11:26:22 +0200 |
---|---|---|
committer | Florian Pritz <bluewind@xinu.at> | 2012-04-09 20:48:16 +0200 |
commit | c0f1755842211996a7a21ffb8773b260bb2be281 (patch) | |
tree | 609107150d2ee82cdbb3ed9157ceccf0cf98f8a7 /application/migrations/003_add_referrers.php | |
parent | cb8b733a6c2333ff90d3af0fc37e8c21c73d9e7a (diff) |
Implement simple referral system
Signed-off-by: Florian Pritz <bluewind@xinu.at>
Diffstat (limited to 'application/migrations/003_add_referrers.php')
-rw-r--r-- | application/migrations/003_add_referrers.php | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/application/migrations/003_add_referrers.php b/application/migrations/003_add_referrers.php new file mode 100644 index 000000000..524e92ff0 --- /dev/null +++ b/application/migrations/003_add_referrers.php @@ -0,0 +1,33 @@ +<?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'); + + } +} |