Update of /cvsroot/oscarmcmaster/oscar_mcmaster/database/mysql
In directory sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv13178
Modified Files:
oscarinit.sql
Log Message:
removed the collate utf8_bin
Index: oscarinit.sql
===================================================================
RCS file: /cvsroot/oscarmcmaster/oscar_mcmaster/database/mysql/oscarinit.sql,v
retrieving revision 1.275
retrieving revision 1.276
diff -C2 -d -r1.275 -r1.276
*** oscarinit.sql 11 Jan 2011 16:39:07 -0000 1.275
--- oscarinit.sql 14 Jan 2011 15:25:19 -0000 1.276
***************
*** 8166,8195 ****
CREATE TABLE `eyeform_macro` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
! `label` varchar(255) COLLATE utf8_bin NOT NULL,
`display_order` tinyint(4) NOT NULL,
! `impression` text COLLATE utf8_bin,
`followup_no` smallint(5),
! `followup_unit` varchar(50) COLLATE utf8_bin ,
! `followup_doctor` varchar(6) COLLATE utf8_bin ,
! `followup_reason` varchar(255) COLLATE utf8_bin ,
! `tickler_staff` varchar(6) COLLATE utf8_bin ,
! `billing_visit_type` varchar(50) COLLATE utf8_bin,
! `billing_visit_location` varchar(50) COLLATE utf8_bin ,
! `billing_codes` text COLLATE utf8_bin,
! `billing_dxcode` varchar(50) COLLATE utf8_bin ,
! `billing_total` varchar(50) COLLATE utf8_bin ,
! `billing_comment` varchar(255) COLLATE utf8_bin ,
! `billing_billtype` varchar(50) COLLATE utf8_bin ,
! `billing_pay_method` varchar(50) COLLATE utf8_bin ,
! `billing_billto` varchar(50) COLLATE utf8_bin ,
! `billing_remitto` varchar(50) COLLATE utf8_bin ,
! `billing_gstBilledTotal` varchar(50) COLLATE utf8_bin ,
! `billing_payment` varchar(50) COLLATE utf8_bin ,
! `billing_refund` varchar(50) COLLATE utf8_bin ,
! `billing_gst` varchar(50) COLLATE utf8_bin ,
! `test_records` text COLLATE utf8_bin,
! `discharge` varchar(20) COLLATE uft8_bin,
! `stat` varchar(20) COLLATE uft8_bin,
! `opt` varchar(20) COLLATE uft8_bin,
PRIMARY KEY (`id`)
);
--- 8166,8195 ----
CREATE TABLE `eyeform_macro` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
! `label` varchar(255) NOT NULL,
`display_order` tinyint(4) NOT NULL,
! `impression` text,
`followup_no` smallint(5),
! `followup_unit` varchar(50),
! `followup_doctor` varchar(6),
! `followup_reason` varchar(255) ,
! `tickler_staff` varchar(6) ,
! `billing_visit_type` varchar(50) ,
! `billing_visit_location` varchar(50) ,
! `billing_codes` text,
! `billing_dxcode` varchar(50),
! `billing_total` varchar(50) ,
! `billing_comment` varchar(255),
! `billing_billtype` varchar(50) ,
! `billing_pay_method` varchar(50) ,
! `billing_billto` varchar(50) ,
! `billing_remitto` varchar(50) ,
! `billing_gstBilledTotal` varchar(50) ,
! `billing_payment` varchar(50),
! `billing_refund` varchar(50),
! `billing_gst` varchar(50),
! `test_records` text,
! `discharge` varchar(20),
! `stat` varchar(20),
! `opt` varchar(20),
PRIMARY KEY (`id`)
);
|