 ALTER TABLE users ADD COLUMN usr_svie_state character varying(255) NOT NULL DEFAULT 'NEMTAG';
 ALTER TABLE users ADD COLUMN usr_svie_member_type character varying(255) NOT NULL DEFAULT 'NEMTAG';
 ALTER TABLE users ADD COLUMN usr_svie_primary_group integer;
-ALTER TABLE users ADD COLUMN usr_delegated BOOLEAN NOT NULL DEFAULT false;
 ALTER TABLE groups ADD COLUMN grp_issvie boolean NOT NULL DEFAULT false;
 ALTER TABLE groups ADD COLUMN grp_svie_delegate_nr integer;
 

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');

\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);
