Hi all As part of the new release i need the convertion of this script in postgres ---------------------------------------- DROP TABLE IF EXISTS `care_encounter_custom_ddc`; CREATE TABLE IF NOT EXISTS `care_encounter_custom_ddc` ( `nr` int(11) NOT NULL auto_increment, `encounter_nr` int(11) NOT NULL, `indatetime` datetime NOT NULL, `urinesugar` varchar(35) NOT NULL, `acetone` varchar(35) NOT NULL, `bloodsugar` decimal(10,2) NOT NULL, `tablets` varchar(35) NOT NULL, `insulin` decimal(10,2) NOT NULL, `createid` varchar(64) NOT NULL, `createtime` timestamp NOT NULL, PRIMARY KEY (`nr`) ) TYPE=MyISAM ;
DROP TABLE IF EXISTS `care_encounter_custom_inout`; CREATE TABLE IF NOT EXISTS `care_encounter_custom_inout` ( `nr` int(11) NOT NULL auto_increment, `encounter_nr` int(11) NOT NULL, `indatetime` datetime NOT NULL, `pint` decimal(10,2) NOT NULL, `solution` varchar(32) NOT NULL, `solutionamount` decimal(10,2) NOT NULL, `initial` varchar(6) NOT NULL, `oralfluid` varchar(32) NOT NULL, `oralfluidamount` decimal(10,2) NOT NULL, `urinetime` time NOT NULL, `urineamount` decimal(10,2) NOT NULL, `rta` decimal(10,2) NOT NULL, `drain` decimal(10,2) NOT NULL, `createid` varchar(64) NOT NULL, `createtime` timestamp NOT NULL, PRIMARY KEY (`nr`) ) TYPE=MyISAM ; DROP TABLE IF EXISTS `care_encounter_custom_noc`; CREATE TABLE IF NOT EXISTS `care_encounter_custom_noc` ( `nr` int(11) NOT NULL auto_increment, `encounter_nr` int(11) NOT NULL, `indatetime` datetime NOT NULL, `verbal` tinyint(1) NOT NULL, `moton` tinyint(1) NOT NULL, `eyes` tinyint(1) NOT NULL, `createid` varchar(64) NOT NULL, `createtime` timestamp NOT NULL, PRIMARY KEY (`nr`) ) TYPE=MyISAM ; DROP TABLE IF EXISTS `care_encounter_custom_tc`; CREATE TABLE IF NOT EXISTS `care_encounter_custom_tc` ( `nr` int(11) NOT NULL auto_increment, `encounter_nr` int(11) NOT NULL, `createid` varchar(64) NOT NULL, `createtime` timestamp NOT NULL, `indatetime` datetime NOT NULL, `time` time NOT NULL, `position` varchar(32) NOT NULL, PRIMARY KEY (`nr`) ) TYPE=MyISAM ; ------------------------------------------------------ As soon as possible... Tnx Claudio ---------------------------------- CGT // mind in progress. http://cgt.altervista.org (Claudio Torbinio) email: [EMAIL PROTECTED] tel. +393339925580 -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Collezioni Moda Giro dÂ’Italia Fashion. Approfitta dei saldi estivi. Sconti dal 30 al 50%. Uomo, Donna e Bambino. Prodotto ufficiale. Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6908&d=28-7 ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
