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