phpOpenTracker/phpOpenTracker/docs/sql/mysql innodb.sql,NONE,1.1.4.1 myisam.sql,NONE,1.1.4.1 myisam_merge.sql,NONE,1.1.4.1 mysql.sql,1.11.4.1,NONE pma.sql,1.3.6.1,NONE
Sebastian Bergmann <[email protected]> Fri, 12 Mar 2004 14:50:55 +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-serv320/phpOpenTracker/docs/sql/mysql
Added Files:
Tag: phpOpenTracker_1_4
innodb.sql myisam.sql myisam_merge.sql
Removed Files:
Tag: phpOpenTracker_1_4
mysql.sql pma.sql
Log Message:
MFH
--- 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.4.1 2004/03/12 14:50:52 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: 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.4.1 2004/03/12 14:50:52 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.4.1 2004/03/12 14:50:52 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