CREATE TABLE "resources" ("id" integer primary key autoincrement not null, "name" varchar not null, "internal_id" integer not null default '0', "url" varchar not null, "type" varchar not null, "created_at" datetime, "updated_at" datetime, "metadata" text)