-- drop the existing tables before starting
drop table aodb;
drop table aodb_nano;
drop table aodb_ext;
drop table aodb_other;
drop table aodb_eff;
drop table aodb_req;
drop table aodb_skill;

-- create new tables
create table aodb (
-- metadata
	xid integer primary key,
	hash integer not null,
	metatype char(1) not null,
	aoid integer not null,
	patch integer not null,
	current boolean not null default false,
-- common properties
	flags integer default 0,
	props integer default 0,
	ql integer,
	type integer,
	slot integer,
	patchadded integer
);

create table aodb_ext (
	xid integer primary key,
	icon integer,
	defslot integer,
	value integer,
	tequip integer,
	tattack integer,
	trecharge integer,
	dmin integer,
	dmax integer,
	dcrit integer,
	dtype integer,
	clip integer,
	atype integer,
-- for nanos
	duration integer,
-- both weapons and nanos
	range integer,
-- text fields (common)
	name text,
	info text
);

CREATE TABLE aodb_nano (
	xid integer primary key,
	crystal integer,
	ncu integer,
	nanocost integer,
	school integer,
	strain integer
);

create table aodb_other (
	xid integer,
	attribute integer,
	value integer
);

create table aodb_eff (
	xid integer not null,
	hook integer,
	type integer,
	reqid integer,
	hits integer,
	delay integer,
	target integer,
	value1 integer,
	value2 integer,
	value3 integer,
	value4 integer,
	value5 integer,
	text text
);

create table aodb_req (
	xid integer not null,
	reqid integer,
	hook integer,
	attribute integer,
	value integer,
	type integer,
	opmod integer
);

create table aodb_skill (
	xid integer not null,
	type integer not null,
	attribute integer,
	value integer
);