File: 24_dbmigrate.sql

package info (click to toggle)
kraft 2.0.0-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 10,112 kB
  • sloc: cpp: 28,535; sql: 1,248; perl: 396; xml: 330; python: 101; sh: 92; makefile: 10
file content (16 lines) | stat: -rw-r--r-- 634 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 

ALTER TABLE units ADD COLUMN ec20 VARCHAR(10);

UPDATE units set ec20 = "MTR" WHERE unitShort = "m";
UPDATE units set ec20 = "MTK" WHERE unitShort = "qm" or unitShort = "sm";
UPDATE units set ec20 = "MTQ" WHERE unitShort = "cbm";
UPDATE units set ec20 = "XSA" WHERE unitLong = "Sack" or unitLong = "Bag";
UPDATE units set ec20 = "LTR" WHERE unitLong = "Liter";
UPDATE units set ec20 = "KGM" WHERE unitLong = "Kilogramm";
UPDATE units set ec20 = "XPP" WHERE unitShort = "Stck." or unitShort ="Pcs.";
UPDATE units set ec20 = "TNE" WHERE unitShort = "t";
UPDATE units set ec20 = "HUR" WHERE unitLong = "Stunde" or unitLong ="Hour";