Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 75f484cf

Von Sven Donath vor fast 14 Jahren hinzugefügt

  • ID 75f484cf53923b2734363b5ed3c81623037aeac3
  • Vorgänger 76f65ebb
  • Nachfolger 5f82c0ec

Vorgaben bei Neuinstallation auf sinnvollere Werte geändert.
Das sind: * "Stck" statt "mg" an erste Stelle. Alle anderen von groß nach klein sortiert * "EUR:USD" als Vorgabe für Währungen. * "Standard 16%/19%" Buchungsgruppe an erste Stelle gesetzt
Alle Änderungen sollen den Start nach der Neuinstallation vereinfachen und
bei Updates nichts verändern.

Unterschiede anzeigen:

sql/Pg-upgrade2/buchungsgruppen_sortkey.sql
6 6 
UPDATE buchungsgruppen SET sortkey = nextval('tmp_counter');
7 7 
DROP SEQUENCE tmp_counter;
8 8 
ALTER TABLE buchungsgruppen ALTER COLUMN sortkey SET NOT NULL;
9 

  		




  
  10
  
    
-- 'Standard 16%/19%' als ersten Eintrag. Der ermäßigte Umsatzsteuersatz wird seltener verwendet.


  		




  
  11
  
    
UPDATE buchungsgruppen SET sortkey=2  WHERE description='Standard 7%';


  		




  
  12
  
    
UPDATE buchungsgruppen SET sortkey=1  WHERE description='Standard 16%/19%';


  		












  

    
      sql/lx-office.sql
    
  





  1253
  1253
  
    
-- Name: defaults; Type: TABLE DATA; Schema: public; Owner: postgres


  		




  1254
  1254
  
    
--


  		




  1255
  1255
  
    

  		




  1256
  
  
    
INSERT INTO "defaults" ("version") VALUES ('2.4.0.0');


  		




  1257
  
  
    

  		




  
  1256
  
    
INSERT INTO "defaults" ("version", "curr") VALUES ('2.4.0.0', 'EUR:USD');


  		




  1258
  1257
  
    

  		




  1259
  1258
  
    
--


  		




  1260
  1259
  
    
-- Data for TOC entry 204 (OID 1982194)


  		




  ......




  1954
  1953
  
    
-- Name: units; Type: TABLE DATA; Schema: public; Owner: postgres


  		




  1955
  1954
  
    
--


  		




  1956
  1955
  
    

  		




  1957
  
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('mg', NULL, NULL, 'dimension');


  		




  1958
  
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('g', 'mg', 1000.00000, 'dimension');


  		




  1959
  
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('kg', 'g', 1000.00000, 'dimension');


  		




  1960
  
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('t', 'kg', 1000.00000, 'dimension');


  		




  1961
  
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('ml', NULL, NULL, 'dimension');


  		




  1962
  
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('L', 'ml', 1000.00000, 'dimension');


  		




  1963
  1956
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('Stck', NULL, NULL, 'dimension');


  		




  1964
  
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('min', NULL, 0.00000, 'service');


  		




  1965
  
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('Std', 'min', 60.00000, 'service');


  		




  1966
  
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('Tag', 'Std', 8.00000, 'service');


  		




  1967
  1957
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('psch', NULL, 0.00000, 'service');


  		




  
  1958
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('Tag', 'Std', 8.00000, 'service');


  		




  
  1959
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('Std', 'min', 60.00000, 'service');


  		




  
  1960
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('min', NULL, 0.00000, 'service');


  		




  
  1961
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('t', 'kg', 1000.00000, 'dimension');


  		




  
  1962
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('kg', 'g', 1000.00000, 'dimension');


  		




  
  1963
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('g', 'mg', 1000.00000, 'dimension');


  		




  
  1964
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('mg', NULL, NULL, 'dimension');


  		




  
  1965
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('L', 'ml', 1000.00000, 'dimension');


  		




  
  1966
  
    
INSERT INTO units (name, base_unit, factor, "type") VALUES ('ml', NULL, NULL, 'dimension');


  		




  1968
  1967
  
    

  		




  1969
  1968
  
    

  		




  1970
  1969
  
    
--


  		












Auch abrufbar als:  Unified diff