CVS: phpweather/db pw_db_mysql.php,1.8,1.9

[Etienne T. <eti...@us...>]

Update of /cvsroot/phpweather/phpweather/db
In directory sc8-pr-cvs1:/tmp/cvs-serv15470/db

Modified Files:
	pw_db_mysql.php 
Log Message:
Modified create_tables()

Index: pw_db_mysql.php
===================================================================
RCS file: /cvsroot/phpweather/phpweather/db/pw_db_mysql.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -3 -r1.8 -r1.9
--- pw_db_mysql.php	30 Sep 2003 19:48:00 -0000	1.8
+++ pw_db_mysql.php	30 Sep 2003 20:01:15 -0000	1.9
@@ -360,17 +360,18 @@
    UNIQUE icao (icao))');
 
     /* We make the archival databases */
-    $this->query('DROP TABLE IF EXISTS ' . $this->properties['db_metars_arch']);
+
+    $this->query('DROP TABLE IF EXISTS ' . $this->properties['db_metars_arch']); 
     $this->query('CREATE TABLE ' . $this->properties['db_metars_arch'] . '(
-   icao varchar(4) NOT NULL default '',
+   icao varchar(4) NOT NULL,
    time timestamp(14) NOT NULL,
-   metar varchar(255) NOT NULL default '',
+   metar varchar(255) NOT NULL,
    PRIMARY KEY  (icao,time)');
     $this->query('DROP TABLE IF EXISTS ' . $this->properties['db_tafs_arch']);
     $this->query('CREATE TABLE ' . $this->properties['db_tafs_arch'] . '(
-   icao varchar(4) NOT NULL default '',
+   icao varchar(4) NOT NULL,
    time timestamp(14) NOT NULL,
-   taf varchar(255) NOT NULL default '',
+   taf varchar(255) NOT NULL,
    PRIMARY KEY  (icao,time)');
 
     /* Then we make a table for the stations. */