blob: 379cdfd256c3489c31bff93d2672ba19dd155fb8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
CREATE TABLE hosts_profiles_tmp (
hostid bigint unsigned DEFAULT '0' NOT NULL,
devicetype varchar(64) DEFAULT '' NOT NULL,
name varchar(64) DEFAULT '' NOT NULL,
os varchar(64) DEFAULT '' NOT NULL,
serialno varchar(64) DEFAULT '' NOT NULL,
tag varchar(64) DEFAULT '' NOT NULL,
macaddress varchar(64) DEFAULT '' NOT NULL,
hardware blob DEFAULT '' NOT NULL,
software blob DEFAULT '' NOT NULL,
contact blob DEFAULT '' NOT NULL,
location blob DEFAULT '' NOT NULL,
notes blob DEFAULT '' NOT NULL,
PRIMARY KEY (hostid)
);
insert into hosts_profiles_tmp select * from hosts_profiles;
drop table hosts_profiles;
alter table hosts_profiles_tmp rename hosts_profiles;
|
