Skip to content
master
Switch branches/tags
Go to file
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
css
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

README.md

earls-urls

earl shortener

.env file

Define your db connection string and port

DATABASE_URL="postgres://user@host/dbname"
PORT=5000

Database schema:

urls

Column | Type | Modifiers
-----------+-----------------------------+------------------------------------- id | integer | default nextval('id_seq'::regclass) url | text | timestamp | timestamp without time zone | default now() user_id | integer |

CREATE TABLE urls (
id integer DEFAULT nextval('id_seq'::regclass),
url text,
"timestamp" timestamp without time zone DEFAULT now(),
user_id integer
);

users

Column | Type | Modifiers
----------+------------------------+---------------------------------------------------- id | integer | not null default nextval('users_id_seq'::regclass) username | character varying(40) | password | character varying(255) | Indexes: "users_username_key" UNIQUE, btree (lower(username::text))

CREATE TABLE users (
id integer NOT NULL,
username character varying(40),
password character varying(255)
);


CREATE SEQUENCE users_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);

CREATE UNIQUE INDEX users_username_key ON users USING btree (lower((username)::text));

Front-end

gulp default|watch