1 |
-- 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 |
|