Update of /cvsroot/oscarmcmaster/oscar_mcmaster/database/mysql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5239
Modified Files:
oscarinit.sql
Log Message:
updated formVTForm
Index: oscarinit.sql
===================================================================
RCS file: /cvsroot/oscarmcmaster/oscar_mcmaster/database/mysql/oscarinit.sql,v
retrieving revision 1.68
retrieving revision 1.69
diff -C2 -d -r1.68 -r1.69
*** oscarinit.sql 16 Jan 2005 21:17:00 -0000 1.68
--- oscarinit.sql 30 Jan 2005 01:51:07 -0000 1.69
***************
*** 4653,4659 ****
) TYPE=MyISAM;
! --
! -- Table structure for table `formVTForm`
! --
CREATE TABLE formVTForm(
ID int(10) NOT NULL auto_increment ,
--- 4653,4660 ----
) TYPE=MyISAM;
! # Connection: root@localhost:mysql.sock
! # Host: localhost
! # Saved: 2004-06-15 15:47:55
! #
CREATE TABLE formVTForm(
ID int(10) NOT NULL auto_increment ,
***************
*** 4661,4891 ****
provider_no int(10),
formCreated date,
! formEdited timestamp NOT NULL,
! visitCod varchar(10),
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),
WHRValue varchar(10),
WHRDate varchar(10),
WHRComments varchar(255),
- WHRLastData varchar(10),
- WHRLastDataEnteredDate 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),
DMValue varchar(10),
HTNValue varchar(10),
--- 4662,4802 ----
provider_no int(10),
formCreated date,
! formEdited timestamp NOT NULL,
! visitCod varchar(10),
HTValue varchar(10),
HTDate varchar(10),
HTComments varchar(255),
WTValue varchar(10),
WTDate varchar(10),
WTComments varchar(255),
WHRValue varchar(10),
WHRDate varchar(10),
WHRComments varchar(255),
WCValue varchar(10),
WCDate varchar(10),
WCComments varchar(255),
HCValue varchar(10),
HCDate varchar(10),
HCComments varchar(255),
BPValue varchar(10),
BPDate varchar(10),
BPComments varchar(255),
HRValue varchar(10),
HRDate varchar(10),
HRComments varchar(255),
HbA1Value varchar(10),
HbA1Date varchar(10),
HbA1Comments varchar(255),
BGValue varchar(10),
BGDate varchar(10),
BGComments varchar(255),
LDLValue varchar(10),
LDLDate varchar(10),
LDLComments varchar(255),
HDLValue varchar(10),
HDLDate varchar(10),
HDLComments varchar(255),
TCHLValue varchar(10),
TCHLDate varchar(10),
TCHLComments varchar(255),
TRIGValue varchar(10),
TRIGDate varchar(10),
TRIGComments varchar(255),
UALBValue varchar(10),
UALBDate varchar(10),
UALBComments varchar(255),
24UAValue varchar(10),
24UADate varchar(10),
! 24UAComments varchar(255),
! FTExValue varchar(10),
! FTExDate varchar(10),
! FTExComments varchar(255),
FTNeValue varchar(10),
FTNeDate varchar(10),
! FTNeComments varchar(255),
FTIsValue varchar(10),
FTIsDate varchar(10),
! FTIsComments varchar(255),
FTUlValue varchar(10),
FTUlDate varchar(10),
! FTUlComments varchar(255),
FTInValue varchar(10),
FTInDate varchar(10),
! FTInComments varchar(255),
FTOtValue varchar(10),
FTOtDate varchar(10),
! FTOtComments varchar(255),
FTReValue varchar(10),
FTReDate varchar(10),
! FTReComments varchar(255),
! iExValue varchar(10),
! iExDate varchar(10),
! iExComments varchar(255),
iDiaValue varchar(10),
iDiaDate varchar(10),
! iDiaComments varchar(255),
iHypValue varchar(10),
iHypDate varchar(10),
! iHypComments varchar(255),
iOthValue varchar(10),
iOthDate varchar(10),
! iOthComments varchar(255),
iRefValue varchar(10),
iRefDate varchar(10),
! iRefComments varchar(255),
SmkSValue varchar(10),
SmkSDate varchar(10),
! SmkSComments varchar(255),
SmkHValue varchar(10),
SmkHDate varchar(10),
! SmkHComments varchar(255),
SmkCValue varchar(10),
SmkCDate varchar(10),
! SmkCComments varchar(255),
ExerValue varchar(10),
ExerDate varchar(10),
! ExerComments varchar(255),
DietValue varchar(10),
DietDate varchar(10),
! DietComments varchar(255),
DpScValue varchar(10),
DpScDate varchar(10),
! DpScComments varchar(255),
StScValue varchar(10),
StScDate varchar(10),
! StScComments varchar(255),
LcCtValue varchar(10),
LcCtDate varchar(10),
! LcCtComments varchar(255),
MedGValue varchar(10),
MedGDate varchar(10),
! MedGComments varchar(255),
MedNValue varchar(10),
MedNDate varchar(10),
! MedNComments varchar(255),
MedRValue varchar(10),
MedRDate varchar(10),
! MedRComments varchar(255),
MedAValue varchar(10),
MedADate varchar(10),
! MedAComments varchar(255),
NtrCValue varchar(10),
NtrCDate varchar(10),
! NtrCComments varchar(255),
ExeCValue varchar(10),
ExeCDate varchar(10),
! ExeCComments varchar(255),
SmCCValue varchar(10),
SmCCDate varchar(10),
! SmCCComments varchar(255),
DiaCValue varchar(10),
DiaCDate varchar(10),
! DiaCComments varchar(255),
PsyCValue varchar(10),
PsyCDate varchar(10),
! PsyCComments varchar(255),
OthCValue varchar(10),
OthCDate varchar(10),
! OthCComments varchar(255),
DMValue varchar(10),
HTNValue varchar(10),
***************
*** 4905,4911 ****
) TYPE=MyISAM;
-
-
-
--
-- Table structure for table `groupMembers_tbl`
--- 4816,4819 ----
|