 CREATE TABLE creatures (
     guid        INTEGER      PRIMARY KEY AUTOINCREMENT
                              DEFAULT (1),
-    creature_id INTEGER,
+    creature_id INTEGER      REFERENCES creature_template (entry),
     type        VARCHAR (60),
     zone        VARCHAR (60),
     sub_zone    VARCHAR (60) 

                              NULL,
                              1,
                              1,
                              '',
                              '',
                              '',
                              NULL
                          );


CREATE TABLE npc_vendor (
    creature_entry INTEGER PRIMARY KEY AUTOINCREMENT,
    item_id        INTEGER REFERENCES item_template (entry),
    item_count     INTEGER DEFAULT (1),
    price          INTEGER
);
