User Tools

Site Tools


podoc:ev_comp_sql_table

Database Table Description of "ev_comp"

Name

ev_comp

Description

Purpose

Schema

CREATE TABLE ev_comp (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

References tables

None.

Is referenced by tables

None.

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

CREATE TABLE ev_comp (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);
Data change history

= Version 2.5 =

INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-4.7');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-4.5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-4.3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-4');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-3.7');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-3.5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-3.3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-2.7');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-2.5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-2.3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-2');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-1.7');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-1.5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-1.3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-1');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-0.7');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-0.5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-0.3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '0');
-- the missing values were added in 2.6
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '1.3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '1.5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '1.7');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '2');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '2.3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '2.5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '2.7');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '3.3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '3.5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '3.7');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '4');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '4.3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '4.5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '4.7');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '5');

= Version 2.6 =

-- insert the missing ev_comp values
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '0.3');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '0.5');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '0.7');
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '1');
-- reset ev compensation values so that they appear in the sequence they should
UPDATE ev_comp SET VALUE='0.3' WHERE identifier=22;
UPDATE ev_comp SET VALUE='0.5' WHERE identifier=23;
UPDATE ev_comp SET VALUE='0.7' WHERE identifier=24;
UPDATE ev_comp SET VALUE='1'   WHERE identifier=25;
UPDATE ev_comp SET VALUE='1.3' WHERE identifier=26;
UPDATE ev_comp SET VALUE='1.5' WHERE identifier=27;
UPDATE ev_comp SET VALUE='1.7' WHERE identifier=28;
UPDATE ev_comp SET VALUE='2'   WHERE identifier=29;
UPDATE ev_comp SET VALUE='2.3' WHERE identifier=30;
UPDATE ev_comp SET VALUE='2.5' WHERE identifier=31;
UPDATE ev_comp SET VALUE='2.7' WHERE identifier=32;
UPDATE ev_comp SET VALUE='3'   WHERE identifier=33;
UPDATE ev_comp SET VALUE='3.3' WHERE identifier=34;
UPDATE ev_comp SET VALUE='3.5' WHERE identifier=35;
UPDATE ev_comp SET VALUE='3.7' WHERE identifier=36;
UPDATE ev_comp SET VALUE='4'   WHERE identifier=37;
UPDATE ev_comp SET VALUE='4.3' WHERE identifier=38;
UPDATE ev_comp SET VALUE='4.5' WHERE identifier=39;
UPDATE ev_comp SET VALUE='4.7' WHERE identifier=40;
UPDATE ev_comp SET VALUE='5'   WHERE identifier=41;
podoc/ev_comp_sql_table.txt · Last modified: 2007/04/20 10:24 by Luud