[Phpgroupware-cvs] CVS: phonelog/doc/examples/sql create_tables.mysql,NONE,1.1 create_tables.pgsql,NONE,1.1

[Luca - De Whiskey's - De Vitis <address@hidden>]

Update of /cvsroot/phpgroupware/phonelog/doc/examples/sql
In directory subversions:/tmp/cvs-serv15597/phonelog/doc/examples/sql

Added Files:
        create_tables.mysql create_tables.pgsql 
Log Message:


Minor changes to directory structure:
- Moved old sql files to a more suitable place.
- Moved chora/docs to chora/doc


--- NEW FILE ---
#
# 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');

--- NEW FILE ---

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

INSERT INTO applications VALUES ('phonelog','Phone 
Log',1,30,'phonelog_entry','0.8.1pre1');