phpOpenTracker/phpOpenTracker/docs/sql/mysql myisam.sql,1.1.2.1,1.1.2.2

Sebastian Bergmann <[email protected]> Fri, 12 Mar 2004 15:13:13 +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-serv6116/phpOpenTracker/docs/sql/mysql

Modified Files:
      Tag: phpOpenTracker_1
	myisam.sql 
Log Message:
MFH: Oops.

Index: myisam.sql
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/docs/sql/mysql/myisam.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -C2 -d -r1.1.2.1 -r1.1.2.2
*** myisam.sql	4 Mar 2004 18:52:48 -0000	1.1.2.1
--- myisam.sql	12 Mar 2004 15:13:11 -0000	1.1.2.2
***************
*** 33,37 ****
    KEY document_id    (document_id),
    KEY exit_target_id (exit_target_id)
! ) TYPE=InnoDB;
  
  DROP TABLE IF EXISTS pot_add_data;
--- 33,37 ----
    KEY document_id    (document_id),
    KEY exit_target_id (exit_target_id)
! ) TYPE=MyISAM;
  
  DROP TABLE IF EXISTS pot_add_data;
***************
*** 42,46 ****
  
    KEY accesslog_id (accesslog_id)
! ) TYPE=InnoDB;
  
  DROP TABLE IF EXISTS pot_documents;
--- 42,46 ----
  
    KEY accesslog_id (accesslog_id)
! ) TYPE=MyISAM;
  
  DROP TABLE IF EXISTS pot_documents;
***************
*** 51,55 ****
  
    PRIMARY KEY (data_id)
! ) TYPE=InnoDB;
  
  DROP TABLE IF EXISTS pot_exit_targets;
--- 51,55 ----
  
    PRIMARY KEY (data_id)
! ) TYPE=MyISAM;
  
  DROP TABLE IF EXISTS pot_exit_targets;
***************
*** 59,63 ****
  
    PRIMARY KEY (data_id)
! ) TYPE=InnoDB;
  
  DROP TABLE IF EXISTS pot_hostnames;
--- 59,63 ----
  
    PRIMARY KEY (data_id)
! ) TYPE=MyISAM;
  
  DROP TABLE IF EXISTS pot_hostnames;
***************
*** 67,71 ****
  
    PRIMARY KEY (data_id)
! ) TYPE=InnoDB;
  
  DROP TABLE IF EXISTS pot_operating_systems;
--- 67,71 ----
  
    PRIMARY KEY (data_id)
! ) TYPE=MyISAM;
  
  DROP TABLE IF EXISTS pot_operating_systems;
***************
*** 75,79 ****
  
    PRIMARY KEY (data_id)
! ) TYPE=InnoDB;
  
  DROP TABLE IF EXISTS pot_referers;
--- 75,79 ----
  
    PRIMARY KEY (data_id)
! ) TYPE=MyISAM;
  
  DROP TABLE IF EXISTS pot_referers;
***************
*** 83,87 ****
  
    PRIMARY KEY (data_id)
! ) TYPE=InnoDB;
  
  DROP TABLE IF EXISTS pot_user_agents;
--- 83,87 ----
  
    PRIMARY KEY (data_id)
! ) TYPE=MyISAM;
  
  DROP TABLE IF EXISTS pot_user_agents;
***************
*** 91,95 ****
  
    PRIMARY KEY (data_id)
! ) TYPE=InnoDB;
  
  DROP TABLE IF EXISTS pot_visitors;
--- 91,95 ----
  
    PRIMARY KEY (data_id)
! ) TYPE=MyISAM;
  
  DROP TABLE IF EXISTS pot_visitors;
***************
*** 109,111 ****
    PRIMARY KEY         (accesslog_id),
    KEY client_time     (client_id, timestamp)
! ) TYPE=InnoDB;
--- 109,111 ----
    PRIMARY KEY         (accesslog_id),
    KEY client_time     (client_id, timestamp)
! ) 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