CREATE TABLE item_types ( symbol TEXT PRIMARY KEY, value INTEGER ); CREATE INDEX item_types_idx1 ON item_types (value); .import item_types item_types CREATE TABLE socials ( name TEXT PRIMARY KEY, char_no_arg TEXT, others_no_arg TEXT, char_found TEXT, others_found TEXT, vict_found TEXT, char_auto TEXT, others_auto TEXT ); .import socials socials CREATE TABLE titles ( class INTEGER, level INTEGER, sex INTEGER, title TEXT ); .import titles titles CREATE TABLE helps ( level INTEGER, keyword INTEGER, text TEXT ); CREATE TABLE areas ( id INTEGER PRIMARY KEY, name TEXT ); CREATE TABLE mobiles ( id INTEGER PRIMARY KEY, name TEXT, short_descr TEXT, description TEXT, vnum INTEGER, long_descr TEXT actflags INTEGER, affected_by INTEGER, alignment INTEGER, level INTEGER, sex INTEGER, area_id INTEGER ); CREATE TABLE objects ( id INTEGER PRIMARY KEY, name TEXT, short_descr TEXT, description TEXT, vnum INTEGER, item_type INTEGER, wear_flags INTEGER, extra_flags INTEGER, value1 TEXT, value2 TEXT, value3 TEXT, value4 TEXT, weight INTEGER, cost INTEGER, area_id INTEGER ); CREATE TABLE rooms ( id INTEGER PRIMARY KEY, name TEXT, short_descr TEXT, description TEXT, vnum INTEGER, room_flags INTEGER, light INTEGER, sector_type INTEGER, area_id INTEGER ); CREATE TABLE extra_descriptions ( id INTEGER PRIMARY KEY, keyword TEXT, description TEXT, eid INTEGER ); CREATE TABLE exits ( id INTEGER PRIMARY KEY, name TEXT, short_descr TEXT, description TEXT, vnum INTEGER, direction INTEGER, exit_info INTEGER, key INTEGER, room_id INTEGER ); CREATE TABLE affects ( id INTEGER PRIMARY KEY, type INTEGER, duration INTEGER, location INTEGER, modifer INTEGER, bitvector INTEGER, aid INTEGER ); CREATE TABLE resets ( id INTEGER PRIMARY KEY, command TEXT, arg1 INTEGER, arg2 INTEGER, arg3 INTEGER ); CREATE TABLE shops ( id INTEGER PRIMARY KEY, keeper INTEGER, buy_type1 INTEGER, buy_type2 INTEGER, buy_type3 INTEGER, buy_type4 INTEGER, buy_type5 INTEGER, profit_buy INTEGER, profit_sell INTEGER, open_hour INTEGER, close_hour INTEGER );