#
# Table structure for table 'phonelog_entry'
#

CREATE TABLE phonelog_entry (
  pl_id            int(11) DEFAULT '0' NOT NULL auto_increment,
  pl_callfrom_id   int(11) DEFAULT '0' NOT NULL,
  pl_callfrom_txt  varchar(255),
  pl_callfor       int(11) DEFAULT '0' NOT NULL,
  pl_calldate      int,
  pl_status        tinyint(4) DEFAULT '0' NOT NULL,
  pl_desc_short    varchar(255),
  pl_desc_long     text,
  PRIMARY KEY (pl_id)
);

#
# insert the phonelog application in the list of applications
#
INSERT INTO phpgw_applications (app_name,app_title, app_enabled, app_order, app_tables, app_version) 
VALUES ('phonelog','Phone Log',1,30,'phonelog_entry','0.9.10pre16');
