33 lines (33 with data), 32.8 kB

SQLite format 3@  
.ß
ľi×╩c]
ůwié==
â)tableconversation_associationconversation_associationCREATE TABLE conversation_association (
	conversation_id INTEGER, 
	statement_id INTEGER, 
	FOREIGN KEY(conversation_id) REFERENCES conversation (id), 
	FOREIGN KEY(statement_id) REFERENCES statement (id)
)é
âitableresponseresponseCREATE TABLE response (
	id INTEGER NOT NULL, 
	text VARCHAR, 
	created_at DATETIME DEFAULT CURRENT_TIMESTAMP, 
	occurrence INTEGER, 
	statement_text VARCHAR, 
	PRIMARY KEY (id), 
	FOREIGN KEY(statement_text) REFERENCES statement (text)
)üU++
éatabletag_associationtag_associationCREATE TABLE tag_association (
	tag_id INTEGER, 
	statement_id INTEGER, 
	FOREIGN KEY(tag_id) REFERENCES tag (id), 
	FOREIGN KEY(statement_id) REFERENCES statement (id)
)k%%
ütableconversationconversationCREATE TABLE conversation (
	id INTEGER NOT NULL, 
	PRIMARY KEY (id)
)ü
ü{tablestatementstatementCREATE TABLE statement (
	id INTEGER NOT NULL, 
	text VARCHAR, 
	extra_data BLOB, 
	PRIMARY KEY (id), 
	UNIQUE (text)
)1E
indexsqlite_autoindex_statement_1statement`

ü'tabletagtagCREATE TABLE tag (
	id INTEGER NOT NULL, 
	name VARCHAR, 
	PRIMARY KEY (id)
)