| 199 |
199 |
`Hits` int(10) unsigned NOT NULL default '0',
|
| 200 |
200 |
`IP` char(1) NOT NULL default '',
|
| 201 |
201 |
`UserID` int(10) unsigned NOT NULL default '0',
|
| 202 |
|
`Interface` enum('api','webview') default NULL,
|
|
202 |
`Interface` enum('api','webview') default NULL,
|
| 203 |
203 |
PRIMARY KEY (`SessionID`)
|
| 204 |
204 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
| 205 |
205 |
|
| ... | ... | |
| 303 |
303 |
`W_Comments` text NOT NULL,
|
| 304 |
304 |
`W_Debug` char(1) NOT NULL default '0',
|
| 305 |
305 |
`W_DebugCount` int(10) unsigned NOT NULL default '0',
|
| 306 |
|
`W_BalanceThreshold` decimal(11,4) unsigned NOT NULL default '0.0000',
|
|
306 |
`W_BalanceThreshold` decimal(11,4) unsigned NOT NULL default '0.0000',
|
| 307 |
307 |
`W_AllowDataLogging` char(1) NOT NULL default '0' COMMENT 'Determines whether logging of data for update services is allowed',
|
| 308 |
308 |
PRIMARY KEY (`UserID`),
|
| 309 |
309 |
UNIQUE KEY `Nickname` (`Nickname`),
|
| ... | ... | |
| 540 |
540 |
`ResponseText` text,
|
| 541 |
541 |
PRIMARY KEY (`LogID`)
|
| 542 |
542 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
| 543 |
|
|
| 544 |
|
-- --------------------------------------------------------
|
| 545 |
|
|
| 546 |
|
--
|
| 547 |
|
-- Table structure for table `W_RequestLog`
|
| 548 |
|
--
|
| 549 |
|
|
| 550 |
|
CREATE TABLE `W_RequestLog` (
|
| 551 |
|
`LogID` int(10) unsigned NOT NULL,
|
| 552 |
|
`EndpointProtocol` enum('http','https') NOT NULL default 'http',
|
| 553 |
|
`EndpointPath` varchar(100) NOT NULL default '',
|
| 554 |
|
`MethodName` varchar(64) NOT NULL,
|
| 555 |
|
`IncludeTime` float unsigned NOT NULL default '0',
|
| 556 |
|
`InitTime` float unsigned NOT NULL default '0',
|
| 557 |
|
`ActionTime` float unsigned NOT NULL default '0',
|
| 558 |
|
`DatabaseTime` float unsigned NOT NULL default '0',
|
| 559 |
|
`TotalTime` float unsigned NOT NULL default '0',
|
| 560 |
|
PRIMARY KEY (`LogID`)
|
| 561 |
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
| 562 |
543 |
|
| 563 |
544 |
-- --------------------------------------------------------
|
| 564 |
545 |
|
| 565 |
546 |
--
|
|
547 |
-- Table structure for table `W_RequestLog`
|
|
548 |
--
|
|
549 |
|
|
550 |
CREATE TABLE `W_RequestLog` (
|
|
551 |
`LogID` int(10) unsigned NOT NULL,
|
|
552 |
`EndpointProtocol` enum('http','https') NOT NULL default 'http',
|
|
553 |
`EndpointPath` varchar(100) NOT NULL default '',
|
|
554 |
`MethodName` varchar(64) NOT NULL,
|
|
555 |
`IncludeTime` float unsigned NOT NULL default '0',
|
|
556 |
`InitTime` float unsigned NOT NULL default '0',
|
|
557 |
`ActionTime` float unsigned NOT NULL default '0',
|
|
558 |
`DatabaseTime` float unsigned NOT NULL default '0',
|
|
559 |
`TotalTime` float unsigned NOT NULL default '0',
|
|
560 |
PRIMARY KEY (`LogID`)
|
|
561 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
562 |
|
|
563 |
-- --------------------------------------------------------
|
|
564 |
|
|
565 |
--
|
| 566 |
566 |
-- Table structure for table `W_SyncBalance`
|
| 567 |
567 |
--
|
| 568 |
568 |
|
| ... | ... | |
| 682 |
682 |
-- Table structure for table `W_ErrorLog`
|
| 683 |
683 |
--
|
| 684 |
684 |
|
| 685 |
|
CREATE TABLE `W_ErrorLog` (
|
| 686 |
|
`Action` varchar(255) NOT NULL,
|
| 687 |
|
`ErrorCode` varchar(255) NOT NULL,
|
| 688 |
|
`FirstOccurrence` datetime NOT NULL,
|
| 689 |
|
`LastMail` datetime NOT NULL,
|
| 690 |
|
`LastOccurrence` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
|
| 691 |
|
`AmountTotal` int(10) unsigned NOT NULL default '1',
|
| 692 |
|
`AmountSinceLastMail` int(10) unsigned NOT NULL default '0',
|
| 693 |
|
PRIMARY KEY (`Action`,`ErrorCode`)
|
|
685 |
CREATE TABLE `W_ErrorLog` (
|
|
686 |
`Action` varchar(255) NOT NULL,
|
|
687 |
`ErrorCode` varchar(255) NOT NULL,
|
|
688 |
`FirstOccurrence` datetime NOT NULL,
|
|
689 |
`LastMail` datetime NOT NULL,
|
|
690 |
`LastOccurrence` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
|
|
691 |
`AmountTotal` int(10) unsigned NOT NULL default '1',
|
|
692 |
`AmountSinceLastMail` int(10) unsigned NOT NULL default '0',
|
|
693 |
PRIMARY KEY (`Action`,`ErrorCode`)
|
| 694 |
694 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
| 695 |
695 |
|
| 696 |
696 |
|
| ... | ... | |
| 820 |
820 |
KEY `Key` (`Key`,`TTL_Time`)
|
| 821 |
821 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
| 822 |
822 |
|
| 823 |
|
|
| 824 |
|
-- --------------------------------------------------------
|
| 825 |
|
|
| 826 |
|
--
|
| 827 |
|
-- Table structure for table `W_BusinessDataLog`
|
| 828 |
|
--
|
| 829 |
|
|
| 830 |
|
CREATE TABLE `W_BusinessDataLog` (
|
| 831 |
|
`UserID` int(10) unsigned NOT NULL,
|
| 832 |
|
`DossierNo` int(8) unsigned zerofill NOT NULL,
|
| 833 |
|
`SubDossierNo` smallint(4) unsigned zerofill NOT NULL,
|
| 834 |
|
`DateRetrievedVersion` date NOT NULL,
|
| 835 |
|
`IsCurrent` tinyint(3) unsigned NOT NULL default '0',
|
| 836 |
|
PRIMARY KEY (`UserID`,`DossierNo`,`SubDossierNo`),
|
| 837 |
|
KEY `UserID` (`UserID`,`IsCurrent`)
|
| 838 |
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
| 839 |
823 |
|
|
824 |
-- --------------------------------------------------------
|
| 840 |
825 |
|
|
826 |
--
|
|
827 |
-- Table structure for table `W_BusinessDataLog`
|
|
828 |
--
|
|
829 |
|
|
830 |
CREATE TABLE `W_BusinessDataLog` (
|
|
831 |
`UserID` int(10) unsigned NOT NULL,
|
|
832 |
`DossierNo` int(8) unsigned zerofill NOT NULL,
|
|
833 |
`SubDossierNo` smallint(4) unsigned zerofill NOT NULL,
|
|
834 |
`DateRetrievedVersion` date NOT NULL,
|
|
835 |
`IsCurrent` tinyint(3) unsigned NOT NULL default '0',
|
|
836 |
PRIMARY KEY (`UserID`,`DossierNo`,`SubDossierNo`),
|
|
837 |
KEY `UserID` (`UserID`,`IsCurrent`)
|
|
838 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
839 |
|
|
840 |
|
| 841 |
841 |
-- --------------------------------------------------------
|
| 842 |
842 |
|
| 843 |
843 |
--
|
| 844 |
844 |
-- Table structure for table `W_SyncBusinessDataLog`
|
| 845 |
845 |
--
|
| 846 |
846 |
|
| 847 |
|
CREATE TABLE `W_SyncBusinessDataLog` (
|
| 848 |
|
`SyncID` int(11) unsigned NOT NULL auto_increment,
|
| 849 |
|
`Synced` tinyint(1) unsigned NOT NULL default '0',
|
| 850 |
|
`RecordTimestamp` int(10) unsigned NOT NULL,
|
| 851 |
|
`Action` enum('insert','delete') NOT NULL,
|
| 852 |
|
`UserID` int(11) unsigned NOT NULL,
|
| 853 |
|
`DossierNo` int(8) unsigned zerofill NOT NULL,
|
| 854 |
|
`SubDossierNo` smallint(4) unsigned zerofill NOT NULL,
|
| 855 |
|
PRIMARY KEY (`SyncID`),
|
| 856 |
|
KEY `Synced` (`Synced`),
|
| 857 |
|
KEY `ConflictIndex` (`RecordTimestamp`,`UserID`,`DossierNo`)
|
| 858 |
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
847 |
CREATE TABLE `W_SyncBusinessDataLog` (
|
|
848 |
`SyncID` int(11) unsigned NOT NULL auto_increment,
|
|
849 |
`Synced` tinyint(1) unsigned NOT NULL default '0',
|
|
850 |
`RecordTimestamp` int(10) unsigned NOT NULL,
|
|
851 |
`Action` enum('insert','delete') NOT NULL,
|
|
852 |
`UserID` int(11) unsigned NOT NULL,
|
|
853 |
`DossierNo` int(8) unsigned zerofill NOT NULL,
|
|
854 |
`SubDossierNo` smallint(4) unsigned zerofill NOT NULL,
|
|
855 |
PRIMARY KEY (`SyncID`),
|
|
856 |
KEY `Synced` (`Synced`),
|
|
857 |
KEY `ConflictIndex` (`RecordTimestamp`,`UserID`,`DossierNo`)
|
|
858 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
859 |
|
|
860 |
--
|
|
861 |
-- Table structure for table `W_CountryLog`
|
|
862 |
--
|
|
863 |
|
|
864 |
CREATE TABLE `W_CountryLog` (
|
|
865 |
`Country` varchar(3) NOT NULL,
|
|
866 |
`Count` int(11) NOT NULL,
|
|
867 |
PRIMARY KEY (`Country`)
|
|
868 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
869 |
|
