Update of /cvsroot/phpweather/phpweather
In directory usw-pr-cvs1:/tmp/cvs-serv15365

Modified Files:
        INSTALL 
Log Message:
Added information about how to create the tables in MySQL and
PostgreSQL.


Index: INSTALL
===================================================================
RCS file: /cvsroot/phpweather/phpweather/INSTALL,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -3 -r1.3 -r1.4
--- INSTALL     2001/03/25 08:18:37     1.3
+++ INSTALL     2001/04/06 15:03:54     1.4
@@ -1,4 +1,4 @@
-Installation instructions for PHP Weather
+Installation instructions for PHP Weather #VERSION# #DATE#
 Copyright (C) 2000, 2001 Martin Geisler <[EMAIL PROTECTED]>
 Licensed under the GNU GPL. See the file COPYING for details.
 
@@ -31,6 +31,29 @@
 I've chosen to put the documentation there, because it's easier for me
 to update. It also gives you a chance to see all the features of PHP
 Weather in action.
+
+Database Setup
+--------------
+To use a MySQL database, you should create a table with the following
+SQL-statement:
+
+CREATE TABLE metars (
+  metar VARCHAR(255) NOT NULL,
+  timestamp TIMESTAMP(14),
+  station VARCHAR(4) NOT NULL,
+  PRIMARY KEY (station),
+  UNIQUE station (station)
+);
+
+If you're using a PostgreSQL database, you should use this statement
+instead:
+
+CREATE TABLE metars (
+  metar VARCHAR(255) NOT NULL,
+  timestamp TIMESTAMP,
+  station VARCHAR(4) PRIMARY KEY NOT NULL
+);
+
 
 Bugs?
 -----


_______________________________________________
PHPWeather-checkins mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/phpweather-checkins

Reply via email to