CREATE TABLE tblTx_Radiation
(
	strRadiationType           VARCHAR(30),
	strRadiationName           VARCHAR(64),
	intRadiationSer            INT, 
	intRadiationNumber         INT,
	strRadiationId             VARCHAR(16),
	intPlanSetupSer            INT,
	dteHstryDateTime		   DATETIME
)

CREATE TABLE tblTx_RadiationRefPoint
(							
	intRadiationSer			   INT,
	intRefPointSer             INT,
	blnIsDose				   BIT,
	dblFieldDose			   FLOAT,
	dteHstryDateTime		   DATETIME,
	intCacheKeySer			   INT
)

CREATE TABLE tblTX_TFHFull
(
	dblActualMeterset          FLOAT,
	strEnergyMode		   	   VARCHAR(16),
	strRadiationId			   VARCHAR(16),
	intRadiationSer			   INT,
	intFractionNumber          INT,
	intPatientSer			   INT,
	strPIFlag                  CHAR(1),
	intResourceSer			   INT,
	intTreatmentRecordSer      INT,
	strUserName1               VARCHAR(64),
	dteTreatmentRecordDateTime DATETIME,
	dteHstryDateTime           DATETIME,
	intCourseSer			   INT
)


ALTER TABLE tblTx_CaptureDate ADD dteRadiation DATETIME,dteRadiationRefPoint DATETIME, dteTFHFull DATETIME,dtePrescription DATETIME

ALTER TABLE tblTx_CaptureDate 
ADD dteRadiation DATETIME,
	dteRadiationRefPoint DATETIME, 
	dteTFHFull DATETIME,
	dtePrescription DATETIME

DECLARE @dte  DATETIME
DECLARE @dte2 DATETIME 

SET @dte = '2013-01-01'
SET @dte2 = '2220-01-01'
update tbltx_CaptureDate SET dteActivity=@dte,	dteCourse=@dte,
							 dteRadiation=@dte,dteRadiationRefPoint=@dte,
							 dtePatient=@dte,  dtePlanSetup=@dte,
							 dteRefPoint=@dte, dteRefPointHstry=@dte,
							 dteMachine=@dte,  dteTFHFull=@dte,
							 dtePrescription=@dte2