crimson server: Implemented SelectHost and InsertHost

go/src/infra/crimson/sql/schema.sql

Index: go/src/infra/crimson/sql/schema.sql
diff --git a/go/src/infra/crimson/sql/schema.sql b/go/src/infra/crimson/sql/schema.sql
index 6ecc54cd6a9780d5ee0662ebc4d5f15a26cb3675..83474c0b6770e5a60386f460499603b20fadc541 100644
--- a/go/src/infra/crimson/sql/schema.sql
+++ b/go/src/infra/crimson/sql/schema.sql
@@ -9,6 +9,15 @@
 CREATE TABLE ip_range (
   site varchar(20) NOT NULL,
   vlan varchar(20),
-  start_ip varbinary(16) NOT NULL,
-  end_ip varbinary(16) NOT NULL
+  start_ip varchar(34) NOT NULL,
+  end_ip varchar(34) NOT NULL
+) ENGINE=INNODB;
+
+CREATE TABLE host (
+  site varchar(20) NOT NULL,
+  hostname varchar(63) NOT NULL,
+  mac_addr varchar(14) NOT NULL,
+  ip varchar(34) NOT NULL,
+  boot_class varchar(20),
+  PRIMARY KEY (mac_addr)
 ) ENGINE=INNODB;