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 |