# clean mysql privileges
use mysql ;
delete from columns_priv where user='guest1' ;
delete from columns_priv where user='guest2' ;
delete from columns_priv where user='guest3' ;
delete from columns_priv where user='guest4' ;
delete from columns_priv where user='guest5' ;
delete from columns_priv where user='arthur' ;
delete from tables_priv where user='guest1' ;
delete from tables_priv where user='guest2' ;
delete from tables_priv where user='guest3' ;
delete from tables_priv where user='guest4' ;
delete from tables_priv where user='guest5' ;
delete from tables_priv where user='arthur' ;
delete from db where user='guest1' ;
delete from db where user='guest2' ;
delete from db where user='guest3' ;
delete from db where user='guest4' ;
delete from db where user='guest5' ;
delete from db where user='arthur' ;
delete from user where user='guest1' ;
delete from user where user='guest2' ;
delete from user where user='guest3' ;
delete from user where user='guest4' ;
delete from user where user='guest5' ;
delete from user where user='arthur' ;
# initialize Admin database
drop database if exists Admin ;
drop database if exists Documentation ;
create database Admin ;
# initialize customer database
drop database if exists ITTDCPrimary1 ;
drop database if exists ITTDCPrimary2 ;
drop database if exists ITTDCPrimary3 ;
drop database if exists ITTDCPrimary4 ;
drop database if exists ITTDCPrimary5 ;
drop database if exists ZZ ;
# create Admin tables
use Admin ;
CREATE TABLE `Problem` (
  Key1 varchar(30) NOT NULL default '',
  Key2 varchar(30) NOT NULL default '',
  Problem varchar(255) NOT NULL default '',
  Solution varchar(255) NOT NULL default ''
) TYPE=InnoDB COMMENT='Potenial problems & solution';
INSERT INTO Problem VALUES ('Slow', 'Transaction', 'Occasional slow response of upto 1 min. A new browser window sometimes give good response.', '');
INSERT INTO Problem VALUES ('Dish', 'Capacity', 'ibdata1 keeps expanding from 90M to 110M to 133M to 144M during testing. Documention says space should be released after database dropped.', ''); 
INSERT INTO Problem VALUES ('Security', 'Password', 'If user is allowed to change his password, he can change all users passwords including root!', 'May be user can submit new password via his Contact table and nightly run use it to update the mysql.user table. 1 day turn around.'); 
CREATE TABLE `Documentation` (
  Key1 varchar(30) NOT NULL default '',
  Key2 varchar(30) NOT NULL default '',
  Content varchar(255) NOT NULL default ''
) TYPE=InnoDB COMMENT='Job, policy, procedure and others';
INSERT INTO Documentation VALUES ('Job', 'Start Business', 'Start, Daily, Nightly, Monthly, Yearly');
INSERT INTO Documentation VALUES ('Job', 'Start', 'Run at starting business. Initialize system user and databasses...');
INSERT INTO Documentation VALUES ('Manual', 'New root', '1. Run s9.changep1 with existing root password.
to set root to 
null. 2. Change s9i.change2/s6.changep2S1 to new root password, run 
s9.changep2
Must add 
a new 
Admin.Contact record to trigger the creation of a new customer and its database. Payment/correspondence should be added via Admin.Payment/Correspondence. Contact info should be added via <ShortName>.Contact') ; 
INSERT INTO Documentation VALUES ('Manual', 'New Customer', 'Must add a new Admin.Contact record to trigger the creation of a new customer and its database. Payment/correspondence should be added via Admin.Payment/Correspondence. Contact info should be added via <ShortName>.Contact') ; 
INSERT INTO Documentation VALUES ('Manual', 'Current Customer', 'Can change password via <ShortName>.Contact.Password. However, it will become effective the next morning (after Nightly run)') ;
INSERT INTO Documentation VALUES ('Transaction', 'New Customer', 'Must create a new customer and its database before adding Payment/correspondence') ; 
INSERT INTO Documentation VALUES ('Transaction', 'New Customer', 'Create a <ShortName> as database name and user id ''StJosephPy'' or ''StJsPy'' for St. Joseph''s Primary say and a password ''123456''');
INSERT INTO Documentation VALUES ('Transaction', 'New Customer', 'Create a new row in Admin.Contact with Status=''New''->(Daily)-><ShortName>.database ->(customer upddates)-><contact info>-><ShortName>.Contact (Nightly)[not=]->Admin.Contact');
INSERT INTO Documentation VALUES ('Transaction', 'New Customer', 'new customer->email->Admin.Correspondance');
INSERT INTO Documentation VALUES ('Transaction', 'New Customer', 'new customer->cheque/credit card->Admin.Payment');
INSERT INTO Documentation VALUES ('Job', 'Daily', 'Run before midnight at 11:00 pm say. Roll forward history and create databases for new customers Admin.Contact,Correspondence,Payment-><ShortName>...');
INSERT INTO Documentation VALUES ('Job', 'Nightly', 'Run after midnight at 2:00 am say, after logs transfered www1/2 logs ->TodayLog ->Admin.Yerterday-0Log(emptied) -><ShortName>.Yesterday-0Log + ZZ.Yesterday-0Log(unexpected log entries) [DateUpdated=''0000-oo-oo'']-><ShortName>.Correspondence/Payment Admin.Contact-><ShortName>.Contact');
INSERT INTO Documentation VALUES ('Transaction', 'Current Customer', 'Update <ShortName>.Contact/Password (Nightly)->Admin.Contact/Password');
INSERT INTO Documentation VALUES ('Transaction', 'Current Customer', 'Current customer ->email->Admin.Correspondence	 (Nightly)[DateUpdated=''0000-oo-oo'']-><ShortName>.Correspondence');
INSERT INTO Documentation VALUES ('Transaction', 'Current Customer', 'Current customer ->cheque/credit card ->Admin.Payment (Nightly)[DateUpdate=''0000-00-00'']-><ShortName>.Payment');
INSERT INTO Documentation VALUES ('Job', 'Monthly', 'Run after Nightly, summarize an entry into ThisYear,	 ThisMonth->LastMonth, Clear ThisMonth');
INSERT INTO Documentation VALUES ('Job', 'Yearly', 'Run after Monthly, ThisYear->LastYear, Clear ThisYear');
INSERT INTO Documentation VALUES ('Job', 'Past Customer', 'stop rolling forward history, ie all Daily, Nightly ..');
CREATE TABLE `Contact` (
  ShortName varchar(30) NOT NULL default '',
  User varchar(16) binary NOT NULL default '',
  password varchar(16) NOT NULL default '',
  ServerName varchar(30) NOT NULL default '',
  Status varchar(20) NOT NULL default '',
  Person varchar(30) NOT NULL default '',
  Tel bigint(12) NOT NULL default '0',
  email varchar(30) NOT NULL default '',
  Organization varchar(30) NOT NULL default '',
  Address varchar(60) NOT NULL default '',
  PRIMARY KEY  (ShortName)
) TYPE=InnoDB COMMENT='Customer organization information';
INSERT INTO Contact VALUES ('Admin', '', '', '', 'System', 'Arthur Lam', 28361835, 'art@ittdc.org', 'Vocational Training Council', '27 Wood Road, 9/F, Wanchai, Hong Kong');
INSERT INTO Contact VALUES ('ITTDCPrimary1', 'guest1', 'guest1', 'www1.elc.ittdc.org', 'New', 'Arthur Lam', 28361835, 'art@ittdc.org', 'Vocational Training Council', '27 Wood Road, 9/F, Wanchai, Hong Kong');
INSERT INTO Contact VALUES ('ZZ', 'arthur', 'arthur', '/', 'New', 'Arthur Lam', 28361835, 'art@ittdc.org', 'Vocational Training Council', '27 Wood Road, 9/F, Wanchai, Hong Kong');
CREATE TABLE `Payment` (
  ShortName varchar(30) NOT NULL default '',
  Date date NOT NULL default '0000-00-00',
  Reference varchar(30) NOT NULL default '',
  Amount decimal(8,2) unsigned default NULL,
  PaidStartDate date NOT NULL default '0000-00-00',
  PaidEndDate date NOT NULL default '0000-00-00',
  Handler varchar(30) NOT NULL default '',
  DateUpdated date NOT NULL default '0000-00-00'
) TYPE=InnoDB COMMENT='Customer Payment information';
CREATE TABLE `Correspondence` (
  ShortName varchar(30) NOT NULL default '',
  Date date NOT NULL default '0000-00-00',
  Sender varchar(30) NOT NULL default '',
  Receiver varchar(30) NOT NULL default '',
  Handler varchar(30) NOT NULL default '',
  Content varchar(250) NOT NULL default '',
  DateUpdated date NOT NULL default '0000-00-00'
) TYPE=InnoDB COMMENT='Customer Correspondence information';
CREATE TABLE `JobHist` (
  Year mediumint(4) NOT NULL default '0',
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Job varchar(8) NOT NULL default '',
  Input bigint(12) NOT NULL default '0',
  ibdata1Size bigint(12) NOT NULL default '0',
  Disk char(4) NOT NULL default '0',
  GJTime time NULL default '00:00:00',
  RJTime time NULL default '00:00:00',
  GJStart time NULL default '00:00:00',
  GJFin time NULL default '00:00:00',
  RJFin time NULL default '00:00:00',
) TYPE=InnoDB COMMENT='Job timings for monitoring';
CREATE TABLE `TodayLog` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='Today Access Log';
CREATE TABLE `Yesterday-0Log` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='Yesterday Access Log';
CREATE TABLE `Yesterday-1Log` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='1 day before Yesterday Access Log';
CREATE TABLE `Yesterday-2Log` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='2 days before Yesterday Access Log';
CREATE TABLE `Yesterday-3Log` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='3 days before Yesterday Access Log';
CREATE TABLE `Yesterday-4Log` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='4 days before Yesterday Access Log';
CREATE TABLE `Yesterday-5Log` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='5 days before Yesterday Access Log';
CREATE TABLE `Yesterday-6Log` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='6 days before Yesterday Access Log';
CREATE TABLE `Yesterday-0LogSum` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  User varchar(30) NOT NULL default '',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='Yesterday Access Log Summary';
CREATE TABLE `Yesterday-1LogSum` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  User varchar(30) NOT NULL default '',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='1 day before Yesterday Access Log Summary';
CREATE TABLE `Yesterday-2LogSum` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  User varchar(30) NOT NULL default '',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='2 days before Yesterday Access Log Summary';
CREATE TABLE `Yesterday-3LogSum` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  User varchar(30) NOT NULL default '',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='3 days before Yesterday Access Log Summary';
CREATE TABLE `Yesterday-4LogSum` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  User varchar(30) NOT NULL default '',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='4 days before Yesterday Access Log Summary';
CREATE TABLE `Yesterday-5LogSum` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  User varchar(30) NOT NULL default '',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='5 days before Yesterday Access Log Summary';
CREATE TABLE `Yesterday-6LogSum` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  User varchar(30) NOT NULL default '',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='6 days before Yesterday Access Log Summary';
CREATE TABLE `LastMonth` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Users mediumint(9) NOT NULL default '0',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='Squid Access Log Summary for last month';
CREATE TABLE `ThisMonth` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Users mediumint(9) NOT NULL default '0',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='Squid Access Log Summary for this month';
CREATE TABLE `LastYear` (
  Mth char(3) NOT NULL default '',
  Days mediumint(9) NOT NULL default '0',
  Users mediumint(9) NOT NULL default '0',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='Squid Access Log Summary for last year';
CREATE TABLE `ThisYear` (
  Mth char(3) NOT NULL default '',
  Days mediumint(9) NOT NULL default '0',
  Users mediumint(9) NOT NULL default '0',
  TotPages mediumint(9) NOT NULL default '0',
  TotSize bigint(12) NOT NULL default '0',
  MaxSize bigint(12) NOT NULL default '0',
  Size bigint(12) NOT NULL default '0',
  MinSize bigint(12) NOT NULL default '0',
  MaxSpeed decimal(8,2) unsigned default NULL,
  Speed decimal(8,2) unsigned default NULL,
  MinSpeed decimal(8,2) unsigned default NULL,
  MaxWait mediumint(9) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  MinWait mediumint(9) NOT NULL default '0'
) TYPE=InnoDB COMMENT='Squid Access Log Summary for this year';
CREATE TABLE `PageSize` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='This month daily 10 biggest pages';
CREATE TABLE `PageWait` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='This month daily 10 wait-longest pages';
CREATE TABLE `PageSpeed` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='This month daily 10 slowest pages';
CREATE TABLE `PageSizeLastMonth` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='Last month daily 10 biggest pages';
CREATE TABLE `PageWaitLastMonth` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='Last month daily 10 wait-longest pages';
CREATE TABLE `PageSpeedLastMonth` (
  Mth char(3) NOT NULL default '',
  Day smallint(2) NOT NULL default '0',
  Time varchar(8) NOT NULL default '',
  User varchar(30) NOT NULL default '',
  Size bigint(12) NOT NULL default '0',
  Wait mediumint(9) NOT NULL default '0',
  Speed decimal(8,2) unsigned default NULL,
  Status varchar(30) default NULL,
  Command varchar(20) default NULL,
  Page varchar(250) default NULL
) TYPE=InnoDB COMMENT='Last month daily 10 slowest pages';
EXIT