here´s an sql dump of the current structure, maybe you can see what´s missing, I can´t figure it out (sorry for the big postings):
-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 28. August 2005 um 18:51
-- Server Version: 4.1.13
-- PHP-Version: 5.0.4-3
--
-- Datenbank: `gallery`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `admingroups`
--
CREATE TABLE admingroups (
id int(3) NOT NULL auto_increment,
name varchar(35) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `admlog`
--
CREATE TABLE admlog (
id int(10) NOT NULL auto_increment,
adminuser varchar(50) NOT NULL default '',
description varchar(255) NOT NULL default '',
datestamp int(20) NOT NULL default '0',
ip varchar(35) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `categories`
--
CREATE TABLE categories (
id int(12) NOT NULL auto_increment,
catname varchar(255) NOT NULL default '',
description varchar(255) default NULL,
catorder mediumint(4) NOT NULL default '9999',
thumbs varchar(4) NOT NULL default 'yes',
parent int(5) NOT NULL default '0',
header varchar(200) default NULL,
footer varchar(200) default NULL,
headtags varchar(200) default NULL,
private varchar(5) NOT NULL default 'no',
ugnoview varchar(255) default NULL,
ugnoupload varchar(255) default NULL,
ugnopost varchar(255) default NULL,
ugnovote varchar(255) default NULL,
ugnoanno varchar(255) default NULL,
children text,
albums text,
lastpost int(11) unsigned default NULL,
lastphoto int(11) unsigned default NULL,
photos int(11) unsigned default '0',
posts int(11) unsigned default '0',
`password` varchar(24) default NULL,
cattype varchar(4) NOT NULL default 'c',
theme varchar(32) NOT NULL default '',
catdepth varchar(6) default NULL,
watermark varchar(250) NOT NULL default '',
sortorder int(2) NOT NULL default '1',
extra1 varchar(250) default NULL,
extra2 varchar(250) default NULL,
extra3 varchar(250) default NULL,
extra4 varchar(250) default NULL,
extra5 varchar(250) default NULL,
extra6 varchar(250) default NULL,
thumbnail int(15) NOT NULL default '0',
maximages int(12) NOT NULL default '0',
canzip char(3) NOT NULL default 'no',
frames varchar(32) default NULL,
numextra int(3) NOT NULL default '0',
intro char(3) NOT NULL default 'no',
introtitle varchar(128) default NULL,
introcopy text,
moderators text,
ratingtype int(1) NOT NULL default '0',
takevotes int(1) NOT NULL default '0',
ismember smallint(1) NOT NULL default '0',
PRIMARY KEY (id),
KEY parent (parent),
KEY lastphoto (lastphoto),
KEY thumbnail (thumbnail)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `comments`
--
CREATE TABLE comments (
id int(11) NOT NULL auto_increment,
username tinytext NOT NULL,
userid mediumint(9) NOT NULL default '0',
`date` int(15) NOT NULL default '0',
rating float(12,2) default NULL,
`comment` text NOT NULL,
photo int(11) NOT NULL default '0',
cat smallint(4) NOT NULL default '0',
approved int(2) NOT NULL default '0',
ipaddress varchar(32) default '0',
PRIMARY KEY (id),
KEY photo (photo),
KEY cat (cat)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ecards`
--
CREATE TABLE ecards (
id int(25) NOT NULL auto_increment,
fromname varchar(100) NOT NULL default '',
toname varchar(100) NOT NULL default '',
`subject` varchar(150) NOT NULL default '',
message text NOT NULL,
photoid int(25) NOT NULL default '0',
`date` int(25) NOT NULL default '0',
backcolor varchar(12) NOT NULL default '#696969',
bordcolor varchar(12) NOT NULL default '#000000',
fontcolor varchar(12) NOT NULL default '#FFFFFF',
pickfont varchar(32) NOT NULL default 'arial',
layout varchar(24) NOT NULL default 'tobottom',
returnr int(15) NOT NULL default '0',
readdate int(15) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `exif`
--
CREATE TABLE exif (
photoid int(11) NOT NULL default '0',
exifinfo text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `extrafields`
--
CREATE TABLE extrafields (
id int(12) NOT NULL auto_increment,
cat int(12) default NULL,
fieldname varchar(255) default NULL,
fieldtype char(2) default NULL,
fieldoptions text,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `favorites`
--
CREATE TABLE favorites (
id int(12) NOT NULL auto_increment,
userid int(8) NOT NULL default '0',
photo int(11) NOT NULL default '0',
PRIMARY KEY (id),
KEY parent (photo)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ipcache`
--
CREATE TABLE ipcache (
id int(10) NOT NULL auto_increment,
userid int(25) NOT NULL default '0',
ipaddr varchar(75) NOT NULL default '',
`date` int(11) unsigned default NULL,
`type` varchar(4) NOT NULL default '',
photo int(10) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `iponline`
--
CREATE TABLE iponline (
userid varchar(128) NOT NULL default '',
ipaddr varchar(75) NOT NULL default '',
`date` int(11) unsigned default NULL,
what varchar(64) NOT NULL default '',
item varchar(16) NOT NULL default '',
PRIMARY KEY (ipaddr),
KEY userid (userid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `laston`
--
CREATE TABLE laston (
cat smallint(4) NOT NULL default '0',
userid mediumint(9) NOT NULL default '0',
laston int(11) unsigned default NULL,
PRIMARY KEY (cat,userid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `notify`
--
CREATE TABLE notify (
id int(15) NOT NULL auto_increment,
userid int(25) NOT NULL default '0',
photo int(25) NOT NULL default '0',
`type` int(2) NOT NULL default '0',
PRIMARY KEY (id),
KEY photo (photo)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `photoextras`
--
CREATE TABLE photoextras (
id int(12) NOT NULL auto_increment,
photo int(12) default NULL,
extraid int(12) default NULL,
selection text,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `photos`
--
CREATE TABLE photos (
id int(10) NOT NULL auto_increment,
`user` varchar(50) NOT NULL default '',
userid int(8) NOT NULL default '0',
cat int(11) NOT NULL default '0',
storeid int(12) NOT NULL default '0',
storecat int(12) NOT NULL default '0',
`date` int(15) NOT NULL default '0',
title varchar(75) default '',
description text,
keywords varchar(150) default NULL,
bigimage varchar(100) NOT NULL default '',
width smallint(6) default NULL,
height smallint(4) default NULL,
filesize int(10) default '0',
views int(10) NOT NULL default '0',
medwidth int(12) default '0',
medheight smallint(6) default '0',
medsize mediumint(9) default '0',
approved tinyint(2) NOT NULL default '0',
lastpost int(15) NOT NULL default '0',
rating float(12,2) NOT NULL default '0.00',
watermarked varchar(5) NOT NULL default 'no',
allowprint varchar(5) NOT NULL default 'yes',
extra1 varchar(255) default NULL,
extra2 varchar(255) default NULL,
extra3 varchar(255) default NULL,
extra4 varchar(255) default NULL,
extra5 varchar(255) default NULL,
extra6 varchar(255) default NULL,
disporder int(5) NOT NULL default '99999',
ipaddress varchar(32) default '0',
numcom int(8) NOT NULL default '0',
lastposter varchar(255) default NULL,
lastpid int(8) NOT NULL default '0',
PRIMARY KEY (id),
KEY userid (userid),
KEY cat (cat),
KEY bigimage (bigimage,cat),
KEY approved (approved,storecat),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `photoviews`
--
CREATE TABLE photoviews (
photoid mediumint(9) NOT NULL default '0'
) ENGINE=HEAP DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `settings`
--
CREATE TABLE settings (
id int(11) NOT NULL auto_increment,
title varchar(255) NOT NULL default '',
varname varchar(25) NOT NULL default '',
description varchar(150) NOT NULL default '',
setting varchar(250) NOT NULL default '',
optionorder int(3) NOT NULL default '0',
section int(3) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `sort`
--
CREATE TABLE sort (
sortid int(15) NOT NULL auto_increment,
name varchar(35) NOT NULL default '',
code varchar(75) NOT NULL default '',
PRIMARY KEY (sortid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `sortmemb`
--
CREATE TABLE sortmemb (
sortid int(15) NOT NULL auto_increment,
name varchar(35) NOT NULL default '',
code varchar(75) NOT NULL default '',
PRIMARY KEY (sortid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `usergroups`
--
CREATE TABLE usergroups (
groupid int(5) NOT NULL auto_increment,
groupname varchar(50) NOT NULL default '',
cpaccess smallint(3) NOT NULL default '0',
uploads smallint(3) NOT NULL default '1',
comments smallint(3) NOT NULL default '1',
diskspace int(10) default NULL,
uploadsize int(10) default NULL,
editpho int(3) NOT NULL default '1',
editposts int(3) NOT NULL default '1',
modaccess smallint(3) NOT NULL default '0',
useralbums int(3) NOT NULL default '0',
reqmod int(3) NOT NULL default '0',
canassign int(3) NOT NULL default '0',
uplimit int(5) NOT NULL default '0',
PRIMARY KEY (groupid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `users`
--
CREATE TABLE users (
userid int(25) NOT NULL auto_increment,
usergroupid int(5) NOT NULL default '0',
username varchar(30) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
email varchar(75) NOT NULL default '',
homepage varchar(100) default NULL,
icq varchar(50) default NULL,
aim varchar(30) default NULL,
yahoo varchar(30) default NULL,
joindate int(25) NOT NULL default '0',
posts int(20) NOT NULL default '0',
birthday date NOT NULL default '0000-00-00',
ipaddress varchar(18) default NULL,
location varchar(100) default NULL,
interests varchar(250) default NULL,
occupation varchar(250) default NULL,
bio varchar(250) default NULL,
site varchar(30) default NULL,
`offset` smallint(2) NOT NULL default '0',
views int(10) NOT NULL default '0',
cellphone varchar(255) default NULL,
PRIMARY KEY (userid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;