From 1792dbea851a846294b2b938b4fab4d96bc42166 Mon Sep 17 00:00:00 2001
From: zacheiss <zacheiss>
Date: Wed, 17 Oct 2001 21:32:45 +0000
Subject: [PATCH] Add created and creator columns to the users table.

---
 db/schema.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/db/schema.sql b/db/schema.sql
index 5866b34d..5ff0509c 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -45,7 +45,9 @@ create table users
 	signature    	VARCHAR(68)	DEFAULT CHR(0)	NOT NULL,
 	secure       	INTEGER		DEFAULT 0	NOT NULL,       
 	reservations	VARCHAR(10)	DEFAULT CHR(0)	NOT NULL,
-	flag         	INTEGER		DEFAULT 0	NOT NULL
+	flag         	INTEGER		DEFAULT 0	NOT NULL,
+	created		DATE		DEFAULT SYSDATE	NOT NULL,
+	creator		INTEGER		DEFAULT 0	NOT NULL
 );
 
 create table krbmap
-- 
2.45.2