diff options
| author | Tharre <tharre3@gmail.com> | 2017-08-16 04:50:59 +0200 |
|---|---|---|
| committer | Tharre <tharre3@gmail.com> | 2017-08-16 04:50:59 +0200 |
| commit | efc118af1bd4910c64292a45dca34bf13d428f8d (patch) | |
| tree | 3bc5beeda33e2a3174eab1448c1692946be7b39f /schema.sql | |
| download | albion-api-efc118af1bd4910c64292a45dca34bf13d428f8d.tar.gz albion-api-efc118af1bd4910c64292a45dca34bf13d428f8d.tar.xz albion-api-efc118af1bd4910c64292a45dca34bf13d428f8d.zip | |
Initial commit
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 15 |
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 +); |