CVS: phpweather/db pw_db_mysql.php,1.10,1.11
Brought to you by:
iridium
From: Martin G. <gim...@us...> - 2004-01-03 18:38:48
|
Update of /cvsroot/phpweather/phpweather/db In directory sc8-pr-cvs1:/tmp/cvs-serv24485/db Modified Files: pw_db_mysql.php Log Message: Hmm... that was broke! Index: pw_db_mysql.php =================================================================== RCS file: /cvsroot/phpweather/phpweather/db/pw_db_mysql.php,v retrieving revision 1.10 retrieving revision 1.11 diff -u -3 -r1.10 -r1.11 --- pw_db_mysql.php 2 Oct 2003 22:54:46 -0000 1.10 +++ pw_db_mysql.php 3 Jan 2004 18:38:43 -0000 1.11 @@ -379,7 +379,7 @@ time timestamp(14), metar varchar(255) NOT NULL, timestamp timestamp(14), - PRIMARY KEY (icao)'); + PRIMARY KEY (icao))'); /* Then we make a table for the TAFs */ $this->query('DROP TABLE IF EXISTS ' . $this->properties['db_tafs']); @@ -388,7 +388,7 @@ time timestamp(14), taf varchar(255) NOT NULL, timestamp timestamp(14), - PRIMARY KEY (icao)'); + PRIMARY KEY (icao))'); /* We make the archival databases */ $this->query('DROP TABLE IF EXISTS ' . $this->properties['db_metars_arch']); @@ -396,13 +396,13 @@ icao char(4) NOT NULL, time timestamp(14) NOT NULL, metar varchar(255) NOT NULL, - PRIMARY KEY (icao,time)'); + 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 char(4) NOT NULL, time timestamp(14) NOT NULL, taf varchar(255) NOT NULL, - PRIMARY KEY (icao,time)'); + PRIMARY KEY (icao,time))'); /* Then we make a table for the stations. */ $this->query('DROP TABLE IF EXISTS ' . $this->properties['db_stations']); |