-- MySQL dump 10.12
--
-- Host: localhost Database:
-- ------------------------------------------------------
-- Server version 5.1.16-beta-community-nt-log
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `webeng`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `webeng` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `webeng`;
--
-- Table structure for table `tasks`
--
DROP TABLE IF EXISTS `tasks`;
CREATE TABLE `tasks` (
`taskID` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`deadline` datetime NOT NULL,
`created` datetime NOT NULL,
`data` longtext NOT NULL,
`username` varchar(100) NOT NULL,
PRIMARY KEY (`taskID`),
KEY `FK_tasks_1` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=110 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tasks`
--
LOCK TABLES `tasks` WRITE;
/*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
INSERT INTO `tasks` VALUES (109,'','2007-06-08 00:00:00','2007-06-05 18:04:18','0dsyfddsfpendingCrazy Men Can Make You Do Crazy Thingshttp://www.amazon.com/gp/redirect.html?ASIN=1599713624&tag=ws&lcode=sp1&cID=2025&ccmID=165953&location=/o/ASIN/1599713624%3FSubscriptionId=1N6WVQ1WTVVF17PQSKG2','heiri'),(107,'MTI is fun!','2007-05-04 00:00:00','2007-05-26 10:52:14','0teststcompleted1998 IEEE International Symposium on Information Theoryhttp://www.amazon.com/gp/redirect.html?ASIN=0780350006----------------tag=ws----------------lcode=sp1----------------cID=2025----------------ccmID=165953----------------location=/o/ASIN/0780350006%3FSubscriptionId=1N6WVQ1WTVVF17PQSKG2','heiri'),(106,'sleep','2007-06-08 00:00:00','2007-05-26 10:45:48','0dfdadf completedCrazy Men Can Make You Do Crazy Thingshttp://www.amazon.com/gp/redirect.html?ASIN=1599713624&tag=ws&lcode=sp1&cID=2025&ccmID=165953&location=/o/ASIN/1599713624%3FSubscriptionId=1N6WVQ1WTVVF17PQSKG2','heiri'),(108,'good moooooooorning','2007-06-06 00:00:00','2007-06-05 13:28:16','2sleeeeep, sleeep, sleeppendingUp to Speed with Swinghttp://www.amazon.com/gp/redirect.html?ASIN=1884777759&tag=ws&lcode=sp1&cID=2025&ccmID=165953&location=/o/ASIN/1884777759%3FSubscriptionId=1N6WVQ1WTVVF17PQSKG2','zindeld'),(104,'test','2007-05-02 00:00:00','2007-05-26 10:33:02','0adfafdasfdadfafdafaf acompletedCrazy Men Can Make You Do Crazy Thingshttp://www.amazon.com/gp/redirect.html?ASIN=1599713624&tag=ws&lcode=sp1&cID=2025&ccmID=165953&location=/o/ASIN/1599713624%3FSubscriptionId=1N6WVQ1WTVVF17PQSKG2','zindeld'),(102,'webtech','2007-06-13 00:00:00','2007-05-22 15:25:09','2i wanna sleep and eat at the same timecompletedHousing the Poorhttp://www.amazon.com/gp/redirect.html?ASIN=B000GR9JFE&tag=ws&lcode=sp1&cID=2025&ccmID=165953&location=/o/ASIN/B000GR9JFE%3FSubscriptionId=1N6WVQ1WTVVF17PQSKG2','zindeld'),(100,'test','2007-05-25 00:00:00','2007-05-22 15:16:36','2good morning. time to get up.pendingUp to Speed with Swinghttp://www.amazon.com/gp/redirect.html?ASIN=1884777759&tag=ws&lcode=sp1&cID=2025&ccmID=165953&location=/o/ASIN/1884777759%3FSubscriptionId=1N6WVQ1WTVVF17PQSKG2','micheal'),(105,'todo','2007-04-30 00:00:00','2007-05-26 10:37:29','1sssecompletedL\'info, c\'est rigolohttp://www.amazon.com/gp/redirect.html?ASIN=2020200090&tag=ws&lcode=sp1&cID=2025&ccmID=165953&location=/o/ASIN/2020200090%3FSubscriptionId=1N6WVQ1WTVVF17PQSKG2','micheal');
/*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`username` varchar(100) NOT NULL,
`firstname` varchar(100) NOT NULL,
`lastname` varchar(100) NOT NULL,
`email` varchar(250) NOT NULL,
`password` varchar(100) NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('zindeld','Dominik','Zindel','dominik@zindel.org','1234'),('micheal','Micheal','El-Betjali','bill.gates@microsoft.com','4567'),('heiri','Heiri','Müller','heiri@mueller.ch','heidiho');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2007-06-14 13:17:04