· 7 years ago · Feb 13, 2019, 05:26 AM
1CREATE TABLE IF NOT EXISTS quick(
2 id integer DEFAULT nextval('quick_id_seq'::regclass) NOT NULL,
3 profile integer NOT NULL,
4 wayname character varying NOT NULL,
5 datetime timestamp without time zone NULL,
6);
7
8CREATE TABLE IF NOT EXISTS streak(
9 id integer DEFAULT nextval('streak_id_seq'::regclass) NOT NULL,
10 user_id integer NOT NULL,
11 wayid integer NOT NULL,
12 status character varying(50) DEFAULT NULL::character varying NULL,
13 day character varying(50) DEFAULT NULL::character varying NULL,
14 streak character varying(50) DEFAULT NULL::character varying NULL,
15 datetime timestamp without time zone NULL,
16 CONSTRAINT "routine_streak_pkey" PRIMARY KEY (id)
17);