Location: PHPKode > projects > DataDivisions > _docs/dbSetupSQL_displayInfoTable.txt
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# DataDivisions, Build 1.0, 12/11/2003                                      #
# FileName: dbSetupSQL_displayInfoTable.txt                                 #
# File Description:                                                         #
#   SQL dump file to setup displayInfo table (where all possible displays   #
#   are organized and limitations/restrictions for display are set)         #
#                                                                           #
# +-----------------------------------------------------------------------+ #
# | DataDivisions - Website Statistic Visualization Software              | #
# | Copyright (c) 2003, Brian Willison                                    | #
# +-----------------------------------------------------------------------+ #
# | The contents of this file are subject to the GNU General Public       | #
# | License version 2 (June 1991). This file and all its contents (incl.  | #
# | functions, methods, etc.) are free for general use within any         | #
# | community. This software is distributed with the intent to allow      | #
# | developers the opportunity to copy, manipulate and revamp this        | #
# | application in part or whole for best use cases.                      | #
# |                                                                       | #
# | This software is distributed "AS-IS" with no warranties of any kind   | #
# | either expressed or implied.                                          | #
# |                                                                       | #
# | Please refer to the GPL license document for more information:        | #
# | (_docs/gplLicense.pdf)                                                | #
# +-----------------------------------------------------------------------+ #
# | Developer, Designer, Initial Creator:                                 | #
# | Brian Willison (hide@address.com)                       | #
# +-----------------------------------------------------------------------+ #
# | Initial Download Reference:                                           | #
# | http://datadivisions.sourceforge.net                                  | #
# +-----------------------------------------------------------------------+ #
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
#
# NOTE:
# Directory displays have not been implemented as of Build 1.0. The inserts
# will be made into the displayInfo table with screenAvail = 5 to not
# interact with PHP scripts. The following is a list of proposed screenAvail
# values for the reference numbers:
# 
# 033 - 1,2,4
# 034 - 1,2
# 035 - 1,2,4
# 036 - 1,2,4
# 037 - 1,2
# 038 - 1,2
# 039 - 1,2
# 040 - 1,2
# 041 - 2
# 042 - 1,2
# 043 - 1,2
# 044 - 1,2

CREATE TABLE `dataDivisions_displayInfo` (
  `refNum` varchar(10) NOT NULL default '',
  `infoLocation` varchar(10) NOT NULL default '',
  `screenAvail` varchar(6) NOT NULL default '',
  `displayType` varchar(20) NOT NULL default '',
  `displayInfo` varchar(30) NOT NULL default '',
  `limit` char(2) NOT NULL default '',
  `description` varchar(35) NOT NULL default ''
) TYPE=MyISAM COMMENT='DataDivisons: Info Display Methods & Limitations';

INSERT INTO `dataDivisions_displayInfo` VALUES ('001', 'log', '1,2,4', 'bar,plot', 'visitsDayOfMonth', 'N', 'Visits By Day Of Month');
INSERT INTO `dataDivisions_displayInfo` VALUES ('002', 'log', '1,2,4', 'bar,plot', 'pagesDayOfMonth', 'N', 'Total Pages By Day Of Month');
INSERT INTO `dataDivisions_displayInfo` VALUES ('003', 'log', '1,2,4', 'bar,plot', 'hitsDayOfMonth', 'N', 'Hits By Day Of Month');
INSERT INTO `dataDivisions_displayInfo` VALUES ('004', 'log', '1,2,4', 'bar,plot', 'visitsDayOfWeek', 'N', 'Visits By Day Of Week');
INSERT INTO `dataDivisions_displayInfo` VALUES ('005', 'log', '1,2,4', 'bar,plot', 'pagesDayOfWeek', 'N', 'Total Pages By Day Of Week');
INSERT INTO `dataDivisions_displayInfo` VALUES ('006', 'log', '1,2,4', 'bar,plot', 'hitsDayOfWeek', 'N', 'Hits By Day Of Week');
INSERT INTO `dataDivisions_displayInfo` VALUES ('007', 'log', '1,2,4', 'bar,plot', 'visitsHourOfDay', 'N', 'Visits By Hour Of Day');
INSERT INTO `dataDivisions_displayInfo` VALUES ('008', 'log', '1,2,4', 'bar,plot', 'pagesHourOfDay', 'N', 'Total Pages By Hour Day');
INSERT INTO `dataDivisions_displayInfo` VALUES ('009', 'log', '1,2,4', 'bar,plot', 'hitsHourOfDay', 'N', 'Hits By Hour Of Day');
INSERT INTO `dataDivisions_displayInfo` VALUES ('010', 'log', '1,2,4', 'bar,plot', 'visitorsFromDomain', 'Y', 'Visitors From Domain');
INSERT INTO `dataDivisions_displayInfo` VALUES ('011', 'log', '1,2,4', 'text,plot', 'visitorsFromCountry', 'Y', 'Visitors From Country');
INSERT INTO `dataDivisions_displayInfo` VALUES ('012', 'log', '1,2,4', 'text,bar', 'visitorsFromWorldRegion', 'Y', 'Visitors From World Region');
INSERT INTO `dataDivisions_displayInfo` VALUES ('013', 'log', '1,2,4', 'text', 'hostAddresses', 'Y', 'All Host Addresses To Website');
INSERT INTO `dataDivisions_displayInfo` VALUES ('014', 'log', '1,2,4', 'text', 'lastHostAddresses', 'N', 'Last Host Addresses To Website');
INSERT INTO `dataDivisions_displayInfo` VALUES ('015', 'log', '2,4', 'text', 'earliestHostAddresses', 'N', 'Earliest Host Addresses To Website');
INSERT INTO `dataDivisions_displayInfo` VALUES ('016', 'log', '2,4', 'text,bar', 'robotHits', 'N', 'Number Of Robot Hits');
INSERT INTO `dataDivisions_displayInfo` VALUES ('017', 'log', '1,2,4', 'text,bar', 'durationIndivVisits', 'N', 'Duration Of Individual Visits');
INSERT INTO `dataDivisions_displayInfo` VALUES ('018', 'log', '1,2,4', 'text,bar,plot', 'fileTypesHit', 'N', 'File Types Hit By Quantity');
INSERT INTO `dataDivisions_displayInfo` VALUES ('019', 'log', '1,2,4', 'text,bar', 'fileTypesHitBandwidth', 'N', 'File Types Hit By Bandwidth');
INSERT INTO `dataDivisions_displayInfo` VALUES ('020', 'log', '1,2,4', 'text', 'pagesHit', 'Y', 'Pages In Website Hit');
INSERT INTO `dataDivisions_displayInfo` VALUES ('021', 'log', '1,2,4', 'text', 'pagesHitByName', 'Y', 'Pages Hit In Website By Name');
INSERT INTO `dataDivisions_displayInfo` VALUES ('022', 'log', '1,2,4', 'text,bar', 'operatingSystems', 'N', 'Operating Systems Hitting Website');
INSERT INTO `dataDivisions_displayInfo` VALUES ('023', 'log', '1,2,4', 'text,bar', 'browsers', 'Y', 'Browsers Hitting Website');
INSERT INTO `dataDivisions_displayInfo` VALUES ('024', 'log', '1,2', 'text', 'incomingPageReferrer', 'Y', 'Incoming Page Referrers');
INSERT INTO `dataDivisions_displayInfo` VALUES ('025', 'log', '1,2', 'text', 'incomingServerReferrer', 'Y', 'Incoming Server Referrers');
INSERT INTO `dataDivisions_displayInfo` VALUES ('026', 'log', '1,2,4', 'text', 'incomingSearchPhrases', 'Y', 'Incoming Search Phrases');
INSERT INTO `dataDivisions_displayInfo` VALUES ('027', 'log', '2,4', 'text', 'incomingSearchWords', 'Y', 'Incoming Search Keywords');
INSERT INTO `dataDivisions_displayInfo` VALUES ('028', 'error', '1', 'text', 'errorPagesFileNames', 'Y', 'Error Reported By File Name Tried');
INSERT INTO `dataDivisions_displayInfo` VALUES ('029', 'error', '2,4', 'text,bar', 'errorPagesDayOfMonth', 'Y', 'Errors Reported By Day Of Month');
INSERT INTO `dataDivisions_displayInfo` VALUES ('030', 'error', '2,4', 'text,bar', 'errorPagesDayOfWeek', 'Y', 'Errors Reported By Day Of Week');
INSERT INTO `dataDivisions_displayInfo` VALUES ('031', 'error', '2,4', 'text,bar', 'errorPagesHourOfDay', 'Y', 'Errors Reported By Hour Of Day');
INSERT INTO `dataDivisions_displayInfo` VALUES ('032', 'log', '2,4', 'text,bar', 'errorCodes', 'N', 'Number Of Errors Reported By Code');
INSERT INTO `dataDivisions_displayInfo` VALUES ('033', 'dir', '5', 'text', 'dirNamesInSite', 'Y', 'Directory Names In Website');
INSERT INTO `dataDivisions_displayInfo` VALUES ('034', 'dir', '5', 'text', 'filesInDir', 'Y', 'Files By Directory');
INSERT INTO `dataDivisions_displayInfo` VALUES ('035', 'dir', '5', 'text,bar,plot', 'dirsBySize', 'Y', 'Directories By Total Size');
INSERT INTO `dataDivisions_displayInfo` VALUES ('036', 'dir', '5', 'text', 'dirsAsNextLevel', 'Y', 'Directory Structure By Hierarchy');
INSERT INTO `dataDivisions_displayInfo` VALUES ('037', 'dir', '5', 'text', 'fileNames', 'Y', 'File Names In Website');
INSERT INTO `dataDivisions_displayInfo` VALUES ('038', 'dir', '5', 'text', 'mostCommonFileNames', 'Y', 'Most Common File Names In Website');
INSERT INTO `dataDivisions_displayInfo` VALUES ('039', 'dir', '5', 'text,bar,plot', 'filesByFileType', 'N', 'Files Listed By File Type');
INSERT INTO `dataDivisions_displayInfo` VALUES ('040', 'dir', '5', 'text,bar,plot', 'filesByFileSize', 'Y', 'Files Listed By File Size');
INSERT INTO `dataDivisions_displayInfo` VALUES ('041', 'dir', '5', 'text', 'imageNames', 'Y', 'Image Names In Website');
INSERT INTO `dataDivisions_displayInfo` VALUES ('042', 'dir', '5', 'text,bar,plot', 'imageSizes', 'Y', 'Images In Website By File Size');
INSERT INTO `dataDivisions_displayInfo` VALUES ('043', 'dir', '5', 'text', 'textBasedFiles', 'Y', 'List Of Text-Based Files');
INSERT INTO `dataDivisions_displayInfo` VALUES ('044', 'dir', '5', 'text', 'scriptFiles', 'Y', 'List Of Script-Based Files');
Return current item: DataDivisions