Topic: Create SQL Scripts for All Tables
Is there a file with all the create table scripts for Postgres including the RAW files and all other dump files on the servers here somewhere? I can't locate the files.
Thanks,
Allison
2 2012-07-11 14:40:56 (edited by InvisibleMan78 2012-07-11 14:42:08)
Re: Create SQL Scripts for All Tables
You could have a look here: https://github.com/metabrainz/musicbrai … /admin/sql
You find the dump files here: ftp://ftp.musicbrainz.org/pub/musicbrai … ullexport/
Re: Create SQL Scripts for All Tables
The top one worked except this particular table create- CREATE TABLE tracklist_index ( tracklist INTEGER, -- PK toc CUBE);
Apparently my server doesn't know what a CUBE is. It's a Windows Postgres 9.1 installation
Do you know where the scripts for create table for the CDStubs, Editor dumps might be?
Than you so much!
Re: Create SQL Scripts for All Tables
ignore my last for the CDStubs. That script seems to have all fields in it and all of the dump needs. Thanks again! Any ideas on the CUBE error perchance>?
Re: Create SQL Scripts for All Tables
allison wrote:
Any ideas on the CUBE error perchance?
Unfortunately, not... :(
Re: Create SQL Scripts for All Tables
CREATE EXTENSION cube WITH SCHEMA public;