Advertisement
Guest User

fake1025

a guest
Dec 3rd, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 8.72 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: 23-Nov-2016 às 18:14
  7. -- Versão do servidor: 10.1.13-MariaDB
  8. -- PHP Version: 5.6.23
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET 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 utf8mb4 */;
  18.  
  19. --
  20. -- Database: `facefake`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Estrutura da tabela `amizade`
  27. --
  28.  
  29. CREATE TABLE `amizade` (
  30.   `usuario_usuarioCodigo` bigint(20) NOT NULL,
  31.   `usuario_usuarioCodigoAmigo` bigint(20) NOT NULL
  32. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  33.  
  34. --
  35. -- Extraindo dados da tabela `amizade`
  36. --
  37.  
  38. INSERT INTO `amizade` (`usuario_usuarioCodigo`, `usuario_usuarioCodigoAmigo`) VALUES
  39. (1, 1),
  40. (1, 2),
  41. (1, 3),
  42. (2, 1),
  43. (2, 2),
  44. (2, 3),
  45. (3, 1),
  46. (3, 2),
  47. (3, 3),
  48. (4, 1),
  49. (4, 2),
  50. (4, 3),
  51. (5, 1),
  52. (5, 2),
  53. (5, 3),
  54. (6, 1),
  55. (6, 2),
  56. (6, 3);
  57.  
  58. -- --------------------------------------------------------
  59.  
  60. --
  61. -- Estrutura da tabela `comentario_post`
  62. --
  63.  
  64. CREATE TABLE `comentario_post` (
  65.   `comentario_postCodigo` bigint(20) NOT NULL,
  66.   `comentario_postTexto` text,
  67.   `usuario_usuarioCodigo` bigint(20) NOT NULL,
  68.   `post_postCodigo` bigint(20) NOT NULL
  69. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  70.  
  71. --
  72. -- Extraindo dados da tabela `comentario_post`
  73. --
  74.  
  75. INSERT INTO `comentario_post` (`comentario_postCodigo`, `comentario_postTexto`, `usuario_usuarioCodigo`, `post_postCodigo`) VALUES
  76. (1, 'FELIZ ANIVERSARIO', 1, 1),
  77. (2, 'PARABENS', 1, 1),
  78. (3, 'BOM DIA', 1, 1),
  79. (4, 'FELIZ ANIVERSARIO', 1, 2),
  80. (5, 'PARABENS', 1, 2),
  81. (6, 'BOM DIA', 1, 2),
  82. (7, 'FELIZ ANIVERSARIO', 1, 3),
  83. (8, 'PARABENS', 1, 3),
  84. (9, 'BOM DIA', 1, 3),
  85. (10, 'FELIZ ANIVERSARIO', 2, 4),
  86. (11, 'PARABENS', 2, 4),
  87. (12, 'BOM DIA', 2, 4),
  88. (13, 'FELIZ ANIVERSARIO', 2, 5),
  89. (14, 'PARABENS', 2, 5),
  90. (15, 'BOM DIA', 2, 5),
  91. (16, 'FELIZ ANIVERSARIO', 2, 6),
  92. (17, 'PARABENS', 2, 6),
  93. (18, 'BOM DIA', 2, 6),
  94. (19, 'FELIZ ANIVERSARIO', 3, 7),
  95. (20, 'PARABENS', 3, 7),
  96. (21, 'BOM DIA', 3, 7),
  97. (22, 'FELIZ ANIVERSARIO', 3, 8),
  98. (23, 'PARABENS', 3, 8),
  99. (24, 'BOM DIA', 3, 8),
  100. (25, 'FELIZ ANIVERSARIO', 3, 9),
  101. (26, 'PARABENS', 3, 9),
  102. (27, 'BOM DIA', 3, 9),
  103. (28, 'FELIZ ANIVERSARIO', 4, 10),
  104. (29, 'PARABENS', 4, 10),
  105. (30, 'BOM DIA', 4, 10),
  106. (31, 'FELIZ ANIVERSARIO', 4, 11),
  107. (32, 'PARABENS', 4, 11),
  108. (33, 'BOM DIA', 4, 11),
  109. (34, 'FELIZ ANIVERSARIO', 4, 12),
  110. (35, 'PARABENS', 4, 12),
  111. (36, 'BOM DIA', 4, 12),
  112. (37, 'FELIZ ANIVERSARIO', 5, 13),
  113. (38, 'PARABENS', 5, 13),
  114. (39, 'BOM DIA', 5, 13),
  115. (40, 'FELIZ ANIVERSARIO', 5, 14),
  116. (41, 'PARABENS', 5, 14),
  117. (42, 'BOM DIA', 5, 14),
  118. (43, 'FELIZ ANIVERSARIO', 5, 15),
  119. (44, 'PARABENS', 5, 15),
  120. (45, 'BOM DIA', 5, 15),
  121. (46, 'FELIZ ANIVERSARIO', 6, 16),
  122. (47, 'PARABENS', 6, 16),
  123. (48, 'BOM DIA', 6, 16),
  124. (49, 'FELIZ ANIVERSARIO', 6, 17),
  125. (50, 'PARABENS', 6, 17),
  126. (51, 'BOM DIA', 6, 17),
  127. (52, 'FELIZ ANIVERSARIO', 6, 18),
  128. (53, 'PARABENS', 6, 18),
  129. (54, 'BOM DIA', 6, 18);
  130.  
  131. -- --------------------------------------------------------
  132.  
  133. --
  134. -- Estrutura da tabela `curtidas_post`
  135. --
  136.  
  137. CREATE TABLE `curtidas_post` (
  138.   `curtidas_postCodigo` bigint(20) NOT NULL,
  139.   `curtidas_postTipo` varchar(10) NOT NULL,
  140.   `usuario_usuarioCodigo` bigint(20) NOT NULL,
  141.   `post_postCodigo` bigint(20) NOT NULL
  142. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  143.  
  144. --
  145. -- Extraindo dados da tabela `curtidas_post`
  146. --
  147.  
  148. INSERT INTO `curtidas_post` (`curtidas_postCodigo`, `curtidas_postTipo`, `usuario_usuarioCodigo`, `post_postCodigo`) VALUES
  149. (1, 'JOINHA', 1, 1),
  150. (2, 'JOINHA', 1, 1),
  151. (3, 'JOINHA', 1, 2),
  152. (4, 'JOINHA', 1, 2),
  153. (5, 'JOINHA', 1, 3),
  154. (6, 'JOINHA', 1, 3),
  155. (7, 'JOINHA', 2, 4),
  156. (8, 'JOINHA', 2, 4),
  157. (9, 'JOINHA', 2, 5),
  158. (10, 'JOINHA', 2, 5),
  159. (11, 'JOINHA', 2, 6),
  160. (12, 'JOINHA', 2, 6),
  161. (13, 'JOINHA', 3, 7),
  162. (14, 'JOINHA', 3, 7),
  163. (15, 'JOINHA', 3, 8),
  164. (16, 'JOINHA', 3, 8),
  165. (17, 'JOINHA', 3, 9),
  166. (18, 'JOINHA', 3, 9),
  167. (19, 'JOINHA', 4, 10),
  168. (20, 'JOINHA', 4, 10),
  169. (21, 'JOINHA', 4, 11),
  170. (22, 'JOINHA', 4, 11),
  171. (23, 'JOINHA', 4, 12),
  172. (24, 'JOINHA', 4, 12),
  173. (25, 'JOINHA', 5, 13),
  174. (26, 'JOINHA', 5, 13),
  175. (27, 'JOINHA', 5, 14),
  176. (28, 'JOINHA', 5, 14),
  177. (29, 'JOINHA', 5, 15),
  178. (30, 'JOINHA', 5, 15),
  179. (31, 'JOINHA', 6, 16),
  180. (32, 'JOINHA', 6, 16),
  181. (33, 'JOINHA', 6, 17),
  182. (34, 'JOINHA', 6, 17),
  183. (35, 'JOINHA', 6, 18),
  184. (36, 'JOINHA', 6, 18);
  185.  
  186. -- --------------------------------------------------------
  187.  
  188. --
  189. -- Estrutura da tabela `post`
  190. --
  191.  
  192. CREATE TABLE `post` (
  193.   `postCodigo` bigint(20) NOT NULL,
  194.   `postTexto` text,
  195.   `postaDataHora` datetime DEFAULT NULL,
  196.   `usuario_usuarioCodigo` bigint(20) NOT NULL
  197. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  198.  
  199. --
  200. -- Extraindo dados da tabela `post`
  201. --
  202.  
  203. INSERT INTO `post` (`postCodigo`, `postTexto`, `postaDataHora`, `usuario_usuarioCodigo`) VALUES
  204. (1, 'BEM VINDO', '2016-11-23 09:00:00', 1),
  205. (2, 'BOA NOITE', '2016-11-25 19:00:00', 1),
  206. (3, 'BOM DIA', '2016-11-29 07:00:00', 1),
  207. (4, 'BEM VINDO', '2016-11-23 09:00:00', 2),
  208. (5, 'BOA NOITE', '2016-11-25 19:00:00', 2),
  209. (6, 'BOM DIA', '2016-11-29 07:00:00', 2),
  210. (7, 'BEM VINDO', '2016-11-23 09:00:00', 3),
  211. (8, 'BOA NOITE', '2016-11-25 19:00:00', 3),
  212. (9, 'BOM DIA', '2016-11-29 07:00:00', 3),
  213. (10, 'BEM VINDO', '2016-11-23 09:00:00', 4),
  214. (11, 'BOA NOITE', '2016-11-25 19:00:00', 4),
  215. (12, 'BOM DIA', '2016-11-29 07:00:00', 4),
  216. (13, 'BEM VINDO', '2016-11-23 09:00:00', 5),
  217. (14, 'BOA NOITE', '2016-11-25 19:00:00', 5),
  218. (15, 'BOM DIA', '2016-11-29 07:00:00', 5),
  219. (16, 'BEM VINDO', '2016-11-23 09:00:00', 6),
  220. (17, 'BOA NOITE', '2016-11-25 19:00:00', 6),
  221. (18, 'BOM DIA', '2016-11-29 07:00:00', 6);
  222.  
  223. -- --------------------------------------------------------
  224.  
  225. --
  226. -- Estrutura da tabela `post_imagens`
  227. --
  228.  
  229. CREATE TABLE `post_imagens` (
  230.   `post_imagensCodigo` bigint(20) NOT NULL,
  231.   `post_imagens_Caminho` varchar(200) DEFAULT NULL,
  232.   `post_postCodigo` bigint(20) NOT NULL
  233. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  234.  
  235. --
  236. -- Extraindo dados da tabela `post_imagens`
  237. --
  238.  
  239. INSERT INTO `post_imagens` (`post_imagensCodigo`, `post_imagens_Caminho`, `post_postCodigo`) VALUES
  240. (1, 'ANIVESARIO.PNG', 1),
  241. (2, 'DIA.PNG', 1),
  242. (3, 'NOITE.PNG', 1),
  243. (4, 'ANIVESARIO.PNG', 2),
  244. (5, 'DIA.PNG', 2),
  245. (6, 'NOITE.PNG', 2),
  246. (7, 'ANIVESARIO.PNG', 3),
  247. (8, 'DIA.PNG', 3),
  248. (9, 'NOITE.PNG', 3);
  249.  
  250. -- --------------------------------------------------------
  251.  
  252. --
  253. -- Estrutura da tabela `usuario`
  254. --
  255.  
  256. CREATE TABLE `usuario` (
  257.   `usuarioCodigo` bigint(20) NOT NULL,
  258.   `usuarioLogin` varchar(100) NOT NULL,
  259.   `usuarioSenha` varchar(100) DEFAULT NULL,
  260.   `usuarioNome` varchar(100) DEFAULT NULL,
  261.   `usuarioFotoCaminho` varchar(200) DEFAULT NULL
  262. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  263.  
  264. --
  265. -- Extraindo dados da tabela `usuario`
  266. --
  267.  
  268. INSERT INTO `usuario` (`usuarioCodigo`, `usuarioLogin`, `usuarioSenha`, `usuarioNome`, `usuarioFotoCaminho`) VALUES
  269. (1, 'JOAO@HOTMAIL.COM', '236547', 'JOAO', 'JOAO.PNG'),
  270. (2, 'PEDRO@HOTMAIL.COM', '35698270', 'PEDRO', 'PEDRO.PNG'),
  271. (3, 'MARIA@HOTMAIL.COM', '45289673', 'MARIA', 'MARIA.PNG'),
  272. (4, 'JOSE@HOTMAIL.COM', '89563142', 'JOSE', 'JOSE.PNG'),
  273. (5, 'TIAGO@HOTMAIL.COM', '10236582', 'TIAGO', 'TIAGO.PNG'),
  274. (6, 'PAULO@HOTMAIL.COM', '22365471', 'PAULO', 'PAULO.PNG');
  275.  
  276. --
  277. -- Indexes for dumped tables
  278. --
  279.  
  280. --
  281. -- Indexes for table `amizade`
  282. --
  283. ALTER TABLE `amizade`
  284.   ADD PRIMARY KEY (`usuario_usuarioCodigo`,`usuario_usuarioCodigoAmigo`),
  285.   ADD KEY `fk_usuario_has_usuario_usuario2_idx` (`usuario_usuarioCodigoAmigo`),
  286.   ADD KEY `fk_usuario_has_usuario_usuario1_idx` (`usuario_usuarioCodigo`);
  287.  
  288. --
  289. -- Indexes for table `comentario_post`
  290. --
  291. ALTER TABLE `comentario_post`
  292.   ADD PRIMARY KEY (`comentario_postCodigo`),
  293.   ADD KEY `fk_comentario_post_usuario1_idx` (`usuario_usuarioCodigo`),
  294.   ADD KEY `fk_comentario_post_post1_idx` (`post_postCodigo`);
  295.  
  296. --
  297. -- Indexes for table `curtidas_post`
  298. --
  299. ALTER TABLE `curtidas_post`
  300.   ADD PRIMARY KEY (`curtidas_postCodigo`),
  301.   ADD KEY `fk_curtidas_post_usuario1_idx` (`usuario_usuarioCodigo`),
  302.   ADD KEY `fk_curtidas_post_post1_idx` (`post_postCodigo`);
  303.  
  304. --
  305. -- Indexes for table `post`
  306. --
  307. ALTER TABLE `post`
  308.   ADD PRIMARY KEY (`postCodigo`),
  309.   ADD KEY `fk_post_usuario_idx` (`usuario_usuarioCodigo`);
  310.  
  311. --
  312. -- Indexes for table `post_imagens`
  313. --
  314. ALTER TABLE `post_imagens`
  315.   ADD PRIMARY KEY (`post_imagensCodigo`),
  316.   ADD KEY `fk_post_imagens_post1_idx` (`post_postCodigo`);
  317.  
  318. --
  319. -- Indexes for table `usuario`
  320. --
  321. ALTER TABLE `usuario`
  322.   ADD PRIMARY KEY (`usuarioCodigo`);
  323.  
  324. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  325. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  326. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement