From 8b0d41cb8f2296047611f9fc9745ce8c5deefdd2 Mon Sep 17 00:00:00 2001 From: Ran Guin Date: Thu, 13 May 2021 14:51:38 -0700 Subject: add migrations for referrals & waiting list --- db/migrations/referrals.sql | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 db/migrations/referrals.sql (limited to 'db/migrations/referrals.sql') diff --git a/db/migrations/referrals.sql b/db/migrations/referrals.sql new file mode 100644 index 00000000..b755000a --- /dev/null +++ b/db/migrations/referrals.sql @@ -0,0 +1,30 @@ +-- Note: Adding FK contraints may cause issues, so I have commented them out for now, but these need to be established + +CREATE TABLE `referrals` ( + `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, + `token` varchar(255) DEFAULT NULL UNIQUE, + `expiry` date DEFAULT NULL, + `status` enum('pending','active','expired','cancelled') DEFAULT NULL, + `sponsor_id` int(11) NOT NULL, + `user_id` int(11) DEFAULT NULL, + `created_at` datetime DEFAULT CURRENT_TIMESTAMP, + `updated_at` datetime DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (`id`), + KEY `sponsor_id` (`sponsor_id`), + KEY `user_id` (`user_id`) + -- FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), + -- FOREIGN KEY (`sponsor_id`) REFERENCES `users` (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 + +CREATE TABLE `waiting_list` ( + `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, + `email` varchar(255) DEFAULT NULL UNIQUE, + `sms` varchar(255) DEFAULT NULL, + `user_id` int(11) DEFAULT NULL, + `status` enum('pending','contacted','registered','cancelled') DEFAULT 'pending', + `notes` text DEFAULT NULL, + `created_at` datetime DEFAULT CURRENT_TIMESTAMP, + `updated_at` datetime DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (`id`) + -- CONSTRAINT `user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 \ No newline at end of file -- cgit v1.2.3