To bring the DB upto SVN 6828, the following SQL needs to be executed:
CREATE TABLE IF NOT EXISTS `care_med_orderlist_sub` (
`sub_order` int(20) NOT NULL AUTO_INCREMENT,
`order_nr_sub` int(20) NOT NULL,
`bestellnum` varchar(25) DEFAULT '0',
`idsub` varchar(20) NOT NULL DEFAULT '0' COMMENT 'id of
care_pharma_products_main_sub',
`artikelname` varchar(25) DEFAULT NULL,
`pcs` double NOT NULL DEFAULT '0',
`maxorder` int(11) DEFAULT NULL,
`minorder` int(11) DEFAULT NULL,
`proorder` int(11) DEFAULT NULL,
`unit` varchar(20) DEFAULT NULL,
`expiry_date` date DEFAULT NULL,
`price` decimal(11,2) DEFAULT NULL,
`dose` decimal(11,2) DEFAULT NULL,
`value` decimal(11,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`sub_order`),
KEY `order_nr_sub` (`order_nr_sub`)
) ENGINE=InnoDB ;
CREATE TABLE IF NOT EXISTS `care_med_products_main_movements` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`pharmacy_id` int(11) NOT NULL DEFAULT '0',
`data` date NOT NULL DEFAULT '0000-00-00',
`bill_nr` varchar(255) NOT NULL DEFAULT '0',
`medicament` tinytext,
`qty` double NOT NULL DEFAULT '0',
`price` double NOT NULL DEFAULT '0',
`value` double NOT NULL DEFAULT '0',
`expiry_date` date NOT NULL DEFAULT '0000-00-00',
`id_sub` int(11) NOT NULL COMMENT 'connection to id te sub product',
PRIMARY KEY (`id`)
) ENGINE=InnoDB ;
CREATE TABLE IF NOT EXISTS `care_med_products_main_sub` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`pcs` double NOT NULL DEFAULT '0',
`expiry_date` date DEFAULT NULL,
`price` double DEFAULT NULL,
`bestellnum` varchar(25) DEFAULT NULL COMMENT 'connection to
care_med_products_main',
`idcare_supply` int(10) DEFAULT NULL,
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB ;
CREATE TABLE IF NOT EXISTS `care_pharma_orderlist_sub` (
`sub_order` int(20) NOT NULL AUTO_INCREMENT,
`order_nr_sub` int(20) NOT NULL,
`bestellnum` varchar(25) DEFAULT '0',
`idsub` varchar(20) NOT NULL DEFAULT '0' COMMENT 'id of
care_pharma_products_main_sub',
`artikelname` varchar(25) DEFAULT NULL,
`pcs` double NOT NULL DEFAULT '0',
`maxorder` int(11) DEFAULT NULL,
`minorder` int(11) DEFAULT NULL,
`proorder` int(11) DEFAULT NULL,
`unit` varchar(20) DEFAULT NULL,
`expiry_date` date DEFAULT NULL,
`price` decimal(11,2) DEFAULT NULL,
`dose` decimal(11,2) DEFAULT NULL,
`value` decimal(11,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`sub_order`),
KEY `order_nr_sub` (`order_nr_sub`)
) ENGINE=InnoDB ;
CREATE TABLE IF NOT EXISTS `care_pharma_products_main_movements` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`dept_id` int(11) NOT NULL DEFAULT '0',
`data` date NOT NULL DEFAULT '0000-00-00',
`bill_nr` varchar(255) NOT NULL DEFAULT '0',
`medicament` varchar(255) NOT NULL DEFAULT '0',
`qty` double NOT NULL DEFAULT '0',
`price` double NOT NULL DEFAULT '0',
`value` double NOT NULL DEFAULT '0',
`expiry_date` date NOT NULL DEFAULT '0000-00-00',
`id_sub` int(11) NOT NULL COMMENT 'connected with the med products table',
PRIMARY KEY (`id`)
) ENGINE=InnoDB ;
CREATE TABLE IF NOT EXISTS `care_pharma_products_main_sub` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`bestellnum` varchar(25) DEFAULT NULL COMMENT 'connection to
care_pharma_products_main',
`pcs` double NOT NULL DEFAULT '0',
`expiry_date` date DEFAULT NULL,
`price` double DEFAULT NULL,
`idcare_pharma` int(10) DEFAULT NULL,
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB ;
CREATE TABLE IF NOT EXISTS `care_supplier` (
`idcare_supplier` int(3) NOT NULL AUTO_INCREMENT,
`supplier` varchar(35) NOT NULL DEFAULT '',
`address` varchar(100) DEFAULT NULL,
`telephone` varchar(35) DEFAULT NULL,
`fax` varchar(35) DEFAULT NULL,
`postal_code` varchar(5) DEFAULT NULL,
`representative` varchar(35) DEFAULT NULL,
`history` text,
`create_id` varchar(35) DEFAULT NULL,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`idcare_supplier`)
) ENGINE=InnoDB ;
CREATE TABLE IF NOT EXISTS `care_supply` (
`idcare_furnizim` int(10) unsigned NOT NULL AUTO_INCREMENT,
`idcare_supplier` tinyint(3) unsigned NOT NULL,
`bestellnum` varchar(25) NOT NULL,
`expiry_date` varchar(25) DEFAULT '0000-00-00 00:00:00',
`qty` double unsigned NOT NULL DEFAULT '0',
`price` double DEFAULT '0',
`value` double DEFAULT '0',
`notes` varchar(200) DEFAULT NULL,
`bill_nr` varchar(25) DEFAULT NULL,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`create_id` varchar(35) DEFAULT NULL,
`history` text,
`order_date` date DEFAULT NULL,
`articles` text,
`order_time` time DEFAULT NULL,
`ip_addr` tinytext,
`status` varchar(25) DEFAULT NULL,
`sent_datetime` datetime DEFAULT '0000-00-00 00:00:00',
`validator` tinytext,
`modify_id` varchar(35) DEFAULT NULL,
`process_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`idcare_furnizim`,`idcare_supplier`,`bestellnum`),
KEY `idcare_furnitor` (`idcare_supplier`),
KEY `bestellnum` (`bestellnum`)
) ENGINE=InnoDB ;
CREATE TABLE IF NOT EXISTS `care_supply_movements` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`id_supplier` int(11) NOT NULL,
`data` date NOT NULL,
`bill_nr` varchar(255) NOT NULL DEFAULT '',
`medicament` varchar(255) NOT NULL DEFAULT '',
`qty` double NOT NULL,
`price` double NOT NULL,
`value` double NOT NULL,
`expiry_date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB ;
ALTER TABLE `care_med_orderlist_sub`
ADD CONSTRAINT `care_med_orderlist_sub_fk` FOREIGN KEY (`order_nr_sub`)
REFERENCES `care_med_orderlist` (`order_nr`) ON DELETE CASCADE ON UPDATE
CASCADE;
ALTER TABLE `care_pharma_orderlist_sub`
ADD CONSTRAINT `care_pharma_orderlist_sub_fk` FOREIGN KEY (`order_nr_sub`)
REFERENCES `care_pharma_orderlist` (`order_nr`) ON DELETE CASCADE ON UPDATE
CASCADE;
Regards,
Ap.Muthu
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers
