X-Git-Url: http://matita.cs.unibo.it/gitweb/?p=helm.git;a=blobdiff_plain;f=helm%2Fmetadata%2Fpostgresql_V7_mowgli%2FREADME;fp=helm%2Fmetadata%2Fpostgresql_V7_mowgli%2FREADME;h=0000000000000000000000000000000000000000;hp=0d1b720a197fc5c52aa8b2058b5ec8fa39679500;hb=869549224eef6278a48c16ae27dd786376082b38;hpb=89262281b6e83bd2321150f81f1a0583645eb0c8 diff --git a/helm/metadata/postgresql_V7_mowgli/README b/helm/metadata/postgresql_V7_mowgli/README deleted file mode 100644 index 0d1b720a1..000000000 --- a/helm/metadata/postgresql_V7_mowgli/README +++ /dev/null @@ -1,29 +0,0 @@ -* da utente postgres: - - $ createuser helm # con permessi minimi (i.e. no create altri database, - # no create altri utenti) - $ createdb helm - $ pg_passwd data/passwords - # settare una password - -* da un utente qualsiasi: - - $ psql -h mowgli -U helm helm_mowgli_new_schema - - create table registry (uri varchar, id int); - CREATE INDEX registry_index ON registry (uri); - - create table objectName (value varchar, uri varchar); - CREATE INDEX objectName_index ON objectName (value); - CREATE INDEX objectName_rev_index ON objectName (uri); - - create table hrefRel (uri varchar, position varchar, depth int); - create table hrefSort (uri varchar, position varchar, sort varchar, depth int); - CREATE INDEX hrefRel_rev_index ON hrefRel (uri); - CREATE INDEX hrefSort_rev_index ON hrefSort (uri); - -* svuotamento: - drop table tn; - delete from registry; -* svuotamento totale: - come postgres: dropdb helm