devFTP/create_tables.sql at master · devpurohit/devFTP · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61

#
# Table structure for table `devFTP_logAccess`
#

CREATE TABLE devFTP_logAccess (
  date date NOT NULL default '0000-00-00',
  time time NOT NULL default '00:00:00',
  remote_addr text NOT NULL,
  remote_port text NOT NULL,
  http_user_agent text NOT NULL,
  page text NOT NULL,
  ftpserver text NOT NULL,
  username text NOT NULL,
  state text NOT NULL,
  manage text NOT NULL,
  directory text NOT NULL,
  file text NOT NULL,
  http_referer text NOT NULL
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `devFTP_logError`
#

CREATE TABLE devFTP_logError (
  date date NOT NULL default '0000-00-00',
  time time NOT NULL default '00:00:00',
  ftpserver text NOT NULL,
  username text NOT NULL,
  message text NOT NULL,
  cause text NOT NULL,
  drilldown text NOT NULL,
  state text NOT NULL,
  manage text NOT NULL,
  directory text NOT NULL,
  debug1 text NOT NULL,
  debug2 text NOT NULL,
  debug3 text NOT NULL,
  debug4 text NOT NULL,
  debug5 text NOT NULL,
  remote_addr text NOT NULL,
  remote_port text NOT NULL,
  http_user_agent text NOT NULL
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `devFTP_logLogin`
#

CREATE TABLE devFTP_logLogin (
  date date NOT NULL default '0000-00-00',
  time time NOT NULL default '00:00:00',
  ftpserver text NOT NULL,
  username text NOT NULL,
  remote_addr text NOT NULL,
  remote_port text NOT NULL,
  http_user_agent text NOT NULL
) TYPE=MyISAM;