database-fill.sql 105 KB
Newer Older
1
-- MySQL dump 8.23
2
3
--
-- Host: localhost    Database: tbdb
4
-- -------------------------------------------------------
Kevin Atkinson's avatar
   
Kevin Atkinson committed
5
-- Server version	3.23.59-nightly-20050301-log
6

Kevin Atkinson's avatar
   
Kevin Atkinson committed
7
8
9
10
11
12
13
14
15
16
17
--
-- Dumping data for table `causes`
--


REPLACE INTO causes VALUES ('temp','Temp Resource Shortage');
REPLACE INTO causes VALUES ('user','User Error');
REPLACE INTO causes VALUES ('internal','Internal Error');
REPLACE INTO causes VALUES ('software','Software Problem');
REPLACE INTO causes VALUES ('hardware','Hardware Problem');
REPLACE INTO causes VALUES ('unknown','Cause Unknown');
Kevin Atkinson's avatar
   
Kevin Atkinson committed
18
REPLACE INTO causes VALUES ('canceled','Canceled');
Kevin Atkinson's avatar
   
Kevin Atkinson committed
19

20
--
21
-- Dumping data for table `comments`
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
REPLACE INTO comments VALUES ('users','','testbed user accounts');
REPLACE INTO comments VALUES ('experiments','','user experiments');
REPLACE INTO comments VALUES ('images','','available disk images');
REPLACE INTO comments VALUES ('current_reloads','','currently pending disk reloads');
REPLACE INTO comments VALUES ('delays','','delay nodes');
REPLACE INTO comments VALUES ('loginmessage','','appears under login button in web interface');
REPLACE INTO comments VALUES ('nodes','','hardware, software, and status of testbed machines');
REPLACE INTO comments VALUES ('projects','','projects using the testbed');
REPLACE INTO comments VALUES ('partitions','','loaded operating systems on node partitions');
REPLACE INTO comments VALUES ('os_info','','available operating system features and information');
REPLACE INTO comments VALUES ('reserved','','node reservation');
REPLACE INTO comments VALUES ('wires','','physical wire types and connections');
REPLACE INTO comments VALUES ('nologins','','presence of a row will disallow non-admin web logins');
REPLACE INTO comments VALUES ('nsfiles','','NS simulator files used to configure experiments');
REPLACE INTO comments VALUES ('tiplines','','serial control \'TIP\' lines');
REPLACE INTO comments VALUES ('proj_memb','','project membership');
REPLACE INTO comments VALUES ('group_membership','','group membership');
REPLACE INTO comments VALUES ('node_types','','specifications regarding types of node hardware available');
REPLACE INTO comments VALUES ('last_reservation','','the last project to have reserved listed nodes');
REPLACE INTO comments VALUES ('groups','','groups information');
REPLACE INTO comments VALUES ('vlans','','configured router VLANs');
REPLACE INTO comments VALUES ('tipservers','','machines driving serial control \'TIP\' lines');
REPLACE INTO comments VALUES ('uidnodelastlogin','','last node logged into by users');
REPLACE INTO comments VALUES ('nodeuidlastlogin','','last user logged in to nodes');
REPLACE INTO comments VALUES ('scheduled_reloads','','pending disk reloads');
REPLACE INTO comments VALUES ('tmcd_redirect','','used to redirect node configuration client (TMCC) to \'fake\' database for testing purposes');
REPLACE INTO comments VALUES ('deltas','','user filesystem deltas');
REPLACE INTO comments VALUES ('delta_compat','','delta/OS compatibilities');
REPLACE INTO comments VALUES ('delta_inst','','nodes on which listed deltas are installed');
REPLACE INTO comments VALUES ('delta_proj','','projects which own listed deltas');
REPLACE INTO comments VALUES ('next_reserve','','scheduled reservations (e.g. by sched_reserve)');
REPLACE INTO comments VALUES ('outlets','','power controller and outlet connections for nodes');
REPLACE INTO comments VALUES ('exppid_access','','allows access to one project\'s experiment by another project');
REPLACE INTO comments VALUES ('lastlogin','','list of recently logged in web interface users');
REPLACE INTO comments VALUES ('switch_stacks','','switch stack membership');
REPLACE INTO comments VALUES ('switch_stack_types','','types of each switch stack');
REPLACE INTO comments VALUES ('nodelog','','log entries for nodes');
REPLACE INTO comments VALUES ('unixgroup_membership','','Unix group memberships for control (non-experiment) nodes');
REPLACE INTO comments VALUES ('interface_types','','network interface types');
64
REPLACE INTO comments VALUES ('foo','bar','baz');
65
66
67
68
69
70
71
72
73
REPLACE INTO comments VALUES ('login','','currently active web logins');
REPLACE INTO comments VALUES ('portmap','','provides consistency of ports across swaps');
REPLACE INTO comments VALUES ('webdb_table_permissions','','table access permissions for WebDB interface ');
REPLACE INTO comments VALUES ('comments','','database table and row descriptions (such as this)');
REPLACE INTO comments VALUES ('interfaces','','node network interfaces');
REPLACE INTO comments VALUES ('foreign_keys','','foreign key constraints for use by the dbcheck script');
REPLACE INTO comments VALUES ('nseconfigs','','Table for storing NSE configurations');
REPLACE INTO comments VALUES ('widearea_delays','','Delay and bandwidth metrics between WAN nodes');
REPLACE INTO comments VALUES ('virt_nodes','','Experiment virtual nodes');
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
--
-- Dumping data for table `client_services`
--


REPLACE INTO `client_services` VALUES (10,'rc.tbsetup','boot','every',1);
REPLACE INTO `client_services` VALUES (20,'rc.ipod','boot','every',0);
REPLACE INTO `client_services` VALUES (30,'rc.healthd','boot','every',0);
REPLACE INTO `client_services` VALUES (40,'rc.slothd','boot','every',0);
REPLACE INTO `client_services` VALUES (50,'rc.firewall','boot','every',0);
REPLACE INTO `client_services` VALUES (60,'rc.tpmsetup','boot','every',0);
REPLACE INTO `client_services` VALUES (70,'rc.misc','boot','every',0);
REPLACE INTO `client_services` VALUES (80,'rc.localize','boot','every',0);
REPLACE INTO `client_services` VALUES (90,'rc.keys','boot','every',0);
REPLACE INTO `client_services` VALUES (100,'rc.mounts','boot','every',0);
REPLACE INTO `client_services` VALUES (110,'rc.blobs','boot','every',0);
REPLACE INTO `client_services` VALUES (120,'rc.topomap','boot','every',0);
REPLACE INTO `client_services` VALUES (130,'rc.accounts','boot','every',0);
REPLACE INTO `client_services` VALUES (140,'rc.route','boot','every',0);
REPLACE INTO `client_services` VALUES (150,'rc.tunnels','boot','every',0);
REPLACE INTO `client_services` VALUES (160,'rc.ifconfig','boot','every',0);
REPLACE INTO `client_services` VALUES (170,'rc.delays','boot','every',0);
REPLACE INTO `client_services` VALUES (180,'rc.hostnames','boot','every',0);
REPLACE INTO `client_services` VALUES (190,'rc.lmhosts','boot','every',0);
REPLACE INTO `client_services` VALUES (200,'rc.trace','boot','every',0);
REPLACE INTO `client_services` VALUES (210,'rc.syncserver','boot','every',0);
REPLACE INTO `client_services` VALUES (220,'rc.trafgen','boot','every',0);
REPLACE INTO `client_services` VALUES (230,'rc.tarfiles','boot','every',0);
REPLACE INTO `client_services` VALUES (240,'rc.rpms','boot','every',0);
REPLACE INTO `client_services` VALUES (250,'rc.progagent','boot','every',0);
REPLACE INTO `client_services` VALUES (260,'rc.linkagent','boot','every',0);
REPLACE INTO `client_services` VALUES (270,'rc.tiptunnels','boot','every',0);
REPLACE INTO `client_services` VALUES (280,'rc.motelog','boot','every',0);
REPLACE INTO `client_services` VALUES (290,'rc.simulator','boot','every',0);
REPLACE INTO `client_services` VALUES (1000,'rc.canaryd','boot','every',1);
REPLACE INTO `client_services` VALUES (1010,'rc.linktest','boot','every',1);
REPLACE INTO `client_services` VALUES (1020,'rc.isup','boot','every',1);
REPLACE INTO `client_services` VALUES (1030,'rc.startcmd','boot','every',0);
REPLACE INTO `client_services` VALUES (1040,'rc.vnodes','boot','every',1);
REPLACE INTO `client_services` VALUES (1050,'rc.subnodes','boot','every',1);

116
--
117
-- Dumping data for table `event_eventtypes`
118
119
--

120
121
122
123
124
125
126
127
128
129
130

REPLACE INTO event_eventtypes VALUES (0,'REBOOT');
REPLACE INTO event_eventtypes VALUES (1,'START');
REPLACE INTO event_eventtypes VALUES (2,'STOP');
REPLACE INTO event_eventtypes VALUES (3,'UP');
REPLACE INTO event_eventtypes VALUES (4,'DOWN');
REPLACE INTO event_eventtypes VALUES (5,'UPDATE');
REPLACE INTO event_eventtypes VALUES (6,'MODIFY');
REPLACE INTO event_eventtypes VALUES (7,'SET');
REPLACE INTO event_eventtypes VALUES (8,'TIME');
REPLACE INTO event_eventtypes VALUES (9,'RESET');
131
132
133
REPLACE INTO event_eventtypes VALUES (10,'KILL');
REPLACE INTO event_eventtypes VALUES (11,'HALT');
REPLACE INTO event_eventtypes VALUES (12,'SWAPOUT');
134
REPLACE INTO event_eventtypes VALUES (13,'NSEEVENT');
135
136
REPLACE INTO event_eventtypes VALUES (14,'REPORT');
REPLACE INTO event_eventtypes VALUES (15,'ALERT');
Timothy Stack's avatar
   
Timothy Stack committed
137
REPLACE INTO event_eventtypes VALUES (16,'SETDEST');
Timothy Stack's avatar
Timothy Stack committed
138
139
140
141
REPLACE INTO event_eventtypes VALUES (17,'COMPLETE');
REPLACE INTO event_eventtypes VALUES (18,'MESSAGE');
REPLACE INTO event_eventtypes VALUES (19,'LOG');
REPLACE INTO event_eventtypes VALUES (20,'RUN');
Mike Hibler's avatar
Mike Hibler committed
142
REPLACE INTO event_eventtypes VALUES (21,'SNAPSHOT');
Timothy Stack's avatar
Timothy Stack committed
143
REPLACE INTO event_eventtypes VALUES (22,'RELOAD');
144
145
REPLACE INTO event_eventtypes VALUES (23,'CLEAR');
REPLACE INTO event_eventtypes VALUES (24,'CREATE');
146
REPLACE INTO event_eventtypes VALUES (25,'STOPRUN');
147

148
--
149
-- Dumping data for table `event_objecttypes`
150
151
--

152
153
154
155
156
157

REPLACE INTO event_objecttypes VALUES (0,'TBCONTROL');
REPLACE INTO event_objecttypes VALUES (1,'LINK');
REPLACE INTO event_objecttypes VALUES (2,'TRAFGEN');
REPLACE INTO event_objecttypes VALUES (3,'TIME');
REPLACE INTO event_objecttypes VALUES (4,'PROGRAM');
158
REPLACE INTO event_objecttypes VALUES (5,'FRISBEE');
159
REPLACE INTO event_objecttypes VALUES (6,'SIMULATOR');
160
REPLACE INTO event_objecttypes VALUES (7,'LINKTEST');
161
REPLACE INTO event_objecttypes VALUES (8,'NSE');
162
REPLACE INTO event_objecttypes VALUES (9,'SLOTHD');
Timothy Stack's avatar
   
Timothy Stack committed
163
REPLACE INTO event_objecttypes VALUES (10,'NODE');
164
165
REPLACE INTO event_objecttypes VALUES (11,'SEQUENCE');
REPLACE INTO event_objecttypes VALUES (12,'TIMELINE');
166
REPLACE INTO event_objecttypes VALUES (13,'CONSOLE');
167
REPLACE INTO event_objecttypes VALUES (14,'TOPOGRAPHY');
168
REPLACE INTO event_objecttypes VALUES (15,'LINKTRACE');
Timothy Stack's avatar
Timothy Stack committed
169
REPLACE INTO event_objecttypes VALUES (16,'EVPROXY');
Timothy Stack's avatar
Timothy Stack committed
170
REPLACE INTO event_objecttypes VALUES (17,'BGMON');
171
172
REPLACE INTO event_objecttypes VALUES (18,'DISK');
REPLACE INTO event_objecttypes VALUES (19,'CUSTOM');
173

174
--
175
-- Dumping data for table `exported_tables`
176
177
--

178

Kevin Atkinson's avatar
   
Kevin Atkinson committed
179
REPLACE INTO exported_tables VALUES ('causes');
180
181
182
183
184
REPLACE INTO exported_tables VALUES ('comments');
REPLACE INTO exported_tables VALUES ('event_eventtypes');
REPLACE INTO exported_tables VALUES ('event_objecttypes');
REPLACE INTO exported_tables VALUES ('exported_tables');
REPLACE INTO exported_tables VALUES ('foreign_keys');
185
REPLACE INTO exported_tables VALUES ('mode_transitions');
186
REPLACE INTO exported_tables VALUES ('priorities');
187
188
REPLACE INTO exported_tables VALUES ('state_timeouts');
REPLACE INTO exported_tables VALUES ('state_transitions');
189
REPLACE INTO exported_tables VALUES ('state_triggers');
190
REPLACE INTO exported_tables VALUES ('table_regex');
191
192
REPLACE INTO exported_tables VALUES ('testsuite_preentables');
REPLACE INTO exported_tables VALUES ('webdb_table_permissions');
Kevin Atkinson's avatar
   
Kevin Atkinson committed
193
REPLACE INTO exported_tables VALUES ('emulab_pubs_month_map');
194
REPLACE INTO exported_tables VALUES ('event_triggertypes');
195
REPLACE INTO exported_tables VALUES ('client_services');
196

197
--
198
-- Dumping data for table `foreign_keys`
199
200
--

201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256

REPLACE INTO foreign_keys VALUES ('projects','head_uid','users','uid');
REPLACE INTO foreign_keys VALUES ('groups','pid','projects','pid');
REPLACE INTO foreign_keys VALUES ('groups','leader','users','uid');
REPLACE INTO foreign_keys VALUES ('experiments','expt_head_uid','users','uid');
REPLACE INTO foreign_keys VALUES ('experiments','pid','projects','pid');
REPLACE INTO foreign_keys VALUES ('experiments','pid,gid','groups','pid,gid');
REPLACE INTO foreign_keys VALUES ('os_info','pid','projects','pid');
REPLACE INTO foreign_keys VALUES ('node_types','osid','os_info','osid');
REPLACE INTO foreign_keys VALUES ('node_types','delay_osid','os_info','osid');
REPLACE INTO foreign_keys VALUES ('nodes','def_boot_osid','os_info','osid');
REPLACE INTO foreign_keys VALUES ('nodes','next_boot_osid','os_info','osid');
REPLACE INTO foreign_keys VALUES ('nodes','type','node_types','type');
REPLACE INTO foreign_keys VALUES ('images','pid','projects','pid');
REPLACE INTO foreign_keys VALUES ('images','part1_osid','os_info','osid');
REPLACE INTO foreign_keys VALUES ('images','part2_osid','os_info','osid');
REPLACE INTO foreign_keys VALUES ('images','part3_osid','os_info','osid');
REPLACE INTO foreign_keys VALUES ('images','part4_osid','os_info','osid');
REPLACE INTO foreign_keys VALUES ('images','default_osid','os_info','osid');
REPLACE INTO foreign_keys VALUES ('current_reloads','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('current_reloads','image_id','images','imageid');
REPLACE INTO foreign_keys VALUES ('delays','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('delays','eid,pid','experiments','eid,pid');
REPLACE INTO foreign_keys VALUES ('partitions','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('partitions','osid','os_info','osid');
REPLACE INTO foreign_keys VALUES ('exppid_access','exp_pid,exp_eid','experiments','pid,eid');
REPLACE INTO foreign_keys VALUES ('group_membership','uid','users','uid');
REPLACE INTO foreign_keys VALUES ('group_membership','pid,gid','groups','pid,gid');
REPLACE INTO foreign_keys VALUES ('interfaces','interface_type','interface_types','type');
REPLACE INTO foreign_keys VALUES ('interfaces','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('last_reservation','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('last_reservation','pid','projects','pid');
REPLACE INTO foreign_keys VALUES ('lastlogin','uid','users','uid');
REPLACE INTO foreign_keys VALUES ('login','uid','users','uid');
REPLACE INTO foreign_keys VALUES ('newdelays','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('newdelays','eid,pid','experiments','eid,pid');
REPLACE INTO foreign_keys VALUES ('next_reserve','eid,pid','experiments','eid,pid');
REPLACE INTO foreign_keys VALUES ('next_reserve','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('nodeuidlastlogin','uid','users','uid');
REPLACE INTO foreign_keys VALUES ('nodeuidlastlogin','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('nsfiles','eid,pid','experiments','eid,pid');
REPLACE INTO foreign_keys VALUES ('proj_memb','pid','projects','pid');
REPLACE INTO foreign_keys VALUES ('reserved','eid,pid','experiments','eid,pid');
REPLACE INTO foreign_keys VALUES ('reserved','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('scheduled_reloads','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('scheduled_reloads','image_id','images','imageid');
REPLACE INTO foreign_keys VALUES ('tiplines','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('tmcd_redirect','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('uidnodelastlogin','uid','users','uid');
REPLACE INTO foreign_keys VALUES ('uidnodelastlogin','node_id','nodes','node_id');
REPLACE INTO foreign_keys VALUES ('virt_lans','pid,eid','experiments','pid,eid');
REPLACE INTO foreign_keys VALUES ('virt_nodes','pid,eid','experiments','pid,eid');
REPLACE INTO foreign_keys VALUES ('virt_nodes','osname','os_info','osname');
REPLACE INTO foreign_keys VALUES ('vlans','pid,eid','experiments','pid,eid');
REPLACE INTO foreign_keys VALUES ('nseconfigs','eid,pid,vname','virt_nodes','eid,pid,vname');
REPLACE INTO foreign_keys VALUES ('nseconfigs','eid,pid','experiments','eid,pid');
257
REPLACE INTO foreign_keys VALUES ('virt_nodes','parent_osname','os_info','osname');
258

259
--
260
-- Dumping data for table `mode_transitions`
261
262
--

263

264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
REPLACE INTO mode_transitions VALUES ('MINIMAL','SHUTDOWN','NETBOOT','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('MINIMAL','SHUTDOWN','NORMAL','REBOOTING','');
REPLACE INTO mode_transitions VALUES ('MINIMAL','SHUTDOWN','NORMALv1','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('MINIMAL','SHUTDOWN','RELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NETBOOT','SHUTDOWN','MINIMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NETBOOT','SHUTDOWN','NORMAL','REBOOTING','');
REPLACE INTO mode_transitions VALUES ('NETBOOT','SHUTDOWN','NORMALv1','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NETBOOT','SHUTDOWN','RELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','MINIMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','NETBOOT','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','NORMALv1','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','RELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','SHUTDOWN','MINIMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','SHUTDOWN','NETBOOT','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','SHUTDOWN','NORMALv1','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','SHUTDOWN','RELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','MINIMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','NETBOOT','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','NORMAL','REBOOTING','');
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','RELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','MINIMAL','SHUTDOWN','');
285
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONEV2','MINIMAL','SHUTDOWN','');
286
287
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','NETBOOT','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','NORMAL','REBOOTING','');
288
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONEV2','NORMAL','REBOOTING','');
289
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','NORMALv1','SHUTDOWN','');
290
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONEV2','NORMALv1','SHUTDOWN','');
291
292
293
294
REPLACE INTO mode_transitions VALUES ('RELOAD','SHUTDOWN','MINIMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('RELOAD','SHUTDOWN','NETBOOT','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('RELOAD','SHUTDOWN','NORMAL','REBOOTING','');
REPLACE INTO mode_transitions VALUES ('RELOAD','SHUTDOWN','NORMALv1','SHUTDOWN','');
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
REPLACE INTO mode_transitions VALUES ('MINIMAL','SHUTDOWN','NORMALv2','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv2','SHUTDOWN','NORMALv1','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NETBOOT','SHUTDOWN','NORMALv2','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('PXEFBSD','SHUTDOWN','NORMAL','REBOOTING','');
REPLACE INTO mode_transitions VALUES ('PXEFBSD','SHUTDOWN','NORMALv1','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('PXEFBSD','SHUTDOWN','NORMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('PXEFBSD','SHUTDOWN','MINIMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('PXEFBSD','SHUTDOWN','NETBOOT','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('PXEFBSD','SHUTDOWN','NORMALv2','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('PXEFBSD','SHUTDOWN','RELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv2','SHUTDOWN','MINIMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv2','SHUTDOWN','NETBOOT','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv2','SHUTDOWN','RELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('RELOAD','SHUTDOWN','PXEFBSD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','NORMALv2','SHUTDOWN','');
310
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONEV2','NORMALv2','SHUTDOWN','');
311
312
313
314
315
316
317
318
319
REPLACE INTO mode_transitions VALUES ('NORMALv2','SHUTDOWN','PXEFBSD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('RELOAD','SHUTDOWN','NORMALv2','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','PXEFBSD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','SHUTDOWN','PXEFBSD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NETBOOT','SHUTDOWN','PXEFBSD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('MINIMAL','SHUTDOWN','PXEFBSD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','NORMALv2','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv2','SHUTDOWN','NORMAL','REBOOTING','');
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','NORMALv2','SHUTDOWN','');
320
321
322
REPLACE INTO mode_transitions VALUES ('ALWAYSUP','SHUTDOWN','RELOAD-MOTE','SHUTDOWN','ReloadStart');
REPLACE INTO mode_transitions VALUES ('ALWAYSUP','ISUP','RELOAD-MOTE','SHUTDOWN','ReloadStart');
REPLACE INTO mode_transitions VALUES ('ALWAYSUP','ISUP','RELOAD-MOTE','ISUP','ReloadStart');
Timothy Stack's avatar
   
Timothy Stack committed
323
REPLACE INTO mode_transitions VALUES ('RELOAD-MOTE','SHUTDOWN','ALWAYSUP','ISUP','ReloadDone');
324
325
REPLACE INTO mode_transitions VALUES ('PCVM','SHUTDOWN','RELOAD-PCVM','SHUTDOWN','ReloadSetup');
REPLACE INTO mode_transitions VALUES ('RELOAD-PCVM','SHUTDOWN','PCVM','SHUTDOWN','ReloadDone');
326
327
REPLACE INTO mode_transitions VALUES ('RELOAD-PCVM','RELOADDONE','NORMALv2','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('RELOAD-PCVM','SHUTDOWN','NORMALv2','SHUTDOWN','');
328
329
REPLACE INTO mode_transitions VALUES ('RELOAD-PUSH','SHUTDOWN','MINIMAL','SHUTDOWN','ReloadDone');
REPLACE INTO mode_transitions VALUES ('MINIMAL','SHUTDOWN','RELOAD-PUSH','SHUTDOWN','ReloadStart');
330
331
332
333
REPLACE INTO mode_transitions VALUES ('SECUREBOOT','TPMSIGNOFF','MINIMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('SECUREBOOT','TPMSIGNOFF','NORMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('SECUREBOOT','TPMSIGNOFF','NORMALv2','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('SECUREBOOT','TPMSIGNOFF','PXEFBSD','SHUTDOWN','');
334
REPLACE INTO mode_transitions VALUES ('SECUREBOOT','TPMSIGNOFF','PXEKERNEL','SHUTDOWN','SecureBootDone');
335
REPLACE INTO mode_transitions VALUES ('NORMALv2','SHUTDOWN','SECURELOAD','SHUTDOWN','SecureLoadStart');
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
REPLACE INTO mode_transitions VALUES ('PXEFBSD','SHUTDOWN','WIMRELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('MINIMAL','SHUTDOWN','WIMRELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NETBOOT','SHUTDOWN','WIMRELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMAL','SHUTDOWN','WIMRELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','WIMRELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('NORMALv2','SHUTDOWN','WIMRELOAD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','SHUTDOWN','PXEFBSD','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','SHUTDOWN','MINIMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','SHUTDOWN','NETBOOT','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','SHUTDOWN','NORMAL','REBOOTING','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','SHUTDOWN','NORMALv1','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','SHUTDOWN','NORMALv2','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','RELOADDONE','MINIMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','RELOADDONE','NETBOOT','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','RELOADDONE','NORMAL','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','RELOADDONE','NORMALv1','SHUTDOWN','');
REPLACE INTO mode_transitions VALUES ('WIMRELOAD','RELOADDONE','NORMALv2','SHUTDOWN','');
353

354
355
356
357
358
359
360
361
362
363
364
365
366
367
--
-- Dumping data for table `priorities`
--


REPLACE INTO priorities VALUES (0,'EMERG');
REPLACE INTO priorities VALUES (100,'ALERT');
REPLACE INTO priorities VALUES (200,'CRIT');
REPLACE INTO priorities VALUES (300,'ERR');
REPLACE INTO priorities VALUES (400,'WARNING');
REPLACE INTO priorities VALUES (500,'NOTICE');
REPLACE INTO priorities VALUES (600,'INFO');
REPLACE INTO priorities VALUES (700,'DEBUG');

368
--
369
-- Dumping data for table `state_timeouts`
370
--
371

372
373

REPLACE INTO state_timeouts VALUES ('NORMAL','REBOOTING',120,'REBOOT');
374
REPLACE INTO state_timeouts VALUES ('NORMAL','REBOOTED',60,'NOTIFY');
375
REPLACE INTO state_timeouts VALUES ('MINIMAL','SHUTDOWN',120,'REBOOT');
376
REPLACE INTO state_timeouts VALUES ('NORMALv1','TBSETUP',600,'NOTIFY');
377
REPLACE INTO state_timeouts VALUES ('RELOAD','RELOADDONE',60,'NOTIFY');
378
REPLACE INTO state_timeouts VALUES ('RELOAD','RELOADDONEV2',60,'NOTIFY');
379
380
381
382
383
384
385
386
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','ACTIVATING',0,'');
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','ACTIVE',0,'');
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','NEW',0,'');
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','PRERUN',0,'');
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','SWAPPED',0,'');
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','SWAPPING',0,'');
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','TERMINATING',0,'');
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','TESTING',0,'');
387
REPLACE INTO state_timeouts VALUES ('MINIMAL','BOOTING',180,'REBOOT');
388
389
390
391
392
REPLACE INTO state_timeouts VALUES ('NODEALLOC','FREE_CLEAN',0,'');
REPLACE INTO state_timeouts VALUES ('NODEALLOC','FREE_DIRTY',0,'');
REPLACE INTO state_timeouts VALUES ('NODEALLOC','REBOOT',0,'');
REPLACE INTO state_timeouts VALUES ('NODEALLOC','RELOAD',0,'');
REPLACE INTO state_timeouts VALUES ('NODEALLOC','RESERVED',0,'');
393
394
395
REPLACE INTO state_timeouts VALUES ('NORMAL','BOOTING',180,'REBOOT');
REPLACE INTO state_timeouts VALUES ('NORMALv1','BOOTING',180,'REBOOT');
REPLACE INTO state_timeouts VALUES ('RELOAD','BOOTING',180,'REBOOT');
396
REPLACE INTO state_timeouts VALUES ('RELOAD','RELOADING',600,'NOTIFY');
397
398
REPLACE INTO state_timeouts VALUES ('RELOAD','RELOADSETUP',60,'NOTIFY');
REPLACE INTO state_timeouts VALUES ('RELOAD','SHUTDOWN',120,'REBOOT');
399
400
401
402
REPLACE INTO state_timeouts VALUES ('USERSTATUS','ACTIVE',0,'');
REPLACE INTO state_timeouts VALUES ('USERSTATUS','FROZEN',0,'');
REPLACE INTO state_timeouts VALUES ('USERSTATUS','NEWUSER',0,'');
REPLACE INTO state_timeouts VALUES ('USERSTATUS','UNAPPROVED',0,'');
403
REPLACE INTO state_timeouts VALUES ('TBCOMMAND','REBOOT',75,'CMDRETRY');
404
405
406
REPLACE INTO state_timeouts VALUES ('TBCOMMAND','POWEROFF',0,'CMDRETRY');
REPLACE INTO state_timeouts VALUES ('TBCOMMAND','POWERON',0,'CMDRETRY');
REPLACE INTO state_timeouts VALUES ('TBCOMMAND','POWERCYCLE',0,'CMDRETRY');
407
REPLACE INTO state_timeouts VALUES ('PCVM','BOOTING',1200,'NOTIFY');
408
409
410
REPLACE INTO state_timeouts VALUES ('PCVM','SHUTDOWN',0,'');
REPLACE INTO state_timeouts VALUES ('PCVM','ISUP',0,'');
REPLACE INTO state_timeouts VALUES ('PCVM','TBSETUP',600,'NOTIFY');
411
412
REPLACE INTO state_timeouts VALUES ('PXEFBSD','REBOOTING',120,'REBOOT');
REPLACE INTO state_timeouts VALUES ('PXEFBSD','REBOOTED',60,'NOTIFY');
413
REPLACE INTO state_timeouts VALUES ('PXEFBSD','BOOTING',180,'REBOOT');
414
REPLACE INTO state_timeouts VALUES ('NORMALv2','TBSETUP',600,'NOTIFY');
415
REPLACE INTO state_timeouts VALUES ('NORMALv2','BOOTING',180,'REBOOT');
416
REPLACE INTO state_timeouts VALUES ('GARCIA-STARGATEv1','TBSETUP',600,'NOTIFY');
417
REPLACE INTO state_timeouts VALUES ('PXEKERNEL','PXEWAKEUP',20,'REBOOT');
418
419
420
421
422
REPLACE INTO state_timeouts VALUES ('SECUREBOOT','BOOTING',300,'STATE:SECVIOLATION');
REPLACE INTO state_timeouts VALUES ('SECUREBOOT','GPXEBOOTING',60,'STATE:SECVIOLATION');
REPLACE INTO state_timeouts VALUES ('SECUREBOOT','PXEBOOTING',60,'STATE:SECVIOLATION');
REPLACE INTO state_timeouts VALUES ('SECUREBOOT','SHUTDOWN',300,'STATE:SECVIOLATION');
REPLACE INTO state_timeouts VALUES ('SECUREBOOT','TPMSIGNOFF',60,'STATE:SECVIOLATION');
423
REPLACE INTO state_timeouts VALUES ('SECUREBOOT','PXEWAIT',10,'STATE:SECVIOLATION');
424
425
426
427
REPLACE INTO state_timeouts VALUES ('SECURELOAD','BOOTING',300,'STATE:SECVIOLATION');
REPLACE INTO state_timeouts VALUES ('SECURELOAD','GPXEBOOTING',60,'STATE:SECVIOLATION');
REPLACE INTO state_timeouts VALUES ('SECURELOAD','PXEBOOTING',60,'STATE:SECVIOLATION');
REPLACE INTO state_timeouts VALUES ('SECURELOAD','RELOADDONE',300,'STATE:SECVIOLATION');
428
REPLACE INTO state_timeouts VALUES ('SECURELOAD','RELOADING',3600,'STATE:SECVIOLATION');
429
430
431
REPLACE INTO state_timeouts VALUES ('SECURELOAD','RELOADSETUP',60,'STATE:SECVIOLATION');
REPLACE INTO state_timeouts VALUES ('SECURELOAD','SHUTDOWN',300,'STATE:SECVIOLATION');
REPLACE INTO state_timeouts VALUES ('SECURELOAD','TPMSIGNOFF',300,'STATE:SECVIOLATION');
432
433
434
435
REPLACE INTO state_timeouts VALUES ('WIMRELOAD','SHUTDOWN',240,'REBOOT');
REPLACE INTO state_timeouts VALUES ('WIMRELOAD','RELOADSETUP',60,'NOTIFY');
REPLACE INTO state_timeouts VALUES ('WIMRELOAD','RELOADING',1800,'NOTIFY');
REPLACE INTO state_timeouts VALUES ('WIMRELOAD','RELOADDONE',60,'NOTIFY');
436

437
--
438
-- Dumping data for table `state_transitions`
439
440
--

441

442
443
REPLACE INTO state_transitions VALUES ('ALWAYSUP','ISUP','SHUTDOWN','Reboot');
REPLACE INTO state_transitions VALUES ('ALWAYSUP','SHUTDOWN','ISUP','BootDone');
Mac Newbold's avatar
Mac Newbold committed
444
REPLACE INTO state_transitions VALUES ('PCVM','ISUP','BOOTING','Crash');
Robert Ricci's avatar
Robert Ricci committed
445
446
447
448
REPLACE INTO state_transitions VALUES ('EXPTSTATE','TERMINATING','SWAPPED','Error');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','TERMINATING','ENDED','NoError');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','MODIFY_RESWAP','SWAPPING','Nonrecover Error');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','MODIFY_PARSE','ACTIVE','Error');
449
450
451
REPLACE INTO state_transitions VALUES ('NETBOOT','SHUTDOWN','PXEBOOTING','DHCP');
REPLACE INTO state_transitions VALUES ('RELOAD','PXEBOOTING','BOOTING','BootInfo');
REPLACE INTO state_transitions VALUES ('RELOAD','SHUTDOWN','PXEBOOTING','DHCP');
452
453
454
455
456
457
458
REPLACE INTO state_transitions VALUES ('NETBOOT','BOOTING','ISUP','BootDone');
REPLACE INTO state_transitions VALUES ('NETBOOT','BOOTING','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('NETBOOT','ISUP','BOOTING','KernelChange');
REPLACE INTO state_transitions VALUES ('NETBOOT','ISUP','ISUP','Retry');
REPLACE INTO state_transitions VALUES ('NETBOOT','ISUP','SHUTDOWN','Reboot');
REPLACE INTO state_transitions VALUES ('NETBOOT','SHUTDOWN','BOOTING','DHCP');
REPLACE INTO state_transitions VALUES ('NETBOOT','SHUTDOWN','SHUTDOWN','Retry');
459
460
461
462
463
REPLACE INTO state_transitions VALUES ('MINIMAL','BOOTING','ISUP','BootDone');
REPLACE INTO state_transitions VALUES ('MINIMAL','BOOTING','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('MINIMAL','ISUP','BOOTING','SilentReboot');
REPLACE INTO state_transitions VALUES ('MINIMAL','ISUP','SHUTDOWN','Reboot');
REPLACE INTO state_transitions VALUES ('MINIMAL','SHUTDOWN','BOOTING','DHCP');
464
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTING','REBOOTING','Retry');
465
REPLACE INTO state_transitions VALUES ('NORMALv1','TBSETUP','ISUP','BootDone');
466
467
468
469
REPLACE INTO state_transitions VALUES ('NORMALv1','SHUTDOWN','SHUTDOWN','Retry');
REPLACE INTO state_transitions VALUES ('NORMALv1','SHUTDOWN','PXEBOOTING','DHCP');
REPLACE INTO state_transitions VALUES ('NORMALv1','ISUP','SHUTDOWN','Reboot');
REPLACE INTO state_transitions VALUES ('NORMALv1','BOOTING','SHUTDOWN','Error');
470
471
472
473
REPLACE INTO state_transitions VALUES ('RELOAD','BOOTING','BOOTING','DHCPRetry');
REPLACE INTO state_transitions VALUES ('RELOAD','BOOTING','RELOADSETUP','BootOK');
REPLACE INTO state_transitions VALUES ('RELOAD','BOOTING','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADING','RELOADDONE','ReloadDone');
474
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADING','RELOADDONEV2','ReloadDone');
475
476
477
478
479
480
481
482
483
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADING','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADSETUP','RELOADING','ReloadReady');
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADSETUP','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('RELOAD','SHUTDOWN','BOOTING','DHCP');
REPLACE INTO state_transitions VALUES ('RELOAD','SHUTDOWN','SHUTDOWN','Retry');
REPLACE INTO state_transitions VALUES ('USERSTATUS','ACTIVE','FROZEN','');
REPLACE INTO state_transitions VALUES ('USERSTATUS','FROZEN','ACTIVE','');
REPLACE INTO state_transitions VALUES ('USERSTATUS','NEWUSER','UNAPPROVED','');
REPLACE INTO state_transitions VALUES ('USERSTATUS','UNAPPROVED','ACTIVE','');
Robert Ricci's avatar
Robert Ricci committed
484
REPLACE INTO state_transitions VALUES ('BATCHSTATE','SWAPPED','ACTIVATING','SwapIn');
485
486
487
488
REPLACE INTO state_transitions VALUES ('WIDEAREA','ISUP','REBOOTED','SilentReboot');
REPLACE INTO state_transitions VALUES ('WIDEAREA','ISUP','SHUTDOWN','Reboot');
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTED','ISUP','BootDone');
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTED','SHUTDOWN','Error');
Robert Ricci's avatar
Robert Ricci committed
489
REPLACE INTO state_transitions VALUES ('BATCHSTATE','ACTIVATING','ACTIVE','SwapIn');
490
REPLACE INTO state_transitions VALUES ('NORMALv2','SHUTDOWN','SHUTDOWN','Retry');
Robert Ricci's avatar
Robert Ricci committed
491
REPLACE INTO state_transitions VALUES ('BATCHSTATE','ACTIVATING','POSTED','Batch');
492
REPLACE INTO state_transitions VALUES ('WIDEAREA','SHUTDOWN','REBOOTED','BootOK');
493
494
495
496
REPLACE INTO state_transitions VALUES ('WIDEAREA','SHUTDOWN','SHUTDOWN','Retry');
REPLACE INTO state_transitions VALUES ('PCVM','BOOTING','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('PCVM','BOOTING','TBSETUP','BootOK');
REPLACE INTO state_transitions VALUES ('PCVM','ISUP','SHUTDOWN','Reboot');
497
REPLACE INTO state_transitions VALUES ('PCVM','SHUTDOWN','BOOTING','StartBoot');
498
499
500
501
502
REPLACE INTO state_transitions VALUES ('PCVM','TBSETUP','ISUP','BootDone');
REPLACE INTO state_transitions VALUES ('PCVM','TBSETUP','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('PCVM','BOOTING','ISUP','BootDone');
REPLACE INTO state_transitions VALUES ('ALWAYSUP','ISUP','ISUP','Retry');
REPLACE INTO state_transitions VALUES ('PCVM','SHUTDOWN','SHUTDOWN','Retry');
503
504
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','REBOOTING','Error');
REPLACE INTO state_transitions VALUES ('NORMALv1','BOOTING','TBSETUP','BootOK');
505
REPLACE INTO state_transitions VALUES ('NODEALLOC','RELOAD_TO_FREE','FREE_CLEAN','ReloadDone');
506
507
508
509
510
REPLACE INTO state_transitions VALUES ('NORMAL','SHUTDOWN','REBOOTING','Reboot');
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','ISUP','BootDone');
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('NORMAL','PXEBOOTING','BOOTING','BootInfo');
REPLACE INTO state_transitions VALUES ('NORMALv1','PXEBOOTING','BOOTING','BootInfo');
Robert Ricci's avatar
Robert Ricci committed
511
REPLACE INTO state_transitions VALUES ('BATCHSTATE','POSTED','ACTIVATING','SwapIn');
512
513
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTING','PXEBOOTING','DHCP');
REPLACE INTO state_transitions VALUES ('NORMALv1','ISUP','PXEBOOTING','KernelChange');
514
REPLACE INTO state_transitions VALUES ('NODEALLOC','FREE_CLEAN','RES_INIT_CLEAN','Reserve');
Mac Newbold's avatar
Mac Newbold committed
515
REPLACE INTO state_transitions VALUES ('PXEKERNEL','PXEWAIT','PXEBOOTING','Retry');
516
REPLACE INTO state_transitions VALUES ('PXEKERNEL','PXEBOOTING','PXEWAIT','Free');
517
REPLACE INTO state_transitions VALUES ('PXEKERNEL','PXELIMBO','PXEBOOTING','Bootinfo-Restart');
Robert Ricci's avatar
Robert Ricci committed
518
REPLACE INTO state_transitions VALUES ('BATCHSTATE','ACTIVATING','SWAPPED','NonBatch');
519
520
521
522
523
REPLACE INTO state_transitions VALUES ('NORMAL','ISUP','SHUTDOWN','Reboot');
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTING','SHUTDOWN','Reboot');
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','REBOOTING','Error');
REPLACE INTO state_transitions VALUES ('NORMAL','ISUP','REBOOTING','Reboot');
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','REBOOTED','BootOK');
524
REPLACE INTO state_transitions VALUES ('NORMALv2','SHUTDOWN','PXEBOOTING','DHCP');
525
526
REPLACE INTO state_transitions VALUES ('NORMAL','SHUTDOWN','PXEBOOTING','DHCP');
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','SHUTDOWN','Error');
527
528
529
530
REPLACE INTO state_transitions VALUES ('EXAMPLE','NEW','VERIFIED','Verify');
REPLACE INTO state_transitions VALUES ('EXAMPLE','NEW','APPROVED','Approve');
REPLACE INTO state_transitions VALUES ('EXAMPLE','APPROVED','READY','Verify');
REPLACE INTO state_transitions VALUES ('EXAMPLE','VERIFIED','READY','Approve');
531
532
533
534
535
536
REPLACE INTO state_transitions VALUES ('EXAMPLE','FROZEN','READY','Thaw');
REPLACE INTO state_transitions VALUES ('EXAMPLE','READY','FROZEN','Freeze');
REPLACE INTO state_transitions VALUES ('EXAMPLE','LOCKED','READY','Unlock');
REPLACE INTO state_transitions VALUES ('EXAMPLE','READY','LOCKED','Lock');
REPLACE INTO state_transitions VALUES ('EXAMPLE','FROZEN','LOCKED','Lock');
REPLACE INTO state_transitions VALUES ('EXAMPLE','LOCKED','FROZEN','Freeze');
537
538
539
540
REPLACE INTO state_transitions VALUES ('EXAMPLE','READY','APPROVED','Un-Verify');
REPLACE INTO state_transitions VALUES ('EXAMPLE','READY','VERIFIED','Un-Approve');
REPLACE INTO state_transitions VALUES ('EXAMPLE','VERIFIED','NEW','Un-Verify');
REPLACE INTO state_transitions VALUES ('EXAMPLE','APPROVED','NEW','Un-Approve');
Robert Ricci's avatar
Robert Ricci committed
541
542
543
REPLACE INTO state_transitions VALUES ('BATCHSTATE','ACTIVE','TERMINATING','SwapOut');
REPLACE INTO state_transitions VALUES ('BATCHSTATE','TERMINATING','SWAPPED','SwapOut');
REPLACE INTO state_transitions VALUES ('BATCHSTATE','SWAPPED','POSTED','RePost');
Robert Ricci's avatar
Robert Ricci committed
544
545
546
547
REPLACE INTO state_transitions VALUES ('EXPTSTATE','MODIFY_PRERUN','SWAPPED','(No)Error');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','SWAPPED','MODIFY_PRERUN','Modify');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','SWAPPED','TERMINATING','EndExp');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','SWAPPING','SWAPPED','(No)Error');
548
549
550
551
REPLACE INTO state_transitions VALUES ('EXPTSTATE','ACTIVATING','SWAPPED','Error');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','ACTIVE','SWAPPING','SwapOut');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','ACTIVE','RESTARTING','Restart');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','RESTARTING','ACTIVE','(No)Error');
Robert Ricci's avatar
Robert Ricci committed
552
553
554
555
556
557
558
559
560
561
REPLACE INTO state_transitions VALUES ('EXPTSTATE','ACTIVATING','ACTIVE','NoError');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','QUEUED','TERMINATING','Endexp');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','SWAPPED','QUEUED','Queue');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','QUEUED','ACTIVATING','BatchRun');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','QUEUED','SWAPPED','Dequeue');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','PRERUN','QUEUED','Batch');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','PRERUN','SWAPPED','Immediate');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','NEW','PRERUN','Create');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','NEW','ENDED','Endexp');
REPLACE INTO state_transitions VALUES ('EXPTSTATE','SWAPPED','ACTIVATING','SwapIn');
562
REPLACE INTO state_transitions VALUES ('PXEKERNEL','PXEWAKEUP','PXEBOOTING','Wokeup');
563
REPLACE INTO state_transitions VALUES ('EXPTSTATE','MODIFY_PARSE','MODIFY_RESWAP','NoError');
Robert Ricci's avatar
Robert Ricci committed
564
REPLACE INTO state_transitions VALUES ('EXPTSTATE','ACTIVE','MODIFY_PARSE','Modify');
565
REPLACE INTO state_transitions VALUES ('EXPTSTATE','MODIFY_RESWAP','ACTIVE','(No)Error');
566
567
568
569
REPLACE INTO state_transitions VALUES ('PXEKERNEL','PXEWAIT','PXEWAKEUP','NodeAlloced');
REPLACE INTO state_transitions VALUES ('PXEKERNEL','SHUTDOWN','PXEBOOTING','BootInfo');
REPLACE INTO state_transitions VALUES ('PXEKERNEL','PXEBOOTING','PXEBOOTING','Retry');
REPLACE INTO state_transitions VALUES ('PXEKERNEL','PXEBOOTING','BOOTING','Not Free');
570
571
REPLACE INTO state_transitions VALUES ('NORMALv2','RECONFIG','SHUTDOWN','ReConfigFail');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RELOAD_PENDING','RELOAD_TO_FREE','Reload');
572
573
REPLACE INTO state_transitions VALUES ('PXEKERNEL','PXEWAKEUP','PXEWAKEUP','Retry');
REPLACE INTO state_transitions VALUES ('NORMALv2','ISUP','SHUTDOWN','Reboot');
574
REPLACE INTO state_transitions VALUES ('NORMALv2','BOOTING','SHUTDOWN','Error');
575
REPLACE INTO state_transitions VALUES ('NORMALv2','SHUTDOWN','WEDGED','Error');
576
REPLACE INTO state_transitions VALUES ('NORMALv2','BOOTING','TBSETUP','BootOK');
577
REPLACE INTO state_transitions VALUES ('NORMALv2','PXEBOOTING','BOOTING','BootInfo');
578
REPLACE INTO state_transitions VALUES ('NORMALv2','ISUP','PXEBOOTING','KernelChange');
579
REPLACE INTO state_transitions VALUES ('NORMALv2','TBSETUP','SHUTDOWN','Error');
580
581
582
REPLACE INTO state_transitions VALUES ('NORMALv2','ISUP','RECONFIG','DoReConfig');
REPLACE INTO state_transitions VALUES ('NORMALv2','RECONFIG','TBSETUP','ReConfig');
REPLACE INTO state_transitions VALUES ('NORMALv2','TBSETUP','ISUP','BootDone');
583
584
585
REPLACE INTO state_transitions VALUES ('NORMALv1','TBSETUP','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('NORMAL','SHUTDOWN','SHUTDOWN','Retry');
REPLACE INTO state_transitions VALUES ('NETBOOT','PXEBOOTING','BOOTING','BootInfo');
586
587
588
589
590
591
592
593
REPLACE INTO state_transitions VALUES ('NODEALLOC','RES_INIT_CLEAN','RES_CLEAN_REBOOT','Reboot');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RES_INIT_CLEAN','RELOAD_TO_DIRTY','Reload');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RES_CLEAN_REBOOT','RES_WAIT_CLEAN','Rebooting');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RELOAD_TO_DIRTY','RES_DIRTY_REBOOT','Reboot');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RES_DIRTY_REBOOT','RES_WAIT_DIRTY','Rebooting');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RES_WAIT_CLEAN','RES_READY','IsUp');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RES_WAIT_DIRTY','RES_READY','IsUp');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RES_READY','RELOAD_PENDING','Free');
594
595
REPLACE INTO state_transitions VALUES ('MINIMAL','BOOTING','BOOTING','DHCPRetry');
REPLACE INTO state_transitions VALUES ('MINIMAL','SHUTDOWN','SHUTDOWN','Retry');
Robert Ricci's avatar
Robert Ricci committed
596
REPLACE INTO state_transitions VALUES ('NORMALv2','TBSETUP','TBSETUP','LongSetup');
597
598
599
600
REPLACE INTO state_transitions VALUES ('OPSNODEBSD','ISUP','SHUTDOWN','Reboot');
REPLACE INTO state_transitions VALUES ('OPSNODEBSD','SHUTDOWN','TBSETUP','Booting');
REPLACE INTO state_transitions VALUES ('OPSNODEBSD','TBSETUP','ISUP','BootDone');
REPLACE INTO state_transitions VALUES ('OPSNODEBSD','ISUP','TBSETUP','Crash');
601
602
REPLACE INTO state_transitions VALUES ('RELOAD-MOTE','RELOADING','RELOADDONE','ReloadDone');
REPLACE INTO state_transitions VALUES ('RELOAD-MOTE','SHUTDOWN','RELOADING','Booting');
603
604
605
606
REPLACE INTO state_transitions VALUES ('NORMALv2','TBSETUP','TBFAILED','BootFail');
REPLACE INTO state_transitions VALUES ('NORMALv2','TBFAILED','SHUTDOWN','RebootAfterFail');
REPLACE INTO state_transitions VALUES ('PCVM','TBSETUP','TBFAILED','BootError');
REPLACE INTO state_transitions VALUES ('PCVM','TBFAILED','SHUTDOWN','Reboot');
607
608
609
610
611
612
613
614
615
616
617
618
619
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','SHUTDOWN','SHUTDOWN','Retry');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','SHUTDOWN','TBSETUP','DHCP');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','SHUTDOWN','POWEROFF','PowerOff');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','POWEROFF','TBSETUP','PowerOn');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','RECONFIG','SHUTDOWN','ReConfigFail');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','ISUP','SHUTDOWN','Reboot');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','TBSETUP','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','ISUP','RECONFIG','DoReConfig');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','RECONFIG','TBSETUP','ReConfig');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','TBSETUP','ISUP','BootDone');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','TBSETUP','TBSETUP','LongSetup');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','TBSETUP','TBFAILED','BootFail');
REPLACE INTO state_transitions VALUES ('GARCIA-STARGATEv1','TBFAILED','SHUTDOWN','RebootAfterFail');
620
621
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADSETUP','RELOADOLDMFS','');
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADOLDMFS','SHUTDOWN','');
622

623
624
625
REPLACE INTO state_transitions VALUES ('RELOAD-PCVM','RELOADSETUP','RELOADING','ReloadStart');
REPLACE INTO state_transitions VALUES ('RELOAD-PCVM','RELOADING','RELOADDONE','ReloadDone');
REPLACE INTO state_transitions VALUES ('RELOAD-PCVM','RELOADDONE','SHUTDOWN','ReloadDone');
626
627
628
REPLACE INTO state_transitions VALUES ('RELOAD-PCVM','BOOTING','RELOADSETUP','ReloadSetup');
REPLACE INTO state_transitions VALUES ('RELOAD-PCVM','SHUTDOWN','BOOTING','Booting');

629
630
631
632
633
REPLACE INTO state_transitions VALUES ('RELOAD','BOOTING','TBSETUP','FailedBoot');
REPLACE INTO state_transitions VALUES ('RELOAD','TBSETUP','ISUP','FailedBoot');
REPLACE INTO state_transitions VALUES ('RELOAD','TBSETUP','TBFAILED','FailedBoot');
REPLACE INTO state_transitions VALUES ('RELOAD','ISUP','SHUTDOWN','RebootAfterFail');
REPLACE INTO state_transitions VALUES ('RELOAD','TBFAILED','SHUTDOWN','RebootAfterFail');
634
635
636
637
638
639
REPLACE INTO state_transitions VALUES ('RELOAD-PUSH','SHUTDOWN','BOOTING','Booting');
REPLACE INTO state_transitions VALUES ('RELOAD-PUSH','BOOTING','BOOTING','BootRetry');
REPLACE INTO state_transitions VALUES ('RELOAD-PUSH','RELOADSETUP','RELOADING','ReloadStart');
REPLACE INTO state_transitions VALUES ('RELOAD-PUSH','RELOADING','RELOADDONE','ReloadDone');
REPLACE INTO state_transitions VALUES ('RELOAD-PUSH','RELOADDONE','SHUTDOWN','ReloadDone');
REPLACE INTO state_transitions VALUES ('RELOAD-PUSH','SHUTDOWN','RELOADSETUP','ReloadSetup');
640
641
REPLACE INTO state_transitions VALUES ('SECUREBOOT','BOOTING','SECVIOLATION','QuoteFailed');
REPLACE INTO state_transitions VALUES ('SECUREBOOT','BOOTING','TPMSIGNOFF','QuoteOK');
642
REPLACE INTO state_transitions VALUES ('SECUREBOOT','BOOTING','PXEBOOTING','re-BootInfo');
643
644
REPLACE INTO state_transitions VALUES ('SECUREBOOT','GPXEBOOTING','PXEBOOTING','DHCP');
REPLACE INTO state_transitions VALUES ('SECUREBOOT','PXEBOOTING','BOOTING','BootInfo');
645
646
647
REPLACE INTO state_transitions VALUES ('SECUREBOOT','PXEBOOTING','PXEWAIT','BootInfoFree');
REPLACE INTO state_transitions VALUES ('SECUREBOOT','PXEWAIT','SECVIOLATION','QuoteFailed');
REPLACE INTO state_transitions VALUES ('SECUREBOOT','PXEWAIT','TPMSIGNOFF','QuoteOK');
648
649
650
651
652
653
654
655
656
657
REPLACE INTO state_transitions VALUES ('SECURELOAD','BOOTING','PXEBOOTING','re-BootInfo');
REPLACE INTO state_transitions VALUES ('SECURELOAD','BOOTING','RELOADSETUP','QuoteOK');
REPLACE INTO state_transitions VALUES ('SECURELOAD','BOOTING','SECVIOLATION','QuoteFailed');
REPLACE INTO state_transitions VALUES ('SECURELOAD','GPXEBOOTING','PXEBOOTING','DHCP');
REPLACE INTO state_transitions VALUES ('SECURELOAD','PXEBOOTING','BOOTING','BootInfo');
REPLACE INTO state_transitions VALUES ('SECURELOAD','RELOADDONE','SECVIOLATION','QuoteFailed');
REPLACE INTO state_transitions VALUES ('SECURELOAD','RELOADDONE','TPMSIGNOFF','QuoteOK');
REPLACE INTO state_transitions VALUES ('SECURELOAD','RELOADING','RELOADDONE','ImageOK');
REPLACE INTO state_transitions VALUES ('SECURELOAD','RELOADING','SECVIOLATION','ImageBad');
REPLACE INTO state_transitions VALUES ('SECURELOAD','RELOADSETUP','RELOADING','ReloadReady');
658
REPLACE INTO state_transitions VALUES ('SECURELOAD','SHUTDOWN','SHUTDOWN','Retry');
659
660
REPLACE INTO state_transitions VALUES ('SECURELOAD','SHUTDOWN','GPXEBOOTING','QuoteOK');
REPLACE INTO state_transitions VALUES ('SECURELOAD','SHUTDOWN','SECVIOLATION','QuoteFailed');
661
662
663
664
665
666
667
668
REPLACE INTO state_transitions VALUES ('PXEKERNEL','PXEWAIT','POWEROFF','Power Save');
REPLACE INTO state_transitions VALUES ('PXEKERNEL','POWEROFF','SHUTDOWN','Power Recovery');
REPLACE INTO state_transitions VALUES ('NORMAL','*','POWEROFF','Power Off');
REPLACE INTO state_transitions VALUES ('NORMALv1','*','POWEROFF','Power Off');
REPLACE INTO state_transitions VALUES ('NORMALv2','*','POWEROFF','Power Off');
REPLACE INTO state_transitions VALUES ('NORMAL','POWEROFF','SHUTDOWN','Power On');
REPLACE INTO state_transitions VALUES ('NORMALv1','POWEROFF','SHUTDOWN','Power On');
REPLACE INTO state_transitions VALUES ('NORMALv2','POWEROFF','SHUTDOWN','Power On');
669
670
671
672
REPLACE INTO state_transitions VALUES ('SECUREBOOT','SECVIOLATION','POWEROFF','Power Off');
REPLACE INTO state_transitions VALUES ('SECURELOAD','SECVIOLATION','POWEROFF','Power Off');
REPLACE INTO state_transitions VALUES ('SECUREBOOT','POWEROFF','SHUTDOWN','Power On');
REPLACE INTO state_transitions VALUES ('SECURELOAD','POWEROFF','SHUTDOWN','Power On');
673
674
675
676
677
678
679
REPLACE INTO state_transitions VALUES ('WIMRELOAD','SHUTDOWN','RELOADSETUP','BootOK');
REPLACE INTO state_transitions VALUES ('WIMRELOAD','RELOADSETUP','RELOADING','ReloadStart');
REPLACE INTO state_transitions VALUES ('WIMRELOAD','RELOADING','RELOADDONE','ReloadDone');
REPLACE INTO state_transitions VALUES ('WIMRELOAD','SHUTDOWN','SHUTDOWN','Retry');
REPLACE INTO state_transitions VALUES ('WIMRELOAD','SHUTDOWN','PXEBOOTING','WrongPXEboot');
REPLACE INTO state_transitions VALUES ('WIMRELOAD','RELOADSETUP','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('WIMRELOAD','RELOADING','SHUTDOWN','Error');
680
REPLACE INTO state_transitions VALUES ('PXEKERNEL','PXEBOOTING','REBOOTING','ForcedReboot');
681
682
683
684
685
686
687
REPLACE INTO state_transitions VALUES ('PXEFBSD','BOOTING','MFSSETUP','BootOK');
REPLACE INTO state_transitions VALUES ('PXEFBSD','BOOTING','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('PXEFBSD','MFSSETUP','ISUP','BootDone');
REPLACE INTO state_transitions VALUES ('PXEFBSD','MFSSETUP','SHUTDOWN','Error');
REPLACE INTO state_transitions VALUES ('PXEFBSD','ISUP','SHUTDOWN','Reboot');
REPLACE INTO state_transitions VALUES ('PXEFBSD','SHUTDOWN','PXEBOOTING','DHCP');
REPLACE INTO state_transitions VALUES ('SECURELOAD','TPMSIGNOFF','GPXEBOOTING','ReloadDone');
688
689
REPLACE INTO state_transitions VALUES ('SECUREBOOT','SHUTDOWN','GPXEBOOTING','QuoteOK');
REPLACE INTO state_transitions VALUES ('SECUREBOOT','SHUTDOWN','SECVIOLATION','QuoteFailed');
690

691
--
692
-- Dumping data for table `state_triggers`
693
694
--

Mac Newbold's avatar
Mac Newbold committed
695

696
REPLACE INTO state_triggers VALUES ('*','RELOAD','RELOADDONE','RESET, RELOADDONE');
697
REPLACE INTO state_triggers VALUES ('*','RELOAD','RELOADDONEV2','RESET, RELOADDONEV2');
698
REPLACE INTO state_triggers VALUES ('*','ALWAYSUP','SHUTDOWN','ISUP');
699
REPLACE INTO state_triggers VALUES ('*','*','ISUP','RESET, CHECKPORTREG');
Mac Newbold's avatar
Mac Newbold committed
700
701
REPLACE INTO state_triggers VALUES ('*','*','PXEBOOTING','PXEBOOT');
REPLACE INTO state_triggers VALUES ('*','*','BOOTING','BOOTING, CHECKGENISUP');
702
REPLACE INTO state_triggers VALUES ('*','MINIMAL','ISUP','RESET');
703
REPLACE INTO state_triggers VALUES ('*','RELOAD-MOTE','RELOADDONE','RELOADDONE');
704
REPLACE INTO state_triggers VALUES ('*','OPSNODEBSD','ISUP','SCRIPT:opsreboot');
705
REPLACE INTO state_triggers VALUES ('*','NORMALv2','WEDGED','POWERCYCLE');
706
REPLACE INTO state_triggers VALUES ('*','RELOAD','RELOADOLDMFS','RELOADOLDMFS');
707
REPLACE INTO state_triggers VALUES ('*','RELOAD-PCVM','RELOADDONE','RESET, RELOADDONE');
708
709
REPLACE INTO state_triggers VALUES ('*','RELOAD','ISUP','REBOOT');
REPLACE INTO state_triggers VALUES ('*','RELOAD','TBFAILED','REBOOT');
710
REPLACE INTO state_triggers VALUES ('*','RELOAD-PUSH','RELOADDONE','RELOADDONE');
711
712
713
714
REPLACE INTO state_triggers VALUES ('*','*','GPXEBOOTING','SECUREBOOT');
REPLACE INTO state_triggers VALUES ('*','*','SECVIOLATION','POWEROFF, EMAILNOTIFY');
REPLACE INTO state_triggers VALUES ('*','SECUREBOOT','BOOTING','');
REPLACE INTO state_triggers VALUES ('*','SECUREBOOT','PXEBOOTING','');
715
REPLACE INTO state_triggers VALUES ('*','SECUREBOOT','TPMSIGNOFF','PXEBOOT');
716
REPLACE INTO state_triggers VALUES ('*','SECURELOAD','BOOTING','BOOTING');
717
718
REPLACE INTO state_triggers VALUES ('*','SECURELOAD','PXEBOOTING','');
REPLACE INTO state_triggers VALUES ('*','SECURELOAD','RELOADDONE','RESET, RELOADDONE');
719
720
721
722
REPLACE INTO state_triggers VALUES ('*','WIMRELOAD','RELOADDONE','PXERESET, RESET, RELOADDONE');
REPLACE INTO state_triggers VALUES ('*','WIMRELOAD','PXEBOOTING','REBOOT');
REPLACE INTO state_triggers VALUES ('*','WIMRELOAD','BOOTING','REBOOT');
REPLACE INTO state_triggers VALUES ('*','WIMRELOAD','ISUP','REBOOT');
Mac Newbold's avatar
Mac Newbold committed
723

724
725
726
727
728
729
730
731
--
-- Dumping data for table `table_regex`
--


REPLACE INTO table_regex VALUES ('eventlist','pid','text','redirect','projects:pid',0,0,NULL);
REPLACE INTO table_regex VALUES ('eventlist','eid','text','redirect','experiments:eid',0,0,NULL);
REPLACE INTO table_regex VALUES ('eventlist','time','float','redirect','default:float',0,0,NULL);
732
REPLACE INTO table_regex VALUES ('eventlist','vnode','text','redirect','virt_agents:vnode',0,0,NULL);
733
REPLACE INTO table_regex VALUES ('eventlist','vname','text','regex','^[-\\w\\(\\)]+$',1,64,NULL);
734
735
REPLACE INTO table_regex VALUES ('eventlist','objecttype','int','redirect','default:tinyint',0,0,NULL);
REPLACE INTO table_regex VALUES ('eventlist','eventtype','int','redirect','default:tinyint',0,0,NULL);
736
737
REPLACE INTO table_regex VALUES ('eventlist','arguments','text','redirect','default:text',0,1024,NULL);
REPLACE INTO table_regex VALUES ('eventlist','atstring','text','redirect','default:text',0,1024,NULL);
738
739
REPLACE INTO table_regex VALUES ('eventlist','triggertype','int','redirect','default:tinyint',0,0,NULL);

740
REPLACE INTO table_regex VALUES ('experiments','eid','text','regex','^[a-zA-Z0-9][-a-zA-Z0-9]+$',2,19,'Must ensure not too long for the database. PID is 12, and the max is 32, so the user is not allowed to specify an EID more than 19, since other parts of the system may concatenate them together with a hyphen');
741
REPLACE INTO table_regex VALUES ('experiments','eid_idx','text','regex','^[\\d]+$',1,12,NULL);
742
743
744
745
746
747
748
749
750
REPLACE INTO table_regex VALUES ('experiments','multiplex_factor','int','redirect','default:tinyint',0,0,NULL);
REPLACE INTO table_regex VALUES ('experiments','forcelinkdelays','int','redirect','default:boolean',0,0,NULL);
REPLACE INTO table_regex VALUES ('experiments','uselinkdelays','int','redirect','default:boolean',0,0,NULL);
REPLACE INTO table_regex VALUES ('experiments','usewatunnels','int','redirect','default:boolean',0,0,NULL);
REPLACE INTO table_regex VALUES ('experiments','uselatestwadata','int','redirect','default:boolean',0,0,NULL);
REPLACE INTO table_regex VALUES ('experiments','wa_delay_solverweight','float','redirect','default:float',0,1024,NULL);
REPLACE INTO table_regex VALUES ('experiments','wa_bw_solverweight','float','redirect','default:float',0,1024,NULL);
REPLACE INTO table_regex VALUES ('experiments','wa_plr_solverweight','float','redirect','default:float',0,1024,NULL);
REPLACE INTO table_regex VALUES ('experiments','sync_server','text','redirect','virt_nodes:vname',0,0,NULL);
751
752

REPLACE INTO table_regex VALUES ('groups','project','text','redirect','projects:pid',0,0,NULL);
753
REPLACE INTO table_regex VALUES ('groups','pid_idx','text','redirect','projects:pid_idx',0,0,NULL);
754
REPLACE INTO table_regex VALUES ('groups','gid','text','regex','^[a-zA-Z][-\\w]+$',2,32,NULL);
755
REPLACE INTO table_regex VALUES ('groups','gid_idx','text','regex','^[\\d]+$',1,12,NULL);
756
REPLACE INTO table_regex VALUES ('groups','group_id','text','redirect','groups:gid',2,32,NULL);
757
758
REPLACE INTO table_regex VALUES ('groups','group_leader','text','redirect','users:uid',2,8,NULL);
REPLACE INTO table_regex VALUES ('groups','group_description','text','redirect','default:tinytext',0,256,NULL);
759
760
761
REPLACE INTO table_regex VALUES ('groups','change','text','regex','^permit$',0,0,NULL);
REPLACE INTO table_regex VALUES ('groups','add','text','regex','^permit$',0,0,NULL);
REPLACE INTO table_regex VALUES ('groups','trust','text','regex','^(user|local_root|group_root)$',0,0,NULL);
762

763
REPLACE INTO table_regex VALUES ('nodes','node_id','text','regex','^[-\\w]+$',1,12,NULL);
764
765
766
REPLACE INTO table_regex VALUES ('nseconfigs','pid','text','redirect','projects:pid',0,0,NULL);
REPLACE INTO table_regex VALUES ('nseconfigs','eid','text','redirect','experiments:eid',0,0,NULL);
REPLACE INTO table_regex VALUES ('nseconfigs','vname','text','redirect','virt_nodes:vname',0,0,NULL);
767
REPLACE INTO table_regex VALUES ('nseconfigs','nseconfig','text','regex','^[\\040-\\176\\012\\011\\015]*$',0,16777215,NULL);
768
769

REPLACE INTO table_regex VALUES ('projects','newuser_xml','text','regex','^[-_\\w\\.\\/:+]*$',1,256,NULL);
770
REPLACE INTO table_regex VALUES ('projects','newpid','text','regex','^[a-zA-Z][-a-zA-Z0-9]+$',2,48,NULL);
771
772
773
774
775
776
777
REPLACE INTO table_regex VALUES ('projects','head_uid','text','redirect','users:uid',0,0,NULL);
REPLACE INTO table_regex VALUES ('projects','name','text','redirect','default:tinytext',0,256,NULL);
REPLACE INTO table_regex VALUES ('projects','funders','text','redirect','default:tinytext',0,256,NULL);
REPLACE INTO table_regex VALUES ('projects','public','int','redirect','default:tinyint',0,1,NULL);
REPLACE INTO table_regex VALUES ('projects','linked_to_us','int','redirect','default:tinyint',0,1,NULL);
REPLACE INTO table_regex VALUES ('projects','public_whynot','text','redirect','default:tinytext',0,256,NULL);
REPLACE INTO table_regex VALUES ('projects','default_user_interface','text','regex','^(emulab|plab)$',2,12,NULL);
778
REPLACE INTO table_regex VALUES ('projects','pid','text','regex','^[-\\w]+$',2,48,NULL);
779
REPLACE INTO table_regex VALUES ('projects','pid_idx','text','regex','^[\\d]+$',1,12,NULL);
780
REPLACE INTO table_regex VALUES ('projects','URL','text','redirect','default:tinytext',0,0,NULL);
781
REPLACE INTO table_regex VALUES ('projects','manager_urn','text','regex','^[-_\\w\\.\\/:+]*$',10,128,NULL);
782
783
REPLACE INTO table_regex VALUES ('projects','nonlocal_id','text','regex','^[-_\\w\\.\\/:+]*$',10,128,NULL);
REPLACE INTO table_regex VALUES ('projects','nonlocal_type','text','regex','^[-\\w]*$',1,64,NULL);
784
REPLACE INTO table_regex VALUES ('reserved','vname','text','redirect','virt_nodes:vname',1,32,NULL);
785
786
787
REPLACE INTO table_regex VALUES ('users','manager_urn','text','regex','^[-_\\w\\.\\/:+]*$',10,128,NULL);
REPLACE INTO table_regex VALUES ('users','nonlocal_id','text','regex','^[-_\\w\\.\\/:+]*$',10,128,NULL);
REPLACE INTO table_regex VALUES ('users','nonlocal_type','text','regex','^[-\\w]*$',1,64,NULL);
788
REPLACE INTO table_regex VALUES ('users','uid','text','regex','^[a-zA-Z][\\w]+$',2,8,NULL);
789
REPLACE INTO table_regex VALUES ('users','uid_idx','text','regex','^[\\d]+$',1,12,NULL);
790
REPLACE INTO table_regex VALUES ('users','usr_phone','text','regex','^[-\\d\\(\\)\\+\\.x ]+$',7,64,NULL);
791
REPLACE INTO table_regex VALUES ('users','usr_name','text','regex','^[-\\w\\. ]+$',4,64,NULL);
792
REPLACE INTO table_regex VALUES ('users','usr_email','text','regex','^([-\\w\\+\\.]+)\\@([-\\w\\.]+)$',3,64,NULL);
Mike Hibler's avatar
Mike Hibler committed
793
REPLACE INTO table_regex VALUES ('users','usr_shell','text','regex','^(csh|sh|bash|tcsh|zsh)$',0,0,NULL);
794
795
REPLACE INTO table_regex VALUES ('users','usr_title','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','usr_affil','text','redirect','default:tinytext',0,0,NULL);
796
REPLACE INTO `table_regex` VALUES ('users','usr_affil_abbrev','text','regex','^[\\040-\\176]*$',0,16,NULL);
797
798
799
800
801
802
803
804
REPLACE INTO table_regex VALUES ('users','usr_addr','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','usr_addr2','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','usr_state','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','usr_city','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','usr_zip','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','usr_country','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','usr_URL','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','usr_pswd','text','redirect','default:tinytext',0,0,NULL);
805
806
807
808
809
REPLACE INTO table_regex VALUES ('users','password1','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','password2','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','w_password1','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','w_password2','text','redirect','default:tinytext',0,0,NULL);
REPLACE INTO table_regex VALUES ('users','user_interface','text','regex','^(emulab|plab)$',0,0,NULL);
810
REPLACE INTO table_regex VALUES ('users','notes','text','redirect','default:fulltext',0,65535,NULL);
811
REPLACE INTO table_regex VALUES ('users','initial_passphrase','text','redirect','default:tinytext',0,128,NULL);
812

813
814
815
REPLACE INTO table_regex VALUES ('virt_agents','pid','text','redirect','projects:pid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_agents','eid','text','redirect','experiments:eid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_agents','vname','text','redirect','eventlist:vname',0,0,NULL);
816
REPLACE INTO table_regex VALUES ('virt_agents','vnode','text','regex','^([-\\w]+)|(\\*{1})$',1,32,NULL);
817
REPLACE INTO table_regex VALUES ('virt_agents','objecttype','int','redirect','default:tinyint',0,0,NULL);
818

819
820
821
REPLACE INTO table_regex VALUES ('virt_lans','pid','text','redirect','projects:pid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','eid','text','redirect','experiments:eid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','vname','text','redirect','virt_nodes:vname',0,0,NULL);
822
REPLACE INTO table_regex VALUES ('virt_lans','vindex','int','redirect','default:int',0,4098,NULL);
823
824
REPLACE INTO table_regex VALUES ('virt_lans','delay','float','redirect','default:float',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','bandwidth','int','redirect','default:int',0,2147483647,NULL);
825
REPLACE INTO table_regex VALUES ('virt_lans','lossrate','float','function','_checklossrate',0,1,NULL);
826
827
828
829
830
831
832
833
834
835
836
837
838
839
REPLACE INTO table_regex VALUES ('virt_lans','q_limit','int','redirect','default:int',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_maxthresh','int','redirect','default:int',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_minthresh','int','redirect','default:int',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_weight','float','redirect','default:float',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_linterm','int','redirect','default:int',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_qinbytes','int','redirect','default:tinyint',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_bytes','int','redirect','default:tinyint',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_meanpsize','int','redirect','default:int',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_wait','int','redirect','default:int',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_setbit','int','redirect','default:int',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_droptail','int','redirect','default:int',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_red','int','redirect','default:tinyint',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','q_gentle','int','redirect','default:tinyint',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','member','text','regex','^[-\\w]+:[\\d]+$',0,128,NULL);
840
REPLACE INTO table_regex VALUES ('virt_lans','mask','text','regex','^\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}$',0,15,NULL);
841
842
REPLACE INTO table_regex VALUES ('virt_lans','rdelay','float','redirect','virt_lans:delay',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','rbandwidth','int','redirect','virt_lans:bandwidth',0,0,NULL);
843
REPLACE INTO table_regex VALUES ('virt_lans','rlossrate','float','function','_checklossrate',0,1,NULL);
844
845
846
847
848
849
REPLACE INTO table_regex VALUES ('virt_lans','cost','float','redirect','default:float',0,1,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','widearea','int','redirect','default:boolean',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','emulated','int','redirect','default:boolean',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','uselinkdelay','int','redirect','default:boolean',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','nobwshaping','int','redirect','default:boolean',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','usevethiface','int','redirect','default:boolean',0,0,NULL);
850
REPLACE INTO table_regex VALUES ('virt_lans','encap_style','text','redirect','experiments:encap_style',0,0,NULL);
851
REPLACE INTO table_regex VALUES ('virt_lans','trivial_ok','int','redirect','default:boolean',0,0,NULL);
852
853
854
855
856
REPLACE INTO table_regex VALUES ('virt_lans','traced','int','redirect','default:boolean',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','trace_type','text','regex','^(header|packet|monitor)$',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','trace_expr','text','redirect','default:text',1,255,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','trace_snaplen','int','redirect','default:int',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','trace_endnode','int','redirect','default:tinyint',0,1,NULL);
857
REPLACE INTO table_regex VALUES ('virt_lans','trace_db','int','redirect','default:tinyint',0,1,NULL);
Leigh B. Stoller's avatar
Leigh B. Stoller committed
858
REPLACE INTO table_regex VALUES ('virt_lans','fixed_iface','text','redirect','default:tinytext',0,128,NULL);
Russ Fish's avatar
Russ Fish committed
859
REPLACE INTO table_regex VALUES ('virt_lans','modbase','int','redirect','default:boolean',0,0,NULL);
860
REPLACE INTO table_regex VALUES ('virt_lans','compat','int','redirect','default:boolean',0,0,NULL);
861
REPLACE INTO table_regex VALUES ('virt_lans','layer','int','redirect','default:tinyint',1,2,NULL);
862
863
REPLACE INTO table_regex VALUES ('virt_lans','ofenabled','int','redirect','default:boolean',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_lans','ofcontroller','text','redirect','default:tinytext',0,0,NULL);
864

865
866
867
868
869
870
871
872
873
REPLACE INTO table_regex VALUES ('virt_node_disks','pid','text','redirect','projects:pid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_node_disks','eid','text','redirect','experiments:eid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_node_disks','vname','text','redirect','virt_nodes:vname',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_node_disks','diskname','text','regex','^[-\\w]+$',2,32,NULL);
REPLACE INTO table_regex VALUES ('virt_node_disks','disktype','text','regex','^[-\\w]+$',2,32,NULL);
REPLACE INTO table_regex VALUES ('virt_node_disks','mountpoint','text','redirect','default:tinytext',1,255,NULL);
REPLACE INTO table_regex VALUES ('virt_node_disks','parameters','text','redirect','default:tinytext',1,255,NULL);
REPLACE INTO table_regex VALUES ('virt_node_disks','command','text','redirect','default:tinytext',1,255,NULL);

874
875
876
877
REPLACE INTO table_regex VALUES ('virt_node_attributes','pid','text','redirect','projects:pid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_node_attributes','eid','text','redirect','experiments:eid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_node_attributes','vname','text','redirect','virt_nodes:vname',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_node_attributes','attrkey','text','regex','^[-\\w]+$',1,64,NULL);
878
REPLACE INTO table_regex VALUES ('virt_node_attributes','attrvalue','text','regex','^[-\\w\\.\\+,\\s\\/:]+$',0,255,NULL);
879

880
881
882
REPLACE INTO table_regex VALUES ('virt_node_desires','pid','text','redirect','projects:pid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_node_desires','eid','text','redirect','experiments:eid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_node_desires','vname','text','redirect','virt_nodes:vname',0,0,NULL);
883
REPLACE INTO table_regex VALUES ('virt_node_desires','desire','text','regex','^[\\?\\*]?[\\+\\!\\&]?[-\\w?+]+$',1,64,NULL);
884
REPLACE INTO table_regex VALUES ('virt_node_desires','weight','int','redirect','default:float',0,0,NULL);
885
886
REPLACE INTO table_regex VALUES ('virt_nodes','pid','text','redirect','projects:pid',0,0,NULL);
REPLACE INTO table_regex VALUES ('virt_nodes','eid','text','redirect','experiments:eid',0,0,NULL);
887
REPLACE INTO table_regex VALUES ('virt_nodes','ips','text','regex','^(\\d{1,2}:\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3} {0,1})*$',0,2048,NULL);
888
REPLACE INTO table_regex VALUES ('virt_nodes','cmd_line','text','redi