Changeset 15 for trunk/SQL

Timestamp:

Sep 5, 2019, 9:47:21 AM (5 years ago)

Author:

chronos

Message:

• Added: Support for storing data for multiple years.
• Modified: Improved data synchronization to sync data only if they were changed. Checked with hash function agains previous stored value.

Location:

trunk/SQL

Files:

• Structure.sql (modified) (7 diffs)
• Upgrade.txt (added)

trunk/SQL/Structure.sql

@@ -4 +4 @@
 --
 -- Host: localhost:3306
--- Generation Time: Aug 29, 2019 at 12:02 AM
+-- Generation Time: Sep 05, 2019 at 09:42 AM
 -- Server version: 10.3.17-MariaDB-0ubuntu0.19.04.1
 -- PHP Version: 7.2.19-0ubuntu0.19.04.2
@@ -20 +20 @@
 -- Database: `teribear`
 --
-CREATE DATABASE IF NOT EXISTS `teribear` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
-USE `teribear`;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `Import`
+--
+
+CREATE TABLE `Import` (
+  `Id` int(11) NOT NULL,
+  `Time` datetime NOT NULL,
+  `Hash` varchar(255) NOT NULL,
+  `ItemCount` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 
 -- --------------------------------------------------------
@@ -34 +45 @@
   `Gender` int(11) NOT NULL,
   `Team` int(11) DEFAULT NULL,
-  `ChipNumber` int(11) NOT NULL
+  `ChipNumber` int(11) NOT NULL,
+  `Year` int(11) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
 
@@ -62 +74 @@
   `Name` varchar(255) NOT NULL,
   `WebId` int(11) NOT NULL,
-  `IsFamily` int(11) NOT NULL
+  `IsFamily` int(11) NOT NULL,
+  `Year` int(11) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
 
@@ -83 +96 @@
 -- Indexes for dumped tables
 --
+
+--
+-- Indexes for table `Import`
+--
+ALTER TABLE `Import`
+  ADD PRIMARY KEY (`Id`);
 
 --
@@ -116 +135 @@
 
 --
+-- AUTO_INCREMENT for table `Import`
+--
+ALTER TABLE `Import`
+  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
+--
 -- AUTO_INCREMENT for table `Runner`
 --
 ALTER TABLE `Runner`
-  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18158;
+  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31205;
 --
 -- AUTO_INCREMENT for table `RunnerStat`
 --
 ALTER TABLE `RunnerStat`
-  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=136448;
+  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250219;
 --
 -- AUTO_INCREMENT for table `Team`
@@ -134 +158 @@
 --
 ALTER TABLE `TeamStat`
-  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4088;
+  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55625;
 --
 -- Constraints for dumped tables