Add sponsor_type/sponsor_id column to users table, and client support for manipulatin...

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 763f05d7d1725a2ccbd62d8daeeeb27225b93e62..27c02557201805b81801c49956ae0ed1ac5664ba 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -50,7 +50,9 @@ create table users
        created         DATE            DEFAULT SYSDATE NOT NULL,
        creator         INTEGER         DEFAULT 0       NOT NULL,
        winhomedir      VARCHAR(260)    DEFAULT '[DFS]' NOT NULL,
-       winprofiledir   VARCHAR(260)    DEFAULT '[DFS]' NOT NULL
+       winprofiledir   VARCHAR(260)    DEFAULT '[DFS]' NOT NULL,
+       sponsor_type    VARCHAR(8)      DEFAULT 'NONE'  NOT NULL,
+       sponsor_id      INTEGER         DEFAULT 0       NOT NULL
 );
 
 create table krbmap