--
-- Database: `lofo`
--

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

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

-- drop TABLE `admin`;
-- DROP TABLE `users`;
-- drop TABLE `found`;
-- drop TABLE `lost`;
-- DROP TABLE `message`;


CREATE TABLE IF NOT EXISTS `admin` (
`id` int(30) NOT NULL,
  `username` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

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

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

--
-- Table structure for table `found`
--
CREATE TABLE IF NOT EXISTS `found` (
`id` int(100) NOT NULL,
  `title` varchar(30) NOT NULL,
  `foundDate` date NOT NULL,
  `category` varchar(20) NOT NULL,
  `subCategory` varchar(20) NOT NULL,
  `color` varchar(20) NOT NULL,
  `details` text NOT NULL,
  `area` varchar(20) NOT NULL,
  `postedAt` date NOT NULL,
  `userId` int(10) NOT NULL,
  `foun` int(2) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `found`
--

INSERT INTO `found` (`id`, `title`, `foundDate`, `category`, `subCategory`, `color`, `details`, `area`, `postedAt`, `userId`, `foun`) VALUES
(1, 'ochelari', '2016-03-05', 'bags', 'suitcase', 'green', 'ochelari de soare', 'Roman', '0000-00-00', 1, 1),
(2, 'Glasses', '2016-04-01', 'personal', 'glass', 'Red', 'nice ', 'Iasi', '2016-04-04', 2, 1),
(3, 'carte', '2016-03-11', 'collector', 'card', 'red', 'nice red book', 'Bucuresti', '2016-04-05', 2, 1),
(4, 'cohelo', '2016-02-19', 'jewelry', 'necklace', 'blue', 'blue jewelry', 'Bucuresti', '2016-04-05', 2, 1);

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

--
-- Table structure for table `lost`
--
CREATE TABLE IF NOT EXISTS `lost` (
`id` int(11) NOT NULL,
  `title` varchar(20) NOT NULL,
  `lastTimeSeen` date NOT NULL,
  `category` varchar(20) NOT NULL,
  `subCategory` varchar(20) NOT NULL,
  `color` varchar(20) NOT NULL,
  `details` text NOT NULL,
  `area` varchar(20) NOT NULL,
  `postedAt` date NOT NULL,
  `userId` int(10) NOT NULL,
  `los` int(2) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lost`
--

INSERT INTO `lost` (`id`, `title`, `lastTimeSeen`, `category`, `subCategory`, `color`, `details`, `area`, `postedAt`, `userId`, `los`) VALUES
(1, 'ion', '2016-03-03', 'bags', 'briefcase', 'red', 'nu iti zic', 'Romania', '0000-00-00', 2, 0),
(2, 'ceva', '2016-03-08', 'currency', 'foreign', 'Nur', '	CEva', 'Iasi', '0000-00-00', 2, 0);

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

--
-- Table structure for table `message`
--


CREATE TABLE IF NOT EXISTS `message` (
`id` int(11) NOT NULL,
  `username1` varchar(30) NOT NULL,
  `username2` varchar(30) NOT NULL,
  `title` varchar(30) NOT NULL,
  `body` text NOT NULL,
  `seen` varchar(3) NOT NULL DEFAULT 'no',
  `sentAt` date NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `message`
--

INSERT INTO `message` (`id`, `username1`, `username2`, `title`, `body`, `seen`, `sentAt`) VALUES
(1, 'bb', 'alex', 'boss', 'ce faci?:)', 'yes', '2016-04-09'),
(2, 'bb', 'alex', 'cd', 'cddse', 'yes', '2016-04-09'),
(3, 'bb', 'alex', 'msg2', 'ce faci', 'yes', '2016-04-09'),
(4, 'cc', 'alex', 'ceva', 'boss esti okfea daed amedieam fiaef iamfaei fnaefn aejfnaj fnaejifneaijfnaeifjna fjanfkjaenfjaenfkaje neakjfn aekjfankfjanefk jae', 'yes', '2016-04-09'),
(5, 'cc', 'bb', 'ce', 'daewdd', 'no', '2016-04-09'),
(6, 'cc', 'bb', 'de', 'jh uh iu hkiy hky bg yb ky bky b kyb ky byb yb ky b ky bkybky bky bkyb ky', 'no', '2016-04-09'),
(7, 'alex', 'blitz08', 'hello', 'ce faci boss', 'yes', '2016-05-03');

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

--
-- Table structure for table `users`


CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) NOT NULL,
  `firstName` varchar(20) NOT NULL,
  `lastName` varchar(20) NOT NULL,
  `username` varchar(20) NOT NULL,
  `email` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL,
  `city` varchar(20) NOT NULL,
  `address` text NOT NULL,
  `country` varchar(20) NOT NULL,
  `singup` date NOT NULL,
  `salt` varchar(20) --default value
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `firstName`, `lastName`, `username`, `email`, `password`, `city`, `address`, `country`, `singup`) VALUES
(1, 'Dumea', 'Alexandru', 'blitz08', 'alex_blitz08@yahoo.com', 'steaua', '', 'conductelor 6', 'Romania', '2016-03-08'),
(2, 'Danca', 'Alex', 'alex', 'alex.dumea@gmail.com', 'steaua', 'Iasi', 'ceva frumos', 'Romania', '2016-03-08'),
(3, 'Lebada', 'Ciprian', 'lebada', 'lebada@yahoo.com', 'lebada', '', 'Roman strada Lebada', 'Romania', '2016-03-24'),
(4, 'aa', 'aa', 'aa', 'alex@gmail.com', 'aa', '', 'aa', 'Germania', '2016-04-04'),
(5, 'bb', 'bb', 'bb', 'bb@gmail.com', 'bb', '', 'bb', 'Romania', '2016-04-04'),
(6, 'cc', 'cc', 'cc', 'cc@gmail.com', 'cc', 'cc', 'cc', 'Germania', '2016-04-04');

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
MODIFY `id` int(30) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `found`
--
ALTER TABLE `found`
MODIFY `id` int(100) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `lost`
--
ALTER TABLE `lost`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `message`
--
ALTER TABLE `message`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;