plugins/search_engines/docs/plugins/search_engines/sql/mysql innodb.sql,NONE,1.1 myisam.sql,NONE,1.1

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

Added Files:
	innodb.sql myisam.sql 
Log Message:
Add separate database creation scripts for the InnoDB and MyISAM backends for MySQL.

--- 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/04/14 08:06:03 bergmann Exp $
#

DROP TABLE IF EXISTS pot_search_engines;
CREATE TABLE pot_search_engines (
  accesslog_id  int(11)       NOT NULL,
  search_engine varchar(64)   NOT NULL,
  keywords      varchar(254)  NOT NULL,

  PRIMARY KEY   (accesslog_id)
) TYPE=MyISAM;

--- 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/04/14 08:06:03 bergmann Exp $
#

DROP TABLE IF EXISTS pot_search_engines;
CREATE TABLE pot_search_engines (
  accesslog_id  int(11)       NOT NULL,
  search_engine varchar(64)   NOT NULL,
  keywords      varchar(254)  NOT NULL,

  PRIMARY KEY   (accesslog_id)
) TYPE=InnoDB;



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