Re: [lms] Wersja CVS z 01.04.2007 problem z bazą
Jarosław Haczyk napisał(a):
Wiem, że to nie tu :) Do mysql jest update z dniem 20070331, do postgres'a juz nie :) LMS ma problem z wyświetlaniem klientów
lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms
<?php
/* * LMS version 1.9-cvs * * (C) Copyright 2001-2007 LMS Developers * * Please, see the doc/AUTHORS for more information about authors! * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License Version 2 as * published by the Free Software Foundation. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, * USA. * * $Id: postgresql.2007033100.php,v 1.3 2007/03/31 19:14:01 zet Exp $ */
$DB->BeginTrans();
// YMSGR (yahoo messenger id ) $DB->Execute("ALTER TABLE customers ADD COLUMN yim varchar(32)"); $DB->Execute("UPDATE customers SET yim=''"); $DB->Execute("ALTER TABLE customers ALTER COLUMN yim SET NOT NULL"); $DB->Execute("ALTER TABLE customers ALTER COLUMN yim SET DEFAULT ''"); //Skype (skype ID ) $DB->Execute("ALTER TABLE customers ADD COLUMN skype varchar(32)"); $DB->Execute("UPDATE customers SET skype=''"); $DB->Execute("ALTER TABLE customers ALTER COLUMN skype SET NOT NULL"); $DB->Execute("ALTER TABLE customers ALTER COLUMN skype SET DEFAULT ''");
$DB->Execute("UPDATE dbinfo SET keyvalue = ? WHERE keytype = ?",array('2007033100', 'dbversion'));
$DB->CommitTrans();
?>
_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms
uczestnicy (1)
-
Jarosław Haczyk