 DROP TABLE IF EXISTS saved_character_inventory;
 
 CREATE TABLE saved_character_inventory (
-    id         INTEGER,
-    item_id    INTEGER,
-    item_count INTEGER
+    id                 INTEGER PRIMARY KEY,
+    saved_character_id INTEGER REFERENCES saved_character,
+    item_id            INTEGER REFERENCES item_template (entry),
+    item_count         INTEGER
 );
 
 INSERT INTO saved_character_inventory (
                                           id,
-                                          item_id,
-                                          item_count
-                                      )
-                                      VALUES (
-                                          2,
-                                          300,
-                                          3
-                                      );
-
-INSERT INTO saved_character_inventory (
-                                          id,
-                                          item_id,
-                                          item_count
-                                      )
-                                      VALUES (
-                                          1,
-                                          11,
-                                          5
-                                      );
-
-INSERT INTO saved_character_inventory (
-                                          id,
-                                          item_id,
-                                          item_count
-                                      )
-                                      VALUES (
-                                          1,
-                                          1,
-                                          1
-                                      );
-
-INSERT INTO saved_character_inventory (
-                                          id,
+                                          saved_character_id,
                                           item_id,
                                           item_count
                                       )
                                       VALUES (
                                           1,
                                           2,
+                                          300,
+                                          3
+                                      );
+
+INSERT INTO saved_character_inventory (
+                                          id,
+                                          saved_character_id,
+                                          item_id,
+                                          item_count
+                                      )
+                                      VALUES (
+                                          2,
+                                          1,
+                                          11,
+                                          5
+                                      );
+
+INSERT INTO saved_character_inventory (
+                                          id,
+                                          saved_character_id,
+                                          item_id,
+                                          item_count
+                                      )
+                                      VALUES (
+                                          3,
+                                          1,
+                                          1,
+                                          5
+                                      );
+
+INSERT INTO saved_character_inventory (
+                                          id,
+                                          saved_character_id,
+                                          item_id,
+                                          item_count
+                                      )
+                                      VALUES (
+                                          4,
+                                          1,
+                                          2,
+                                          3
+                                      );
+
+INSERT INTO saved_character_inventory (
+                                          id,
+                                          saved_character_id,
+                                          item_id,
+                                          item_count
+                                      )
+                                      VALUES (
+                                          5,
+                                          1,
+                                          12,
+                                          1
+                                      );
+
+INSERT INTO saved_character_inventory (
+                                          id,
+                                          saved_character_id,
+                                          item_id,
+                                          item_count
+                                      )
+                                      VALUES (
+                                          6,
+                                          1,
+                                          10,
+                                          1
+                                      );
+
+INSERT INTO saved_character_inventory (
+                                          id,
+                                          saved_character_id,
+                                          item_id,
+                                          item_count
+                                      )
+                                      VALUES (
+                                          7,
+                                          1,
+                                          9,
+                                          1
+                                      );
+
+INSERT INTO saved_character_inventory (
+                                          id,
+                                          saved_character_id,
+                                          item_id,
+                                          item_count
+                                      )
+                                      VALUES (
+                                          8,
+                                          1,
+                                          14,
+                                          1
+                                      );
+
+INSERT INTO saved_character_inventory (
+                                          id,
+                                          saved_character_id,
+                                          item_id,
+                                          item_count
+                                      )
+                                      VALUES (
+                                          9,
+                                          1,
+                                          4,
                                           1
                                       );
 

DROP TABLE IF EXISTS saved_character_killed_monsters;

CREATE TABLE saved_character_killed_monsters (
    id   INTEGER,
    GUID INTEGER
);

INSERT INTO saved_character_killed_monsters (
                                                id,
                                                GUID
                                            )
                                            VALUES (
                                                1,
                                                20
                                            );

INSERT INTO saved_character_killed_monsters (
                                                id,
                                                GUID
                                            )
                                            VALUES (
                                                1,
                                                15
                                            );

                                        6,
                                        NULL,
                                        NULL,
                                        NULL,
                                        NULL
                                    );

