sopeldbexample

CREATE TABLE channel_values (channel STRING, key STRING, value STRING, PRIMARY KEY (channel, key))
CREATE TABLE nick_ids (nick_id INTEGER PRIMARY KEY AUTOINCREMENT)
CREATE TABLE nick_values (nick_id INTEGER REFERENCES nick_ids(nick_id), key STRING, value STRING, PRIMARY KEY (nick_id, key))
CREATE TABLE nicknames (nick_id INTEGER REFERENCES nick_ids, slug STRING PRIMARY KEY, canonical string)
CREATE TABLE plugin_values (
	plugin VARCHAR(255) NOT NULL, 
	"key" VARCHAR(255) NOT NULL, 
	value VARCHAR(255), 
	PRIMARY KEY (plugin, "key")
)


-- DUMB DATA -
INSERT INTO "main"."nick_ids" ("nick_id") VALUES ('567');
INSERT INTO "main"."nick_ids" ("nick_id") VALUES ('589');
INSERT INTO "main"."nick_ids" ("nick_id") VALUES ('658');
INSERT INTO "main"."nick_ids" ("nick_id") VALUES ('716');
INSERT INTO "main"."nicknames" ("nick_id", "slug", "canonical") VALUES ('567', 'guest39235', 'Guest39235');
INSERT INTO "main"."nicknames" ("nick_id", "slug", "canonical") VALUES ('589', 'guest37874', 'Guest37874');
INSERT INTO "main"."nicknames" ("nick_id", "slug", "canonical") VALUES ('658', 'guest23567', 'Guest23567');
INSERT INTO "main"."nicknames" ("nick_id", "slug", "canonical") VALUES ('716', 'guest30887', 'Guest30887');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('567', 'seen_timestamp', '1548439009.22378');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('567', 'seen_channel', '"#miraheze"');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('567', 'seen_message', '"Ok have widgets "');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('567', 'seen_action', 'false');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('589', 'seen_timestamp', '1551643427.91905');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('589', 'seen_channel', '"#miraheze"');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('589', 'seen_message', '"how do i change my name back?"');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('589', 'seen_action', 'false');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('658', 'seen_timestamp', '1558304565.61539');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('658', 'seen_channel', '"#miraheze"');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('658', 'seen_message', '"What is my password"');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('658', 'seen_action', 'false');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('716', 'seen_timestamp', '1564689531.06261');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('716', 'seen_channel', '"#miraheze"');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('716', 'seen_message', '"No problem, thank you for your help!"');
INSERT INTO "main"."nick_values" ("nick_id", "key", "value") VALUES ('716', 'seen_action', 'false');