Revision ea57e835
Von Holger Lindemann vor etwa 15 Jahren hinzugefügt
| sql/Pg-upgrade/Pg-upgrade-2.1.0-2.1.1.sql | ||
|---|---|---|
| 733 | 733 |
-- |
| 734 | 734 |
--TABLE ap |
| 735 | 735 |
alter table ap rename column paid to paidold; |
| 736 |
alter table ap add column paid numeric(10,5);
|
|
| 736 |
alter table ap add column paid numeric(12,5);
|
|
| 737 | 737 |
update ap set paid=paidold; |
| 738 | 738 |
alter table ap drop column paidold; |
| 739 | 739 |
-- |
| 740 | 740 |
alter table ap rename column netamount to netamountold; |
| 741 |
alter table ap add column netamount numeric(10,5);
|
|
| 741 |
alter table ap add column netamount numeric(12,5);
|
|
| 742 | 742 |
update ap set netamount=netamountold; |
| 743 | 743 |
alter table ap drop column netamountold; |
| 744 | 744 |
-- |
| 745 | 745 |
alter table ap rename column amount to amountold; |
| 746 |
alter table ap add column amount numeric(10,5);
|
|
| 746 |
alter table ap add column amount numeric(12,5);
|
|
| 747 | 747 |
update ap set amount=amountold; |
| 748 | 748 |
alter table ap drop column amountold; |
| 749 | 749 |
-- |
| 750 | 750 |
--TABLE acc_trans |
| 751 | 751 |
alter table acc_trans rename column amount to amountold; |
| 752 |
alter table acc_trans add column amount numeric(10,5);
|
|
| 752 |
alter table acc_trans add column amount numeric(12,5);
|
|
| 753 | 753 |
update acc_trans set amount=amountold; |
| 754 | 754 |
alter table acc_trans drop column amountold; |
| 755 | 755 |
-- |
| 756 | 756 |
--TABLE ar |
| 757 | 757 |
alter table ar rename column amount to amountold; |
| 758 |
alter table ar add column amount numeric(10,5);
|
|
| 758 |
alter table ar add column amount numeric(12,5);
|
|
| 759 | 759 |
update ar set amount=amountold; |
| 760 | 760 |
alter table ar drop column amountold; |
| 761 | 761 |
-- |
| 762 | 762 |
alter table ar rename column netamount to netamountold; |
| 763 |
alter table ar add column netamount numeric(10,5);
|
|
| 763 |
alter table ar add column netamount numeric(12,5);
|
|
| 764 | 764 |
update ar set netamount=netamountold; |
| 765 | 765 |
alter table ar drop column netamountold; |
| 766 | 766 |
-- |
| 767 | 767 |
alter table ar rename column paid to paidold; |
| 768 |
alter table ar add column paid numeric(10,5);
|
|
| 768 |
alter table ar add column paid numeric(12,5);
|
|
| 769 | 769 |
update ar set paid=paidold; |
| 770 | 770 |
alter table ar drop column paidold; |
| 771 | 771 |
-- |
| 772 | 772 |
--TABLE customer |
| 773 | 773 |
alter table customer rename column creditlimit to creditlimitold; |
| 774 |
alter table customer add column creditlimit numeric(10,5);
|
|
| 774 |
alter table customer add column creditlimit numeric(12,5);
|
|
| 775 | 775 |
update customer set creditlimit=creditlimitold; |
| 776 | 776 |
alter table customer drop column creditlimitold; |
| 777 | 777 |
-- |
| 778 | 778 |
--TABLE exchangerate |
| 779 | 779 |
alter table exchangerate rename column buy to buyold; |
| 780 |
alter table exchangerate add column buy numeric(10,5);
|
|
| 780 |
alter table exchangerate add column buy numeric(12,5);
|
|
| 781 | 781 |
update exchangerate set buy=buyold; |
| 782 | 782 |
alter table exchangerate drop column buyold; |
| 783 | 783 |
-- |
| 784 | 784 |
alter table exchangerate rename column sell to sellold; |
| 785 |
alter table exchangerate add column sell numeric(10,5);
|
|
| 785 |
alter table exchangerate add column sell numeric(12,5);
|
|
| 786 | 786 |
update exchangerate set sell=sellold; |
| 787 | 787 |
alter table exchangerate drop column sellold; |
| 788 | 788 |
-- |
| 789 | 789 |
--TABLE invoice |
| 790 | 790 |
alter table invoice rename column sellprice to sellpriceold; |
| 791 |
alter table invoice add column sellprice numeric(10,5);
|
|
| 791 |
alter table invoice add column sellprice numeric(12,5);
|
|
| 792 | 792 |
update invoice set sellprice=sellpriceold; |
| 793 | 793 |
alter table invoice drop column sellpriceold; |
| 794 | 794 |
-- |
| 795 | 795 |
alter table invoice rename column fxsellprice to fxsellpriceold; |
| 796 |
alter table invoice add column fxsellprice numeric(10,5);
|
|
| 796 |
alter table invoice add column fxsellprice numeric(12,5);
|
|
| 797 | 797 |
update invoice set fxsellprice=fxsellpriceold; |
| 798 | 798 |
alter table invoice drop column fxsellpriceold; |
| 799 | 799 |
-- |
| 800 | 800 |
--TABLE oe |
| 801 | 801 |
alter table oe rename column amount to amountold; |
| 802 |
alter table oe add column amount numeric(10,5);
|
|
| 802 |
alter table oe add column amount numeric(12,5);
|
|
| 803 | 803 |
update oe set amount=amountold; |
| 804 | 804 |
alter table oe drop column amountold; |
| 805 | 805 |
-- |
| 806 | 806 |
alter table oe rename column netamount to netamountold; |
| 807 |
alter table oe add column netamount numeric(10,5);
|
|
| 807 |
alter table oe add column netamount numeric(12,5);
|
|
| 808 | 808 |
update oe set netamount=netamountold; |
| 809 | 809 |
alter table oe drop column netamountold; |
| 810 | 810 |
-- |
| 811 | 811 |
--TABLE orderitems |
| 812 | 812 |
alter table orderitems rename column sellprice to sellpriceold; |
| 813 |
alter table orderitems add column sellprice numeric(10,5);
|
|
| 813 |
alter table orderitems add column sellprice numeric(12,5);
|
|
| 814 | 814 |
update orderitems set sellprice=sellpriceold; |
| 815 | 815 |
alter table orderitems drop column sellpriceold; |
| 816 | 816 |
-- |
| 817 | 817 |
--TABLE parts |
| 818 | 818 |
alter table parts rename column listprice to listpriceold; |
| 819 |
alter table parts add column listprice numeric(10,5);
|
|
| 819 |
alter table parts add column listprice numeric(12,5);
|
|
| 820 | 820 |
update parts set listprice=listpriceold; |
| 821 | 821 |
alter table parts drop column listpriceold; |
| 822 | 822 |
-- |
| 823 | 823 |
alter table parts rename column sellprice to sellpriceold; |
| 824 |
alter table parts add column sellprice numeric(10,5);
|
|
| 824 |
alter table parts add column sellprice numeric(12,5);
|
|
| 825 | 825 |
update parts set sellprice=sellpriceold; |
| 826 | 826 |
alter table parts drop column sellpriceold; |
| 827 | 827 |
-- |
| 828 | 828 |
alter table parts rename column lastcost to lastcostold; |
| 829 |
alter table parts add column lastcost numeric(10,5);
|
|
| 829 |
alter table parts add column lastcost numeric(12,5);
|
|
| 830 | 830 |
update parts set lastcost=lastcostold; |
| 831 | 831 |
alter table parts drop column lastcostold; |
| 832 | 832 |
-- |
| 833 | 833 |
--TABLE tax |
| 834 | 834 |
alter table tax rename column rate to rateold; |
| 835 |
alter table tax add column rate numeric(10,5);
|
|
| 835 |
alter table tax add column rate numeric(12,5);
|
|
| 836 | 836 |
update tax set rate=rateold; |
| 837 | 837 |
alter table tax drop column rateold; |
| 838 | 838 |
-- |
| 839 | 839 |
--TABLE vendor |
| 840 | 840 |
alter table vendor rename column creditlimit to creditlimitold; |
| 841 |
alter table vendor add column creditlimit numeric(10,5);
|
|
| 841 |
alter table vendor add column creditlimit numeric(12,5);
|
|
| 842 | 842 |
update vendor set creditlimit=creditlimitold; |
| 843 | 843 |
alter table vendor drop column creditlimitold; |
| 844 | 844 |
-- |
Auch abrufbar als: Unified diff
numberwert zu klein, auf 12,5 vergrössert