mirror-nourybot/migrations/prod/000001_create_channels_table.up.sql

11 lines
279 B
MySQL
Raw Permalink Normal View History

2022-08-08 23:58:10 +02:00
CREATE TABLE IF NOT EXISTS channels (
id bigserial PRIMARY KEY,
2022-08-09 20:08:32 +02:00
added_at timestamp(0) with time zone NOT NULL DEFAULT NOW(),
login text UNIQUE NOT NULL,
twitchid text NOT NULL
2022-08-10 18:57:50 +02:00
);
INSERT INTO channels (added_at,login,twitchid) VALUES
2024-07-17 22:40:56 +02:00
(NOW(),'nouryxd','31437432');
2022-08-12 02:50:57 +02:00