ihSw1yB4

1
2create table if not exists items
3(
4	id integer not null
5		constraint items_pkey
6			primary key,
7	name char(100) not null,
8	level integer not null,
9	class char(50) not null,
10	subclass char(50) not null,
11	vendorbuy bigint not null,
12	vendorsell bigint not null
13)
14;
15
16create unique index if not exists items_id_uindex
17	on items (id)
18;
19
20create table if not exists players
21(
22	id integer not null
23		constraint players_pkey
24			primary key,
25	name char(100) not null
26)
27;
28
29create table if not exists auctions
30(
31	id bigint not null
32		constraint auctions_pkey
33			primary key,
34	bid bigint,
35	buyout bigint,
36	quantity integer,
37	time_left smallint,
38	updated_at bigint,
39	owner_id integer not null,
40	item_id integer not null,
41	vl bigint,
42	l bigint,
43	m bigint,
44	s bigint,
45	state smallint,
46	start_bid bigint
47)
48;