From b155544f4d9ff7d2c0689b476602681c6f86dc13 Mon Sep 17 00:00:00 2001 From: sunsetsystems Date: Thu, 24 Aug 2006 04:52:44 +0000 Subject: [PATCH] add phone_pharmacy; change prescription item size to float --- sql/2_8_1-to-2_8_2_upgrade.sql | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/sql/2_8_1-to-2_8_2_upgrade.sql b/sql/2_8_1-to-2_8_2_upgrade.sql index 2075dcdf2..cd9d03db3 100644 --- a/sql/2_8_1-to-2_8_2_upgrade.sql +++ b/sql/2_8_1-to-2_8_2_upgrade.sql @@ -267,8 +267,8 @@ ALTER TABLE registry ADD COLUMN priority INT DEFAULT 0 AFTER date; ALTER TABLE registry ADD COLUMN category VARCHAR(255) DEFAULT "category" AFTER priority; ALTER TABLE registry ADD COLUMN nickname VARCHAR(255) DEFAULT '' AFTER category; -# ALTER TABLE patient_data -# ADD phone_pharmacy varchar(255) NOT NULL default ''; +ALTER TABLE patient_data + ADD phone_pharmacy varchar(255) NOT NULL default ''; ## array table for storing configuration data and string lists etc... @@ -362,3 +362,9 @@ ALTER TABLE drug_inventory ADD destroy_method varchar(255) NOT NULL DEFAULT '', ADD destroy_witness varchar(255) NOT NULL DEFAULT '', ADD destroy_notes varchar(255) NOT NULL DEFAULT ''; + +ALTER TABLE prescriptions + MODIFY `size` float unsigned DEFAULT NULL; + +ALTER TABLE drugs + MODIFY `size` float unsigned NOT NULL DEFAULT 0; -- 2.11.4.GIT