First prototype
Change-Id: Ieceb55636bda133466609471f25508d0ae83c52c
diff --git a/schema/common.sql b/schema/common.sql
new file mode 100644
index 0000000..c74d7e5
--- /dev/null
+++ b/schema/common.sql
@@ -0,0 +1,8 @@
+CREATE TABLE Feature (
+ feat_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
+ codename VARCHAR(80) NOT NULL,
+ feat_type SMALLINT NOT NULL,
+
+ PRIMARY KEY (feat_id),
+ UNIQUE KEY (codename)
+);
diff --git a/schema/kill-switch.sql b/schema/kill-switch.sql
new file mode 100644
index 0000000..91b3e39
--- /dev/null
+++ b/schema/kill-switch.sql
@@ -0,0 +1,36 @@
+CREATE TABLE KillSwitch (
+ kswitch_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
+ feat_id SMALLINT UNSIGNED NOT NULL,
+ min_version VARCHAR(50),
+ max_version VARCHAR(50),
+ active BOOLEAN NOT NULL,
+
+ PRIMARY KEY (kswitch_id),
+ KEY (feat_id)
+);
+
+CREATE TABLE KillSwitch2Browser (
+ kswitch_id SMALLINT UNSIGNED NOT NULL,
+ browser SMALLINT UNSIGNED NOT NULL,
+
+ PRIMARY KEY (kswitch_id, browser),
+ KEY (kswitch_id)
+);
+
+CREATE TABLE KillSwitchAuthorizedUser (
+ user_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
+ google_uid VARCHAR(64),
+ email VARCHAR(255),
+ access_level SMALLINT NOT NULL,
+
+ PRIMARY KEY (user_id),
+ KEY (google_uid),
+ KEY (email)
+);
+
+CREATE TABLE KillSwitchAuditLog (
+ log_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
+ data BLOB,
+
+ PRIMARY KEY (log_id)
+);