You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by do...@apache.org on 2014/09/19 11:22:46 UTC
svn commit: r1626158 -
/empire-db/trunk/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/SampleAdvDB.java
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);