dkforest

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

98.sql (342B)


      1 -- +migrate Up
      2 CREATE TABLE IF NOT EXISTS snippets (
      3     name VARCHAR(20) NOT NULL,
      4     user_id INTEGER NOT NULL,
      5     text TEXT NOT NULL,
      6     PRIMARY KEY (user_id, name),
      7     CONSTRAINT snippets_user_id_fk
      8     FOREIGN KEY (user_id)
      9         REFERENCES users (id)
     10             ON DELETE CASCADE
     11             ON UPDATE CASCADE);
     12 
     13 -- +migrate Down