plugins/conversions/docs/plugins/conversions/sql/mysql innodb.sql,NONE,1.1 myisam.sql,NONE,1.1

Sebastian Bergmann <[email protected]> Sun, 11 Apr 2004 09:45:18 +0000
Newsgroups gmane.comp.web.phpopentracker.cvs
Message-ID <[email protected]>
Update of /cvsroot/phpopencounter/plugins/conversions/docs/plugins/conversions/sql/mysql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2596/conversions/docs/plugins/conversions/sql/mysql

Added Files:
	innodb.sql myisam.sql 
Log Message:
Initial import of Conversions plugin by Daniel Kehoe and Adrian Lanning.

--- NEW FILE: myisam.sql ---
DROP TABLE IF EXISTS pot_conversions;
CREATE TABLE pot_conversions (
  accesslog_id    INT(11)                 NOT NULL,
  client_id       INT(10)       UNSIGNED  NOT NULL,
  sale            DECIMAL(6,2)  UNSIGNED  NOT NULL,
  inquiry         TINYINT(1)    UNSIGNED  NOT NULL,
  signup          TINYINT(1)    UNSIGNED  NOT NULL,
  email           VARCHAR(255)            NOT NULL,
  zip             VARCHAR(255)            NOT NULL,
  country         VARCHAR(32)             NOT NULL,
  name            VARCHAR(255)            NOT NULL,

  KEY accesslog_id (accesslog_id)
) TYPE=MyISAM;

--- NEW FILE: innodb.sql ---
DROP TABLE IF EXISTS pot_conversions;
CREATE TABLE pot_conversions (
  accesslog_id    INT(11)                 NOT NULL,
  client_id       INT(10)       UNSIGNED  NOT NULL,
  sale            DECIMAL(6,2)  UNSIGNED  NOT NULL,
  inquiry         TINYINT(1)    UNSIGNED  NOT NULL,
  signup          TINYINT(1)    UNSIGNED  NOT NULL,
  email           VARCHAR(255)            NOT NULL,
  zip             VARCHAR(255)            NOT NULL,
  country         VARCHAR(32)             NOT NULL,
  name            VARCHAR(255)            NOT NULL,

  KEY accesslog_id (accesslog_id)
) TYPE=InnoDB;



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click