1 |
dpavlin |
8 |
-- MySQL dump 8.22 |
2 |
|
|
-- |
3 |
|
|
-- Host: localhost Database: libstats |
4 |
|
|
--------------------------------------------------------- |
5 |
|
|
-- Server version 3.23.56 |
6 |
|
|
|
7 |
|
|
-- |
8 |
|
|
-- Table structure for table 'elementstats' |
9 |
|
|
-- |
10 |
|
|
|
11 |
|
|
CREATE TABLE elementstats ( |
12 |
|
|
elementstats_id int(11) NOT NULL auto_increment, |
13 |
|
|
page_id mediumint(9) default NULL, |
14 |
|
|
element_id mediumint(9) default NULL, |
15 |
|
|
resource_id mediumint(9) default NULL, |
16 |
|
|
location_id mediumint(9) default NULL, |
17 |
|
|
service_id mediumint(9) default NULL, |
18 |
|
|
staff_id mediumint(9) default NULL, |
19 |
|
|
subject_id mediumint(9) default NULL, |
20 |
|
|
visit_date datetime default NULL, |
21 |
|
|
user_ip varchar(15) default NULL, |
22 |
|
|
PRIMARY KEY (elementstats_id) |
23 |
|
|
) TYPE=MyISAM; |
24 |
|
|
|
25 |
|
|
-- |
26 |
|
|
-- Dumping data for table 'elementstats' |
27 |
|
|
-- |
28 |
|
|
|
29 |
|
|
|
30 |
|
|
|
31 |
|
|
-- |
32 |
|
|
-- Table structure for table 'pagestats' |
33 |
|
|
-- |
34 |
|
|
|
35 |
|
|
CREATE TABLE pagestats ( |
36 |
|
|
pagestats_id int(11) NOT NULL auto_increment, |
37 |
|
|
page_id mediumint(9) default NULL, |
38 |
|
|
visit_date datetime default NULL, |
39 |
|
|
user_ip varchar(15) default NULL, |
40 |
|
|
PRIMARY KEY (pagestats_id) |
41 |
|
|
) TYPE=MyISAM; |
42 |
|
|
|
43 |
|
|
-- |
44 |
|
|
-- Dumping data for table 'pagestats' |
45 |
|
|
-- |
46 |
|
|
|
47 |
|
|
|
48 |
|
|
|
49 |
|
|
-- |
50 |
|
|
-- Table structure for table 'substats' |
51 |
|
|
-- |
52 |
|
|
|
53 |
|
|
CREATE TABLE substats ( |
54 |
|
|
substats_id int(11) NOT NULL auto_increment, |
55 |
|
|
subject_id mediumint(9) default NULL, |
56 |
|
|
visit_date datetime default NULL, |
57 |
|
|
user_ip varchar(15) default NULL, |
58 |
|
|
PRIMARY KEY (substats_id) |
59 |
|
|
) TYPE=MyISAM; |
60 |
|
|
|
61 |
|
|
-- |
62 |
|
|
-- Dumping data for table 'substats' |
63 |
|
|
-- |
64 |
|
|
|