quote-bot/script2.sql
2021-03-08 23:16:14 -05:00

10 lines
657 B
SQL

create table if not exists quotedb (quote_id integer primary key autoincrement, 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
delete from quotedb
drop table quotedb