
#
# Table structure for table afian_activity_logs
#

DROP TABLE IF EXISTS `afian_activity_logs`;
CREATE TABLE `afian_activity_logs` (
  `uid` mediumint(9) NOT NULL default '0',
  `code` char(1) NOT NULL default '',
  `date` varchar(255) NOT NULL default '',
  `action` varchar(255) NOT NULL default '',
  `details` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table afian_activity_logs
#


#
# Table structure for table afian_auth
#

DROP TABLE IF EXISTS `afian_auth`;
CREATE TABLE `afian_auth` (
  `username` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`username`)
) TYPE=MyISAM;

#
# Dumping data for table afian_auth
#

INSERT INTO `afian_auth` (`username`,`password`) VALUES ('admin','admin');

#
# Table structure for table afian_filetypes
#

DROP TABLE IF EXISTS `afian_filetypes`;
CREATE TABLE `afian_filetypes` (
  `id` mediumint(9) NOT NULL auto_increment,
  `extension` varchar(30) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `icon` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table afian_filetypes
#

INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (2,'','','generic.gif','Unknown File Type');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (3,'ace','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (4,'zip','arch','zip.gif','Zip Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (5,'rar','','archive.gif','Rar Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (6,'gz','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (7,'tar','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (8,'arj','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (9,'cab','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (10,'bz','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (11,'bz2','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (12,'jar','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (13,'taz','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (14,'tbz','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (15,'tbz2','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (16,'tgz','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (17,'uu','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (18,'uue','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (19,'war','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (20,'wsz','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (21,'xxe','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (22,'z00','','archive.gif','Archive');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (23,'jpg','img','jpg.gif','Jpeg Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (24,'jpeg','img','jpg.gif','Jpeg Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (25,'gif','img','gif.gif','GIF Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (26,'png','img','png.gif','PNG Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (27,'tga','','generic.gif','Targe Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (28,'tif','','generic.gif','Tag Image File Format');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (29,'bmp','','bmp.gif','Windows Bitmap Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (30,'jpe','img','jpg.gif','Jpeg Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (31,'jif','','generic.gif','Jpeg Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (32,'pcd','','generic.gif','Kodak PhotoCD');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (33,'pcx','','generic.gif','PCX Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (34,'pic','','generic.gif','PIC Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (35,'pix','','generic.gif','PIX Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (36,'psd','','psd.gif','Adobe Photoshop Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (37,'tiff','','jpg.gif','Tag Image File Format');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (38,'cdr','','cdr.gif','Corel Draw Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (39,'xar','','xar.gif',' Xara Image');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (40,'mpg','','video.gif','Mpeg Video');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (41,'mpe','','video.gif','Mpeg Video');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (42,'mpeg','','video.gif','Mpeg Video');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (43,'avi','','video.gif','Avi Video');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (44,'mov','','video.gif','Video File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (45,'asf','','video.gif','Video File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (46,'wmv','','video.gif','Video File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (47,'mp3','','audio.gif','Mp3 Audio File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (48,'mid','','audio.gif','Midi Audio File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (49,'wav','','wav.gif','Wave Audio File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (50,'txt','txt','txt.gif','Text document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (51,'htaccess','','txt.gif','Apache script file');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (52,'url','txt','html.gif','Web Shortcut');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (53,'htm','txt','html.gif','HTML Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (54,'html','txt','html.gif','HTML Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (55,'wml','txt','html.gif','Web Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (56,'htt','txt','html.gif','HTML Template');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (57,'inc','txt','txt.gif','Include File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (58,'vbs','txt','txt.gif','Visual Basic Script');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (59,'js','txt','js.gif','JavaScript Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (60,'jsp','txt','txt.gif','JSP Script');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (61,'asp','txt','asp.gif','Visual Basic Script');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (62,'pl','txt','txt.gif','Perl Script');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (63,'cgi','txt','txt.gif','Web Script');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (64,'php','txt','php.gif','PHP Script');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (65,'php3','txt','php.gif','PHP Script');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (66,'pxp','txt','php.gif','');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (67,'xml','txt','xml.gif','XML Web Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (68,'xhtml','txt','html.gif','XHTML Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (69,'css','txt','css.gif','Cascading Style Sheet');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (70,'swf','','swf.gif','Flash File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (71,'fla','','fla.gif','Flash Source File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (72,'tpl','txt','txt.gif','Template File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (73,'sql','txt','txt.gif','SQL Database dump');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (75,'myd','','txt.gif','MySQL Database File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (76,'myi','','txt.gif','MySQL Database File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (77,'csv','txt','txt.gif','CSV Text Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (78,'sub','txt','txt.gif','Movie Subtitle');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (79,'srt','txt','txt.gif','Movie Subtitle');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (80,'doc','','doc.gif','Word Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (81,'rtf','','doc.gif','Word Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (82,'wri','','doc.gif','Word Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (83,'xls','','xls.gif','Excel Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (84,'pps','','ppt.gif','Power Point Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (85,'ppt','','ppt.gif','Power Point Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (86,'qxd','','qxd.gif','Quark Express Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (87,'pdf','','pdf.gif','Acrobat Reader Document');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (88,'bak','','generic.gif','Backup File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (89,'$$$','','generic.gif','Temporary File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (90,'tmp','','generic.gif','Temporary File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (91,'temp','','generic.gif','Temporary File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (92,'log','txt','txt.gif','Log file');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (93,'ini','txt','txt.gif','Configuration File');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (94,'ttf','','generic.gif','True Type Font');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (95,'exe','bin','exe.gif','Windows Application');
INSERT INTO `afian_filetypes` (`id`,`extension`,`type`,`icon`,`description`) VALUES (96,'hlp','bin','generic.gif','Window Help File');

#
# Table structure for table afian_flags
#

DROP TABLE IF EXISTS `afian_flags`;
CREATE TABLE `afian_flags` (
  `uid` mediumint(9) NOT NULL default '0',
  `id` mediumint(9) NOT NULL auto_increment,
  `path` varchar(255) NOT NULL default '',
  `shared` tinyint(1) NOT NULL default '0',
  `public` tinyint(1) NOT NULL default '0',
  `discussion` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table afian_flags
#


#
# Table structure for table afian_gallery_options
#

DROP TABLE IF EXISTS `afian_gallery_options`;
CREATE TABLE `afian_gallery_options` (
  `fid` mediumint(9) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `showdirs` varchar(255) NOT NULL default '',
  `shownonimages` varchar(255) NOT NULL default '',
  `tplgid` varchar(9) NOT NULL default '',
  `thumbw` varchar(255) NOT NULL default '',
  `thumbh` varchar(255) NOT NULL default '',
  `defaultperpage` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table afian_gallery_options
#


#
# Table structure for table afian_gallery_tpl
#

DROP TABLE IF EXISTS `afian_gallery_tpl`;
CREATE TABLE `afian_gallery_tpl` (
  `id` int(11) NOT NULL auto_increment,
  `tpl_source` blob NOT NULL,
  `tpl_timestamp` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table afian_gallery_tpl
#

INSERT INTO `afian_gallery_tpl` (`id`,`tpl_source`,`tpl_timestamp`) VALUES (1,'<!doctype html public \"-//W3C//DTD HTML 4.0 Transitional//EN\">\r\n<html>\r\n<head>\r\n<title>{$GALLERY_TITLE}</title>\r\n<meta name=\"Generator\" content=\"EditPlus\">\r\n<meta name=\"Author\" content=\"\">\r\n<meta name=\"Keywords\" content=\"\">\r\n<meta name=\"Description\" content=\"\">\r\n\r\n<style>\r\nbody {literal}{{/literal}\r\nmargin:0px;\r\npadding:0px;\r\nbackground-color:white;\r\nbackground-image:url({$BASE_URL}/publicfiles/templates/predefined/gray/background.jpg);\r\ntext-align:center;\r\n{literal}}{/literal}\r\n\r\na\r\n{literal}{{/literal}\r\ncolor:silver;\r\ntext-decoration:none;\r\n{literal}}{/literal}\r\n\r\na:hover\r\n{literal}{{/literal}\r\ncolor:white;\r\ntext-decoration:underline;\r\n{literal}}{/literal}\r\n\r\na:visited\r\n{literal}{{/literal}\r\ncolor:silver;\r\ntext-decoration:none;\r\n{literal}}{/literal}\r\n\r\na:visited:hover\r\n{literal}{{/literal}\r\ncolor:white;\r\ntext-decoration:underline;\r\n{literal}}{/literal}\r\n\r\n</style>\r\n\r\n</head>\r\n\r\n<body>\r\n\r\n<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" style=\"width:650px;align:center;text-align:left;margin-top:50px;border:1px solid gray\"><tr><td>\r\n\r\n<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"border:none;border-bottom:1px solid gray;\"><tr><td style=\"color:white;font-family:arial;font-size:19px;text-align:left;padding:5px;padding-left:10px;\">{$GALLERY_TITLE}</td></tr></table>\r\n\r\n\r\n<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"height:20px;border:none;\"><tr><td style=\"height:20px;color:black;font-family:verdana;font-size:10px;font-weight:bold;text-align:left;padding-left:10px;vertical-align:middle\">{$FOLDER_BREADCRUMBS}</td></tr></table>\r\n\r\n\r\n\r\n\r\n<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\"><tr><td  style=\"padding-bottom:20px;padding-left:30px;padding-top:10px\">\r\n\r\n{foreach from=$THUMBS item=thumb}\r\n\r\n<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"float:left;display:inline;margin:3px;width:{$THUMBNAIL_MAX_WIDTH+30}px;height:{$THUMBNAIL_MAX_HEIGHT+30}px;border:1px solid silver;\">\r\n<tr><td>\r\n\r\n<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"width:100%;\"><tr><td style=\"background-color:none;text-align:center;border:none;\"><a href=\"{$thumb.enlarge_href}\"><img src=\"{$thumb.img_src}\" border=\"0\"></a></td></tr><tr><td style=\"background-color:none;text-align:center;padding-bottom:10px;border:none;\"><span style=\"color:white;font-family:verdana;font-size:9px;\"><a href=\"{$thumb.enlarge_href}\">{$thumb.filename|truncate:30:\"...\":true}</a></span></td></tr></table>\r\n\r\n</td></tr></table>\r\n\r\n\r\n\r\n{/foreach}\r\n\r\n</td></tr></table>\r\n\r\n\r\n</td></tr>\r\n<tr><td style=\"height:4px;font-family:verdana;font-size:4px;border-top:1px solid gray\">&nbsp;</td></tr>\r\n</td></tr></table>\r\n<br><br>\r\n\r\n</body>\r\n</html>','1116845039');
INSERT INTO `afian_gallery_tpl` (`id`,`tpl_source`,`tpl_timestamp`) VALUES (2,'<!doctype html public \"-//W3C//DTD HTML 4.0 Transitional//EN\">\r\n<html>\r\n<head>\r\n<title>{$GALLERY_TITLE} :: Large image</title>\r\n<meta name=\"Generator\" content=\"EditPlus\">\r\n<meta name=\"Author\" content=\"\">\r\n<meta name=\"Keywords\" content=\"\">\r\n<meta name=\"Description\" content=\"\">\r\n\r\n<style>\r\nbody {literal}{{/literal}\r\nmargin:0px;\r\npadding:0px;\r\nbackground-color:white;\r\nbackground-image:url({$BASE_URL}/publicfiles/templates/predefined/gray/background.jpg);\r\ntext-align:center;\r\n{literal}}{/literal}\r\n\r\na\r\n{literal}{{/literal}\r\ncolor:silver;\r\ntext-decoration:none;\r\n{literal}}{/literal}\r\n\r\na:hover\r\n{literal}{{/literal}\r\ncolor:white;\r\ntext-decoration:underline;\r\n{literal}}{/literal}\r\n\r\na:visited\r\n{literal}{{/literal}\r\ncolor:silver;\r\ntext-decoration:none;\r\n{literal}}{/literal}\r\n\r\na:visited:hover\r\n{literal}{{/literal}\r\ncolor:white;\r\ntext-decoration:underline;\r\n{literal}}{/literal}\r\n\r\n</style>\r\n\r\n</head>\r\n\r\n<body>\r\n\r\n\r\n\r\n<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" style=\"width:650px;align:center;text-align:left;margin-top:50px;border:1px solid gray\"><tr><td>\r\n\r\n<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"border:none;border-bottom:1px solid gray;\"><tr><td style=\"color:white;font-family:arial;font-size:19px;text-align:left;padding:5px;padding-left:10px;\">{$GALLERY_TITLE}</td></tr></table>\r\n\r\n<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"height:20px;border:none;\"><tr><td style=\"height:20px;color:black;font-family:verdana;font-size:10px;font-weight:bold;text-align:left;padding-left:10px;vertical-align:middle\">&laquo; {$BACK_LINK}</td><td  style=\"color:white;font-family:verdana;font-size:10px;font-weight:bold;text-align:center;\"><span style=\"color:silver;font-weight:normal\">&nbsp;</td><td  style=\"color:black;font-family:verdana;font-size:10px;font-weight:bold;text-align:right;padding-right:10px;\">&nbsp;</td></tr></table>\r\n\r\n</td></tr>\r\n\r\n<tr><td style=\"padding-top:3px;padding-left:3px;padding-bottom:3px;text-align:center;\">\r\n\r\n<center>\r\n<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"margin:3px;\">\r\n<tr><td><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"width:100%;\"><tr>\r\n\r\n\r\n<td style=\"background-color:none;text-align:center;padding:20px;padding-bottom:5px;border:none;\">\r\n<div style=\"position:relative;width:{$image_size.0}px;height:{$image_size.1}px\">\r\n\r\n{if $previous_url != \"\"}\r\n<div style=\"position:absolute;left:-20px;top:-20px;\">\r\n<a href=\"{$previous_url}\">\r\n<img border=\"0\" src=\"{$previous_thumb_src}\">\r\n</a>\r\n</div>\r\n{/if}\r\n\r\n<img src=\"{$img_src}\">\r\n\r\n{if $next_url != \"\"}\r\n<div style=\"position:absolute;right:-20px;top:-20px;\">\r\n<a href=\"{$next_url}\">\r\n<img border=\"0\" src=\"{$next_thumb_src}\">\r\n</a>\r\n</div>\r\n{/if}\r\n\r\n</div>\r\n</td>\r\n\r\n\r\n</tr><tr><td style=\"background-color:none;text-align:center;padding-bottom:10px;border:none;\" align=\"center\"><span style=\"font-family:verdana;font-size:9px;color:white\">{$filename}</span></td></tr></table></td></tr></table>\r\n</center>\r\n\r\n\r\n</td></tr>\r\n\r\n{if $nr_of_comments > 0}\r\n\r\n\r\n\r\n<!-- USER COMMENTS -->\r\n<tr><td height=\"2\" style=\"height:2px;background-color:none;font-family:verdana;font-size:10px;padding:2px;padding-left:15px;border-top:none;color:black;background-color:gray\"><strong>COMMENTS</strong></td></tr>\r\n<tr><td height=\"2\" style=\"height:2px;background-color:none;font-family:verdana;font-size:10px;border:none;padding:5px;padding-left:15px;\">\r\n\r\n<table style=\"font-size:12px;\">\r\n\r\n{foreach from=$comments item=comment}\r\n\r\n<tr>\r\n<td valign=\"top\" style=\"padding-right:10px;border-right:1px solid silver;\">\r\n<strong style=\"color:white\">{$comment.author}</strong>\r\n</td>\r\n<td valign=\"top\" style=\"color:white;\">\r\n{$comment.message}\r\n</td>\r\n</tr>\r\n\r\n{/foreach}\r\n\r\n</table>\r\n\r\n</td></tr>\r\n<!-- END USER COMMENTS -->\r\n\r\n{else}\r\n{/if}\r\n\r\n\r\n<tr><td style=\"height:4px;font-family:verdana;font-size:4px;border-top:1px solid gray\">&nbsp;</td></tr>\r\n</td></tr></table>\r\n<br><br>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n</body>\r\n</html>','1116865012');

#
# Table structure for table afian_groups
#

DROP TABLE IF EXISTS `afian_groups`;
CREATE TABLE `afian_groups` (
  `id` mediumint(9) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `suspended` char(1) NOT NULL default '',
  `path` varchar(255) NOT NULL default '',
  `readonly` char(1) NOT NULL default '',
  `upload` char(1) NOT NULL default '',
  `sendbyemail` char(1) NOT NULL default '',
  `uploadnotice` char(1) NOT NULL default '',
  `downloadnotice` char(1) NOT NULL default '',
  `sharing` char(1) NOT NULL default '',
  `spacequota` varchar(255) NOT NULL default '',
  `trafficquota` varchar(255) NOT NULL default '',
  `public` char(1) NOT NULL default '',
  `shareaccess` char(1) NOT NULL default '',
  `view_others` varchar(255) NOT NULL default '',
  `ui_type` varchar(10) NOT NULL default '',
  `ui_has_tree` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Dumping data for table afian_groups
#

INSERT INTO `afian_groups` (`id`,`name`,`suspended`,`path`,`readonly`,`upload`,`sendbyemail`,`uploadnotice`,`downloadnotice`,`sharing`,`spacequota`,`trafficquota`,`public`,`shareaccess`, `view_others`, `ui_type`, `ui_has_tree`) VALUES (1,'Default','0','/home/users/','0','1','1','0','0','1','','','1','1','+','normal','1');

#
# Table structure for table afian_history
#

DROP TABLE IF EXISTS `afian_history`;
CREATE TABLE `afian_history` (
  `uid` mediumint(9) NOT NULL default '0',
  `usernames` text NOT NULL
) TYPE=MyISAM;

#
# Dumping data for table afian_history
#
INSERT INTO `afian_history` (`uid`,`usernames`) VALUES (1,'');

#
# Table structure for table afian_interauth
#

DROP TABLE IF EXISTS `afian_interauth`;
CREATE TABLE `afian_interauth` (
  `username` varchar(255) NOT NULL default '',
  `id` mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`,`id`)
) TYPE=MyISAM;

#
# Dumping data for table afian_interauth
#

INSERT INTO `afian_interauth` (`username`,`id`) VALUES ('admin',1);

#
# Table structure for table afian_last_uploads
#

DROP TABLE IF EXISTS `afian_last_uploads`;
CREATE TABLE `afian_last_uploads` (
  `uid` mediumint(9) NOT NULL default '0',
  `id` mediumint(9) NOT NULL auto_increment,
  `path` varchar(255) NOT NULL default '',
  `date` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table afian_last_uploads
#


#
# Table structure for table afian_optional_user_info
#

DROP TABLE IF EXISTS `afian_optional_user_info`;
CREATE TABLE `afian_optional_user_info` (
  `uid` mediumint(9) NOT NULL auto_increment,
  `firstname` varchar(255) NOT NULL default '',
  `lastname` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `company` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

#
# Dumping data for table afian_optional_user_info
#

INSERT INTO `afian_optional_user_info` (`uid`,`firstname`,`lastname`,`email`,`company`) VALUES (1,'','','','');

#
# Table structure for table afian_permvars
#

DROP TABLE IF EXISTS `afian_permvars`;
CREATE TABLE `afian_permvars` (
  `var` varchar(255) NOT NULL default '',
  `val` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`var`)
) TYPE=MyISAM;

#
# Dumping data for table afian_permvars
#

INSERT INTO `afian_permvars` (`var`,`val`) VALUES ('flagsMonthlyCleanUpDate','0');

#
# Table structure for table afian_public_info
#

DROP TABLE IF EXISTS `afian_public_info`;
CREATE TABLE `afian_public_info` (
  `id` mediumint(9) NOT NULL auto_increment,
  `fid` mediumint(9) NOT NULL default '0',
  `expiry` varchar(255) NOT NULL default '',
  `gallery` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `forcedownload` varchar(255) NOT NULL default '',
  `allowuploads` varchar(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table afian_public_info
#


#
# Table structure for table afian_sessions
#

DROP TABLE IF EXISTS `afian_sessions`;
CREATE TABLE `afian_sessions` (
  `key` varchar(32) NOT NULL default '',
  `expiry` varchar(11) NOT NULL default '',
  `data` text NOT NULL,
  `logged` char(1) NOT NULL default '',
  PRIMARY KEY  (`key`)
) TYPE=MyISAM;

#
# Dumping data for table afian_sessions
#


#
# Table structure for table afian_settings
#

DROP TABLE IF EXISTS `afian_settings`;
CREATE TABLE `afian_settings` (
  `var` varchar(255) NOT NULL default '',
  `val` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`var`)
) TYPE=MyISAM;

#
# Dumping data for table afian_settings
#

INSERT INTO `afian_settings` (`var`,`val`) VALUES ('lastuploads','15');
INSERT INTO `afian_settings` (`var`,`val`) VALUES ('logsaction','zip');
INSERT INTO `afian_settings` (`var`,`val`) VALUES ('logsactionlastdate','0');
INSERT INTO `afian_settings` (`var`,`val`) VALUES ('publicfolders','1');
INSERT INTO `afian_settings` (`var`,`val`) VALUES ('suspend','');

#
# Table structure for table afian_share_info
#

DROP TABLE IF EXISTS `afian_share_info`;
CREATE TABLE `afian_share_info` (
  `fid` mediumint(9) NOT NULL default '0',
  `to_uid` mediumint(9) NOT NULL default '0',
  `as` varchar(255) NOT NULL default '',
  `write` tinyint(1) NOT NULL default '0',
  `date` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table afian_share_info
#


#
# Table structure for table afian_tpl_groups
#

DROP TABLE IF EXISTS `afian_tpl_groups`;
CREATE TABLE `afian_tpl_groups` (
  `uid` int(9) default NULL,
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `main_tplid` int(11) default NULL,
  `enlarge_tplid` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table afian_tpl_groups
#

INSERT INTO `afian_tpl_groups` (`uid`,`id`,`name`,`main_tplid`,`enlarge_tplid`) VALUES (0,1,'Dark Gray',1,2);

#
# Table structure for table afian_trash
#

DROP TABLE IF EXISTS `afian_trash`;
CREATE TABLE `afian_trash` (
  `uid` mediumint(9) NOT NULL default '0',
  `id` mediumint(9) NOT NULL auto_increment,
  `path` varchar(255) NOT NULL default '',
  `date` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Dumping data for table afian_trash
#


#
# Table structure for table afian_users
#

DROP TABLE IF EXISTS `afian_users`;
CREATE TABLE `afian_users` (
  `id` mediumint(9) NOT NULL auto_increment,
  `gid` mediumint(9) NOT NULL default '0',
  `suspended` char(1) NOT NULL default '',
  `lastlogin` varchar(255) NOT NULL default '',
  `previouslogin` varchar(255) NOT NULL default '',
  `path` varchar(255) NOT NULL default '',
  `readonly` char(1) NOT NULL default '',
  `upload` char(1) NOT NULL default '',
  `sendbyemail` char(1) NOT NULL default '',
  `uploadnotice` char(1) NOT NULL default '',
  `downloadnotice` char(1) NOT NULL default '',
  `sharing` char(1) NOT NULL default '',
  `spacequota` varchar(255) NOT NULL default '',
  `trafficquota` varchar(255) NOT NULL default '',
  `traffic` varchar(255) NOT NULL default '',
  `trafficdate` varchar(255) NOT NULL default '',
  `public` char(1) NOT NULL default '',
  `shareaccess` char(1) NOT NULL default '',
  `view_others` varchar(255) NOT NULL default '',
  `ui_type` varchar(10) NOT NULL default '',
  `ui_has_tree` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table afian_users
#

INSERT INTO `afian_users` (`id`,`gid`,`suspended`,`lastlogin`,`previouslogin`,`path`,`readonly`,`upload`,`sendbyemail`,`uploadnotice`,`downloadnotice`,`sharing`,`spacequota`,`trafficquota`,`traffic`,`trafficdate`,`public`,`shareaccess`, `view_others`, `ui_type`, `ui_has_tree`) VALUES (1,1,'','0','0','','','','','','','','','','0','0','','','','','');
