Re: [Planner Dev] [patch] update to sql readme

[minus <minus toneby com>]

On Sun, 2005-05-15 at 13:09 +0200, Richard Hult wrote:
> minus wrote:
> > Here is a small update to the README.sql in docs/sql
> 
> Thanks :) Could you resend the patch but this time with -u to get
> unified format please? That's much easier to read.

sure.

[[[ 
Changed the README.sql so it is clearer who should do what to get a
working database setup.
Added a small description of what to do in planner to use the database. 
]]]

minus

Index: docs/sql/README.sql
===================================================================
RCS file: /cvs/gnome/planner/docs/sql/README.sql,v
retrieving revision 1.2
diff -u -r1.2 README.sql
--- docs/sql/README.sql	9 Nov 2004 04:58:27 -0000	1.2
+++ docs/sql/README.sql	15 May 2005 11:19:40 -0000
@@ -12,17 +12,22 @@
 
   postmaster -D /tmp/test-db
 
+
+-- This is usualy done by a database administrator  
+
 * Enable access to another user than the default:
 
   echo 'CREATE USER rhult CREATEDB;' | psql -e template1
 
-* Create a UNICODE database:
+* Create database group:
 
-  createdb -E UNICODE -U rhult plannerdb
+  echo 'CREATE GROUP planner WITH USER rhult;' | psql -e -d plannerdb
 
-* Create database group:
+-- This is done by the user
+
+* Create a UNICODE database:
 
-  echo 'CREATE GROUP planner WITH USER rhult;' | psql -e -U rhult -d plannerdb
+  createdb -E UNICODE -U rhult plannerdb
 
 * Create tables from new. This depends upon the schema that you are up to 
   in your code. Use the highest versioned SQL file.
@@ -39,6 +44,8 @@
   
   e.g.
   cat upgrade-0.6.x-0.11.sql | psql -e -U rhult -d plannerdb
+
+-- How to start over
   
 * Drop database and group to start over:
 
@@ -46,3 +53,12 @@
   dropdb plannerdb
  
 
+
+-- And then...
+
+Start planner
+Add some items to a project
+Export to a database
+
+Import from the database next time you use planner.
+