1 files changed, 15 insertions, 0 deletions
diff --git a/java/state.sql b/java/state.sql
new file mode 100644
index 0000000..a59f11f
--- /dev/null
+++ b/java/state.sql
@@ -0,0 +1,15 @@
+-- Assignment status using SQLite
+
+CREATE TABLE `assignments` (
+    `name` text, `code` boolean, `output` boolean, `text` boolean, `shown` boolean
+);
+
+INSERT INTO `assignments` VALUES 
+    ('ArraySearch', true, true, true, true),
+    ('ArraySort', true, true, true, true),
+    ('StringOperations', true, true, true, true),
+    ('MatrixOperations', true, true, true, true);
+
+.mode markdown
+SELECT * FROM `assignments`;
+