quote-bot/quote-db.sql
2021-03-12 12:41:17 -05:00

14 lines
646 B
SQL

BEGIN TRANSACTION;
create table if not exists quotedb (date_added text not null, added_by text not null, channel text not null, subject text not null, words text not null)
insert into quotedb (date_added, channel, added_by, subject, words) values (datetime('now'), '#lainchan', 'strike', 'Flisk', "<Flisk> yeah hate when hookers who give free blowjobs won't finger my asshole for free too")
insert into quotedb (date_added, channel, added_by, subject, words) values (datetime('now'), '#lainchan', 'oda', 'nimbius', '* nimbius is no longer thinking about those beans')
select * from quotedb
COMMIT;
--delete from quotedb
--drop table quotedb