dkforest

A forum and chat platform (onion)
git clone https://git.dasho.dev/n0tr1v/dkforest.git
Log | Files | Refs | LICENSE

10.sql (538B)

      1 -- +migrate Up
      2 CREATE TABLE IF NOT EXISTS gists (
      3     id INTEGER NOT NULL PRIMARY KEY,
      4     uuid VARCHAR(100) NOT NULL,
      5     user_id INTEGER NOT NULL,
      6     name VARCHAR(255) NOT NULL,
      7     content TEXT NOT NULL,
      8     password VARCHAR(255) NOT NULL DEFAULT '',
      9     created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
     10     CONSTRAINT user_id_fk
     11         FOREIGN KEY (user_id)
     12             REFERENCES users (id)
     13             ON DELETE CASCADE
     14             ON UPDATE CASCADE);
     15 CREATE UNIQUE INDEX gists_uuid_uniq ON gists (uuid);
     16 
     17 -- +migrate Down