| shockjiang | a5ae48c | 2014-07-27 23:21:41 -0700 | [diff] [blame] | 1 | |
| 2 | delete from rrs; |
| 3 | delete from rrsets; |
| 4 | delete from zones; |
| 5 | |
| 6 | insert into zones (id, name) values |
| 7 | (1, "/"), |
| 8 | (2, "/net"), |
| 9 | (3, "/net/ndnsim"), |
| 10 | (4, "/dns/google/com"), |
| 11 | (5, "/net/ndnsim/git/doc") |
| 12 | ; |
| 13 | |
| 14 | insert into rrsets (id, zone_id, label, class, type, ndndata) values |
| 15 | (1, 3, "/www", NULL, "TXT", NULL), |
| 16 | (2, 3, "/doc", NULL, "TXT", NULL), |
| 17 | (3, 2, "/ndnsim", NULL, "NS", NULL), |
| 18 | (4, 1, "/net", NULL, "NS", NULL), |
| 19 | (5, 4, "/net", NULL, "NS", NULL), |
| 20 | (6, 3, "/git/www", NULL, "TXT", NULL), |
| 21 | (7, 3, "/git/doc", NULL, "NS", NULL), |
| 22 | (8, 5, "/www", NULL, "TXT", NULL), |
| 23 | (9, 3, "/repo/www", NULL, "TXT", NULL), |
| 24 | (10, 3, "/norrdata", NULL, "TXT", NULL) |
| 25 | ; |
| 26 | |
| 27 | |
| 28 | insert into rrs (id, rrset_id, ttl, rrdata) values |
| 29 | (1, 1, 3600, "/ucla"), |
| 30 | (2, 1, 8000, "/att"), |
| 31 | (3, 2, 3600, "/ucla"), |
| 32 | (4, 3, 4000, "/net/ndnsim2"), |
| 33 | (5, 4, 5000, "/net"), |
| 34 | (6, 5, 6000, "/net"), |
| 35 | (7, 3, 4000, "/net/ndnsim"), |
| 36 | (8, 6, 3000, "/net/ndnsim/git/www"), |
| 37 | (9, 7, 3000, "/net/ndnsim/git/doc"), |
| 38 | (10,8, 3000, "/net/ndnsim/git/doc/www"), |
| 39 | (11,9, 3000, "/net/ndnsim/repo/www") |
| 40 | ; |