database-fill.sql 27.4 KB
Newer Older
1
2
3
4
5
6
7
8
9
-- MySQL dump 8.22
--
-- Host: localhost    Database: tbdb
---------------------------------------------------------
-- Server version	3.23.54-log

--
-- Dumping data for table 'comments'
--
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


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

110
111
112
113
--
-- Dumping data for table 'event_eventtypes'
--

114
115
116
117
118
119
120
121
122
123
124
125

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');

126
127
128
129
--
-- Dumping data for table 'event_objecttypes'
--

130
131
132
133
134
135

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');
136
REPLACE INTO event_objecttypes VALUES (5,'FRISBEE');
137

138
139
140
141
--
-- Dumping data for table 'exported_tables'
--

142
143
144
145
146
147

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');
148
REPLACE INTO exported_tables VALUES ('mode_transitions');
149
150
REPLACE INTO exported_tables VALUES ('state_timeouts');
REPLACE INTO exported_tables VALUES ('state_transitions');
151
REPLACE INTO exported_tables VALUES ('state_triggers');
152
153
154
REPLACE INTO exported_tables VALUES ('testsuite_preentables');
REPLACE INTO exported_tables VALUES ('webdb_table_permissions');

155
156
157
158
--
-- Dumping data for table 'foreign_keys'
--

159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215

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');

216
217
218
219
--
-- Dumping data for table 'mode_transitions'
--

220

221
REPLACE INTO mode_transitions VALUES ('MINIMAL','SHUTDOWN','NETBOOT','SHUTDOWN');
222
223
224
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');
225
226
227
228
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');
229
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','MINIMAL','SHUTDOWN');
230
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','NETBOOT','SHUTDOWN');
231
232
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','NORMALv1','SHUTDOWN');
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','RELOAD','SHUTDOWN');
233
234
235
236
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');
237
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','MINIMAL','SHUTDOWN');
238
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','NETBOOT','SHUTDOWN');
239
240
241
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');
242
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','NETBOOT','SHUTDOWN');
243
244
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','NORMAL','REBOOTING');
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','NORMALv1','SHUTDOWN');
245
246
247
248
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');
249

250
251
252
--
-- Dumping data for table 'state_timeouts'
--
253

254
255
256

REPLACE INTO state_timeouts VALUES ('NORMAL','REBOOTING',120,'REBOOT');
REPLACE INTO state_timeouts VALUES ('NORMAL','REBOOTED',60,'NOTIFY');
257
REPLACE INTO state_timeouts VALUES ('NORMAL','ISUP',0,NULL);
258
259
260
261
262
263
264
265
266
267
268
REPLACE INTO state_timeouts VALUES ('MINIMAL','SHUTDOWN',120,'REBOOT');
REPLACE INTO state_timeouts VALUES ('NORMALv1','SHUTDOWN',120,'REBOOT');
REPLACE INTO state_timeouts VALUES ('RELOAD','RELOADDONE',60,'NOTIFY');
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','ACTIVATING',0,NULL);
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','ACTIVE',0,NULL);
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','NEW',0,NULL);
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','PRERUN',0,NULL);
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','SWAPPED',0,NULL);
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','SWAPPING',0,NULL);
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','TERMINATING',0,NULL);
REPLACE INTO state_timeouts VALUES ('EXPTSTATUS','TESTING',0,NULL);
269
REPLACE INTO state_timeouts VALUES ('MINIMAL','BOOTING',180,'REBOOT');
270
271
272
273
274
275
REPLACE INTO state_timeouts VALUES ('MINIMAL','ISUP',0,NULL);
REPLACE INTO state_timeouts VALUES ('NODEALLOC','FREE_CLEAN',0,NULL);
REPLACE INTO state_timeouts VALUES ('NODEALLOC','FREE_DIRTY',0,NULL);
REPLACE INTO state_timeouts VALUES ('NODEALLOC','REBOOT',0,NULL);
REPLACE INTO state_timeouts VALUES ('NODEALLOC','RELOAD',0,NULL);
REPLACE INTO state_timeouts VALUES ('NODEALLOC','RESERVED',0,NULL);
276
277
REPLACE INTO state_timeouts VALUES ('NORMAL','BOOTING',180,'REBOOT');
REPLACE INTO state_timeouts VALUES ('NORMALv1','BOOTING',180,'REBOOT');
278
REPLACE INTO state_timeouts VALUES ('NORMALv1','ISUP',0,NULL);
279
REPLACE INTO state_timeouts VALUES ('NORMALv1','TBSETUP',120,'NOTIFY');
280
REPLACE INTO state_timeouts VALUES ('RELOAD','BOOTING',180,'REBOOT');
281
REPLACE INTO state_timeouts VALUES ('RELOAD','RELOADING',600,'NOTIFY');
282
283
284
285
286
287
REPLACE INTO state_timeouts VALUES ('RELOAD','RELOADSETUP',60,'NOTIFY');
REPLACE INTO state_timeouts VALUES ('RELOAD','SHUTDOWN',120,'REBOOT');
REPLACE INTO state_timeouts VALUES ('USERSTATUS','ACTIVE',0,NULL);
REPLACE INTO state_timeouts VALUES ('USERSTATUS','FROZEN',0,NULL);
REPLACE INTO state_timeouts VALUES ('USERSTATUS','NEWUSER',0,NULL);
REPLACE INTO state_timeouts VALUES ('USERSTATUS','UNAPPROVED',0,NULL);
288

289
290
291
292
--
-- Dumping data for table 'state_transitions'
--

293

294
295
296
297
298
299
300
301
302
303
304
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','ACTIVATING','ACTIVE');
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','ACTIVATING','SWAPPED');
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','ACTIVATING','TESTING');
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','ACTIVE','SWAPPING');
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','NEW','PRERUN');
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','PRERUN','SWAPPED');
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','SWAPPED','ACTIVATING');
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','SWAPPED','TERMINATING');
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','SWAPPING','SWAPPED');
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','TERMINATING','TERMINATED');
REPLACE INTO state_transitions VALUES ('EXPTSTATUS','TESTING','SWAPPING');
305
REPLACE INTO state_transitions VALUES ('MINIMAL','BOOTING','BOOTING');
306
307
308
309
310
REPLACE INTO state_transitions VALUES ('MINIMAL','BOOTING','ISUP');
REPLACE INTO state_transitions VALUES ('MINIMAL','BOOTING','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('MINIMAL','ISUP','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('MINIMAL','SHUTDOWN','BOOTING');
REPLACE INTO state_transitions VALUES ('MINIMAL','SHUTDOWN','SHUTDOWN');
311
312
313
314
315
316
317
REPLACE INTO state_transitions VALUES ('NETBOOT','BOOTING','ISUP');
REPLACE INTO state_transitions VALUES ('NETBOOT','BOOTING','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('NETBOOT','ISUP','BOOTING');
REPLACE INTO state_transitions VALUES ('NETBOOT','ISUP','ISUP');
REPLACE INTO state_transitions VALUES ('NETBOOT','ISUP','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('NETBOOT','SHUTDOWN','BOOTING');
REPLACE INTO state_transitions VALUES ('NETBOOT','SHUTDOWN','SHUTDOWN');
318
319
320
321
322
323
324
REPLACE INTO state_transitions VALUES ('NODEALLOC','FREE_CLEAN','RESERVED');
REPLACE INTO state_transitions VALUES ('NODEALLOC','FREE_DIRTY','RELOAD');
REPLACE INTO state_transitions VALUES ('NODEALLOC','FREE_DIRTY','RESERVED');
REPLACE INTO state_transitions VALUES ('NODEALLOC','REBOOT','FREE_DIRTY');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RELOAD','FREE_CLEAN');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RESERVED','REBOOT');
REPLACE INTO state_transitions VALUES ('NODEALLOC','RESERVED','RELOAD');
325
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','BOOTING');
Mac Newbold's avatar
Mac Newbold committed
326
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','REBOOTED');
327
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','REBOOTING');
328
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','SHUTDOWN');
329
REPLACE INTO state_transitions VALUES ('NORMAL','ISUP','REBOOTING');
330
REPLACE INTO state_transitions VALUES ('NORMAL','ISUP','SHUTDOWN');
Mac Newbold's avatar
Mac Newbold committed
331
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','BOOTING');
332
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','ISUP');
333
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','REBOOTING');
334
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','SHUTDOWN');
Mac Newbold's avatar
Mac Newbold committed
335
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTING','BOOTING');
336
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTING','REBOOTING');
337
338
339
340
341
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTING','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('NORMAL','SHUTDOWN','BOOTING');
REPLACE INTO state_transitions VALUES ('NORMAL','SHUTDOWN','REBOOTING');
REPLACE INTO state_transitions VALUES ('NORMAL','SHUTDOWN','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('NORMALv1','BOOTING','BOOTING');
342
REPLACE INTO state_transitions VALUES ('NORMALv1','BOOTING','SHUTDOWN');
343
REPLACE INTO state_transitions VALUES ('NORMALv1','BOOTING','TBSETUP');
344
REPLACE INTO state_transitions VALUES ('NORMALv1','ISUP','BOOTING');
345
346
347
348
REPLACE INTO state_transitions VALUES ('NORMALv1','ISUP','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('NORMALv1','SHUTDOWN','BOOTING');
REPLACE INTO state_transitions VALUES ('NORMALv1','SHUTDOWN','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('NORMALv1','TBSETUP','ISUP');
349
REPLACE INTO state_transitions VALUES ('NORMALv1','TBSETUP','SHUTDOWN');
350
REPLACE INTO state_transitions VALUES ('RELOAD','BOOTING','BOOTING');
351
REPLACE INTO state_transitions VALUES ('RELOAD','BOOTING','RELOADSETUP');
352
REPLACE INTO state_transitions VALUES ('RELOAD','BOOTING','SHUTDOWN');
353
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADING','RELOADDONE');
354
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADING','SHUTDOWN');
355
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADSETUP','RELOADING');
356
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADSETUP','SHUTDOWN');
357
REPLACE INTO state_transitions VALUES ('RELOAD','SHUTDOWN','BOOTING');
358
REPLACE INTO state_transitions VALUES ('RELOAD','SHUTDOWN','SHUTDOWN');
359
360
361
362
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');
363
364
REPLACE INTO state_transitions VALUES ('WIDEAREA','BOOTING','REBOOTED');
REPLACE INTO state_transitions VALUES ('WIDEAREA','BOOTING','REBOOTING');
365
REPLACE INTO state_transitions VALUES ('WIDEAREA','BOOTING','SHUTDOWN');
366
367
REPLACE INTO state_transitions VALUES ('WIDEAREA','ISUP','REBOOTED');
REPLACE INTO state_transitions VALUES ('WIDEAREA','ISUP','REBOOTING');
368
REPLACE INTO state_transitions VALUES ('WIDEAREA','ISUP','SHUTDOWN');
369
370
371
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTED','BOOTING');
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTED','ISUP');
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTED','REBOOTING');
372
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTED','SHUTDOWN');
373
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTING','BOOTING');
374
375
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTING','REBOOTED');
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTING','REBOOTING');
376
377
378
REPLACE INTO state_transitions VALUES ('WIDEAREA','SHUTDOWN','BOOTING');
REPLACE INTO state_transitions VALUES ('WIDEAREA','SHUTDOWN','REBOOTED');
REPLACE INTO state_transitions VALUES ('WIDEAREA','SHUTDOWN','SHUTDOWN');
379

380
381
382
383
--
-- Dumping data for table 'state_triggers'
--

Mac Newbold's avatar
Mac Newbold committed
384
385
386
387

REPLACE INTO state_triggers VALUES ('NORMAL','ISUP','RESET');
REPLACE INTO state_triggers VALUES ('NORMALv1','ISUP','RESET');
REPLACE INTO state_triggers VALUES ('MINIMAL','ISUP','RESET');
388
REPLACE INTO state_triggers VALUES ('RELOAD','RELOADDONE','RESET, RELOADDONE');
Mac Newbold's avatar
Mac Newbold committed
389

390
391
392
393
--
-- Dumping data for table 'testsuite_preentables'
--

394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413

REPLACE INTO testsuite_preentables VALUES ('comments','drop');
REPLACE INTO testsuite_preentables VALUES ('iface_counters','drop');
REPLACE INTO testsuite_preentables VALUES ('lastlogin','drop');
REPLACE INTO testsuite_preentables VALUES ('login','drop');
REPLACE INTO testsuite_preentables VALUES ('loginmessage','drop');
REPLACE INTO testsuite_preentables VALUES ('node_idlestats','drop');
REPLACE INTO testsuite_preentables VALUES ('nodelog','drop');
REPLACE INTO testsuite_preentables VALUES ('nodeuidlastlogin','drop');
REPLACE INTO testsuite_preentables VALUES ('nologins','drop');
REPLACE INTO testsuite_preentables VALUES ('userslastlogin','drop');
REPLACE INTO testsuite_preentables VALUES ('uidnodelastlogin','drop');
REPLACE INTO testsuite_preentables VALUES ('next_reserve','clean');
REPLACE INTO testsuite_preentables VALUES ('last_reservation','clean');
REPLACE INTO testsuite_preentables VALUES ('current_reloads','clean');
REPLACE INTO testsuite_preentables VALUES ('scheduled_reloads','clean');
REPLACE INTO testsuite_preentables VALUES ('projects','prune');
REPLACE INTO testsuite_preentables VALUES ('group_membership','prune');
REPLACE INTO testsuite_preentables VALUES ('groups','prune');

414
415
416
417
--
-- Dumping data for table 'webdb_table_permissions'
--

418
419
420

REPLACE INTO webdb_table_permissions VALUES ('comments',1,1,1);
REPLACE INTO webdb_table_permissions VALUES ('foreign_keys',1,1,1);
421
REPLACE INTO webdb_table_permissions VALUES ('images',1,0,1);
422
423
424
425
426
427
REPLACE INTO webdb_table_permissions VALUES ('interfaces',1,1,1);
REPLACE INTO webdb_table_permissions VALUES ('interface_types',1,1,1);
REPLACE INTO webdb_table_permissions VALUES ('lastlogin',1,1,1);
REPLACE INTO webdb_table_permissions VALUES ('nodes',1,1,0);
REPLACE INTO webdb_table_permissions VALUES ('node_types',1,1,0);
REPLACE INTO webdb_table_permissions VALUES ('tiplines',1,1,1);
428
REPLACE INTO webdb_table_permissions VALUES ('os_info',1,1,1);
429
REPLACE INTO webdb_table_permissions VALUES ('projects',1,1,0);
430
REPLACE INTO webdb_table_permissions VALUES ('osidtoimageid',1,0,1);
431