1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
|
# vim: filetype=mysql:
USE @TANGO_DB_NAME@;
UPDATE access_address SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE access_address
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
UPDATE access_device SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE access_device
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
UPDATE attribute_alias SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE attribute_alias
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
UPDATE attribute_class SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE attribute_class
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
UPDATE device SET started=NULL WHERE started<'2000-01-01 00:00:00';
UPDATE device SET stopped=NULL WHERE stopped<'2000-01-01 00:00:00';
ALTER TABLE device
CHANGE started started datetime NULL default NULL,
CHANGE stopped stopped datetime NULL default NULL,
ENGINE=InnoDB;
UPDATE device SET started=NULL WHERE started<'2000-01-01 00:00:00';
UPDATE device SET stopped=NULL WHERE stopped<'2000-01-01 00:00:00';
ALTER TABLE event
CHANGE started started datetime NULL default NULL,
CHANGE stopped stopped datetime NULL default NULL,
ENGINE=InnoDB;
UPDATE property SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE property
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
UPDATE property_attribute_class SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE property_attribute_class
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
UPDATE property_attribute_device SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE property_attribute_device
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
UPDATE property_class SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE property_class
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
UPDATE property_device SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE property_device
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
UPDATE property_pipe_class SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE property_pipe_class
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
UPDATE property_pipe_device SET accessed='2000-01-01 00:00:00' WHERE accessed<'2000-01-01 00:00:00';
ALTER TABLE property_pipe_device
CHANGE accessed accessed timestamp NOT NULL default '2000-01-01 00:00:00',
ENGINE=InnoDB;
ALTER TABLE server ENGINE=InnoDB;
ALTER TABLE device_history_id ENGINE=InnoDB;
ALTER TABLE device_attribute_history_id ENGINE=InnoDB;
ALTER TABLE device_pipe_history_id ENGINE=InnoDB;
ALTER TABLE class_history_id ENGINE=InnoDB;
ALTER TABLE class_attribute_history_id ENGINE=InnoDB;
ALTER TABLE class_pipe_history_id ENGINE=InnoDB;
ALTER TABLE object_history_id ENGINE=InnoDB;
ALTER TABLE property_hist
DROP KEY index_id,
DROP KEY index_object,
DROP KEY index_name,
ADD PRIMARY KEY (id, count),
ADD INDEX object_name_date (object, name, date),
ENGINE=InnoDB;
ALTER TABLE property_device_hist
DROP KEY index_id,
DROP KEY index_device,
DROP KEY index_name,
ADD PRIMARY KEY (id, count),
ADD INDEX device_name_date (device, name, date),
ENGINE=InnoDB;
ALTER TABLE property_class_hist
DROP KEY index_id,
DROP KEY index_class,
DROP KEY index_name,
ADD PRIMARY KEY (id, count),
ADD INDEX class_name_date (class, name, date),
ENGINE=InnoDB;
ALTER TABLE property_attribute_class_hist
DROP KEY index_id,
DROP KEY index_class,
DROP KEY index_attribute,
DROP KEY index_name,
ADD PRIMARY KEY (id, count),
ADD INDEX class_attribute_name_date (class, attribute, name, date),
ENGINE=InnoDB;
ALTER TABLE property_attribute_device_hist
DROP KEY index_id,
DROP KEY index_device,
DROP KEY index_attribute,
DROP KEY index_name,
ADD PRIMARY KEY (id, count),
ADD KEY device_attribute_name_date (device, attribute, name, date),
ENGINE=InnoDB;
ALTER TABLE property_pipe_class_hist
DROP KEY index_id,
DROP KEY index_class,
DROP KEY index_pipe,
DROP KEY index_name,
ADD PRIMARY KEY (id, count),
ADD INDEX class_pipe_name_date (class, pipe, name, date),
ENGINE=InnoDB;
ALTER TABLE property_pipe_device_hist
DROP KEY index_id,
DROP KEY index_device,
DROP KEY index_pipe,
DROP KEY index_name,
ADD PRIMARY KEY (id, count),
ADD INDEX device_pipe_name_date (device, pipe, name, date),
ENGINE=InnoDB;
|
