From dfb9f8868efab7ccc5440c537c12424e72af3a4a Mon Sep 17 00:00:00 2001
From: M <m@lfurio.us>
Date: Fri, 20 Nov 2015 19:32:37 -0500
Subject: + Defined schema for extern-user object

---
 schema.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 589fafb..58cbc45 100644
--- a/schema.sql
+++ b/schema.sql
@@ -46,6 +46,7 @@ CREATE TABLE `object` (
     `timeUpdated` datetime        NOT NULL,
     `type`   enum(
         'user',
+        'extern-user',
         'group',
         'pad',
         'stage',
@@ -74,6 +75,18 @@ CREATE TABLE `user` (
     `alias`  varchar(50)      DEFAULT NULL,
     `email`  varchar(50)      DEFAULT NULL,
     `emailConf` int(10) unsigned  NOT NULL DEFAULT 0,
+    `emailConfKey` varchar(64)    NOT NULL,
+    PRIMARY KEY (`guid`)
+);
+
+/* Extern-user objects - special attributes */
+/* Notice: these objects are contructred on portal pages or if a scrott user gives ownership of an object to an external user. */
+/* Notice: This table should be searched for addresses while creating a new normal user object.  If in the event the users email address exists here, it should be promoted to a full user account */
+DROP TABLE IF EXISTS `extern-user`;
+CREATE TABLE `extern-user` (
+    `guid`   varchar(10)          NOT NULL,
+    `email`  varchar(50)          NOT NULL,
+    `emailConfKey` varchar(64)    NOT NULL,
     PRIMARY KEY (`guid`)
 );
 
-- 
cgit v1.2.3

