Revision 2599
Added by Matt Jones almost 19 years ago
| xmltables-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 |
|
| 25 | 25 |
/* |
| 26 |
* this is sql script does the same as the sql script named
|
|
| 27 |
* xmltables.sql except that this script is to be use to
|
|
| 28 |
* create the database tables on a Postgresql backend rather
|
|
| 29 |
* than an Oracle Backend
|
|
| 26 |
* this is sql script does the same as the sql script named
|
|
| 27 |
* xmltables.sql except that this script is to be use to
|
|
| 28 |
* create the database tables on a Postgresql backend rather
|
|
| 29 |
* than an Oracle Backend
|
|
| 30 | 30 |
*/ |
| 31 | 31 |
|
| 32 | 32 |
/* |
| 33 |
*Replication -- table to store servers that metacat is replicated to |
|
| 33 |
* Replication -- table to store servers that metacat is replicated to
|
|
| 34 | 34 |
*/ |
| 35 | 35 |
CREATE SEQUENCE xml_replication_id_seq; |
| 36 | 36 |
CREATE TABLE xml_replication ( |
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.