Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE players(
- id INTEGER NOT NULL,
- username VARCHAR2(32) NOT NULL,
- password VARCHAR2(32) NOT NULL,
- email VARCHAR2(160),
- character VARCHAR2(32) NOT NULL,
- status VARCHAR2(32),
- hitpoints INTEGER,
- CONSTRAINT pk_players PRIMARY KEY (uid)
- );
- -- track information on the player
- CREATE TABLE players(
- id INTEGER NOT NULL,
- username VARCHAR2(32) NOT NULL,
- password VARCHAR2(32) NOT NULL,
- email VARCHAR2(160),
- CONSTRAINT pk_players PRIMARY KEY (id)
- );
- -- track information on the character
- CREATE TABLE characters(
- id INTEGER NOT NULL,
- player_id INTEGER NOT NULL,
- character VARCHAR2(32) NOT NULL,
- status VARCHAR2(32),
- hitpoints INTEGER,
- CONSTRAINT pk_characters PRIMARY KEY (id)
- );
- -- foreign key reference
- ALTER TABLE characters
- ADD CONSTRAINT characters__players
- FOREIGN KEY (player_id) REFERENCES players (id);
- CREATE TABLE Players (
- PlayerID int,
- PlayerName varchar(50),
- ...
- Quest1ID int,
- Quest2ID int,
- Quest3ID int,
- ...
- Quest10ID int,
- ...
- )
- CREATE TABLE Players (
- PlayerID int,
- PlayerName varchar(50),
- ...
- Quest1ID int,
- Quest2ID int,
- Quest3ID int,
- ...
- Quest25ID int,
- ...
- )
- CREATE TABLE Players (
- PlayerID int,
- PlayerName varchar(50),
- ...
- )
- CREATE TABLE PlayerQuests (
- PlayerID int,
- QuestID int
- )
Add Comment
Please, Sign In to add comment