 INSERT INTO system_attrs VALUES (136902, 'utolso_log_kuldve', '2009-08-26');
 INSERT INTO event (evt_text) VALUES ('JELENTKEZES');
 INSERT INTO event (evt_text) VALUES ('TAGSAGTORLES');
+insert into event (evt_text) VALUES ('SVIE_JELENTKEZES');
+insert into event (evt_text) VALUES ('SVIE_TAGSAGTORLES');
+insert into event (evt_text) VALUES ('PARTOLOVAVALAS');
+insert into event (evt_text) VALUES ('RENDESTAGGAVALAS');
+insert into event (evt_text) VALUES ('ELFOGADASALATT');
+

\echo indexek létrehozása

create index poszt_fk_idx ON poszt ( grp_member_id );

\echo SVIE posztok hozzáadása


\echo Logolási rendszer előállítása

create table event ( evt_id integer NOT NULL, evt_text character varying(30), PRIMARY KEY (evt_id) );
create table log ( id integer NOT NULL,  grp_id integer, usr_id integer NOT NULL, evt_id integer NOT NULL, evt_date date DEFAULT now(), PRIMARY KEY (id));
create sequence event_seq;
create sequence log_seq;
alter table event alter COLUMN evt_id SET default nextval('event_seq'::regClass);
