-- temporary table used for importing the person table from text.
drop table person.tmppersons;
create table person.tmppersons
(
	Name				text	not null,
	Title				text	null,
	Education			text	null,
	PersonalNo			text	null,
	Address				text	null,
	Town				text	null,
	HomePhone			text	null,
	HomeMobilePhone			text	null,
	WorkPhone			text	null,
	WorkMobilePhone			text	null,
	Fax				text	null,
	OfficeRoom			text	null,
	SomeNewField			text	null,
	LoginName			text	null,
	-- signature = email :))
	Signature			text	null,
	HomePage			text	null,
	SpecialKnowledge		text   null,
	Employed_for			text	null,
	PersonGroups			text	null,
	Status				text	null,
	-- updated by: date/login
	UpdatedBy			text	null,
        trash                           text    null
);
