MySQL

--
-- Table structure for table 'administrators'
--

CREATE TABLE 'administrators' (
  'ADMINID' BIGINT(20) NOT NULL AUTO_INCREMENT,
  'email' VARCHAR(80) NOT NULL DEFAULT '',
  'username' VARCHAR(80) NOT NULL DEFAULT '',
  'password' VARCHAR(50) NOT NULL DEFAULT '',
  PRIMARY KEY  ('ADMINID'),
  UNIQUE KEY 'email' ('email'),
  UNIQUE KEY 'username' ('username')
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table 'administrators'
--

INSERT INTO 'administrators' VALUES (1, '[email protected]', 'tomex009', '48238b7f2aa5f76a1d1e119f8942ebe7');

-- --------------------------------------------------------

--
-- Table structure for table 'advertisements'
--

CREATE TABLE 'advertisements' (
  'AID' BIGINT(30) NOT NULL AUTO_INCREMENT,
  'description' VARCHAR(200) NOT NULL DEFAULT '',
  'code' text NOT NULL,
  'active' enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY  ('AID')
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table 'advertisements'
--

INSERT INTO 'advertisements' VALUES (1, '300 x 250 pixels', '<script type="text/javascript"><!--\r\ngoogle_ad_client = "ca-pub-4038454921391697";\r\n/* 250x250 21 */\r\ngoogle_ad_slot = "7681226835";\r\ngoogle_ad_width = 250;\r\ngoogle_ad_height = 250;\r\n//-->\r\n</script>\r\n<script type="text/javascript"\r\nsrc="http://pagead2.googlesyndication.com/pagead/show_ads.js">\r\n</script>', '1');
INSERT INTO 'advertisements' VALUES (2, '300 x 300 pixels', '<script type="text/javascript"><!--\r\ngoogle_ad_client = "ca-pub-4038454921391697";\r\n/* 300x250 2 */\r\ngoogle_ad_slot = "5822717234";\r\ngoogle_ad_width = 300;\r\ngoogle_ad_height = 250;\r\n//-->\r\n</script>\r\n<script type="text/javascript"\r\nsrc="http://pagead2.googlesyndication.com/pagead/show_ads.js">\r\n</script>', '1');
INSERT INTO 'advertisements' VALUES (3, '728 x 90 pixels', '<script type="text/javascript"><!--\r\ngoogle_ad_client = "ca-pub-4038454921391697";\r\n/* Down Banner */\r\ngoogle_ad_slot = "3166702349";\r\ngoogle_ad_width = 728;\r\ngoogle_ad_height = 90;\r\n//-->\r\n</script>\r\n<script type="text/javascript"\r\nsrc="http://pagead2.googlesyndication.com/pagead/show_ads.js">\r\n</script>', '1');

-- --------------------------------------------------------

--
-- Table structure for table 'bans_ips'
--

CREATE TABLE 'bans_ips' (
  'ip' VARCHAR(20) NOT NULL,
  UNIQUE KEY 'ip' ('ip')
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table 'bans_ips'
--


-- --------------------------------------------------------

--
-- Table structure for table 'config'
--

CREATE TABLE 'config' (
  'setting' VARCHAR(60) NOT NULL DEFAULT '',
  'value' text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table 'config'
--

INSERT INTO 'config' VALUES ('site_email', '[email protected]');
INSERT INTO 'config' VALUES ('site_name', 'Balkan Fail Blog');
INSERT INTO 'config' VALUES ('max_syndicate_results', '25');
INSERT INTO 'config' VALUES ('maximum_results', '1000000');
INSERT INTO 'config' VALUES ('emailsender', 'Admin');
INSERT INTO 'config' VALUES ('max_img_size', '200');
INSERT INTO 'config' VALUES ('items_per_page', '10');
INSERT INTO 'config' VALUES ('approve_stories', '0');
INSERT INTO 'config' VALUES ('metadescription', 'Official Balkan Fail Blog Website');
INSERT INTO 'config' VALUES ('metakeywords', '9gag clone, 9gag script, 9gag clone script, clone, script');
INSERT INTO 'config' VALUES ('pub_mod', '1');
INSERT INTO 'config' VALUES ('ver', '2.9');
INSERT INTO 'config' VALUES ('FACEBOOK_PROFILE', 'BalkanFailBlog');
INSERT INTO 'config' VALUES ('myes', '5');
INSERT INTO 'config' VALUES ('mno', '5');
INSERT INTO 'config' VALUES ('twitter', 'Scriptolution');
INSERT INTO 'config' VALUES ('FACEBOOK_APP_ID', '128333383995241');
INSERT INTO 'config' VALUES ('FACEBOOK_SECRET', 'a3459feb8732bcc1bfeff0b344da35fd');
INSERT INTO 'config' VALUES ('enable_fc', '1');
INSERT INTO 'config' VALUES ('mtrend', '1');
INSERT INTO 'config' VALUES ('quota', '15');
INSERT INTO 'config' VALUES ('contact_email', '[email protected]');
INSERT INTO 'config' VALUES ('short_urls', '1');
INSERT INTO 'config' VALUES ('FACEBOOK_ADMIN', '100000051390750');
INSERT INTO 'config' VALUES ('wm', '0');
INSERT INTO 'config' VALUES ('watermark', 'watermark.png');
INSERT INTO 'config' VALUES ('points_gag', '10');
INSERT INTO 'config' VALUES ('points_view', '1');
INSERT INTO 'config' VALUES ('enable_featured', '0');
INSERT INTO 'config' VALUES ('infinity_paging', '1');
INSERT INTO 'config' VALUES ('wm', '0');
INSERT INTO 'config' VALUES ('watermark', 'watermark.png');
INSERT INTO 'config' VALUES ('FACEBOOK_ADMIN', '100000051390750');
INSERT INTO 'config' VALUES ('re_mobile', '1');
INSERT INTO 'config' VALUES ('m_url', 'http://mobilebfb.tk');

-- --------------------------------------------------------

--
-- Table structure for table 'members'
--

CREATE TABLE 'members' (
  'USERID' BIGINT(20) NOT NULL AUTO_INCREMENT,
  'email' VARCHAR(80) NOT NULL DEFAULT '',
  'username' VARCHAR(80) NOT NULL DEFAULT '',
  'password' VARCHAR(50) NOT NULL DEFAULT '',
  'pwd' VARCHAR(50) NOT NULL,
  'fullname' VARCHAR(200) NOT NULL DEFAULT '',
  'gender' VARCHAR(6) NOT NULL DEFAULT '',
  'description' text NOT NULL,
  'country' VARCHAR(100) NOT NULL DEFAULT '',
  'yourviewed' INT(20) NOT NULL DEFAULT '0',
  'profileviews' INT(20) NOT NULL DEFAULT '0',
  'youviewed' BIGINT(20) NOT NULL DEFAULT '0',
  'addtime' VARCHAR(20) NOT NULL DEFAULT '',
  'lastlogin' VARCHAR(20) NOT NULL DEFAULT '',
  'verified' CHAR(1) NOT NULL DEFAULT '1',
  'status' enum('1','0') NOT NULL DEFAULT '1',
  'profilepicture' VARCHAR(100) NOT NULL DEFAULT '',
  'remember_me_key' VARCHAR(32) DEFAULT NULL,
  'remember_me_time' datetime DEFAULT NULL,
  'ip' VARCHAR(20) NOT NULL,
  'lip' VARCHAR(20) NOT NULL,
  'website' VARCHAR(200) NOT NULL,
  'news' INT(1) NOT NULL DEFAULT '0',
  'mylang' VARCHAR(20) NOT NULL,
  'color1' VARCHAR(6) NOT NULL DEFAULT '333333',
  'color2' VARCHAR(6) NOT NULL DEFAULT 'FFFFFF',
  'filter' BIGINT(1) NOT NULL DEFAULT '1',
  'points' BIGINT(50) NOT NULL,
  PRIMARY KEY  ('USERID'),
  UNIQUE KEY 'email' ('email')
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table 'members'
--

INSERT INTO 'members' VALUES (1, '[email protected]', 'tomex009', '48238b7f2aa5f76a1d1e119f8942ebe7', 'XlQ2v1356734945', '', '', '', '', 6, 0, 5, '1356734945', '', '1', '1', '', NULL, NULL, '89.172.31.197', '89.172.31.197', '', 0, '', '333333', 'FFFFFF', 1, 15);

-- --------------------------------------------------------

--
-- Table structure for table 'members_passcode'
--

CREATE TABLE 'members_passcode' (
  'USERID' BIGINT(20) NOT NULL DEFAULT '0',
  'code' VARCHAR(30) NOT NULL DEFAULT '',
  PRIMARY KEY  ('USERID')
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table 'members_passcode'
--


-- --------------------------------------------------------

--
-- Table structure for table 'members_verifycode'
--

CREATE TABLE 'members_verifycode' (
  'USERID' BIGINT(20) NOT NULL DEFAULT '0',
  'code' VARCHAR(30) NOT NULL DEFAULT '',
  PRIMARY KEY  ('USERID')
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table 'members_verifycode'
--

INSERT INTO 'members_verifycode' VALUES (0, 'h394Y1328501678');

-- --------------------------------------------------------

--
-- Table structure for table 'posts'
--

CREATE TABLE 'posts' (
  'PID' BIGINT(20) NOT NULL AUTO_INCREMENT,
  'USERID' BIGINT(20) NOT NULL DEFAULT '0',
  'story' text NOT NULL,
  'tags' VARCHAR(200) NOT NULL,
  'source' VARCHAR(200) NOT NULL,
  'nsfw' INT(1) NOT NULL DEFAULT '0',
  'pic' VARCHAR(20) NOT NULL,
  'youtube_key' VARCHAR(20) NOT NULL,
  'fod_key' VARCHAR(20) NOT NULL,
  'url' text NOT NULL,
  'time_added' VARCHAR(20) DEFAULT NULL,
  'date_added' DATE NOT NULL DEFAULT '0000-00-00',
  'active' CHAR(1) NOT NULL DEFAULT '',
  'phase' BIGINT(1) NOT NULL DEFAULT '0',
  'favclicks' BIGINT(50) NOT NULL DEFAULT '0',
  'last_viewed' VARCHAR(20) NOT NULL DEFAULT '',
  'mod_yes' BIGINT(20) NOT NULL DEFAULT '0',
  'mod_no' BIGINT(20) NOT NULL DEFAULT '0',
  'pip' VARCHAR(20) NOT NULL,
  'pip2' VARCHAR(20) NOT NULL,
  'unfavclicks' BIGINT(50) NOT NULL DEFAULT '0',
  'fix' BIGINT(20) NOT NULL DEFAULT '0',
  'short' VARCHAR(20) NOT NULL,
  'ttime' VARCHAR(20) NOT NULL,
  'htime' VARCHAR(20) NOT NULL,
  'feat' INT(1) NOT NULL DEFAULT '0',
  'rec' INT(1) NOT NULL DEFAULT '0',
  PRIMARY KEY  ('PID')
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table 'posts'
--

INSERT INTO 'posts' VALUES (1, 1, 'ZM', '', '', 0, '1.jpg', '', '', '', '1357007005', '2012-12-31', '1', 0, 1, '1357007133', 0, 0, '89.172.25.214', '', 0, 0, '', '', '', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table 'posts_favorited'
--

CREATE TABLE 'posts_favorited' (
  'FID' BIGINT(20) NOT NULL AUTO_INCREMENT,
  'USERID' BIGINT(25) NOT NULL DEFAULT '0',
  'PID' BIGINT(25) NOT NULL DEFAULT '0',
  PRIMARY KEY  ('FID'),
  UNIQUE KEY 'USERID' ('USERID','PID')
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table 'posts_favorited'
--

INSERT INTO 'posts_favorited' VALUES (1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table 'posts_reports'
--

CREATE TABLE 'posts_reports' (
  'RID' BIGINT(20) NOT NULL AUTO_INCREMENT,
  'PID' BIGINT(20) NOT NULL DEFAULT '0',
  'time' VARCHAR(20) DEFAULT NULL,
  'ip' VARCHAR(20) NOT NULL,
  'reason' BIGINT(1) NOT NULL,
  PRIMARY KEY  ('RID')
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table 'posts_reports'
--


-- --------------------------------------------------------

--
-- Table structure for table 'posts_unfavorited'
--

CREATE TABLE 'posts_unfavorited' (
  'FID' BIGINT(20) NOT NULL AUTO_INCREMENT,
  'USERID' BIGINT(25) NOT NULL DEFAULT '0',
  'PID' BIGINT(25) NOT NULL DEFAULT '0',
  PRIMARY KEY  ('FID'),
  UNIQUE KEY 'USERID' ('USERID','PID')
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table 'posts_unfavorited'
--


-- --------------------------------------------------------

--
-- Table structure for table 'static'
--

CREATE TABLE 'static' (
  'ID' BIGINT(30) NOT NULL AUTO_INCREMENT,
  'title' VARCHAR(255) NOT NULL DEFAULT '',
  'value' text NOT NULL,
  PRIMARY KEY  ('ID')
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table 'static'
--

INSERT INTO 'static' VALUES (1, 'Terms Of Use', 'Insert your terms of use information here.<br><br>\r\n\r\nHTML is accepted.');
INSERT INTO 'static' VALUES (2, 'Privacy Policy', 'Insert your privacy policy information here.<br><br>\r\n\r\nHTML is accepted.');
INSERT INTO 'static' VALUES (3, 'About', 'Insert your about us information here.<br><br>\r\n\r\nHTML is accepted.');
INSERT INTO 'static' VALUES (4, '9 Rules', 'Insert your 9 rules here.<br><br>\r\n\r\nHTML is accepted.');
INSERT INTO 'static' VALUES (5, 'FAQ', 'Insert your frequently asked questions here.<br><br>\r\n\r\nHTML is accepted.');