Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.6.4
- -- https://www.phpmyadmin.net/
- --
- -- Host: localhost:8889
- -- Generation Time: May 24, 2017 at 03:34 PM
- -- Server version: 5.6.33
- -- PHP Version: 7.0.12
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Database: `DebtAware`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `debts`
- --
- CREATE TABLE `debts` (
- `debt_id` int(11) NOT NULL,
- `loaner_id` int(11) NOT NULL,
- `cost` float NOT NULL,
- `event_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `debts`
- --
- INSERT INTO `debts` (`debt_id`, `loaner_id`, `cost`, `event_id`) VALUES
- (21, 39, 11, 49),
- (22, 38, 3, 49),
- (23, 38, 11.3, 49),
- (24, 38, 14.34, 49),
- (25, 38, 7, 49),
- (26, 38, 11, 50),
- (27, 39, 7, 50),
- (28, 40, 9, 50),
- (29, 40, 1, 50),
- (30, 39, 13, 50);
- -- --------------------------------------------------------
- --
- -- Table structure for table `events`
- --
- CREATE TABLE `events` (
- `event_id` int(11) NOT NULL,
- `eventname` varchar(400) NOT NULL,
- `description` mediumtext NOT NULL,
- `longt` float NOT NULL,
- `latt` float NOT NULL,
- `creator_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `events`
- --
- INSERT INTO `events` (`event_id`, `eventname`, `description`, `longt`, `latt`, `creator_id`) VALUES
- (49, 'test', 'zz', 32, 23, 0),
- (50, 'test2', 'hallo', 32, 23, 0),
- (51, 'hallo', '', 32, 23, 0),
- (52, '', '', 32, 23, 0),
- (53, '', '', 32, 23, 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `Relationships`
- --
- CREATE TABLE `Relationships` (
- `person1` int(11) NOT NULL,
- `person2` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `Relationships`
- --
- INSERT INTO `Relationships` (`person1`, `person2`) VALUES
- (39, 38),
- (40, 38),
- (40, 39);
- -- --------------------------------------------------------
- --
- -- Table structure for table `userevents`
- --
- CREATE TABLE `userevents` (
- `event_id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `userevents`
- --
- INSERT INTO `userevents` (`event_id`, `user_id`) VALUES
- (48, 38),
- (49, 38),
- (49, 39),
- (50, 38),
- (50, 39),
- (50, 40),
- (51, 38),
- (51, 40),
- (52, 40),
- (53, 38);
- -- --------------------------------------------------------
- --
- -- Table structure for table `users`
- --
- CREATE TABLE `users` (
- `user_id` int(11) NOT NULL,
- `email` varchar(60) NOT NULL,
- `name` varchar(40) NOT NULL,
- `password` varchar(150) NOT NULL,
- `ccnumber` varchar(14) NOT NULL DEFAULT '',
- `active` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `users`
- --
- INSERT INTO `users` (`user_id`, `email`, `name`, `password`, `ccnumber`, `active`) VALUES
- (38, 'jorrevynckier@hotmail.com', 'jorre vynckier', '$2y$10$cGVrxxdL6WFbeyrj77imAOUxulKGorAWuRRHVGcpNf27zfzs7R4Ue', 'BE32', NULL),
- (39, 'laurensdierickx', 'laurens dierickx', '$2y$10$Irf8Y0HrvYUUqF6BaNIVSe2iL2nBKe7wXyICwd4zdDt6XcU/KstoC', 'BE32', NULL),
- (40, 'kyara', 'kyara dewyse', '$2y$10$0nuC2y0Hxmo2O8jFsJcbCeDsPq342K9G3CZLXa4f4VYQjK3UGsx1e', 'zz', NULL);
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `debts`
- --
- ALTER TABLE `debts`
- ADD PRIMARY KEY (`debt_id`);
- --
- -- Indexes for table `events`
- --
- ALTER TABLE `events`
- ADD PRIMARY KEY (`event_id`);
- --
- -- Indexes for table `userevents`
- --
- ALTER TABLE `userevents`
- ADD PRIMARY KEY (`event_id`,`user_id`);
- --
- -- Indexes for table `users`
- --
- ALTER TABLE `users`
- ADD PRIMARY KEY (`user_id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `debts`
- --
- ALTER TABLE `debts`
- MODIFY `debt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
- --
- -- AUTO_INCREMENT for table `events`
- --
- ALTER TABLE `events`
- MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;
- --
- -- AUTO_INCREMENT for table `users`
- --
- ALTER TABLE `users`
- MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement