code_junkie

One to One database relation?

Nov 11th, 2011
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. CREATE TABLE players(
  2. id INTEGER NOT NULL,
  3. username VARCHAR2(32) NOT NULL,
  4. password VARCHAR2(32) NOT NULL,
  5. email VARCHAR2(160),
  6. character VARCHAR2(32) NOT NULL,
  7. status VARCHAR2(32),
  8. hitpoints INTEGER,
  9.  
  10. CONSTRAINT pk_players PRIMARY KEY (uid)
  11. );
  12.  
  13. -- track information on the player
  14. CREATE TABLE players(
  15. id INTEGER NOT NULL,
  16. username VARCHAR2(32) NOT NULL,
  17. password VARCHAR2(32) NOT NULL,
  18. email VARCHAR2(160),
  19.  
  20. CONSTRAINT pk_players PRIMARY KEY (id)
  21. );
  22.  
  23. -- track information on the character
  24. CREATE TABLE characters(
  25. id INTEGER NOT NULL,
  26. player_id INTEGER NOT NULL,
  27. character VARCHAR2(32) NOT NULL,
  28. status VARCHAR2(32),
  29. hitpoints INTEGER,
  30.  
  31. CONSTRAINT pk_characters PRIMARY KEY (id)
  32. );
  33. -- foreign key reference
  34. ALTER TABLE characters
  35. ADD CONSTRAINT characters__players
  36. FOREIGN KEY (player_id) REFERENCES players (id);
  37.  
  38. CREATE TABLE Players (
  39. PlayerID int,
  40. PlayerName varchar(50),
  41. ...
  42. Quest1ID int,
  43. Quest2ID int,
  44. Quest3ID int,
  45. ...
  46. Quest10ID int,
  47. ...
  48. )
  49.  
  50. CREATE TABLE Players (
  51. PlayerID int,
  52. PlayerName varchar(50),
  53. ...
  54. Quest1ID int,
  55. Quest2ID int,
  56. Quest3ID int,
  57. ...
  58. Quest25ID int,
  59. ...
  60. )
  61.  
  62. CREATE TABLE Players (
  63. PlayerID int,
  64. PlayerName varchar(50),
  65. ...
  66. )
  67.  
  68. CREATE TABLE PlayerQuests (
  69. PlayerID int,
  70. QuestID int
  71. )
Add Comment
Please, Sign In to add comment