Revision 2599
Added by Matt Jones almost 19 years ago
drop-postgres.sql | ||
---|---|---|
7 | 7 |
* '$Date$' |
8 | 8 |
* '$Revision$' |
9 | 9 |
* |
10 |
* This program is free software; you can redistribute it and/or modify
|
|
10 |
* This program is free software, you can redistribute it and/or modify
|
|
11 | 11 |
* it under the terms of the GNU General Public License as published by |
12 |
* the Free Software Foundation; either version 2 of the License, or
|
|
12 |
* the Free Software Foundation, either version 2 of the License, or
|
|
13 | 13 |
* (at your option) any later version. |
14 | 14 |
* |
15 | 15 |
* This program is distributed in the hope that it will be useful, |
16 |
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
16 |
* but WITHOUT ANY WARRANTY, without even the implied warranty of
|
|
17 | 17 |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
18 | 18 |
* GNU General Public License for more details. |
19 | 19 |
* |
20 | 20 |
* You should have received a copy of the GNU General Public License |
21 |
* along with this program; if not, write to the Free Software
|
|
21 |
* along with this program, if not, write to the Free Software
|
|
22 | 22 |
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
23 | 23 |
*/ |
24 | 24 |
|
... | ... | |
43 | 43 |
DROP SEQUENCE access_log_id_seq; |
44 | 44 |
DROP SEQUENCE xml_queryresult_id_seq; |
45 | 45 |
DROP SEQUENCE xml_returnfield_id_seq; |
46 |
DROP SEQUENCE xml_path_index_id_seq; |
|
46 | 47 |
|
47 | 48 |
DROP TABLE xml_index; |
48 | 49 |
DROP TABLE xml_access; |
49 | 50 |
DROP TABLE xml_accesssubtree; |
50 | 51 |
DROP TABLE xml_revisions; |
51 | 52 |
DROP TABLE xml_relation; |
52 |
DROP TABLE xml_documents; |
|
53 |
DROP TABLE xml_documents CASCADE;
|
|
53 | 54 |
DROP TABLE xml_nodes; |
55 |
DROP TABLE xml_nodes_revisions; |
|
54 | 56 |
DROP TABLE xml_replication; |
55 | 57 |
DROP TABLE xml_catalog; |
56 | 58 |
DROP TABLE accession_number; |
... | ... | |
60 | 62 |
DROP TABLE harvest_log; |
61 | 63 |
DROP TABLE xml_queryresult; |
62 | 64 |
DROP TABLE xml_returnfield; |
65 |
DROP TABLE xml_path_index; |
Also available in: Unified diff
Refactored the build to use a <path> element for the classpath rather
than ant properties. This makes the classpath easier to manage, but required
changes throughout the build. I think everything should still build fine --
it works for me.
Upgraded the JDBC driver for postgres to the version 8 driver.
Fixed problems with the postgres SQL scripts that were preventing them
from being run from ant. Works for me now, but looks like the oracle
scripts might be missing a few tables from its drop list.