monorepo/dezendorf/applications/golink/golink_database/schema.sql

CREATE TABLE golinks (
  id             BIGINT  NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name           text    NOT NULL UNIQUE,
  target         text    NOT NULL,
  visit_count    BIGINT
);

CREATE TABLE authors (
  id     BIGINT  NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name   text    NOT NULL UNIQUE
);