YYCsRJes

1-- phpMyAdmin SQL Dump
2-- version 4.8.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: mysql
6-- Generation Time: Jun 20, 2019 at 02:20 PM
7-- Server version: 10.3.4-MariaDB
8-- PHP Version: 7.2.15
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: `payetonpote`
23--
24CREATE DATABASE IF NOT EXISTS `payetonpote` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
25USE `payetonpote`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `campaign`
31--
32
33CREATE TABLE `campaign` (
34  `id` varchar(32) NOT NULL,
35  `title` varchar(150) DEFAULT NULL,
36  `content` text DEFAULT NULL,
37  `created_at` timestamp NULL DEFAULT NULL,
38  `updated_at` timestamp NULL DEFAULT NULL,
39  `goal` int(11) DEFAULT NULL,
40  `name` varchar(150) DEFAULT NULL
41) ENGINE=InnoDB DEFAULT CHARSET=utf8;
42
43-- --------------------------------------------------------
44
45--
46-- Table structure for table `participant`
47--
48
49CREATE TABLE `participant` (
50  `id` int(11) NOT NULL,
51  `name` varchar(200) DEFAULT NULL,
52  `email` varchar(200) DEFAULT NULL,
53  `campaign_id` varchar(32) NOT NULL
54) ENGINE=InnoDB DEFAULT CHARSET=utf8;
55
56-- --------------------------------------------------------
57
58--
59-- Table structure for table `payment`
60--
61
62CREATE TABLE `payment` (
63  `id` int(11) NOT NULL,
64  `amount` int(11) DEFAULT NULL,
65  `created_at` timestamp NULL DEFAULT NULL,
66  `updated_at` timestamp NULL DEFAULT NULL,
67  `participant_id` int(11) NOT NULL
68) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69
70--
71-- Indexes for dumped tables
72--
73
74--
75-- Indexes for table `campaign`
76--
77ALTER TABLE `campaign`
78  ADD PRIMARY KEY (`id`),
79  
80
81--
82-- Indexes for table `participant`
83--
84ALTER TABLE `participant`
85  ADD PRIMARY KEY (`id`),
86  ADD KEY `fk_participant_campaign1_idx` (`campaign_id`);
87
88--
89-- Indexes for table `payment`
90--
91ALTER TABLE `payment`
92  ADD PRIMARY KEY (`id`),
93  ADD KEY `fk_payment_participant1_idx` (`participant_id`);
94
95--
96-- AUTO_INCREMENT for dumped tables
97--
98
99--
100-- AUTO_INCREMENT for table `participant`
101--
102ALTER TABLE `participant`
103  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
104
105--
106-- AUTO_INCREMENT for table `payment`
107--
108ALTER TABLE `payment`
109  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
110
111--
112-- Constraints for dumped tables
113--
114
115--
116-- Constraints for table `participant`
117--
118ALTER TABLE `participant`
119  ADD CONSTRAINT `fk_participant_campaign1_idx` FOREIGN KEY (`campaign_id`) REFERENCES `campaign` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
120
121--
122-- Constraints for table `payment`
123--
124ALTER TABLE `payment`
125  ADD CONSTRAINT `fk_payment_participant1` FOREIGN KEY (`participant_id`) REFERENCES `participant` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
126COMMIT;
127
128/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
129/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
130/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;