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

--
-- Table structure for table `tonymavundla_com__admin`
--

DROP TABLE IF EXISTS tonymavundla_com__admin;

CREATE TABLE `tonymavundla_com__admin` (
  `usern` varchar(50) NOT NULL,
  `pswrd` varchar(50) NOT NULL,
  `attempts` int(11) NOT NULL,
  `logintime` datetime NOT NULL,
  `login_id` varchar(50) NOT NULL,
  PRIMARY KEY (`login_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tonymavundla_com__admin`
--

INSERT INTO tonymavundla_com__admin VALUES
("1e40148be1019e8f739745973c5e9937","727c148261b7d2e5b22dc14dd5f35e29","0","2020-09-28 13:06:01","a74473adfa1d25bc43f2aa28d1e6a998");

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

--
-- Table structure for table `tonymavundla_com__counter`
--

DROP TABLE IF EXISTS tonymavundla_com__counter;

CREATE TABLE `tonymavundla_com__counter` (
  `cnum` int(11) NOT NULL,
  PRIMARY KEY (`cnum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tonymavundla_com__counter`
--

INSERT INTO tonymavundla_com__counter VALUES
("3341");

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

--
-- Table structure for table `tonymavundla_com__industry`
--

DROP TABLE IF EXISTS tonymavundla_com__industry;

CREATE TABLE `tonymavundla_com__industry` (
  `industryid` bigint(20) NOT NULL AUTO_INCREMENT,
  `ordernum` bigint(20) DEFAULT NULL,
  `title` text,
  `vanity_url` text,
  `description` longtext,
  `image` text,
  `dateadded` datetime DEFAULT NULL,
  PRIMARY KEY (`industryid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tonymavundla_com__industry`
--

INSERT INTO tonymavundla_com__industry VALUES
("1","1","IT & Consulting","it-and-consulting","Description of Industry here....","1.jpg","2019-11-14 11:52:17"),
("2","2","Mining","mining","","1_1.jpg","2019-11-14 11:52:42"),
("3","3","Engineering","engineering","","1_2.jpg","2019-11-14 11:52:53"),
("4","4","Government","government","","1_3.jpg","2019-11-14 11:53:02"),
("5","5","Insurance","insurance","","1_4.jpg","2019-11-14 11:53:19"),
("6","6","Banking","banking","","1_5.jpg","2019-11-14 11:53:33"),
("7","7","Telecommunications","telecommunications","","1_6.jpg","2019-11-14 11:53:40"),
("8","8","FMCG","fmcg","","1_7.jpg","2019-11-14 11:53:49");

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

--
-- Table structure for table `tonymavundla_com__opening`
--

DROP TABLE IF EXISTS tonymavundla_com__opening;

CREATE TABLE `tonymavundla_com__opening` (
  `openingid` bigint(20) NOT NULL AUTO_INCREMENT,
  `cid` bigint(20) DEFAULT NULL,
  `title` text,
  `vanity_url` text,
  `location` text,
  `description` longtext,
  `dateadded` datetime DEFAULT NULL,
  PRIMARY KEY (`openingid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tonymavundla_com__opening`
--

INSERT INTO tonymavundla_com__opening VALUES
("1","1","Test Opening","test-opening","Jacksonville, FL","More info on opening here..","2019-11-14 11:56:01");

