-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `anandaob_db`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` bigint(20) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `salt` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`, `email`, `salt`) VALUES
(1, 'kasun', '558b284c215a74bf5874b78b459c64b3fc0bbbafd9fbbbdda6274f0abfa505f63bd0ba4efbd90f8d9886161b6e7702b35d24b4288ea0428458cc7c29f91e48c5', 'kasun@gmail.com', 'e16cca1e48d75bd1828f394e20c930ebe54ba4fe3f72aa74267c6fb03943d78dc160b1d1af512e2da569e15a5c2ee4e3741b00b09c6f16e6fb69a20a33c1a8f0'),
(2, 'test', 'c469446119eb57ed697a91fe8c3918333a1ffa41b61837ccb259cee675dfc22e40f5ffc5e5db2f5bff41c589c2ceda7657c452f931e73d2728d14e3468b5a2d9', 'kasun@kasun.lk', '60348c2aeea0977b686402960055a79da9ad265054ee0efdd2ecc7fe99406285f4ee114723034701a274ad9100cf508bfd90c9a3c50e69482c7101f3370ea9a6');

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

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `event_id` bigint(20) NOT NULL,
  `event_title` varchar(255) NOT NULL,
  `event_detail` text NOT NULL,
  `event_image` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `event`
--

INSERT INTO `event` (`event_id`, `event_title`, `event_detail`, `event_image`, `created_at`) VALUES
(1, 'ACOBA ANNUAL 2014', 'ACOBA ANNUAL 2014 Meeting @', '1411322893.png', '2014-09-21 20:09:14'),
(5, 'Testing 456', '123 YES', '1411325262.png', '2014-09-22 00:17:42');

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `news_id` bigint(20) NOT NULL,
  `news_title` varchar(255) NOT NULL,
  `news_detail` text NOT NULL,
  `news_image` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`news_id`, `news_title`, `news_detail`, `news_image`, `created_at`) VALUES
(1, 'News 1', 'Apoi4', '1411331120.png', '2014-09-22 01:29:04');

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

--
-- Table structure for table `project`
--

CREATE TABLE `project` (
  `project_id` bigint(20) NOT NULL,
  `project_title` varchar(255) NOT NULL,
  `project_detail` text DEFAULT NULL,
  `project_image` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project`
--

INSERT INTO `project` (`project_id`, `project_title`, `project_detail`, `project_image`, `created_at`) VALUES
(1, 'Project 1', '123 this is test project', '1411348970.png', '2014-09-22 06:52:50'),
(2, 'Testing On Server', 'Test on live server', '1411351751.jpg', '2014-09-21 22:09:11');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `event`
--
ALTER TABLE `event`
  ADD PRIMARY KEY (`event_id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`news_id`);

--
-- Indexes for table `project`
--
ALTER TABLE `project`
  ADD PRIMARY KEY (`project_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `event`
--
ALTER TABLE `event`
  MODIFY `event_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `news_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `project`
--
ALTER TABLE `project`
  MODIFY `project_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

