-- MySQL dump 8.22
--
-- Host: localhost    Database: libstats
---------------------------------------------------------
-- Server version	3.23.56

--
-- Table structure for table 'elementstats'
--

CREATE TABLE elementstats (
  elementstats_id int(11) NOT NULL auto_increment,
  page_id mediumint(9) default NULL,
  element_id mediumint(9) default NULL,
  resource_id mediumint(9) default NULL,
  location_id mediumint(9) default NULL,
  service_id mediumint(9) default NULL,
  staff_id mediumint(9) default NULL,
  subject_id mediumint(9) default NULL,
  element_page_id mediumint(9) default NULL,
  visit_date datetime default NULL,
  user_ip varchar(15) default NULL,
  PRIMARY KEY  (elementstats_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'elementstats'
--



--
-- Table structure for table 'pagestats'
--

CREATE TABLE pagestats (
  pagestats_id int(11) NOT NULL auto_increment,
  page_id mediumint(9) default NULL,
  visit_date datetime default NULL,
  user_ip varchar(15) default NULL,
  PRIMARY KEY  (pagestats_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'pagestats'
--



--
-- Table structure for table 'substats'
--

CREATE TABLE substats (
  substats_id int(11) NOT NULL auto_increment,
  subject_id mediumint(9) default NULL,
  visit_date datetime default NULL,
  user_ip varchar(15) default NULL,
  PRIMARY KEY  (substats_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'substats'
--

