"Fossies" - the Fresh Open Source Software Archive

Member "eventh/update-1.1.7.sql" (20 Aug 2007, 1207 Bytes) of package /linux/privat/old/eventh-1.1.11.tar.gz:

As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file. 
    1 -- This file is part of Event Horizon (EVH).
    2 --
    3 -- EVH is free software; you can redistribute it and/or modify
    4 -- it under the terms of the GNU General Public License as published by
    5 -- the Free Software Foundation; either version 3 of the License, or
    6 -- (at your option) any later version.
    7 --
    8 -- EVH is distributed in the hope that it will be useful,
    9 -- but WITHOUT ANY WARRANTY; without even the implied warranty of
   10 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   11 -- GNU General Public License for more details.
   12 --
   13 -- You should have received a copy of the GNU General Public License
   14 -- along with this program.  If not, see <http://www.gnu.org/licenses/>.
   15 --
   16 
   17 
   18 -- Host: localhost
   19 -- Generation Time: Aug 07, 2007 at 10:25 AM
   20 -- Server version: 3.23.58
   21 -- PHP Version: 5.0.4
   22 -- 
   23 -- Database: `eventhorizon`
   24 -- 
   25 
   26 -- --------------------------------------------------------
   27 
   28 -- 
   29 -- Table structure for table `History`
   30 -- 
   31 
   32 USE eventhorizon;
   33 
   34 ALTER TABLE `History`
   35   DROP COLUMN `sessionid`,
   36   DROP COLUMN `fileid`,
   37   ADD COLUMN `filename` varchar(255) NOT NULL default '',
   38   ADD COLUMN `srcemail` varchar(255) NOT NULL default '',
   39   ADD COLUMN `dstemail` varchar(255) NOT NULL default '';
   40