Page 1 of 1

DB tables

Posted: Mon Jul 23, 2007 3:46 pm
by Scott
Structure of the db tables we're created for those that need them.

[sql]CREATE TABLE `ibf_images` (
`id` int(10) NOT NULL auto_increment,
`mid` mediumint(8) NOT NULL,
`cat` smallint(5) NOT NULL,
`album_id` int(10) NOT NULL,
`name` varchar(255) NOT NULL,
`full_path` varchar(255) NOT NULL,
`preview_path` varchar(255) NOT NULL,
`thumb_path` varchar(255) NOT NULL,
`date` int(10) NOT NULL,
`approved` tinyint(1) NOT NULL default '1',
`reported` tinyint(1) NOT NULL default '0',
`desc` text NOT NULL,
`print` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;[/sql]

DB tables

Posted: Mon Jul 23, 2007 5:09 pm
by Josh
What DB should this be placed in? :\ If we're using IPB and it's going in IPB tables...shouldn't I have IPB installed? :x

DB tables

Posted: Mon Jul 23, 2007 5:17 pm
by Scott
Yep

DB tables

Posted: Mon Jul 23, 2007 5:20 pm
by Josh
*grumbles and goes to find an IPB installation pack*