Skip to content

jgleesawn/websocket_server

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

32 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Requires postgresql with user in it and db_name that user can write to.
Requires environment variable:
DATABASE_URL=postgres://user:password@address/db_name
meant to work with heroku's postgresql system.

CREATE TABLE quests (
questid			int		PRIMARY KEY,
name			text	NOT NULL,
description		text	NOT NULL,
notes			text	NOT NULL,
category		text	NOT NULL,
recurring		boolean	NOT NULL,
xpvalue			int		NOT NULL,
image			text	NOT NULL,
requiredquests	[]int			,
attributes		[]text			
);

ALTER TABLE quests ADD notes text;
ALTER TABLE quests ADD image text;
UPDATE quests SET notes='';
UPDATE quests SET image='';
ALTER TABLE quests ALTER notes SET NOT NULL;
ALTER TABLE quests ALTER image SET NOT NULL;

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors