X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.3.sql;h=c5518404e25e9b185a8569c3abd12b58ea41619a;hb=48589f9ce6c51bb25e2fa8ed83c57d9dfa485e44;hp=af668bc81f9b3dcaac11c18d807c28d0254493a5;hpb=46c5f7a65a7659a44ae8254c63152074363d3987;p=fa-stable.git diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql index af668bc8..c5518404 100644 --- a/sql/alter2.3.sql +++ b/sql/alter2.3.sql @@ -152,7 +152,7 @@ ALTER TABLE `0_chart_master` CHANGE `account_type` `account_type` VARCHAR(10) NO ALTER TABLE `0_chart_types` CHANGE `id` `id` VARCHAR(10) NOT NULL; ALTER TABLE `0_chart_types` CHANGE `parent` `parent` VARCHAR(10) NOT NULL DEFAULT '-1'; ALTER TABLE `0_chart_types` CHANGE `class_id` `class_id` VARCHAR(3) NOT NULL DEFAULT ''; -. + UPDATE `0_chart_types` SET parent='' WHERE parent='0' OR parent='-1'; INSERT INTO `0_sys_prefs` (name, category, type, length, value) VALUES ('auto_curr_reval','setup.company', 'smallint','6', '1');