r27 - in phpOpenTracker/branches: phpOpenTracker-1/phpOpenTracker/docs phpOpenTracker-1/phpOpenTracker/docs/sql phpOpenTracker-1.5/phpOpenTracker/docs phpOpenTracker-1.5/phpOpenTracker/docs/sql
Sebastian Bergmann at BerliOS <[email protected]> Sat, 27 Nov 2004 11:10:07 +0100
| Newsgroups | gmane.comp.web.phpopentracker.cvs |
|---|---|
| Message-ID | <[email protected]> |
Author: s_bergmann Date: 2004-11-27 11:10:06 +0100 (Sat, 27 Nov 2004) New Revision: 27 Modified: phpOpenTracker/branches/phpOpenTracker-1.5/phpOpenTracker/docs/NEWS phpOpenTracker/branches/phpOpenTracker-1.5/phpOpenTracker/docs/sql/postgresql.sql phpOpenTracker/branches/phpOpenTracker-1/phpOpenTracker/docs/NEWS phpOpenTracker/branches/phpOpenTracker-1/phpOpenTracker/docs/sql/postgresql.sql Log: Patch by Peter Adams <[email protected]>. Modified: phpOpenTracker/branches/phpOpenTracker-1/phpOpenTracker/docs/NEWS =================================================================== --- phpOpenTracker/branches/phpOpenTracker-1/phpOpenTracker/docs/NEWS 2004-10-19 11:11:39 UTC (rev 26) +++ phpOpenTracker/branches/phpOpenTracker-1/phpOpenTracker/docs/NEWS 2004-11-27 10:10:06 UTC (rev 27) @@ -21,6 +21,11 @@ + Re-added the 'DELAY_KEY_WRITE=1' option to all tables. + * Changes to the PostgreSQL table creation scripts to use the + correct INT4/INT8 column types instead of INTEGER. + + (Patch by Peter Adams <[email protected]>= + - Deprecated the 'delay_key_write' configuration directive. 26-Apr-2004, Version 1.5.0 (Release Candidate 1) Modified: phpOpenTracker/branches/phpOpenTracker-1/phpOpenTracker/docs/sql/postgresql.sql =================================================================== --- phpOpenTracker/branches/phpOpenTracker-1/phpOpenTracker/docs/sql/postgresql.sql 2004-10-19 11:11:39 UTC (rev 26) +++ phpOpenTracker/branches/phpOpenTracker-1/phpOpenTracker/docs/sql/postgresql.sql 2004-11-27 10:10:06 UTC (rev 27) @@ -17,12 +17,12 @@ */ CREATE TABLE "pot_accesslog" ( - "accesslog_id" integer NOT NULL, - "timestamp" integer NOT NULL, - "weekday" integer NOT NULL, - "hour" integer NOT NULL, - "document_id" integer NOT NULL, - "exit_target_id" integer DEFAULT 0 NOT NULL, + "accesslog_id" INT8 NOT NULL, + "timestamp" INT8 NOT NULL, + "weekday" INT4 NOT NULL, + "hour" INT4 NOT NULL, + "document_id" INT8 NOT NULL, + "exit_target_id" INT8 DEFAULT 0 NOT NULL, "entry_document" boolean NOT NULL ); @@ -31,53 +31,53 @@ CREATE INDEX pot_accesslog_exit_target_id on pot_accesslog(exit_target_id); CREATE TABLE "pot_add_data" ( - "accesslog_id" integer NOT NULL, + "accesslog_id" INT8 NOT NULL, "data_field" character varying(32) NOT NULL, "data_value" character varying(255) NOT NULL ); CREATE TABLE "pot_documents" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL, "document_url" character varying(255) NOT NULL ); CREATE TABLE "pot_exit_targets" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL ); CREATE TABLE "pot_hostnames" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL ); CREATE TABLE "pot_operating_systems" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL ); CREATE TABLE "pot_referers" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL ); CREATE TABLE "pot_user_agents" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL ); CREATE TABLE "pot_visitors" ( - "accesslog_id" integer PRIMARY KEY, - "visitor_id" integer NOT NULL, - "client_id" integer NOT NULL, - "operating_system_id" integer NOT NULL, - "user_agent_id" integer NOT NULL, - "host_id" integer NOT NULL, - "referer_id" integer NOT NULL, - "timestamp" integer NOT NULL, - "weekday" integer NOT NULL, - "hour" integer NOT NULL, + "accesslog_id" INT8 PRIMARY KEY, + "visitor_id" INT8 NOT NULL, + "client_id" INT4 NOT NULL, + "operating_system_id" INT8 NOT NULL, + "user_agent_id" INT8 NOT NULL, + "host_id" INT8 NOT NULL, + "referer_id" INT8 NOT NULL, + "timestamp" INT8 NOT NULL, + "weekday" INT4 NOT NULL, + "hour" INT4 NOT NULL, "returning_visitor" boolean NOT NULL ); Modified: phpOpenTracker/branches/phpOpenTracker-1.5/phpOpenTracker/docs/NEWS =================================================================== --- phpOpenTracker/branches/phpOpenTracker-1.5/phpOpenTracker/docs/NEWS 2004-10-19 11:11:39 UTC (rev 26) +++ phpOpenTracker/branches/phpOpenTracker-1.5/phpOpenTracker/docs/NEWS 2004-11-27 10:10:06 UTC (rev 27) @@ -21,6 +21,11 @@ + Re-added the 'DELAY_KEY_WRITE=1' option to all tables. + * Changes to the PostgreSQL table creation scripts to use the + correct INT4/INT8 column types instead of INTEGER. + + (Patch by Peter Adams <[email protected]>= + - Deprecated the 'delay_key_write' configuration directive. 26-Apr-2004, Version 1.5.0 (Release Candidate 1) Modified: phpOpenTracker/branches/phpOpenTracker-1.5/phpOpenTracker/docs/sql/postgresql.sql =================================================================== --- phpOpenTracker/branches/phpOpenTracker-1.5/phpOpenTracker/docs/sql/postgresql.sql 2004-10-19 11:11:39 UTC (rev 26) +++ phpOpenTracker/branches/phpOpenTracker-1.5/phpOpenTracker/docs/sql/postgresql.sql 2004-11-27 10:10:06 UTC (rev 27) @@ -17,12 +17,12 @@ */ CREATE TABLE "pot_accesslog" ( - "accesslog_id" integer NOT NULL, - "timestamp" integer NOT NULL, - "weekday" integer NOT NULL, - "hour" integer NOT NULL, - "document_id" integer NOT NULL, - "exit_target_id" integer DEFAULT 0 NOT NULL, + "accesslog_id" INT8 NOT NULL, + "timestamp" INT8 NOT NULL, + "weekday" INT4 NOT NULL, + "hour" INT4 NOT NULL, + "document_id" INT8 NOT NULL, + "exit_target_id" INT8 DEFAULT 0 NOT NULL, "entry_document" boolean NOT NULL ); @@ -31,53 +31,53 @@ CREATE INDEX pot_accesslog_exit_target_id on pot_accesslog(exit_target_id); CREATE TABLE "pot_add_data" ( - "accesslog_id" integer NOT NULL, + "accesslog_id" INT8 NOT NULL, "data_field" character varying(32) NOT NULL, "data_value" character varying(255) NOT NULL ); CREATE TABLE "pot_documents" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL, "document_url" character varying(255) NOT NULL ); CREATE TABLE "pot_exit_targets" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL ); CREATE TABLE "pot_hostnames" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL ); CREATE TABLE "pot_operating_systems" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL ); CREATE TABLE "pot_referers" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL ); CREATE TABLE "pot_user_agents" ( - "data_id" integer PRIMARY KEY, + "data_id" INT8 PRIMARY KEY, "string" character varying(255) NOT NULL ); CREATE TABLE "pot_visitors" ( - "accesslog_id" integer PRIMARY KEY, - "visitor_id" integer NOT NULL, - "client_id" integer NOT NULL, - "operating_system_id" integer NOT NULL, - "user_agent_id" integer NOT NULL, - "host_id" integer NOT NULL, - "referer_id" integer NOT NULL, - "timestamp" integer NOT NULL, - "weekday" integer NOT NULL, - "hour" integer NOT NULL, + "accesslog_id" INT8 PRIMARY KEY, + "visitor_id" INT8 NOT NULL, + "client_id" INT4 NOT NULL, + "operating_system_id" INT8 NOT NULL, + "user_agent_id" INT8 NOT NULL, + "host_id" INT8 NOT NULL, + "referer_id" INT8 NOT NULL, + "timestamp" INT8 NOT NULL, + "weekday" INT4 NOT NULL, + "hour" INT4 NOT NULL, "returning_visitor" boolean NOT NULL );