· 9 years ago · Oct 14, 2016, 08:38 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10.14
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Oct 14, 2016 at 08:29 AM
7-- Server version: 5.6.33
8-- PHP Version: 5.6.20
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `smoothup_prince`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `clubs`
27--
28
29CREATE TABLE IF NOT EXISTS `clubs` (
30 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
31 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
32 `addressLogo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;
35
36--
37-- Dumping data for table `clubs`
38--
39
40INSERT INTO `clubs` (`id`, `name`, `addressLogo`) VALUES
41(1, 'ENASTRON', '/uploads/57ffd0ddd1419estate.png'),
42(2, 'KENTRO ATHINON', '/uploads/57ffd14d3fc09kentroathinon_logo_light.png'),
43(3, 'ESTATE', '/uploads/57ffd15f28684estate_logo.png'),
44(4, 'FEVER', '/uploads/57ffd175968cbfever.jpg'),
45(5, 'THEA', '/uploads/57ffd181d4b4dtheaclub.png'),
46(6, 'J''ADORE', '/uploads/57ffd19040b50jadore.jpg'),
47(7, 'MAMOUNIA LIVE', '/uploads/57ffd19d530dcmamounia.png'),
48(8, 'BOUDOIR', '/uploads/57ffd1a850a0eboudoir.jpg');
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `event_dates`
54--
55
56CREATE TABLE IF NOT EXISTS `event_dates` (
57 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
58 `event_date` date NOT NULL,
59 PRIMARY KEY (`id`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ;
61
62--
63-- Dumping data for table `event_dates`
64--
65
66INSERT INTO `event_dates` (`id`, `event_date`) VALUES
67(9, '2016-10-14'),
68(10, '2016-10-15');
69
70-- --------------------------------------------------------
71
72--
73-- Table structure for table `event_images`
74--
75
76CREATE TABLE IF NOT EXISTS `event_images` (
77 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
78 `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
79 `prince_event_id` int(10) unsigned DEFAULT NULL,
80 PRIMARY KEY (`id`),
81 KEY `event_images_prince_event_id_foreign` (`prince_event_id`)
82) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
83
84--
85-- Dumping data for table `event_images`
86--
87
88INSERT INTO `event_images` (`id`, `address`, `prince_event_id`) VALUES
89(3, '/uploads/57ffd4a53591b274_prince.jpg', 3),
90(4, '/uploads/57ffd4e32a6d1274_prince.jpg', 4),
91(5, '/uploads/57ffd59aad169274_prince.jpg', 5),
92(6, '/uploads/57ffd6484deb27974_prince.jpg', 6),
93(7, '/uploads/57ffd688866fb319_prince.jpg', 7),
94(8, '/uploads/57ffd6b096c3c6153_prince.jpg', 8),
95(9, '/uploads/57ffdcaa03a406965_prince.jpg', 9);
96
97-- --------------------------------------------------------
98
99--
100-- Table structure for table `migrations`
101--
102
103CREATE TABLE IF NOT EXISTS `migrations` (
104 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
105 `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
106 `batch` int(11) NOT NULL,
107 PRIMARY KEY (`id`)
108) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `password_resets`
114--
115
116CREATE TABLE IF NOT EXISTS `password_resets` (
117 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
118 `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
119 `created_at` timestamp NULL DEFAULT NULL,
120 KEY `password_resets_email_index` (`email`),
121 KEY `password_resets_token_index` (`token`)
122) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
123
124-- --------------------------------------------------------
125
126--
127-- Table structure for table `prince_events`
128--
129
130CREATE TABLE IF NOT EXISTS `prince_events` (
131 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
132 `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
133 `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
134 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
135 `telephone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
136 `share_count` int(9) NOT NULL DEFAULT '0',
137 `club_id` int(10) unsigned DEFAULT NULL,
138 `event_date_id` int(10) unsigned DEFAULT NULL,
139 `created_at` timestamp NULL DEFAULT NULL,
140 `updated_at` timestamp NULL DEFAULT NULL,
141 PRIMARY KEY (`id`),
142 KEY `prince_events_club_id_foreign` (`club_id`),
143 KEY `prince_events_event_date_id_foreign` (`event_date_id`)
144) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
145
146--
147-- Dumping data for table `prince_events`
148--
149
150INSERT INTO `prince_events` (`id`, `first_name`, `last_name`, `email`, `telephone`, `share_count`, `club_id`, `event_date_id`, `created_at`, `updated_at`) VALUES
151(3, 'oto', 'pweo', 'info@oto.gr', '6940694314', 0, 1, 9, '2016-10-13 18:38:29', '2016-10-13 18:38:29'),
152(4, 'oto', 'pweo', 'info@oto.gr', '6940694314', 0, 1, 9, '2016-10-13 18:39:31', '2016-10-13 18:39:31'),
153(5, 'oto', 'pweo', 'info@oto.gr', '6940694314', 0, 1, 9, '2016-10-13 18:42:35', '2016-10-13 18:42:35'),
154(6, 'ξδξφ', 'ιÏιδ', 'info@oto.ge', '6940694314', 0, 1, 9, '2016-10-13 18:45:29', '2016-10-13 18:45:29'),
155(7, 'ufur', 'hchc', 'hhh@jjj.com', '6954332888', 0, 1, 9, '2016-10-13 18:46:32', '2016-10-13 18:46:32'),
156(8, 'ξδη', 'hdhd', 'uuu@jjj.com', '6940694314', 0, 1, 9, '2016-10-13 18:47:13', '2016-10-13 18:47:13'),
157(9, 'oto', 'pero', 'info@oto.gr', '6940694314', 0, 1, 9, '2016-10-13 19:12:42', '2016-10-13 19:12:42');
158
159-- --------------------------------------------------------
160
161--
162-- Table structure for table `users`
163--
164
165CREATE TABLE IF NOT EXISTS `users` (
166 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
167 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
168 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
169 `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
170 `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
171 `created_at` timestamp NULL DEFAULT NULL,
172 `updated_at` timestamp NULL DEFAULT NULL,
173 PRIMARY KEY (`id`),
174 UNIQUE KEY `users_email_unique` (`email`)
175) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
176
177--
178-- Dumping data for table `users`
179--
180
181INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
182(1, 'prince', 'prince@gmail.com', '$2y$10$oD8Y6W0tL4P/Z5nep3/doOPA7RYacWHjctCmfHsUzzNV3kI8gBfPa', NULL, '2016-10-13 14:18:01', '2016-10-13 14:18:01');
183
184--
185-- Constraints for dumped tables
186--
187
188--
189-- Constraints for table `event_images`
190--
191ALTER TABLE `event_images`
192 ADD CONSTRAINT `event_images_prince_event_id_foreign` FOREIGN KEY (`prince_event_id`) REFERENCES `prince_events` (`id`) ON DELETE CASCADE;
193
194--
195-- Constraints for table `prince_events`
196--
197ALTER TABLE `prince_events`
198 ADD CONSTRAINT `prince_events_club_id_foreign` FOREIGN KEY (`club_id`) REFERENCES `clubs` (`id`),
199 ADD CONSTRAINT `prince_events_event_date_id_foreign` FOREIGN KEY (`event_date_id`) REFERENCES `event_dates` (`id`);
200
201/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
202/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
203/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;