"Fossies" - the Fresh Open Source Software Archive

Member "eventh/update-1.1.6.sql" (21 Aug 2007, 1327 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 CREATE TABLE `History` (
   35   `id` int(11) NOT NULL auto_increment,
   36   `moddate` date NOT NULL default '0000-00-00',
   37   `srcip` varchar(15) NOT NULL default '',
   38   `type` varchar(30) NOT NULL default '',
   39   `browser` varchar(255) NOT NULL default '',
   40   `sessionid` int(11) NOT NULL default '0',
   41   `fileid` int(11) NOT NULL default '0',
   42   PRIMARY KEY  (`id`)
   43 ) TYPE=MyISAM;
   44 
   45