svn commit: r1626158 - /empire-db/trunk/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/SampleAdvDB.java

[doebele]

Author: doebele
Date: Fri Sep 19 09:22:46 2014
New Revision: 1626158

URL: http://svn.apache.org/r1626158
Log:
EMPIREDB-208

Modified:
    
empire-db/trunk/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/SampleAdvDB.java

Modified: 
empire-db/trunk/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/SampleAdvDB.java
URL: 
http://svn.apache.org/viewvc/empire-db/trunk/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/SampleAdvDB.java?rev=1626158&r1=1626157&r2=1626158&view=diff
==============================================================================
--- 
empire-db/trunk/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/SampleAdvDB.java
 (original)
+++ 
empire-db/trunk/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/SampleAdvDB.java
 Fri Sep 19 09:22:46 2014
@@ -66,11 +66,11 @@ public class SampleAdvDB extends DBDatab
         {
             super("DEPARTMENTS", db);
             // ID
-            C_DEPARTMENT_ID   = addColumn("DEPARTMENT_ID",    
DataType.AUTOINC,       0, DataMode.AutoGenerated, "DEP_ID_SEQUENCE");
-            C_NAME            = addColumn("NAME",             DataType.TEXT,   
      80, DataMode.NotNull);
-            C_HEAD            = addColumn("HEAD",             DataType.TEXT,   
      80, DataMode.Nullable);
-            C_BUSINESS_UNIT   = addColumn("BUSINESS_UNIT",    DataType.TEXT,   
       4, DataMode.NotNull, "ITTK");
-            C_UPDATE_TIMESTAMP= addColumn("UPDATE_TIMESTAMP", 
DataType.DATETIME,      0, DataMode.AutoGenerated);
+            C_DEPARTMENT_ID   = addColumn("DEPARTMENT_ID",    
DataType.AUTOINC,       0, true, "DEP_ID_SEQUENCE");
+            C_NAME            = addColumn("NAME",             DataType.TEXT,   
      80, true);
+            C_HEAD            = addColumn("HEAD",             DataType.TEXT,   
      80, false);
+            C_BUSINESS_UNIT   = addColumn("BUSINESS_UNIT",    DataType.TEXT,   
       4, true, "ITTK");
+            C_UPDATE_TIMESTAMP= addColumn("UPDATE_TIMESTAMP", 
DataType.DATETIME,      0, true);
 
             // Primary Key
             setPrimaryKey(C_DEPARTMENT_ID);
@@ -107,17 +107,17 @@ public class SampleAdvDB extends DBDatab
         {
             super("EMPLOYEES", db);
             // ID
-            C_EMPLOYEE_ID     = addColumn("EMPLOYEE_ID",      
DataType.AUTOINC,      0, DataMode.AutoGenerated, "EMPLOYEE_ID_SEQUENCE");
-            C_SALUTATION      = addColumn("SALUTATION",       DataType.TEXT,   
     20, DataMode.Nullable);
-            C_FIRSTNAME       = addColumn("FIRSTNAME",        DataType.TEXT,   
     40, DataMode.NotNull);
-            C_LASTNAME        = addColumn("LASTNAME",         DataType.TEXT,   
     40, DataMode.NotNull);
-            C_DATE_OF_BIRTH   = addColumn("DATE_OF_BIRTH",    DataType.DATE,   
      0, DataMode.Nullable);
-            C_GENDER          = addColumn("GENDER",           DataType.TEXT,   
      1, DataMode.Nullable);
-            C_PHONE_NUMBER    = addColumn("PHONE_NUMBER",     DataType.TEXT,   
     40, DataMode.Nullable);
-            C_EMAIL           = addColumn("EMAIL",            DataType.TEXT,   
     80, DataMode.Nullable);
-            C_RETIRED         = addColumn("RETIRED",          DataType.BOOL,   
      0, DataMode.NotNull, false);
-            C_CHECKSUM        = addColumn("CHECKSUM",         
DataType.INTEGER,      0, DataMode.Nullable);
-            C_UPDATE_TIMESTAMP= addColumn("UPDATE_TIMESTAMP", 
DataType.DATETIME,     0, DataMode.AutoGenerated);
+            C_EMPLOYEE_ID     = addColumn("EMPLOYEE_ID",      
DataType.AUTOINC,      0, true, "EMPLOYEE_ID_SEQUENCE");
+            C_SALUTATION      = addColumn("SALUTATION",       DataType.TEXT,   
     20, false);
+            C_FIRSTNAME       = addColumn("FIRSTNAME",        DataType.TEXT,   
     40, true);
+            C_LASTNAME        = addColumn("LASTNAME",         DataType.TEXT,   
     40, true);
+            C_DATE_OF_BIRTH   = addColumn("DATE_OF_BIRTH",    DataType.DATE,   
      0, false);
+            C_GENDER          = addColumn("GENDER",           DataType.TEXT,   
      1, false);
+            C_PHONE_NUMBER    = addColumn("PHONE_NUMBER",     DataType.TEXT,   
     40, false);
+            C_EMAIL           = addColumn("EMAIL",            DataType.TEXT,   
     80, false);
+            C_RETIRED         = addColumn("RETIRED",          DataType.BOOL,   
      0, true, false);
+            C_CHECKSUM        = addColumn("CHECKSUM",         
DataType.INTEGER,      0, false);
+            C_UPDATE_TIMESTAMP= addColumn("UPDATE_TIMESTAMP", 
DataType.DATETIME,     0, true);
 
             // Primary Key
             setPrimaryKey(C_EMPLOYEE_ID);
@@ -153,9 +153,9 @@ public class SampleAdvDB extends DBDatab
         {
             super("EMPLOYEE_DEPARTMENT_HIST", db);
             // ID
-            C_EMPLOYEE_ID   = addColumn("EMPLOYEE_ID",      DataType.INTEGER,  
     0, DataMode.NotNull);
-            C_DEPARTMENT_ID = addColumn("DEPARTMENT_ID",    DataType.INTEGER,  
     0, DataMode.NotNull);
-            C_DATE_FROM     = addColumn("DATE_FROM",        DataType.DATE,     
     0, DataMode.NotNull);
+            C_EMPLOYEE_ID   = addColumn("EMPLOYEE_ID",      DataType.INTEGER,  
     0, true);
+            C_DEPARTMENT_ID = addColumn("DEPARTMENT_ID",    DataType.INTEGER,  
     0, true);
+            C_DATE_FROM     = addColumn("DATE_FROM",        DataType.DATE,     
     0, true);
 
             // Primary Key
             setPrimaryKey(C_EMPLOYEE_ID, C_DATE_FROM);