blob: 783745a36ae455a5bd9af919cca590a30a1fb0c3 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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
);
|
