Skip to content

Instantly share code, notes, and snippets.

@isocroft
Created October 29, 2025 00:35
Show Gist options
  • Select an option

  • Save isocroft/03eec56bf6db1ca6363b6f1a2b51fc33 to your computer and use it in GitHub Desktop.

Select an option

Save isocroft/03eec56bf6db1ca6363b6f1a2b51fc33 to your computer and use it in GitHub Desktop.
A database schema for a Tinder-clone dating app using either MySQL, SQLite or PostgreSQL as primary database
-- MySQL v8.0.16
-- PostgresSQL v16.9.2
CREATE DATABASE IF NOT EXISTS `test`
DEFAULT CHARACTER SET utf8 -- utf8mb4
DEFAULT COLLATE utf8_general_ci; -- utf8mb4_unicode_ci
SET default_storage_engine = INNODB;
CREATE TABLE ();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment