phpOpenTracker/phpOpenTracker/docs/sql/mysql myisam.sql,1.1.2.2.2.2,1.1.2.2.2.3 myisam_merge.sql,1.1.2.1.2.2,1.1.2.1.2.3
Sebastian Bergmann <[email protected]> Sat, 08 May 2004 13:14:22 +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-serv27431/phpOpenTracker/docs/sql/mysql
Modified Files:
Tag: phpOpenTracker_1_5
myisam.sql myisam_merge.sql
Log Message:
Oops.
Index: myisam.sql
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/docs/sql/mysql/myisam.sql,v
retrieving revision 1.1.2.2.2.2
retrieving revision 1.1.2.2.2.3
diff -u -d -r1.1.2.2.2.2 -r1.1.2.2.2.3
--- myisam.sql 8 May 2004 13:05:27 -0000 1.1.2.2.2.2
+++ myisam.sql 8 May 2004 13:14:20 -0000 1.1.2.2.2.3
@@ -32,7 +32,7 @@
KEY timestamp (timestamp),
KEY document_id (document_id),
KEY exit_target_id (exit_target_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;
+) TYPE=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)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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.1.2.1.2.2
retrieving revision 1.1.2.1.2.3
diff -u -d -r1.1.2.1.2.2 -r1.1.2.1.2.3
--- myisam_merge.sql 8 May 2004 13:05:27 -0000 1.1.2.1.2.2
+++ myisam_merge.sql 8 May 2004 13:14:20 -0000 1.1.2.1.2.3
@@ -28,7 +28,7 @@
data_value VARCHAR(255) NOT NULL,
KEY accesslog_id (accesslog_id)
-) ENGINE=MyISAM DELAY_KEY_WRITE=1;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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;
+) TYPE=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