22 lines
616 B
SQL
22 lines
616 B
SQL
-- Your SQL goes here
|
|
|
|
CREATE TABLE providers_records (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
|
service_name TEXT NOT NULL,
|
|
request_time BIGINT UNSIGNED NOT NULL,
|
|
auth_methode TEXT NOT NULL,
|
|
expires_at BIGINT UNSIGNED,
|
|
has_notifyed BOOLEAN DEFAULT FALSE NOT NULL,
|
|
state TEXT NOT NULL,
|
|
awnsered_at BIGINT UNSIGNED,
|
|
awnsered_by TEXT
|
|
);
|
|
|
|
CREATE TABLE beggars_records (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
|
request_time BIGINT UNSIGNED NOT NULL,
|
|
service_name TEXT NOT NULL,
|
|
http_result INTEGER UNSIGNED NOT NULL,
|
|
note TEXT,
|
|
awnsered_by TEXT
|
|
); |