Context Navigation

dropall.sql

Last change on this file was 944, checked in by Kris Deugau, 22 hours ago

/trunk/t

Add calls to wipe and reload a consistent minimal DB for testing
Add SQL files to drop and reload tables
See #88

File size: 878 bytes

Line
1	-- warning: drops all tables in dnsdb!
2
3	DROP TABLE default_records;
4	DROP TABLE default_rev_records;
5	DROP TABLE log;
6	DROP TABLE misc;
7	DROP TABLE permissions;
8	DROP TABLE records;
9	DROP TABLE domains;
10	DROP TABLE rectypes;
11	DROP TABLE revzones;
12	DROP TABLE users;
13	DROP TABLE locations;
14	DROP TABLE groups;
15	DROP TABLE refresh_zones;
16	DROP TABLE secondary_zones;
17	-- wtf?
18	DROP TABLE rtest;
19
20	DROP SEQUENCE default_records_record_id_seq;
21	DROP SEQUENCE default_rev_records_record_id_seq;
22	DROP SEQUENCE log_log_id_seq;
23	DROP SEQUENCE misc_misc_id_seq;
24	DROP SEQUENCE permissions_permission_id_seq;
25	DROP SEQUENCE records_record_id_seq;
26	DROP SEQUENCE domains_domain_id_seq;
27	DROP SEQUENCE revzones_rdns_id_seq;
28	DROP SEQUENCE users_user_id_seq;
29	DROP SEQUENCE locations_loc_id_seq;
30	DROP SEQUENCE groups_group_id_seq;
31	DROP SEQUENCE secondaryzones_secondary_id_seq;
32	DROP FUNCTION inetlazy(rdata text);

Note: See TracBrowser for help on using the repository browser.