Actually to ensure things are created exactly as s9y would, I used a hacked copy of s9y where sq/db.sql contained only the exits related entries, with changed host varchar(110) and path varchar(217), and a minimal php script to install the database:
Code: Select all
<?php
# Install database from sql/db.sql
# Call this file in a copy of s9y.
# Only the desired database and index(es) must be present in sql/db.sql
define('IN_serendipity', true);
include('serendipity_config.inc.php');
serendipity_installDatabase();
?>
You could also create the table and index manually in phpMyAdmin, make sure you use the MYISAM storage engine and utf8 encoding and collation utf8_unicode_ci on all varchar fields.
Or with SQL statements as expanded by s9y:
Code: Select all
SET storage_engine=MYISAM
CREATE TABLE serendipity_exits (entry_id int(11) NOT NULL default '0',day date NOT NULL,count int(11) NOT NULL default '0',scheme varchar(5),host varchar(110) NOT NULL,port varchar(5),path varchar(217),query varchar(255),PRIMARY KEY (host,path,day,entry_id)) /*!40100 CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
CREATE INDEX exits_idx ON serendipity_exits (entry_id,day,host);
I hope that does it for you.