This repository has been archived by the owner on Jun 9, 2020. It is now read-only.
forked from Fleker/mydnd-party
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtables.js
58 lines (46 loc) · 1.62 KB
/
tables.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
/**
default tags:
* campaign
* combat
* dm
* inventory
* quest
* magic
* monster
* npc
* player
* player-class
* potion
* printout
* race
* reference
* skills
* world-building
default categories:
* DND 1
* DND 2
* DND 3.5
* DND 4
* DND 5
* Pathfinder
resources
| serial id | text title | text description | text url | text tags | text categories | bigint submitted | int clicks |
|___________________________|_________________________________|_______________|_____________________|______________________|_____________________|____________|
| 1 | "Herbs List" | A list of herbs for each season |"bit.ly/herbs" | "herbs", "world" | "DND 1" | 3000 | 0 |
|___________________________|_________________________________|_______________|_____________________|______________________|_____________________|____________|
create table resources (id serial, title text, description text, url text, tags text, categories text, submitted bigint, clicks int);
searches
| serial id | text search | bigint searchtime |
|___________|_____________|______________________|
| 1 | "hurbs" | 3001 |
|___________|_____________|______________________|
create table searches (id serial, search text, searchtime bigint);
user_redirects
| serial id | text campaign | text url |
|___________|_______________|___________________|
| 1 | "Terranor" | "bit.ly/terranor" |
|___________|_______________|___________________|
create table user_redirects (id serial, campaign text, url text);
TODO SQL validation
TODO NPC backstory generator
**/