summaryrefslogtreecommitdiff
path: root/tsp/results-values-result.sql
diff options
context:
space:
mode:
authorAleksander Mistewicz <a.mistewicz@samsung.com>2016-07-22 11:43:26 +0200
committerAleksander Mistewicz <a.mistewicz@samsung.com>2016-11-02 17:17:41 +0100
commita91d1aa1a8b4eb4bbb096d9ab1d9a6b76ac90d70 (patch)
tree1037018ec91fe14eb65606a35a8bcbebde210c65 /tsp/results-values-result.sql
parent92e50d0ae61acb30dc07e60f2dcf0ec6a7e3ac79 (diff)
downloadmajor-a91d1aa1a8b4eb4bbb096d9ab1d9a6b76ac90d70.tar.gz
major-a91d1aa1a8b4eb4bbb096d9ab1d9a6b76ac90d70.tar.bz2
major-a91d1aa1a8b4eb4bbb096d9ab1d9a6b76ac90d70.zip
Add schema and initial values for sqlite3 db
tsp/results-schema.sql contains basic table definitions of device, result, test and "currentstatus" view. Change-Id: I53c5a7e5d744aba07500ef5492c490368692cb44 Signed-off-by: Aleksander Mistewicz <a.mistewicz@samsung.com>
Diffstat (limited to 'tsp/results-values-result.sql')
-rw-r--r--tsp/results-values-result.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/tsp/results-values-result.sql b/tsp/results-values-result.sql
new file mode 100644
index 0000000..d770a39
--- /dev/null
+++ b/tsp/results-values-result.sql
@@ -0,0 +1,5 @@
+INSERT OR IGNORE INTO result VALUES (NULL, "OK");
+INSERT OR IGNORE INTO result VALUES (NULL, "Unclear");
+INSERT OR IGNORE INTO result VALUES (NULL, "Fail");
+INSERT OR IGNORE INTO result VALUES (NULL, "Identical");
+INSERT OR IGNORE INTO result VALUES (NULL, "Snapshot");