Rename DB field identifiers.status to identifiers.active

[coffee/coffee-flask.git] / coffee_db.sql

diff --git a/coffee_db.sql b/coffee_db.sql
index c7c88d1ce29e599f401213691e87457f01f4ac68..5c65d11245b05469d8943899fba4b48bdc7fb2cc 100644 (file)
--- a/coffee_db.sql
+++ b/coffee_db.sql
@@ -40,6 +40,6 @@ CREATE TABLE if not exists identifiers (
     `userid` varchar ( 24 ) NOT NULL,
     `id` varchar ( 24 ) PRIMARY KEY NOT NULL,
     `name` varchar ( 24 ),
-    `status` INTEGER NOT NULL DEFAULT 1,
+    `active` INTEGER NOT NULL DEFAULT 1,
     FOREIGN KEY(`userid`) REFERENCES `users`(`id`)
 );