phpOpenTracker/phpOpenTracker/docs/sql/mysql myisam_merge.sql,NONE,1.1 merge_tables.sql,1.1,NONE

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

Added Files:
	myisam_merge.sql 
Removed Files:
	merge_tables.sql 
Log Message:
Flush.

--- merge_tables.sql DELETED ---

--- NEW FILE: myisam_merge.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_merge.sql,v 1.1 2004/03/04 19:02:23 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;



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