Bem, tá aqui o código da tabela:
arquivo
phpfotolog.sql:
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
`id` smallint(6) NOT NULL auto_increment,
`foto` smallint(6) NOT NULL default '0',
`name` varchar(20) NOT NULL default '',
`email` varchar(20) NOT NULL default '',
`url` varchar(50) NOT NULL default '',
`text` mediumtext NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` smallint(6) NOT NULL auto_increment,
`name` varchar(40) NOT NULL default '',
`value` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `fotos`;
CREATE TABLE `fotos` (
`id` smallint(6) NOT NULL auto_increment,
`filename` varchar(40) NOT NULL default '',
`text` longtext NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`enable_comments` char(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
`id` smallint(6) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`type` varchar(20) NOT NULL default '',
`filename` varchar(40) NOT NULL default '',
`city` varchar(30) NOT NULL default '',
`country` varchar(30) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `links`;
CREATE TABLE `links` (
`id` smallint(6) NOT NULL auto_increment,
`name` varchar(40) NOT NULL default '',
`url` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;