darcs - gombemi

2 --

3 -- This file is part of Gombe-MI.

4 --

5 -- Gombe-MI is free software; you can redistribute it and/or modify

6 -- it under the terms of the GNU General Public License as published by

7 -- the Free Software Foundation; either version 3 of the License, or

8 -- (at your option) any later version.

9 --

10 -- This program is distributed in the hope that it will be useful,

11 -- but WITHOUT ANY WARRANTY; without even the implied warranty of

12 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

13 -- GNU General Public License for more details.

14 --

15 -- You should have received a copy of the GNU General Public License

16 -- along with Gombe-MI. If not, see <http://www.gnu.org/licenses/>.

17 --

18 -- Karl O. Pinc <kop@meme.com>

20 -- Remove all the data from all the tables.

22 -- Main tables

24 BEGIN;

26 DELETE FROM parts;

27 SELECT setval('parts_pid_seq'::regclass, 1, false);

29 DELETE FROM plays;

30 SELECT setval('plays_playid_seq'::regclass, 1, false);

32 DELETE FROM rides;

33 SELECT setval('rides_rideid_seq'::regclass, 1, false);

35 DELETE FROM rests;

36 SELECT setval('rests_restid_seq'::regclass, 1, false);

38 DELETE FROM eats;

39 SELECT setval('eats_eatid_seq'::regclass, 1, false);

41 DELETE FROM fished;

42 SELECT setval('fished_fishedid_seq'::regclass, 1, false);

44 DELETE FROM vocs;

45 SELECT setval('vocs_vocid_seq'::regclass, 1, false);

47 DELETE FROM events;

48 SELECT setval('events_eid_seq'::regclass, 1, false);

50 COMMIT;

52 BEGIN;

54 DELETE FROM distanceparts;

55 SELECT setval('distanceparts_dpid_seq'::regclass, 1, false);

57 DELETE FROM distances;

58 SELECT setval('distances_distid_seq'::regclass, 1, false);

60 COMMIT;

62 BEGIN;

64 DELETE FROM raw_groupmembers;

65 SELECT setval('raw_groupmembers_rgmid_seq'::regclass, 1, false);

67 DELETE FROM raw_groups;

68 SELECT setval('raw_groups_rgid_seq'::regclass, 1, false);

70 DELETE FROM groupmembers;

71 SELECT setval('groupmembers_gmid_seq'::regclass, 1, false);

73 DELETE FROM intervals;

74 SELECT setval('intervals_intid_seq'::regclass, 1, false);

76 DELETE FROM groups;

77 SELECT setval('groups_gid_seq'::regclass, 1, false);

79 DELETE FROM sheets;

80 SELECT setval('sheets_sheetid_seq'::regclass, 1, false);

82 SELECT setval('fieldfollows_ffid_seq'::regclass, 1, false);

84 DELETE FROM followparts;

85 SELECT setval('followparts_fpid_seq'::regclass, 1, false);

87 DELETE FROM follows;

88 SELECT setval('follows_followid_seq'::regclass, 1, false);

90 COMMIT;

92 DELETE FROM adoptions;

93 SELECT setval('adoptions_adoptid_seq'::regclass, 1, false);

95 DELETE FROM twins;

96 SELECT setval('twins_twinid_seq'::regclass, 1, false);

98 DELETE FROM community_membership;

100 BEGIN;

101 DELETE FROM chimpids;

102

103 DELETE FROM biography_data;

104 COMMIT;

105

106 -- Support tables.

107

108 DELETE FROM bddists;

109 DELETE FROM entrytypes;

110 DELETE FROM departtypes;

111 DELETE FROM followtypes;

112 DELETE FROM people;

113 DELETE FROM followroles;

114 DELETE FROM distancecodes;

115 DELETE FROM behaviors CASCADE;

116 DELETE FROM positions CASCADE;

117 DELETE FROM vocalizations CASCADE;

118 DELETE FROM foodparts CASCADE;

119 DELETE FROM foodkinds CASCADE;

120 DELETE FROM resting_postures CASCADE;

121 DELETE FROM riding_postures CASCADE;

122 DELETE FROM play_types CASCADE;

123 DELETE FROM fishing_results CASCADE;

124 DELETE FROM gcstatuses CASCADE;

125 DELETE FROM gm_origins CASCADE;

126

127

128 -- Warning system.

129

130 -- Main tables

131 DELETE FROM integrity_warnings;

132 SELECT setval('integrity_warnings_iwid_seq'::regclass, 1, false);

133

134 DELETE FROM integrity_queries;

135

136 -- Support tables

137 DELETE FROM iqtypes;

138 DELETE FROM warning_remarks;