Thanks :-D Robert
Am Mittwoch, den 29.09.2010, 18:08 +0530 schrieb Ap.Muthu: > 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; -- -- -------------------------------------------- CARE2X - free Integ Hospital Info System https://sourceforge.net/projects/care2002/ http://www.care2x.org ------------------------------------------------------------------------------ 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