phpOpenTracker/phpOpenTracker/docs/sql/mysql myisam.sql,1.3,1.4 myisam_merge.sql,1.2,1.3

Update of /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/docs/sql/mysql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25885/phpOpenTracker/docs/sql/mysql

Modified Files:
	myisam.sql myisam_merge.sql 
Log Message:
Only use PACK_KEYS where it makes sense.

Index: myisam.sql
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/docs/sql/mysql/myisam.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- myisam.sql	8 May 2004 07:59:57 -0000	1.3
+++ myisam.sql	8 May 2004 13:04:30 -0000	1.4
@@ -41,7 +41,7 @@
   data_value   VARCHAR(255) NOT NULL,
 
   KEY accesslog_id (accesslog_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_documents;
 CREATE TABLE pot_documents (
@@ -50,7 +50,7 @@
   document_url VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_exit_targets;
 CREATE TABLE pot_exit_targets (
@@ -58,7 +58,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_hostnames;
 CREATE TABLE pot_hostnames (
@@ -66,7 +66,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_operating_systems;
 CREATE TABLE pot_operating_systems (
@@ -74,7 +74,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_referers;
 CREATE TABLE pot_referers (
@@ -82,7 +82,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_user_agents;
 CREATE TABLE pot_user_agents (
@@ -90,7 +90,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_visitors;
 CREATE TABLE pot_visitors (
@@ -108,4 +108,4 @@
 
   PRIMARY KEY         (accesslog_id),
   KEY client_time     (client_id, timestamp)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;

Index: myisam_merge.sql
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/docs/sql/mysql/myisam_merge.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- myisam_merge.sql	8 May 2004 07:59:57 -0000	1.2
+++ myisam_merge.sql	8 May 2004 13:04:31 -0000	1.3
@@ -28,7 +28,7 @@
   data_value   VARCHAR(255) NOT NULL,
 
   KEY accesslog_id (accesslog_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_documents;
 CREATE TABLE pot_documents (
@@ -37,7 +37,7 @@
   document_url VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_exit_targets;
 CREATE TABLE pot_exit_targets (
@@ -45,7 +45,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_hostnames;
 CREATE TABLE pot_hostnames (
@@ -53,7 +53,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_operating_systems;
 CREATE TABLE pot_operating_systems (
@@ -61,7 +61,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_referers;
 CREATE TABLE pot_referers (
@@ -69,7 +69,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;
 
 DROP TABLE IF EXISTS pot_user_agents;
 CREATE TABLE pot_user_agents (
@@ -77,4 +77,4 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1;



-------------------------------------------------------
This SF.Net email is sponsored by Sleepycat Software
Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver
higher performing products faster, at low TCO.
http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3