| OLD | NEW |
| 1 -- Copyright 2016 The Chromium Authors. All Rights Reserved. | 1 -- Copyright 2016 The Chromium Authors. All Rights Reserved. |
| 2 -- | 2 -- |
| 3 -- Use of this source code is governed by a BSD-style | 3 -- Use of this source code is governed by a BSD-style |
| 4 -- license that can be found in the LICENSE file or at | 4 -- license that can be found in the LICENSE file or at |
| 5 -- https://developers.google.com/open-source/licenses/bsd | 5 -- https://developers.google.com/open-source/licenses/bsd |
| 6 | 6 |
| 7 -- Create tables in the crimson DB. | 7 -- Create tables in the crimson DB. |
| 8 | 8 |
| 9 CREATE TABLE ip_range ( | 9 CREATE TABLE ip_range ( |
| 10 site varchar(20) NOT NULL, | 10 site varchar(20) NOT NULL, |
| 11 vlan varchar(20), | 11 vlan varchar(20), |
| 12 start_ip varbinary(16) NOT NULL, | 12 start_ip varchar(34) NOT NULL, |
| 13 end_ip varbinary(16) NOT NULL | 13 end_ip varchar(34) NOT NULL |
| 14 ) ENGINE=INNODB; | 14 ) ENGINE=INNODB; |
| 15 |
| 16 CREATE TABLE host ( |
| 17 site varchar(20) NOT NULL, |
| 18 hostname varchar(63) NOT NULL, |
| 19 mac_addr varchar(14) NOT NULL, |
| 20 ip varchar(34) NOT NULL, |
| 21 boot_class varchar(20), |
| 22 PRIMARY KEY (mac_addr) |
| 23 ) ENGINE=INNODB; |
| OLD | NEW |