phpOpenTracker/phpOpenTracker/docs/sql/mysql innodb.sql,NONE,1.1 merge_tables.sql,NONE,1.1 myisam.sql,NONE,1.1 mysql.sql,1.12,NONE pma.sql,1.4,NONE

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

Added Files:
	innodb.sql merge_tables.sql myisam.sql 
Removed Files:
	mysql.sql pma.sql 
Log Message:
Reorganize MySQL scripts.

--- NEW FILE: myisam.sql ---
#
# phpOpenTracker - The Website Traffic and Visitor Analysis Solution
#
# Copyright 2000 - 2004 Sebastian Bergmann. All rights reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
# $Id: myisam.sql,v 1.1 2004/03/04 18:50:15 bergmann Exp $
#

DROP TABLE IF EXISTS pot_accesslog;
CREATE TABLE pot_accesslog (
  accesslog_id      INT(11)                NOT NULL,
  timestamp         INT(10)    UNSIGNED    NOT NULL,
  weekday           TINYINT(1) UNSIGNED    NOT NULL,
  `hour`            TINYINT(2) UNSIGNED    NOT NULL,
  document_id       INT(11)                NOT NULL,
  exit_target_id    INT(11)    DEFAULT '0' NOT NULL,
  entry_document    TINYINT(1) UNSIGNED    NOT NULL,

  KEY accesslog_id   (accesslog_id),
  KEY timestamp      (timestamp),
  KEY document_id    (document_id),
  KEY exit_target_id (exit_target_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_add_data;
CREATE TABLE pot_add_data (
  accesslog_id INT(11)      NOT NULL,
  data_field   VARCHAR(32)  NOT NULL,
  data_value   VARCHAR(255) NOT NULL,

  KEY accesslog_id (accesslog_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_documents;
CREATE TABLE pot_documents (
  data_id      INT(11)      NOT NULL,
  string       VARCHAR(255) NOT NULL,
  document_url VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_exit_targets;
CREATE TABLE pot_exit_targets (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_hostnames;
CREATE TABLE pot_hostnames (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_operating_systems;
CREATE TABLE pot_operating_systems (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_referers;
CREATE TABLE pot_referers (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_user_agents;
CREATE TABLE pot_user_agents (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_visitors;
CREATE TABLE pot_visitors (
  accesslog_id        INT(11)             NOT NULL,
  visitor_id          INT(11)             NOT NULL,
  client_id           INT(10)    UNSIGNED NOT NULL,
  operating_system_id INT(11)             NOT NULL,
  user_agent_id       INT(11)             NOT NULL,
  host_id             INT(11)             NOT NULL,
  referer_id          INT(11)             NOT NULL,
  timestamp           INT(10)    UNSIGNED NOT NULL,
  weekday             TINYINT(1) UNSIGNED NOT NULL,
  `hour`              TINYINT(2) UNSIGNED NOT NULL,
  returning_visitor   TINYINT(1) UNSIGNED NOT NULL,

  PRIMARY KEY         (accesslog_id),
  KEY client_time     (client_id, timestamp)
) TYPE=InnoDB;

--- NEW FILE: merge_tables.sql ---
#
# phpOpenTracker - The Website Traffic and Visitor Analysis Solution
#
# Copyright 2000 - 2004 Sebastian Bergmann. All rights reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
# $Id: merge_tables.sql,v 1.1 2004/03/04 18:50:15 bergmann Exp $
#

DROP TABLE IF EXISTS pot_accesslog;
DROP TABLE IF EXISTS pot_visitors;

DROP TABLE IF EXISTS pot_add_data;
CREATE TABLE pot_add_data (
  accesslog_id INT(11)      NOT NULL,
  data_field   VARCHAR(32)  NOT NULL,
  data_value   VARCHAR(255) NOT NULL,

  KEY accesslog_id (accesslog_id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pot_documents;
CREATE TABLE pot_documents (
  data_id      INT(11)      NOT NULL,
  string       VARCHAR(255) NOT NULL,
  document_url VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pot_exit_targets;
CREATE TABLE pot_exit_targets (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pot_hostnames;
CREATE TABLE pot_hostnames (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pot_operating_systems;
CREATE TABLE pot_operating_systems (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pot_referers;
CREATE TABLE pot_referers (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pot_user_agents;
CREATE TABLE pot_user_agents (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=MyISAM;

--- mysql.sql DELETED ---

--- NEW FILE: innodb.sql ---
#
# phpOpenTracker - The Website Traffic and Visitor Analysis Solution
#
# Copyright 2000 - 2004 Sebastian Bergmann. All rights reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
# $Id: innodb.sql,v 1.1 2004/03/04 18:50:15 bergmann Exp $
#

DROP TABLE IF EXISTS pot_accesslog;
CREATE TABLE pot_accesslog (
  accesslog_id      INT(11)                NOT NULL,
  timestamp         INT(10)    UNSIGNED    NOT NULL,
  weekday           TINYINT(1) UNSIGNED    NOT NULL,
  `hour`            TINYINT(2) UNSIGNED    NOT NULL,
  document_id       INT(11)                NOT NULL,
  exit_target_id    INT(11)    DEFAULT '0' NOT NULL,
  entry_document    TINYINT(1) UNSIGNED    NOT NULL,

  KEY accesslog_id   (accesslog_id),
  KEY timestamp      (timestamp),
  KEY document_id    (document_id),
  KEY exit_target_id (exit_target_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_add_data;
CREATE TABLE pot_add_data (
  accesslog_id INT(11)      NOT NULL,
  data_field   VARCHAR(32)  NOT NULL,
  data_value   VARCHAR(255) NOT NULL,

  KEY accesslog_id (accesslog_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_documents;
CREATE TABLE pot_documents (
  data_id      INT(11)      NOT NULL,
  string       VARCHAR(255) NOT NULL,
  document_url VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_exit_targets;
CREATE TABLE pot_exit_targets (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_hostnames;
CREATE TABLE pot_hostnames (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_operating_systems;
CREATE TABLE pot_operating_systems (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_referers;
CREATE TABLE pot_referers (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_user_agents;
CREATE TABLE pot_user_agents (
  data_id INT(11)      NOT NULL,
  string  VARCHAR(255) NOT NULL,

  PRIMARY KEY (data_id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS pot_visitors;
CREATE TABLE pot_visitors (
  accesslog_id        INT(11)             NOT NULL,
  visitor_id          INT(11)             NOT NULL,
  client_id           INT(10)    UNSIGNED NOT NULL,
  operating_system_id INT(11)             NOT NULL,
  user_agent_id       INT(11)             NOT NULL,
  host_id             INT(11)             NOT NULL,
  referer_id          INT(11)             NOT NULL,
  timestamp           INT(10)    UNSIGNED NOT NULL,
  weekday             TINYINT(1) UNSIGNED NOT NULL,
  `hour`              TINYINT(2) UNSIGNED NOT NULL,
  returning_visitor   TINYINT(1) UNSIGNED NOT NULL,

  PRIMARY KEY         (accesslog_id),
  KEY client_time     (client_id, timestamp)
) TYPE=InnoDB;

--- pma.sql DELETED ---



-------------------------------------------------------
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