FVrZ2G24

1"SELECT * FROM postagens WHERE id='$p_id' AND u_id='$u_id';";
2	
3CREATE DATABASE IF NOT EXISTS social
4DEFAULT CHARACTER SET utf8
5DEFAULT COLLATE utf8_general_ci;
6USE social;
7CREATE TABLE IF NOT EXISTS usuarios(
8    id INT NOT NULL AUTO_INCREMENT,
9    nome VARCHAR(24) NOT NULL,
10    sobrenome VARCHAR(64) NOT NULL,
11    email VARCHAR(50) NOT NULL UNIQUE,
12    senha VARCHAR(16) NOT NULL,
13    sexo enum('M','F'),
14    perfil VARCHAR(512) NOT NULL,
15    capa VARCHAR(512) NOT NULL,
16    recado VARCHAR(256) NOT NULL,
17    CONSTRAINT u_id_pk PRIMARY KEY(id)
18) DEFAULT CHARSET=utf8;
19
20CREATE TABLE IF NOT EXISTS postagens(
21    id INT NOT NULL AUTO_INCREMENT,
22    u_id INT,
23    titulo VARCHAR(128) NOT NULL,
24    conteudo VARCHAR(4096),
25    imagem VARCHAR(256),
26    video VARCHAR(256),
27    audio VARCHAR(256),
28    CONSTRAINT id_pk PRIMARY KEY(id),
29    CONSTRAINT u_id_fk FOREIGN KEY(u_id) REFERENCES postagens(id)
30) DEFAULT CHARSET=utf8;