plugins/localizer/docs/plugins/localizer/sql innodb.sql,NONE,1.1 myisam.sql,NONE,1.1 mysql.sql,1.6,NONE

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

Added Files:
	innodb.sql myisam.sql 
Removed Files:
	mysql.sql 
Log Message:
Flush.

--- 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/05/08 08:12:32 bergmann Exp $
#

DROP TABLE IF EXISTS pot_localizer;

CREATE TABLE pot_localizer (
  accesslog_id  int(11)     NOT NULL,
  city          varchar(32) NOT NULL default '',
  province      varchar(32) NOT NULL default '',
  country       varchar(32) NOT NULL default '',
  provider      varchar(32) NOT NULL default '',
  longitude     float       NOT NULL default '0',
  latitude      float       NOT NULL default '0',
  radius        float       NOT NULL default '0',

  PRIMARY KEY   (accesslog_id)
) TYPE=MyISAM DELAY_KEY_WRITE=1 PACK_KEYS=1;

--- 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/05/08 08:12:32 bergmann Exp $
#

DROP TABLE IF EXISTS pot_localizer;

CREATE TABLE pot_localizer (
  accesslog_id  int(11)     NOT NULL,
  city          varchar(32) NOT NULL default '',
  province      varchar(32) NOT NULL default '',
  country       varchar(32) NOT NULL default '',
  provider      varchar(32) NOT NULL default '',
  longitude     float       NOT NULL default '0',
  latitude      float       NOT NULL default '0',
  radius        float       NOT NULL default '0',

  PRIMARY KEY   (accesslog_id)
) TYPE=InnoDB;



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