yMa353qL

1-- phpMyAdmin SQL Dump
2-- version 4.7.7
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Apr 26, 2018 at 09:58 AM
7-- Server version: 10.1.30-MariaDB
8-- PHP Version: 7.1.14
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `people_activity`
23--
24CREATE DATABASE IF NOT EXISTS `people_activity` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `people_activity`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `activity`
31--
32
33DROP TABLE IF EXISTS `activity`;
34CREATE TABLE `activity` (
35  `id` int(10) UNSIGNED NOT NULL,
36  `person_id` int(10) UNSIGNED NOT NULL,
37  `steps_count` int(10) UNSIGNED NOT NULL,
38  `date` date NOT NULL,
39  `weight` tinyint(3) UNSIGNED NOT NULL
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `persons`
46--
47
48DROP TABLE IF EXISTS `persons`;
49CREATE TABLE `persons` (
50  `id` int(10) UNSIGNED NOT NULL,
51  `name` varchar(100) NOT NULL,
52  `dob` date NOT NULL,
53  `sex` varchar(1) NOT NULL
54) ENGINE=InnoDB DEFAULT CHARSET=latin1;
55
56--
57-- Indexes for dumped tables
58--
59
60--
61-- Indexes for table `activity`
62--
63ALTER TABLE `activity`
64  ADD PRIMARY KEY (`id`),
65  ADD KEY `person_id` (`person_id`);
66
67--
68-- Indexes for table `persons`
69--
70ALTER TABLE `persons`
71  ADD PRIMARY KEY (`id`);
72
73--
74-- AUTO_INCREMENT for dumped tables
75--
76
77--
78-- AUTO_INCREMENT for table `activity`
79--
80ALTER TABLE `activity`
81  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
82
83--
84-- AUTO_INCREMENT for table `persons`
85--
86ALTER TABLE `persons`
87  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
88COMMIT;
89
90/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
91/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
92/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;