From efc118af1bd4910c64292a45dca34bf13d428f8d Mon Sep 17 00:00:00 2001
From: Tharre <tharre3@gmail.com>
Date: Wed, 16 Aug 2017 04:50:59 +0200
Subject: Initial commit

---
 schema.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 schema.sql

(limited to 'schema.sql')

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
+);
-- 
cgit v1.2.3-70-g09d2