[Shopsuite-dev] shop.psql

[Davi Leal]

I think there is a typing mistake into HowToMake_ingredient table. Must
prodout_id be prodid_out?. See attached xfig figure. Right?.

#FIG 3.2
Landscape
Center
Metric
A4      
100.00
Single
-2
1200 2
6 450 450 4545 2925
6 2700 990 4545 1800
2 2 0 1 0 7 50 0 -1 0.000 0 0 -1 0 0 5
         2700 990 4545 990 4545 1800 2700 1800 2700 990
4 0 0 50 0 16 12 0.0000 4 135 300 2835 1620 unit\001
4 0 0 50 0 18 12 0.0000 4 135 1680 2790 1260 MeasurementUnits\001
-6
2 2 0 1 0 7 50 0 -1 0.000 0 0 -1 0 0 5
         450 450 1800 450 1800 2925 450 2925 450 450
2 1 0 1 0 7 50 0 -1 0.000 0 0 -1 1 0 2
        3 1 1.00 60.00 120.00
         945 1575 2790 1575
4 0 0 50 0 18 12 0.0000 4 135 795 540 720 Products\001
4 0 0 50 0 16 12 0.0000 4 135 705 540 1170 shortdsc\001
4 0 0 50 0 16 12 0.0000 4 180 660 540 1395 longdsc\001
4 0 0 50 0 16 12 0.0000 4 135 390 540 1620 units\001
4 0 0 50 0 16 12 0.0000 4 180 705 540 1845 sellprice\001
4 0 0 50 0 16 12 0.0000 4 150 315 540 2070 qpu\001
4 0 0 50 0 16 12 0.0000 4 135 435 540 2295 stock\001
4 0 0 50 0 16 12 0.0000 4 135 510 540 2520 active\001
4 0 0 50 0 16 12 0.0000 4 180 525 540 2745 prodid\001
-6
6 3735 2250 12150 6795
6 6435 2250 8505 4095
2 2 0 1 0 7 50 0 -1 0.000 0 0 -1 0 0 5
         6435 2250 8505 2250 8505 4095 6435 4095 6435 2250
4 0 0 50 0 16 12 0.0000 4 135 900 6525 3195 transformid\001
4 0 0 50 0 18 12 0.0000 4 180 1905 6525 2520 Transform_ingredient\001
4 0 0 50 0 16 12 0.0000 4 180 780 6525 3420 prodid_in\001
4 0 0 50 0 16 12 0.0000 4 135 600 6525 3645 amount\001
-6
2 1 0 1 0 7 50 0 -1 0.000 0 0 -1 1 0 2
        3 1 1.00 60.00 120.00
         4770 3105 6480 3105
2 2 0 1 0 7 50 0 -1 0.000 0 0 -1 0 0 5
         3735 2250 5085 2250 5085 4050 3735 4050 3735 2250
2 2 0 1 0 7 50 0 -1 0.000 0 0 -1 0 0 5
         3735 4950 5535 4950 5535 6795 3735 6795 3735 4950
2 1 0 1 0 7 50 0 -1 0.000 0 0 -1 1 0 2
        3 1 1.00 60.00 120.00
         4725 5850 6480 3105
2 2 0 1 0 7 50 0 -1 0.000 0 0 -1 0 0 5
         9900 2250 12150 2250 12150 4095 9900 4095 9900 2250
4 0 0 50 0 16 12 0.0000 4 135 300 5535 3060 1..1\001
4 0 0 50 0 16 12 0.0000 4 135 900 3825 5895 transformid\001
4 0 0 50 0 18 12 0.0000 4 180 1665 3825 5220 Transform_history\001
4 0 0 50 0 18 12 0.0000 4 135 930 3825 2520 Transform\001
4 0 0 50 0 16 12 0.0000 4 180 885 3825 2970 prodid_out\001
4 0 0 50 0 16 12 0.0000 4 135 900 3825 3195 transformid\001
4 0 0 50 0 16 12 0.0000 4 135 450 3825 3420 notes\001
4 0 0 50 0 16 12 0.0000 4 135 510 3825 3645 active\001
4 0 0 50 0 16 12 0.0000 4 135 960 3825 6120 inactivation\001
4 0 0 50 0 16 12 0.0000 4 135 300 5760 4500 1..1\001
4 0 0 50 0 18 12 0.0000 4 180 2100 9990 2520 HowToMake_Ingredient\001
4 0 1 50 0 16 12 0.0000 4 180 885 9990 3420 prodout_id\001
4 0 1 50 0 16 12 0.0000 4 180 780 9990 3645 prodid_in\001
4 0 0 50 0 16 12 0.0000 4 135 600 9990 3870 amount\001
-6
2 1 0 1 0 7 50 0 -1 0.000 0 0 -1 1 0 2
        3 1 1.00 60.00 120.00
         1125 2700 3780 2880
2 2 0 1 0 7 50 0 -1 0.000 0 0 -1 0 0 5
         450 7200 2250 7200 2250 8550 450 8550 450 7200
4 0 0 50 0 18 12 0.0000 4 180 1290 585 7470 DeviationType\001
4 0 0 50 0 16 12 0.0000 4 135 705 585 7875 shortdsc\001
4 0 0 50 0 16 12 0.0000 4 180 660 585 8100 longdsc\001
4 0 0 50 0 16 12 0.0000 4 135 465 585 8325 devid\001
4 0 0 50 0 18 16 0.0000 4 240 1890 4725 405 Not finished yet\001