[Tynstep-svn] r71 - trunk/StepDataLoader/sql/com/tyndalehouse/step/dataloader/sql/create

[ChrisBurrell at crosswire.org]

Author: ChrisBurrell
Date: 2010-02-09 13:37:50 -0700 (Tue, 09 Feb 2010)
New Revision: 71

Modified:
   trunk/StepDataLoader/sql/com/tyndalehouse/step/dataloader/sql/create/3.timeline.sql
Log:
new schema and data updates

Modified: trunk/StepDataLoader/sql/com/tyndalehouse/step/dataloader/sql/create/3.timeline.sql
===================================================================
--- trunk/StepDataLoader/sql/com/tyndalehouse/step/dataloader/sql/create/3.timeline.sql	2010-01-09 16:52:42 UTC (rev 70)
+++ trunk/StepDataLoader/sql/com/tyndalehouse/step/dataloader/sql/create/3.timeline.sql	2010-02-09 20:37:50 UTC (rev 71)
@@ -14,7 +14,9 @@
 	timeband_description		varchar(50),			-- TODO: this should probably be made an ID to timeline_description
 														-- table, so that we can localise, or remove this
 														-- and localise in the java layer...
-	timeband_code				varchar(50)
+	timeband_code				varchar(50),
+	timeband_unit				varchar(10) default 'DECADE',
+	is_biblical					char(1)
 );
 
 /**
@@ -25,7 +27,8 @@
 	sub_timeband_description		varchar(50),			-- TODO: this should probably be made an ID to timeline_description
 														-- table, so that we can localise, or remove this
 														-- and localise in the java layer...
-	sub_timeband_code				varchar(50)
+	sub_timeband_code				varchar(50),
+	sub_timeband_unit				varchar(10) default 'DECADE'
 );