[sql] instagram_clone

Viewer

copydownloadembedprintName: instagram_clone
  1. CREATE DATABASE instagram_clone;
  2.  
  3. USE instagram_clone;
  4.  
  5. CREATE TABLE posts (
  6.     id INT AUTO_INCREMENT PRIMARY KEY,
  7.     username VARCHAR(255) NOT NULL,
  8.     image VARCHAR(255) NOT NULL,
  9.     caption TEXT,
  10.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  11. );
  12.  

Editor

You can edit this paste and save as new:


File Description
  • instagram_clone
  • Paste Code
  • 30 Jun-2024
  • 268 Bytes
You can Share it: