/
opt
/
canhelp
/
packages
/
db
/
migrations
/
/opt/canhelp/packages/db/migrations
mkdir
upload
Name
Size
Mode
Actions
meta/
-
0755
rm
0000_organic_ultimo.sql
23071
0644
edit
dl
rm
0001_demonic_vertigo.sql
272
0644
edit
dl
rm
0002_tricky_wild_child.sql
1116
0644
edit
dl
rm
0003_absent_carlie_cooper.sql
67
0644
edit
dl
rm
0004_clean_kid_colt.sql
857
0644
edit
dl
rm
0005_support_tickets.sql
821
0644
edit
dl
rm
0006_plan_history.sql
453
0644
edit
dl
rm
0007_unknown_ricochet.sql
1179
0644
edit
dl
rm
0008_massive_cable.sql
68
0644
edit
dl
rm
0009_talented_stepford_cuckoos.sql
372
0644
edit
dl
rm
0010_gorgeous_ironclad.sql
387
0644
edit
dl
rm
0011_gifted_nightcrawler.sql
107
0644
edit
dl
rm
0012_quiet_santa_claus.sql
65
0644
edit
dl
rm
0013_single_role_unification.sql
732
0644
edit
dl
rm
0014_jazzy_menace.sql
59
0644
edit
dl
rm
0015_moaning_nightshade.sql
1736
0644
edit
dl
rm
0016_gorgeous_maximus.sql
93
0644
edit
dl
rm
0017_outstanding_daimon_hellstrom.sql
557
0644
edit
dl
rm
0018_price_list_i18n.sql
2808
0644
edit
dl
rm
0019_typical_harry_osborn.sql
2417
0644
edit
dl
rm
0020_simple_queen_noir.sql
190
0644
edit
dl
rm
0021_specialist_card_publication_status.sql
426
0644
edit
dl
rm
0022_youthful_brother_voodoo.sql
1594
0644
edit
dl
rm
Edit:
/opt/canhelp/packages/db/migrations/0006_plan_history.sql
(453B)
CREATE TABLE IF NOT EXISTS "plan_history" ( "id" text PRIMARY KEY NOT NULL, "user_id" text NOT NULL REFERENCES "users"("id") ON DELETE CASCADE, "event" varchar(30) NOT NULL, "plan_id" text NOT NULL, "plan_name" varchar(100) NOT NULL, "previous_plan_id" text, "previous_plan_name" varchar(100), "expires_at" timestamp, "days_added" integer, "referral_reward_id" text, "note" text, "created_at" timestamp NOT NULL DEFAULT now() );
Save
cmd:
run