Update of /cvsroot/oscarmcmaster/oscar_mcmaster/database/mysql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28603
Modified Files:
oscarinit.sql
Log Message:
added formVTForm
Index: oscarinit.sql
===================================================================
RCS file: /cvsroot/oscarmcmaster/oscar_mcmaster/database/mysql/oscarinit.sql,v
retrieving revision 1.63
retrieving revision 1.64
diff -C2 -d -r1.63 -r1.64
*** oscarinit.sql 19 Nov 2004 01:47:04 -0000 1.63
--- oscarinit.sql 23 Nov 2004 21:10:07 -0000 1.64
***************
*** 4654,4657 ****
--- 4654,4894 ----
--
+ -- Table structure for table `formVTForm`
+ --
+ CREATE TABLE formVTForm(
+ ID int(10) NOT NULL auto_increment ,
+ demographic_no int(10) NOT NULL,
+ provider_no int(10),
+ formCreated date,
+ formEdited timestamp NOT NULL,
+ HTValue varchar(10),
+ HTDate varchar(10),
+ HTComments varchar(255),
+ HTLastData varchar(10),
+ HTLastDataEnteredDate varchar(10),
+ WTValue varchar(10),
+ WTDate varchar(10),
+ WTComments varchar(255),
+ WTLastData varchar(10),
+ WTLastDataEnteredDate varchar(10),
+ WCValue varchar(10),
+ WCDate varchar(10),
+ WCComments varchar(255),
+ WCLastData varchar(10),
+ WCLastDataEnteredDate varchar(10),
+ HCValue varchar(10),
+ HCDate varchar(10),
+ HCComments varchar(255),
+ HCLastData varchar(10),
+ HCLastDataEnteredDate varchar(10),
+ BPValue varchar(10),
+ BPDate varchar(10),
+ BPComments varchar(255),
+ BPLastData varchar(10),
+ BPLastDataEnteredDate varchar(10),
+ HRValue varchar(10),
+ HRDate varchar(10),
+ HRComments varchar(255),
+ HRLastData varchar(10),
+ HRLastDataEnteredDate varchar(10),
+ HbA1Value varchar(10),
+ HbA1Date varchar(10),
+ HbA1Comments varchar(255),
+ HbA1LastData varchar(10),
+ HbA1LastDataEnteredDate varchar(10),
+ BGValue varchar(10),
+ BGDate varchar(10),
+ BGComments varchar(255),
+ BGLastData varchar(10),
+ BGLastDataEnteredDate varchar(10),
+ LDLValue varchar(10),
+ LDLDate varchar(10),
+ LDLComments varchar(255),
+ LDLLastData varchar(10),
+ LDLLastDataEnteredDate varchar(10),
+ HDLValue varchar(10),
+ HDLDate varchar(10),
+ HDLComments varchar(255),
+ HDLLastData varchar(10),
+ HDLLastDataEnteredDate varchar(10),
+ TCHLValue varchar(10),
+ TCHLDate varchar(10),
+ TCHLComments varchar(255),
+ THCLLastData varchar(10),
+ THCLLastDataEnteredDate varchar(10),
+ TRIGValue varchar(10),
+ TRIGDate varchar(10),
+ TRIGComments varchar(255),
+ TRIGLastData varchar(10),
+ TRIGLastDataEnteredDate varchar(10),
+ UALBValue varchar(10),
+ UALBDate varchar(10),
+ UALBComments varchar(255),
+ UALBLastData varchar(10),
+ UALBLastDataEnteredDate varchar(10),
+ 24UAValue varchar(10),
+ 24UADate varchar(10),
+ 24UAComments varchar(255),
+ 24UALastData varchar(10),
+ 24UALastDataEnteredDate varchar(10),
+ FTNoValue varchar(10),
+ FTNoDate varchar(10),
+ FTNoComments varchar(255),
+ FTNoLastData varchar(10),
+ FTNoLastDataEnteredDate varchar(10),
+ FTNeValue varchar(10),
+ FTNeDate varchar(10),
+ FTNeComments varchar(255),
+ FTNeLastData varchar(10),
+ FTNeLastDataEnteredDate varchar(10),
+ FTIsValue varchar(10),
+ FTIsDate varchar(10),
+ FTIsComments varchar(255),
+ FTIsLastData varchar(10),
+ FTIsLastDataEnteredDate varchar(10),
+ FTUlValue varchar(10),
+ FTUlDate varchar(10),
+ FTUlComments varchar(255),
+ FTUlLastData varchar(10),
+ FTUlLastDataEnteredDate varchar(10),
+ FTInValue varchar(10),
+ FTInDate varchar(10),
+ FTInComments varchar(255),
+ FTInLastData varchar(10),
+ FTInLastDataEnteredDate varchar(10),
+ FTOtValue varchar(10),
+ FTOtDate varchar(10),
+ FTOtComments varchar(255),
+ FTOtLastData varchar(10),
+ FTOtLastDataEnteredDate varchar(10),
+ FTReValue varchar(10),
+ FTReDate varchar(10),
+ FTReComments varchar(255),
+ FTReLastData varchar(10),
+ FTReLastDataEnteredDate varchar(10),
+ iNoValue varchar(10),
+ iNoDate varchar(10),
+ iNoComments varchar(255),
+ iNoLastData varchar(10),
+ iNoLastDataEnteredDate varchar(10),
+ iDiaValue varchar(10),
+ iDiaDate varchar(10),
+ iDiaComments varchar(255),
+ iDiaLastData varchar(10),
+ iDiaLastDataEnteredDate varchar(10),
+ iHypValue varchar(10),
+ iHypDate varchar(10),
+ iHypComments varchar(255),
+ iHypLastData varchar(10),
+ iHypLastDataEnteredDate varchar(10),
+ iOthValue varchar(10),
+ iOthDate varchar(10),
+ iOthComments varchar(255),
+ iOthLastData varchar(10),
+ iOthLastDataEnteredDate varchar(10),
+ iRefValue varchar(10),
+ iRefDate varchar(10),
+ iRefComments varchar(255),
+ iRefLastData varchar(10),
+ iRefLastDataEnteredDate varchar(10),
+ SmkSValue varchar(10),
+ SmkSDate varchar(10),
+ SmkSComments varchar(255),
+ SmkSLastData varchar(10),
+ SmkSLastDataEnteredDate varchar(10),
+ SmkHValue varchar(10),
+ SmkHDate varchar(10),
+ SmkHComments varchar(255),
+ SmkHLastData varchar(10),
+ SmkHLastDataEnteredDate varchar(10),
+ SmkCValue varchar(10),
+ SmkCDate varchar(10),
+ SmkCComments varchar(255),
+ SmkCLastData varchar(10),
+ SmkCLastDataEnteredDate varchar(10),
+ ExerValue varchar(10),
+ ExerDate varchar(10),
+ ExerComments varchar(255),
+ ExerLastData varchar(10),
+ ExerLastDataEnteredDate varchar(10),
+ DietValue varchar(10),
+ DietDate varchar(10),
+ DietComments varchar(255),
+ DietLastData varchar(10),
+ DietLastDataEnteredDate varchar(10),
+ DpScValue varchar(10),
+ DpScDate varchar(10),
+ DpScComments varchar(255),
+ DpScLastData varchar(10),
+ DpScLastDataEnteredDate varchar(10),
+ StScValue varchar(10),
+ StScDate varchar(10),
+ StScComments varchar(255),
+ StScLastData varchar(10),
+ StScLastDataEnteredDate varchar(10),
+ LcCtValue varchar(10),
+ LcCtDate varchar(10),
+ LcCtComments varchar(255),
+ LcCtLastData varchar(10),
+ LcCtLastDataEnteredDate varchar(10),
+ MedGValue varchar(10),
+ MedGDate varchar(10),
+ MedGComments varchar(255),
+ MedGLastData varchar(10),
+ MedGLastDataEnteredDate varchar(10),
+ MedNValue varchar(10),
+ MedNDate varchar(10),
+ MedNComments varchar(255),
+ MedNLastData varchar(10),
+ MedNLastDataEnteredDate varchar(10),
+ MedRValue varchar(10),
+ MedRDate varchar(10),
+ MedRComments varchar(255),
+ MedRLastData varchar(10),
+ MedRLastDataEnteredDate varchar(10),
+ MedAValue varchar(10),
+ MedADate varchar(10),
+ MedAComments varchar(255),
+ MedALastData varchar(10),
+ MedALastDataEnteredDate varchar(10),
+ NtrCValue varchar(10),
+ NtrCDate varchar(10),
+ NtrCComments varchar(255),
+ NtrCLastData varchar(10),
+ NtrCLastDataEnteredDate varchar(10),
+ ExeCValue varchar(10),
+ ExeCDate varchar(10),
+ ExeCComments varchar(255),
+ ExeCLastData varchar(10),
+ ExeCLastDataEnteredDate varchar(10),
+ SmCCValue varchar(10),
+ SmCCDate varchar(10),
+ SmCCComments varchar(255),
+ SmCCLastData varchar(10),
+ SmCCLastDataEnteredDate varchar(10),
+ DiaCValue varchar(10),
+ DiaCDate varchar(10),
+ DiaCComments varchar(255),
+ DiaCLastData varchar(10),
+ DiaCLastDataEnteredDate varchar(10),
+ PsyCValue varchar(10),
+ PsyCDate varchar(10),
+ PsyCComments varchar(255),
+ PsyCLastData varchar(10),
+ PsyCLastDataEnteredDate varchar(10),
+ OthCValue varchar(10),
+ OthCDate varchar(10),
+ OthCComments varchar(255),
+ OthCLastData varchar(10),
+ OthCLastDataEnteredDate varchar(10),
+
+ PRIMARY KEY (ID),
+ INDEX (ID),
+ INDEX (demographic_no)
+
+ ) TYPE=MyISAM;
+
+
+ --
-- Table structure for table `groupMembers_tbl`
--
|