"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "mrbs-1.9.4/tables.pg.sql" between
mrbs-1.9.4.tar.gz and mrbs-1.10.0.tar.gz

About: MRBS is a web application for booking meeting rooms or other resources (using PHP and MySQL/pgsql).

tables.pg.sql  (mrbs-1.9.4)	:	tables.pg.sql  (mrbs-1.10.0)
skipping to change at line 110		skipping to change at line 110
comment on column mrbs_room.invalid_types is 'JSON encoded';		comment on column mrbs_room.invalid_types is 'JSON encoded';
create index mrbs_idxSortKey on mrbs_room(sort_key);		create index mrbs_idxSortKey on mrbs_room(sort_key);
CREATE TABLE mrbs_repeat		CREATE TABLE mrbs_repeat
(		(
id serial primary key,		id serial primary key,
start_time int DEFAULT 0 NOT NULL,		start_time int DEFAULT 0 NOT NULL,
end_time int DEFAULT 0 NOT NULL,		end_time int DEFAULT 0 NOT NULL,
rep_type int DEFAULT 0 NOT NULL,		rep_type int DEFAULT 0 NOT NULL,
end_date int DEFAULT 0 NOT NULL,		end_date int DEFAULT 0 NOT NULL,
rep_opt varchar(32) NOT NULL,		rep_opt varchar(32) DEFAULT '' NOT NULL,
room_id int DEFAULT 1 NOT NULL		room_id int DEFAULT 1 NOT NULL
REFERENCES mrbs_room(id)		REFERENCES mrbs_room(id)
ON UPDATE CASCADE		ON UPDATE CASCADE
ON DELETE RESTRICT,		ON DELETE RESTRICT,
timestamp timestamptz DEFAULT current_timestamp,		timestamp timestamptz DEFAULT current_timestamp,
create_by varchar(80) NOT NULL,		create_by varchar(80) DEFAULT '' NOT NULL,
modified_by varchar(80) NOT NULL,		modified_by varchar(80) DEFAULT '' NOT NULL,
name varchar(80) NOT NULL,		name varchar(80) DEFAULT '' NOT NULL,
type char DEFAULT 'E' NOT NULL,		type char DEFAULT 'E' NOT NULL,
description text,		description text,
rep_interval smallint DEFAULT 1 NOT NULL,		rep_interval smallint DEFAULT 1 NOT NULL,
month_absolute smallint DEFAULT NULL,		month_absolute smallint DEFAULT NULL,
month_relative varchar(4) DEFAULT NULL,		month_relative varchar(4) DEFAULT NULL,
status smallint DEFAULT 0 NOT NULL,		status smallint DEFAULT 0 NOT NULL,
reminded int,		reminded int,
info_time int,		info_time int,
info_user varchar(80),		info_user varchar(80),
info_text text,		info_text text,
skipping to change at line 151		skipping to change at line 151
entry_type int DEFAULT 0 NOT NULL,		entry_type int DEFAULT 0 NOT NULL,
repeat_id int DEFAULT NULL		repeat_id int DEFAULT NULL
REFERENCES mrbs_repeat(id)		REFERENCES mrbs_repeat(id)
ON UPDATE CASCADE		ON UPDATE CASCADE
ON DELETE CASCADE,		ON DELETE CASCADE,
room_id int DEFAULT 1 NOT NULL		room_id int DEFAULT 1 NOT NULL
REFERENCES mrbs_room(id)		REFERENCES mrbs_room(id)
ON UPDATE CASCADE		ON UPDATE CASCADE
ON DELETE RESTRICT,		ON DELETE RESTRICT,
timestamp timestamptz DEFAULT current_timestamp,		timestamp timestamptz DEFAULT current_timestamp,
create_by varchar(80) NOT NULL,		create_by varchar(80) DEFAULT '' NOT NULL,
modified_by varchar(80) NOT NULL,		modified_by varchar(80) DEFAULT '' NOT NULL,
name varchar(80) NOT NULL,		name varchar(80) DEFAULT '' NOT NULL,
type char DEFAULT 'E' NOT NULL,		type char DEFAULT 'E' NOT NULL,
description text,		description text,
status smallint DEFAULT 0 NOT NULL,		status smallint DEFAULT 0 NOT NULL,
reminded int,		reminded int,
info_time int,		info_time int,
info_user varchar(80),		info_user varchar(80),
info_text text,		info_text text,
ical_uid varchar(255) DEFAULT '' NOT NULL,		ical_uid varchar(255) DEFAULT '' NOT NULL,
ical_sequence smallint DEFAULT 0 NOT NULL,		ical_sequence smallint DEFAULT 0 NOT NULL,
ical_recur_id varchar(16) DEFAULT NULL,		ical_recur_id varchar(16) DEFAULT NULL,
skipping to change at line 225		skipping to change at line 225
(		(
id varchar(191) NOT NULL primary key,		id varchar(191) NOT NULL primary key,
access int DEFAULT NULL,		access int DEFAULT NULL,
data text DEFAULT NULL		data text DEFAULT NULL
);		);
create index mrbs_idxAccess on mrbs_sessions(access);		create index mrbs_idxAccess on mrbs_sessions(access);
CREATE TABLE mrbs_users		CREATE TABLE mrbs_users
(		(
id serial primary key,		id serial primary key,
level smallint DEFAULT '0' NOT NULL, /* play safe and give no rights */		level smallint DEFAULT 0 NOT NULL, /* play safe and give no rights */
name varchar(30),		name varchar(30),
display_name varchar(191),		display_name varchar(191),
password_hash varchar(255),		password_hash varchar(255),
email varchar(75),		email varchar(75),
timestamp timestamptz DEFAULT current_timestamp,		timestamp timestamptz DEFAULT current_timestamp,
last_login int DEFAULT 0 NOT NULL,		last_login int DEFAULT 0 NOT NULL,
reset_key_hash varchar(255),		reset_key_hash varchar(255),
reset_key_expiry int DEFAULT 0 NOT NULL,		reset_key_expiry int DEFAULT 0 NOT NULL,
CONSTRAINT mrbs_uq_name UNIQUE (name)		CONSTRAINT mrbs_uq_name UNIQUE (name)
skipping to change at line 251		skipping to change at line 251
NEW.timestamp = NOW();		NEW.timestamp = NOW();
RETURN NEW;		RETURN NEW;
END;		END;
$$ language 'plpgsql';		$$ language 'plpgsql';
CREATE TRIGGER update_mrbs_entry_timestamp BEFORE UPDATE ON mrbs_entry FOR EACH ROW EXECUTE PROCEDURE update_timestamp_column();		CREATE TRIGGER update_mrbs_entry_timestamp BEFORE UPDATE ON mrbs_entry FOR EACH ROW EXECUTE PROCEDURE update_timestamp_column();
CREATE TRIGGER update_mrbs_repeat_timestamp BEFORE UPDATE ON mrbs_repeat FOR EAC H ROW EXECUTE PROCEDURE update_timestamp_column();		CREATE TRIGGER update_mrbs_repeat_timestamp BEFORE UPDATE ON mrbs_repeat FOR EAC H ROW EXECUTE PROCEDURE update_timestamp_column();
CREATE TRIGGER update_mrbs_users_timestamp BEFORE UPDATE ON mrbs_users FOR EACH ROW EXECUTE PROCEDURE update_timestamp_column();		CREATE TRIGGER update_mrbs_users_timestamp BEFORE UPDATE ON mrbs_users FOR EACH ROW EXECUTE PROCEDURE update_timestamp_column();
INSERT INTO mrbs_variables (variable_name, variable_content)		INSERT INTO mrbs_variables (variable_name, variable_content)
VALUES ('db_version', '81');		VALUES ('db_version', '82');
INSERT INTO mrbs_variables (variable_name, variable_content)		INSERT INTO mrbs_variables (variable_name, variable_content)
VALUES ('local_db_version', '1');		VALUES ('local_db_version', '1');
End of changes. 5 change blocks.
9 lines changed or deleted		9 lines changed or added

---