1 files changed, 15 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..783745a
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,15 @@
+DROP TABLE IF EXISTS `orders`;
+CREATE TABLE `orders` (
+  `Id` int(11) NOT NULL,
+  `Amount` int(11) NOT NULL,
+  `AuctionType` varchar(20) NOT NULL,
+  `EnchantmentLevel` int(11) NOT NULL,
+  `Expires` timestamp NOT NULL,
+  `ItemTypeId` varchar(50) NOT NULL,
+  `LocationId` int(11) NOT NULL,
+  `QualityLevel` int(11) NOT NULL,
+  `UnitPriceSilver` int(11) NOT NULL,
+  `Inserted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  PRIMARY KEY (`id`)
+  ON CONFLICT REPLACE
+);