CREATE TABLE alairas
(
   alairas_kod serial, 
   nev varchar(50), 
   beosztas varchar(40), 
   c_userid varchar(20),
   c_date date,
   c_time varchar(10),
   m_userid varchar(20),
   m_date date,
   m_time varchar(10),
   CONSTRAINT alairas_pk1 PRIMARY KEY (alairas_kod)
) WITHOUT OIDS;
ALTER TABLE alairas OWNER TO mbt;