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
