"Fossies" - the Fresh Open Source Software Archive 
Member "eventh/eventhorizon.sql" (9 Jun 2008, 2888 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 -- phpMyAdmin SQL Dump
19 -- version 2.9.0.2
20 -- http://www.phpmyadmin.net
21 --
22 -- Host: localhost
23 -- Generation Time: Aug 07, 2007 at 10:25 AM
24 -- Server version: 3.23.58
25 -- PHP Version: 5.0.4
26 --
27 -- Database: `eventhorizon`
28 --
29
30 -- --------------------------------------------------------
31
32 --
33 -- Table structure for table `Availability`
34 --
35
36 USE eventhorizon;
37
38 CREATE TABLE `Availability` (
39 `id` int(11) NOT NULL default '0',
40 `short` varchar(10) NOT NULL default '',
41 `long` varchar(30) NOT NULL default '',
42 PRIMARY KEY (`id`)
43 ) TYPE=MyISAM;
44
45 --
46 -- Dumping data for table `Availability`
47 --
48
49 INSERT INTO `Availability` (`id`, `short`, `long`) VALUES
50 (1, '1d', '1 Day'),
51 (2, '3d', '3 Days'),
52 (3, '1w', '1 Week'),
53 (4, '2w', '2 Weeks'),
54 (5, '3w', '3 Weeks');
55
56 -- --------------------------------------------------------
57
58 --
59 -- Table structure for table `Files`
60 --
61
62 CREATE TABLE `Files` (
63 `id` int(11) NOT NULL auto_increment,
64 `name` varchar(128) NOT NULL default '',
65 `method` varchar(128) NOT NULL default '',
66 `description` varchar(255) NOT NULL default '',
67 `sessionid` int(11) NOT NULL default '0',
68 `size` bigint(15) NOT NULL default '0',
69 PRIMARY KEY (`id`)
70 ) TYPE=MyISAM AUTO_INCREMENT=0 ;
71
72 --
73 -- Table structure for table `Sessions`
74 --
75
76 CREATE TABLE `Sessions` (
77 `id` int(11) NOT NULL auto_increment,
78 `indate` date NOT NULL default '0000-00-00',
79 `outdate` date NOT NULL default '0000-00-00',
80 `avail` tinytext NOT NULL,
81 `srcemail` varchar(50) NOT NULL default '',
82 `destemail` text NOT NULL,
83 `dnldcode` varchar(25) NOT NULL default '',
84 `modcode` varchar(25) NOT NULL default '',
85 PRIMARY KEY (`id`),
86 KEY `dnldcode` (`dnldcode`),
87 KEY `modcode` (`modcode`)
88 ) TYPE=MyISAM AUTO_INCREMENT=0 ;
89
90 --
91 -- Table structure for table `History`
92 --
93
94 CREATE TABLE `History` (
95 `id` int(11) NOT NULL auto_increment,
96 `moddate` date NOT NULL default '0000-00-00',
97 `srcip` varchar(10) NOT NULL default '',
98 `type` varchar(30) NOT NULL default '',
99 `browser` varchar(255) NOT NULL default '',
100 `filename` varchar(255) NOT NULL default '',
101 `srcemail` varchar(255) NOT NULL default '',
102 `dstemail` varchar(255) NOT NULL default '',
103 PRIMARY KEY (`id`)
104 ) TYPE=MyISAM;
105
106