phpOpenTracker/phpOpenTracker/docs/sql/mysql innodb.sql,1.1,1.2 myisam.sql,1.2,1.3 myisam_merge.sql,1.1,1.2

Sebastian Bergmann <[email protected]> Sat, 08 May 2004 07:59:59 +0000
Newsgroups	gmane.comp.web.phpopentracker.cvs
Message-ID	<[email protected]>
Update of /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/docs/sql/mysql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7806/phpOpenTracker/docs/sql/mysql

Modified Files:
	innodb.sql myisam.sql myisam_merge.sql 
Log Message:
Deprecate 'deley_key_write' configuration directive. Create MyISAM and MyISAM Merge tables with the 'DELAY_KEY_WRITE=1 PACK_KEYS=1' options. Switch to from 'TYPE=' to 'ENGINE=' in MySQL table creation scripts.

Index: myisam.sql
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/docs/sql/mysql/myisam.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- myisam.sql	12 Mar 2004 15:12:37 -0000	1.2
+++ myisam.sql	8 May 2004 07:59:57 -0000	1.3
@@ -32,7 +32,7 @@
   KEY timestamp      (timestamp),
   KEY document_id    (document_id),
   KEY exit_target_id (exit_target_id)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
 
 DROP TABLE IF EXISTS pot_add_data;
 CREATE TABLE pot_add_data (
@@ -41,7 +41,7 @@
   data_value   VARCHAR(255) NOT NULL,
 
   KEY accesslog_id (accesslog_id)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=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)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=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)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
 
 DROP TABLE IF EXISTS pot_hostnames;
 CREATE TABLE pot_hostnames (
@@ -66,7 +66,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=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)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
 
 DROP TABLE IF EXISTS pot_referers;
 CREATE TABLE pot_referers (
@@ -82,7 +82,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=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)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=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)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;

Index: innodb.sql
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/docs/sql/mysql/innodb.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- innodb.sql	4 Mar 2004 18:50:15 -0000	1.1
+++ innodb.sql	8 May 2004 07:59:57 -0000	1.2
@@ -32,7 +32,7 @@
   KEY timestamp      (timestamp),
   KEY document_id    (document_id),
   KEY exit_target_id (exit_target_id)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
 
 DROP TABLE IF EXISTS pot_add_data;
 CREATE TABLE pot_add_data (
@@ -41,7 +41,7 @@
   data_value   VARCHAR(255) NOT NULL,
 
   KEY accesslog_id (accesslog_id)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
 
 DROP TABLE IF EXISTS pot_documents;
 CREATE TABLE pot_documents (
@@ -50,7 +50,7 @@
   document_url VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
 
 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)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
 
 DROP TABLE IF EXISTS pot_hostnames;
 CREATE TABLE pot_hostnames (
@@ -66,7 +66,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
 
 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)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
 
 DROP TABLE IF EXISTS pot_referers;
 CREATE TABLE pot_referers (
@@ -82,7 +82,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
 
 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)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;
 
 DROP TABLE IF EXISTS pot_visitors;
 CREATE TABLE pot_visitors (
@@ -108,4 +108,4 @@
 
   PRIMARY KEY         (accesslog_id),
   KEY client_time     (client_id, timestamp)
-) TYPE=InnoDB;
+) ENGINE=InnoDB;

Index: myisam_merge.sql
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/docs/sql/mysql/myisam_merge.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- myisam_merge.sql	4 Mar 2004 19:02:23 -0000	1.1
+++ myisam_merge.sql	8 May 2004 07:59:57 -0000	1.2
@@ -28,7 +28,7 @@
   data_value   VARCHAR(255) NOT NULL,
 
   KEY accesslog_id (accesslog_id)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=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)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=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)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
 
 DROP TABLE IF EXISTS pot_hostnames;
 CREATE TABLE pot_hostnames (
@@ -53,7 +53,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=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)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
 
 DROP TABLE IF EXISTS pot_referers;
 CREATE TABLE pot_referers (
@@ -69,7 +69,7 @@
   string  VARCHAR(255) NOT NULL,
 
   PRIMARY KEY (data_id)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=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)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=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