1 files changed, 11 insertions, 0 deletions
diff --git a/pica-registrar/db_schema.sql b/pica-registrar/db_schema.sql
new file mode 100644
index 0000000..1921bf0
--- /dev/null
+++ b/pica-registrar/db_schema.sql
@@ -0,0 +1,11 @@
+create table registrations
+(
+id int unsigned PRIMARY KEY,
+t datetime  NOT NULL,
+ip_addr int unsigned NOT NULL,
+name varchar(64) CHARACTER SET utf8 NOT NULL,
+req_pem varchar(4096) NOT NULL,
+cert_pem varchar(4096) NOT NULL
+)
+
+ENGINE = InnoDB;