database-fill.sql 25.6 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
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');
51
REPLACE INTO comments VALUES ('foo','bar','baz');
52
53
54
55
56
57
58
59
60
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');
61

62
63
64
65
--
-- Dumping data for table 'event_eventtypes'
--

66
67
68
69
70
71
72
73
74
75
76

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');
77
78
79
REPLACE INTO event_eventtypes VALUES (10,'KILL');
REPLACE INTO event_eventtypes VALUES (11,'HALT');
REPLACE INTO event_eventtypes VALUES (12,'SWAPOUT');
80

81
82
83
84
--
-- Dumping data for table 'event_objecttypes'
--

85
86
87
88
89
90

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');
91
REPLACE INTO event_objecttypes VALUES (5,'FRISBEE');
92
REPLACE INTO event_objecttypes VALUES (6,'SIMULATOR');
93

94
95
96
97
--
-- Dumping data for table 'exported_tables'
--

98
99
100
101
102
103

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');
104
REPLACE INTO exported_tables VALUES ('mode_transitions');
105
106
REPLACE INTO exported_tables VALUES ('state_timeouts');
REPLACE INTO exported_tables VALUES ('state_transitions');
107
REPLACE INTO exported_tables VALUES ('state_triggers');
108
109
110
REPLACE INTO exported_tables VALUES ('testsuite_preentables');
REPLACE INTO exported_tables VALUES ('webdb_table_permissions');

111
112
113
114
--
-- Dumping data for table 'foreign_keys'
--

115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171

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

172
173
174
175
--
-- Dumping data for table 'mode_transitions'
--

176

177
REPLACE INTO mode_transitions VALUES ('MINIMAL','SHUTDOWN','NETBOOT','SHUTDOWN');
178
179
180
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');
181
182
183
184
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');
185
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','MINIMAL','SHUTDOWN');
186
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','NETBOOT','SHUTDOWN');
187
188
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','NORMALv1','SHUTDOWN');
REPLACE INTO mode_transitions VALUES ('NORMAL','REBOOTING','RELOAD','SHUTDOWN');
189
190
191
192
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');
193
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','MINIMAL','SHUTDOWN');
194
REPLACE INTO mode_transitions VALUES ('NORMALv1','SHUTDOWN','NETBOOT','SHUTDOWN');
195
196
197
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');
198
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','NETBOOT','SHUTDOWN');
199
200
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','NORMAL','REBOOTING');
REPLACE INTO mode_transitions VALUES ('RELOAD','RELOADDONE','NORMALv1','SHUTDOWN');
201
202
203
204
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');
205

206
207
208
--
-- Dumping data for table 'state_timeouts'
--
209

210
211

REPLACE INTO state_timeouts VALUES ('NORMAL','REBOOTING',120,'REBOOT');
212
REPLACE INTO state_timeouts VALUES ('NORMAL','REBOOTED',60,'NOTIFY');
213
REPLACE INTO state_timeouts VALUES ('NORMAL','ISUP',0,'');
214
215
216
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');
217
218
219
220
221
222
223
224
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,'');
225
REPLACE INTO state_timeouts VALUES ('MINIMAL','BOOTING',180,'REBOOT');
226
227
228
229
230
231
REPLACE INTO state_timeouts VALUES ('MINIMAL','ISUP',0,'');
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,'');
232
233
REPLACE INTO state_timeouts VALUES ('NORMAL','BOOTING',180,'REBOOT');
REPLACE INTO state_timeouts VALUES ('NORMALv1','BOOTING',180,'REBOOT');
234
REPLACE INTO state_timeouts VALUES ('NORMALv1','ISUP',0,'');
235
REPLACE INTO state_timeouts VALUES ('NORMALv1','TBSETUP',600,'NOTIFY');
236
REPLACE INTO state_timeouts VALUES ('RELOAD','BOOTING',180,'REBOOT');
237
REPLACE INTO state_timeouts VALUES ('RELOAD','RELOADING',600,'NOTIFY');
238
239
REPLACE INTO state_timeouts VALUES ('RELOAD','RELOADSETUP',60,'NOTIFY');
REPLACE INTO state_timeouts VALUES ('RELOAD','SHUTDOWN',120,'REBOOT');
240
241
242
243
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,'');
244
245
246
247
REPLACE INTO state_timeouts VALUES ('TBCOMMAND','REBOOT',15,'CMDRETRY');
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');
Mac Newbold's avatar
Mac Newbold committed
248
249
250
251
REPLACE INTO state_timeouts VALUES ('PCVM','BOOTING',180,'NOTIFY');
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');
252

253
254
255
256
--
-- Dumping data for table 'state_transitions'
--

257

258
259
REPLACE INTO state_transitions VALUES ('ALWAYSUP','ISUP','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('ALWAYSUP','SHUTDOWN','ISUP');
260
261
262
263
264
265
266
267
268
269
270
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');
271
REPLACE INTO state_transitions VALUES ('MINIMAL','BOOTING','BOOTING');
272
273
REPLACE INTO state_transitions VALUES ('MINIMAL','BOOTING','ISUP');
REPLACE INTO state_transitions VALUES ('MINIMAL','BOOTING','SHUTDOWN');
Mac Newbold's avatar
Mac Newbold committed
274
REPLACE INTO state_transitions VALUES ('MINIMAL','ISUP','BOOTING');
275
276
277
REPLACE INTO state_transitions VALUES ('MINIMAL','ISUP','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('MINIMAL','SHUTDOWN','BOOTING');
REPLACE INTO state_transitions VALUES ('MINIMAL','SHUTDOWN','SHUTDOWN');
278
279
280
281
282
283
284
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');
285
286
287
288
289
290
291
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');
292
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','BOOTING');
Mac Newbold's avatar
Mac Newbold committed
293
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','REBOOTED');
294
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','REBOOTING');
295
REPLACE INTO state_transitions VALUES ('NORMAL','BOOTING','SHUTDOWN');
296
REPLACE INTO state_transitions VALUES ('NORMAL','ISUP','REBOOTING');
297
REPLACE INTO state_transitions VALUES ('NORMAL','ISUP','SHUTDOWN');
Mac Newbold's avatar
Mac Newbold committed
298
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','BOOTING');
299
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','ISUP');
300
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','REBOOTING');
301
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTED','SHUTDOWN');
Mac Newbold's avatar
Mac Newbold committed
302
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTING','BOOTING');
303
REPLACE INTO state_transitions VALUES ('NORMAL','REBOOTING','REBOOTING');
304
305
306
307
308
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');
309
REPLACE INTO state_transitions VALUES ('NORMALv1','BOOTING','SHUTDOWN');
310
REPLACE INTO state_transitions VALUES ('NORMALv1','BOOTING','TBSETUP');
311
REPLACE INTO state_transitions VALUES ('NORMALv1','ISUP','BOOTING');
312
313
314
315
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');
316
REPLACE INTO state_transitions VALUES ('NORMALv1','TBSETUP','SHUTDOWN');
Mac Newbold's avatar
Mac Newbold committed
317
318
319
320
321
322
REPLACE INTO state_transitions VALUES ('PCVM','BOOTING','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('PCVM','BOOTING','TBSETUP');
REPLACE INTO state_transitions VALUES ('PCVM','ISUP','SHUTDOWN');
REPLACE INTO state_transitions VALUES ('PCVM','SHUTDOWN','BOOTING');
REPLACE INTO state_transitions VALUES ('PCVM','TBSETUP','ISUP');
REPLACE INTO state_transitions VALUES ('PCVM','TBSETUP','SHUTDOWN');
323
REPLACE INTO state_transitions VALUES ('RELOAD','BOOTING','BOOTING');
324
REPLACE INTO state_transitions VALUES ('RELOAD','BOOTING','RELOADSETUP');
325
REPLACE INTO state_transitions VALUES ('RELOAD','BOOTING','SHUTDOWN');
326
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADING','RELOADDONE');
327
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADING','SHUTDOWN');
328
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADSETUP','RELOADING');
329
REPLACE INTO state_transitions VALUES ('RELOAD','RELOADSETUP','SHUTDOWN');
330
REPLACE INTO state_transitions VALUES ('RELOAD','SHUTDOWN','BOOTING');
331
REPLACE INTO state_transitions VALUES ('RELOAD','SHUTDOWN','SHUTDOWN');
332
333
334
335
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');
336
337
REPLACE INTO state_transitions VALUES ('WIDEAREA','BOOTING','REBOOTED');
REPLACE INTO state_transitions VALUES ('WIDEAREA','BOOTING','REBOOTING');
338
REPLACE INTO state_transitions VALUES ('WIDEAREA','BOOTING','SHUTDOWN');
339
340
REPLACE INTO state_transitions VALUES ('WIDEAREA','ISUP','REBOOTED');
REPLACE INTO state_transitions VALUES ('WIDEAREA','ISUP','REBOOTING');
341
REPLACE INTO state_transitions VALUES ('WIDEAREA','ISUP','SHUTDOWN');
342
343
344
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTED','BOOTING');
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTED','ISUP');
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTED','REBOOTING');
345
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTED','SHUTDOWN');
346
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTING','BOOTING');
347
348
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTING','REBOOTED');
REPLACE INTO state_transitions VALUES ('WIDEAREA','REBOOTING','REBOOTING');
349
350
351
REPLACE INTO state_transitions VALUES ('WIDEAREA','SHUTDOWN','BOOTING');
REPLACE INTO state_transitions VALUES ('WIDEAREA','SHUTDOWN','REBOOTED');
REPLACE INTO state_transitions VALUES ('WIDEAREA','SHUTDOWN','SHUTDOWN');
352

353
354
355
356
--
-- Dumping data for table 'state_triggers'
--

Mac Newbold's avatar
Mac Newbold committed
357

358
359
360
361
REPLACE INTO state_triggers VALUES ('*','NORMAL','ISUP','RESET');
REPLACE INTO state_triggers VALUES ('*','NORMALv1','ISUP','RESET');
REPLACE INTO state_triggers VALUES ('*','MINIMAL','ISUP','RESET');
REPLACE INTO state_triggers VALUES ('*','RELOAD','RELOADDONE','RESET, RELOADDONE');
362
REPLACE INTO state_triggers VALUES ('*','ALWAYSUP','SHUTDOWN','ISUP');
Mac Newbold's avatar
Mac Newbold committed
363
REPLACE INTO state_triggers VALUES ('*','PCVM','ISUP','RESET');
Mac Newbold's avatar
Mac Newbold committed
364

365
366
367
368
--
-- Dumping data for table 'testsuite_preentables'
--

369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386

REPLACE INTO testsuite_preentables VALUES ('comments','drop');
REPLACE INTO testsuite_preentables VALUES ('iface_counters','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');
387
388
389
390
391
392
393
394
REPLACE INTO testsuite_preentables VALUES ('user_sfskeys','clean');
REPLACE INTO testsuite_preentables VALUES ('user_pubkeys','clean');
REPLACE INTO testsuite_preentables VALUES ('port_counters','drop');
REPLACE INTO testsuite_preentables VALUES ('images','prune');
REPLACE INTO testsuite_preentables VALUES ('os_info','prune');
REPLACE INTO testsuite_preentables VALUES ('node_activity','clean');
REPLACE INTO testsuite_preentables VALUES ('portmap','clean');
REPLACE INTO testsuite_preentables VALUES ('webnews','clean');
395
REPLACE INTO testsuite_preentables VALUES ('vis_nodes','clean');
396
REPLACE INTO testsuite_preentables VALUES ('vis_experiments','clean');
397
398
399
400
REPLACE INTO testsuite_preentables VALUES ('group_stats','clean');
REPLACE INTO testsuite_preentables VALUES ('project_stats','clean');
REPLACE INTO testsuite_preentables VALUES ('user_stats','clean');
REPLACE INTO testsuite_preentables VALUES ('experiment_stats','clean');
401
REPLACE INTO testsuite_preentables VALUES ('experiment_resources','clean');
402
REPLACE INTO testsuite_preentables VALUES ('testbed_stats','clean');
403

404
405
406
407
--
-- Dumping data for table 'webdb_table_permissions'
--

408
409
410

REPLACE INTO webdb_table_permissions VALUES ('comments',1,1,1);
REPLACE INTO webdb_table_permissions VALUES ('foreign_keys',1,1,1);
411
REPLACE INTO webdb_table_permissions VALUES ('images',1,0,1);
412
413
414
415
416
417
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);
418
REPLACE INTO webdb_table_permissions VALUES ('os_info',1,1,1);
419
REPLACE INTO webdb_table_permissions VALUES ('projects',1,1,0);
420
REPLACE INTO webdb_table_permissions VALUES ('osidtoimageid',1,0,1);
421