From 59cdd2b7ebceae94fbecdb1eeb46a969666dc88f Mon Sep 17 00:00:00 2001
From: Roberto Sánchez <roberto.sanchez@curisit.net>
Date: Fri, 10 Jan 2014 12:25:27 +0000
Subject: [PATCH] #394 feature - Added all catalog resources with refereced fields

---
 securis/src/main/resources/db/schema.sql |   10 +++++-----
 1 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/securis/src/main/resources/db/schema.sql b/securis/src/main/resources/db/schema.sql
index e26e417..e13879a 100644
--- a/securis/src/main/resources/db/schema.sql
+++ b/securis/src/main/resources/db/schema.sql
@@ -9,9 +9,9 @@
 CREATE  TABLE IF NOT EXISTS user (
   username VARCHAR(45) NOT NULL ,
   password VARCHAR(100) NULL ,
-  roles INT NULL ,
-  full_name VARCHAR(100) NULL ,
-  short_name VARCHAR(3) NULL ,
+  roles INT NOT NULL default 0,
+  first_name VARCHAR(100) NULL ,
+  last_name VARCHAR(100) NULL ,
   last_login DATETIME NULL ,
   lang VARCHAR(10) NULL ,
   creation_timestamp DATETIME NULL ,  
@@ -49,9 +49,9 @@
   
 drop table IF EXISTS user_organization;
 CREATE  TABLE IF NOT EXISTS user_organization (
-  user_id INT NOT NULL,
+  username VARCHAR(45) NOT NULL,
   organization_id INT NOT NULL,  
-  PRIMARY KEY (user_id, organization_id));
+  PRIMARY KEY (username, organization_id));
   
 drop table IF EXISTS pack;
 CREATE  TABLE IF NOT EXISTS pack (

--
Gitblit v1.3.2