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: `burden30`
--
-- --------------------------------------------------------
--
-- Table structure for table `Data`
--
CREATE TABLE `Data` (
`id` smallint(10) NOT NULL AUTO_INCREMENT,
`category` varchar(20) NOT NULL,
`highpriority` tinyint(1) NOT NULL,
`task` varchar(300) NOT NULL,
`details` varchar(300) NOT NULL,
`created` date NOT NULL,
`due` date NOT NULL,
`completed` tinyint(1) NOT NULL DEFAULT '0',
`datecompleted` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `Users`
--
CREATE TABLE `Users` (
`id` smallint(10) NOT NULL AUTO_INCREMENT,
`user` varchar(20) NOT NULL,
`password` varchar(200) NOT NULL,
`salt` varchar(3) NOT NULL,
`email` varchar(100) NOT NULL,
`hash` varchar(200) NOT NULL,
`api_key` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `Users`
--
INSERT INTO `Users` VALUES
(1, '[[admin_username]]', '[[admin_pass]]', '[[salt]]', '[[admin_email]]', '', '[[api_key]]');
/*!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 */;
