DB tables

Post by **Scott** » Mon Jul 23, 2007 3:46 pm

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]

Josh · Post by **Josh** » Mon Jul 23, 2007 5:09 pm

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

Post by **Scott** » Mon Jul 23, 2007 5:17 pm

Josh · Post by **Josh** » Mon Jul 23, 2007 5:20 pm

*grumbles and goes to find an IPB installation pack*