DROP TABLE r_belag;

CREATE TABLE r_belag
(
  belag_id serial NOT NULL,
  belag_name character varying(255),
  CONSTRAINT belag_id PRIMARY KEY (belag_id)
);

INSERT INTO r_belag(belag_name) VALUES ('Beton');
INSERT INTO r_belag(belag_name) VALUES ('Betonboden');
INSERT INTO r_belag(belag_name) VALUES ('Fliesen');
INSERT INTO r_belag(belag_name) VALUES ('Fliesen/Teppich');
INSERT INTO r_belag(belag_name) VALUES ('Kautschuk');
INSERT INTO r_belag(belag_name) VALUES ('Parkett');
INSERT INTO r_belag(belag_name) VALUES ('PVC');
INSERT INTO r_belag(belag_name) VALUES ('PVC/Struktur');
INSERT INTO r_belag(belag_name) VALUES ('PVC/Fliesen');
INSERT INTO r_belag(belag_name) VALUES ('Steine');
INSERT INTO r_belag(belag_name) VALUES ('Teppich');
INSERT INTO r_belag(belag_name) VALUES ('nicht bekannt');


/* TODO: reference belag_id in raumpoly tables */
