summaryrefslogtreecommitdiff
path: root/sql/schema/faredge.sql.example
diff options
context:
space:
mode:
authorckonstanski <kostcarl@isu.edu>2026-07-30 18:17:14 -0600
committerckonstanski <kostcarl@isu.edu>2026-07-30 18:17:14 -0600
commit640ff61422bc0ee3966941b93d9889ddbbd38d77 (patch)
treeabf1c08f5d38ee53ec8b29dc4f425722517505e6 /sql/schema/faredge.sql.example
parent22dae02a86c1fce71091bfa5289cf99abba1b217 (diff)
more filesHEADmaster
Diffstat (limited to 'sql/schema/faredge.sql.example')
-rw-r--r--sql/schema/faredge.sql.example27
1 files changed, 0 insertions, 27 deletions
diff --git a/sql/schema/faredge.sql.example b/sql/schema/faredge.sql.example
index e324d8a..e31606b 100644
--- a/sql/schema/faredge.sql.example
+++ b/sql/schema/faredge.sql.example
@@ -17,30 +17,3 @@ GRANT ALL PRIVILEGES ON faredge.* TO faredge@'%' IDENTIFIED BY 'password_changem
GRANT ALL PRIVILEGES ON faredge.* TO faredge@localhost IDENTIFIED BY 'password_changeme';
FLUSH PRIVILEGES;
-USE `faredge`;
-
-DROP TABLE IF EXISTS orch_image_sync;
-CREATE TABLE orch_image_sync (
- id int(10) unsigned NOT NULL AUTO_INCREMENT,
- remote_region_name varchar(64) not null,
- docker_image text not null,
- upload_start_time datetime not null,
- upload_end_time datetime,
- upload_status enum('STARTED', 'UPLOADING', 'COMPLETE', 'FAILED'),
- upload_message varchar(255),
- PRIMARY KEY (id)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-DROP TABLE IF EXISTS orch_remote_region_setup;
-CREATE TABLE orch_remote_region_setup (
- id int(10) unsigned NOT NULL AUTO_INCREMENT,
- caas_vendor_version varchar(20) not null,
- kubernetes_version varchar(20) not null,
- central_region_name varchar(64) not null,
- remote_region_name varchar(64) not null,
- kubernetes_namespace varchar(64) not null,
- serviceaccount varchar(64) not null,
- kubeconfig mediumtext,
- PRIMARY KEY (id)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-