#!/bin/sh

mysql -B test_www <<END
create table access_log (
		when	datetime not null,
		host	varchar(255) not null,
		method  varchar(4)   not null,
		url	varchar(255) not null,
		auth	varchar(50),
		browser varchar(50),
		referer varchar(255),
		status	smallint(3) default 0,
		bytes   int(8)
);
END