Gecko [ www.airco.bigpunchmedia.co.za ]

Name	Size	Permission	Date
images	[ DIR ]	drwxr-xr-x	2017-01-28 10:38
php53	[ DIR ]	drwxr-xr-x	2017-01-28 10:38
php56	[ DIR ]	drwxr-xr-x	2017-01-28 10:38
config.ini.php	395 B	-rwxr-xr-x	2013-06-13 07:41
db.ini.php	102 B	-rwxr-xr-x	2013-06-13 07:41
edit.php	5.12 KB	-rwxr-xr-x	2017-01-27 06:13
edit.xml	433 B	-rwxr-xr-x	2016-05-04 22:43
fileindex.php	90 B	-rwxr-xr-x	2011-09-27 05:24
import.php	2.94 KB	-rwxr-xr-x	2017-01-27 06:13
info.xml	1.71 KB	-rwxr-xr-x	2017-01-27 06:09
install.js	921 B	-rwxr-xr-x	2013-06-13 07:41
install.php	4.96 KB	-rwxr-xr-x	2017-01-27 06:13
install.xml	897 B	-rwxr-xr-x	2016-05-04 22:43
joobs.sql	3.6 KB	-rwxr-xr-x	2017-01-28 10:38
joobs.zip	4.69 MB	-rwxr-xr-x	2017-01-28 10:38
md5	2.36 KB	-rwxr-xr-x	2017-01-27 06:13
notes.txt	150 B	-rwxr-xr-x	2013-06-13 07:41
passwordSalt.php	8 B	-rwxr-xr-x	2011-09-27 05:24

Rename

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `joobsbox`
--

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

--
-- Table structure for table `[[dbprefix]]categories`
--

CREATE TABLE `[[dbprefix]]categories` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Link` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `OrderIndex` tinyint(4) NOT NULL,
  `Parent` tinyint(4) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `OrderIndex` (`OrderIndex`),
  KEY `Parent` (`Parent`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]categories`
--

INSERT INTO `[[dbprefix]]categories` VALUES(1, 'Uncategorized', 'Uncategorized', 100, 0);

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

--
-- Table structure for table `[[dbprefix]]jobs`
--

CREATE TABLE `[[dbprefix]]jobs` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `CategoryID` int(11) NOT NULL DEFAULT '0',
  `Title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `Description` varchar(4000) COLLATE utf8_unicode_ci NOT NULL,
  `ToApply` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `Company` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
  `Location` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
  `Public` tinyint(1) NOT NULL DEFAULT '0',
  `ExpirationDate` int(10) unsigned NOT NULL,
  `ChangedBy` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `ChangedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `STATUS` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `CodeStamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `PostedAt` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `CategoryID` (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]plugin_data`
--

CREATE TABLE `[[dbprefix]]plugin_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `plugin_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `option_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `option_value` varchar(4096) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `option_name` (`option_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]users`
--

CREATE TABLE `[[dbprefix]]users` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `realname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `password_salt` varchar(51) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]users`
--

INSERT INTO `[[dbprefix]]users` VALUES(1, '[[admin_username]]', '[[admin_realname]]', '[[admin_pass]]', '[[password_salt]]');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;