
 
CREATE DATABASE `imagehosting`



CREATE TABLE IF NOT EXISTS `galleries` (
  `id` bigint(20) NOT NULL auto_increment,
  `userid` bigint(20) NOT NULL default '0',
  `name` varchar(250) NOT NULL default '',
  `type` enum('private','public') NOT NULL default 'private',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;





CREATE TABLE IF NOT EXISTS `gallery-images` (
  `id` varchar(250) NOT NULL default '',
  `galleryid` bigint(20) NOT NULL default '0',
  `image` varchar(250) NOT NULL default '',
  `thumb` varchar(250) NOT NULL default '',
  `tags` varchar(250) NOT NULL default '',
  `details` varchar(30) NOT NULL default '',
  `views` bigint(20) NOT NULL default '0',
  `date` varchar(20) NOT NULL default '',
  `access` date NOT NULL default '0000-00-00',
  `approved` enum('true','false') NOT NULL default 'false',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;





CREATE TABLE IF NOT EXISTS `member-images` (
  `id` varchar(250) NOT NULL default '',
  `userid` bigint(20) NOT NULL default '0',
  `image` varchar(250) NOT NULL default '',
  `thumb` varchar(250) NOT NULL default '',
  `tags` varchar(250) NOT NULL default '',
  `details` varchar(30) NOT NULL default '',
  `type` enum('private','public') NOT NULL default 'public',
  `views` bigint(20) NOT NULL default '0',
  `date` varchar(20) NOT NULL default '',
  `access` date NOT NULL default '0000-00-00',
  `approved` enum('true','false') NOT NULL default 'false',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;






CREATE TABLE IF NOT EXISTS `members` (
  `id` bigint(20) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(30) NOT NULL default '',
  `userpass` varchar(30) NOT NULL default '',
  `email` varchar(30) NOT NULL default '',
  `access` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;






CREATE TABLE IF NOT EXISTS `public-images` (
  `id` varchar(250) NOT NULL default '',
  `image` varchar(250) NOT NULL default '',
  `thumb` varchar(250) NOT NULL default '',
  `tags` varchar(250) NOT NULL default '',
  `details` varchar(30) NOT NULL default '',
  `views` bigint(20) NOT NULL default '0',
  `date` varchar(20) NOT NULL default '',
  `access` date NOT NULL default '0000-00-00',
  `approved` enum('true','false') NOT NULL default 'false',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;






CREATE TABLE IF NOT EXISTS `warned-accounts` (
  `id` varchar(250) NOT NULL default '',
  `userid` bigint(20) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
        




