Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(254)

Side by Side Diff: go/src/infra/crimson/sql/schema.sql

Issue 2108643006: crimson server: Implemented SelectHost and InsertHost (Closed) Base URL: https://chromium.googlesource.com/infra/infra.git@mactohex
Patch Set: Added NULL support for boot class Created 4 years, 5 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
« no previous file with comments | « go/src/infra/crimson/server/frontend/crimson_service.go ('k') | no next file » | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
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;
OLDNEW
« no previous file with comments | « go/src/infra/crimson/server/frontend/crimson_service.go ('k') | no next file » | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698