-- Sovereign full live D1 database export. SQLite SQL, not MySQL SQL.
-- Exported 2026-10-12T08:58:12.623Z
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE "__appgarden_migrations"(id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT UNIQUE,applied_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL);
CREATE TABLE `emergency_alerts` (
	`id` text PRIMARY KEY NOT NULL,
	`user_id` text NOT NULL,
	`created_at` integer NOT NULL,
	`result` text NOT NULL
);
CREATE TABLE `enrolments` (
	`id` text PRIMARY KEY NOT NULL,
	`user_email` text NOT NULL,
	`kind` text NOT NULL,
	`data` text NOT NULL,
	`status` text DEFAULT 'submitted' NOT NULL,
	`review_note` text DEFAULT '' NOT NULL,
	`updated_at` integer NOT NULL
);
CREATE TABLE `membership_trials` (
	`user_email` text PRIMARY KEY NOT NULL,
	`started_at` integer NOT NULL,
	`ends_at` integer NOT NULL
);
CREATE TABLE `payment_receipts` (
	`id` text PRIMARY KEY NOT NULL,
	`subscription_id` text NOT NULL,
	`amount_cents` integer NOT NULL,
	`received_at` integer NOT NULL
);
CREATE TABLE `payment_settings` (
	`id` text PRIMARY KEY NOT NULL,
	`encrypted` text NOT NULL
);
CREATE TABLE `payment_subscriptions` (
	`id` text PRIMARY KEY NOT NULL,
	`user_email` text NOT NULL,
	`plan` text NOT NULL,
	`mode` text NOT NULL,
	`amount_cents` integer NOT NULL,
	`status` text DEFAULT 'pending' NOT NULL,
	`token` text,
	`created_at` integer NOT NULL,
	`paid_until` integer,
	`cancelled_at` integer
);
CREATE TABLE `roadmap` (
	`id` text PRIMARY KEY NOT NULL,
	`data` text NOT NULL,
	`revision` integer DEFAULT 0 NOT NULL
);
CREATE TABLE `support_groups` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`owner` text NOT NULL,
	`invite` text NOT NULL,
	`whatsapp` text DEFAULT '' NOT NULL
);
CREATE TABLE `support_members` (
	`id` text PRIMARY KEY NOT NULL,
	`group_id` text NOT NULL,
	`user_id` text NOT NULL,
	`nickname` text NOT NULL
);
CREATE TABLE `support_messages` (
	`id` text PRIMARY KEY NOT NULL,
	`group_id` text NOT NULL,
	`user_id` text NOT NULL,
	`nickname` text NOT NULL,
	`body` text NOT NULL,
	`created_at` integer NOT NULL
);
INSERT INTO "__appgarden_migrations" ("id","name","applied_at") VALUES (1,CAST(X'303030305f74616e5f6172636c696768742e73716c' AS TEXT),CAST(X'323032362d31302d30362031383a32333a3439' AS TEXT));
INSERT INTO "__appgarden_migrations" ("id","name","applied_at") VALUES (2,CAST(X'303030315f72617069645f646f63746f725f666175737475732e73716c' AS TEXT),CAST(X'323032362d31302d30362031383a32333a3439' AS TEXT));
INSERT INTO "__appgarden_migrations" ("id","name","applied_at") VALUES (3,CAST(X'303030325f62726176655f62696c6c5f686f6c6c69737465722e73716c' AS TEXT),CAST(X'323032362d31302d30372030383a32353a3136' AS TEXT));
INSERT INTO "__appgarden_migrations" ("id","name","applied_at") VALUES (4,CAST(X'303030335f706561636566756c5f7468655f686f6f642e73716c' AS TEXT),CAST(X'323032362d31302d30392030383a30383a3231' AS TEXT));
INSERT INTO "__appgarden_migrations" ("id","name","applied_at") VALUES (5,CAST(X'303030345f616d626967756f75735f68756d616e5f63616e6e6f6e62616c6c2e73716c' AS TEXT),CAST(X'323032362d31302d30392030383a30383a3231' AS TEXT));
INSERT INTO "__appgarden_migrations" ("id","name","applied_at") VALUES (6,CAST(X'303030355f7374757264795f6d6574656f726974652e73716c' AS TEXT),CAST(X'323032362d31302d30392030383a31373a3330' AS TEXT));
INSERT INTO "__appgarden_migrations" ("id","name","applied_at") VALUES (7,CAST(X'303030365f736c6f775f6a6f686e6e795f73746f726d2e73716c' AS TEXT),CAST(X'323032362d31302d31322030343a31393a3435' AS TEXT));
INSERT INTO "payment_receipts" ("id","subscription_id","amount_cents","received_at") VALUES (CAST(X'73616e64626f783a33343339393031' AS TEXT),CAST(X'66373439363039302d616434332d346630342d393637372d396638363134623930643236' AS TEXT),9999,1791534950596);
INSERT INTO "payment_receipts" ("id","subscription_id","amount_cents","received_at") VALUES (CAST(X'73616e64626f783a33343339393036' AS TEXT),CAST(X'66663936646132622d303837382d343537352d623734622d646466633264663133633739' AS TEXT),29999,1791535042930);
INSERT INTO "payment_settings" ("id","encrypted") VALUES (CAST(X'70617966617374' AS TEXT),CAST(X'2f7a2b675662664342503753564659594869774563665a732f695659686f41617832644a4a4a70366d72322b7276324668512b4378434b595555525874446f774a5337694e3645684652684f696739622f6e376c5a48467a6f4d4757335766635a5933433063636e7935656643786c753856716e413336454e316a467576634974684f4a6b4c735a447a47544f66564558784b4a6c703143427a38334a6564366b72584d376744754e3544392b316e455a2b62616877767953494d3058484b5138513d3d' AS TEXT));
INSERT INTO "payment_subscriptions" ("id","user_email","plan","mode","amount_cents","status","token","created_at","paid_until","cancelled_at") VALUES (CAST(X'66373439363039302d616434332d346630342d393637372d396638363134623930643236' AS TEXT),CAST(X'76616e657373612e6d61676e69303140676d61696c2e636f6d' AS TEXT),CAST(X'706572736f6e616c' AS TEXT),CAST(X'73616e64626f78' AS TEXT),9999,CAST(X'63616e63656c6c6564' AS TEXT),CAST(X'33643831326331372d656664392d343732662d616533612d663261323232313966653066' AS TEXT),1791534838930,1794213350596,1791535143214);
INSERT INTO "payment_subscriptions" ("id","user_email","plan","mode","amount_cents","status","token","created_at","paid_until","cancelled_at") VALUES (CAST(X'66663936646132622d303837382d343537352d623734622d646466633264663133633739' AS TEXT),CAST(X'76616e657373612e6d61676e69303140676d61696c2e636f6d' AS TEXT),CAST(X'616666696c69617465' AS TEXT),CAST(X'73616e64626f78' AS TEXT),29999,CAST(X'63616e63656c6c6564' AS TEXT),CAST(X'65353864633333662d643332322d343761322d623937342d666133376161346638393134' AS TEXT),1791535014433,1794213442930,1791535126967);
INSERT INTO "roadmap" ("id","data","revision") VALUES (CAST(X'757365723a76616e657373612e6d61676e69303140676d61696c2e636f6d' AS TEXT),CAST(X'7b22617373756d7074696f6e73223a7b2235223a35373030302c2236223a302c2238223a302c2239223a36303030302c223130223a302c223131223a302c223132223a302c223133223a302c223134223a302c223135223a302c223136223a302c223137223a313735303030303030302c223138223a302e303937352c223139223a31363030302c223230223a36303030302c223231223a333230302c223232223a302e31332c223233223a34373030302c223234223a323030302c223235223a302c223236223a302c223237223a302c223238223a302c223239223a302c223330223a302c223331223a302c223332223a307d2c22627564676574223a5b7b226e616d65223a22446562742072657061796d656e7473222c22616d6f756e74223a32313230302c22647565446179223a31357d2c7b226e616d65223a224d65646963616c20616964222c22616d6f756e74223a333830302c22647565446179223a31357d2c7b226e616d65223a225472616e73706f7274222c22616d6f756e74223a323030307d2c7b226e616d65223a225574696c6974696573222c22616d6f756e74223a323530302c22647565446179223a317d2c7b226e616d65223a22486f7573696e67222c22616d6f756e74223a343530302c22647565446179223a317d2c7b226e616d65223a22496e7465726e657420262050686f6e65222c22616d6f756e74223a313037342c22647565446179223a317d2c7b226e616d65223a22496e737572616e6365222c22616d6f756e74223a313835342c22647565446179223a317d2c7b226e616d65223a2247726f636572696573222c22616d6f756e74223a363030307d2c7b226e616d65223a224f74686572222c22616d6f756e74223a333738307d5d2c22676f616c73223a5b5d2c2266756e6473223a5b7b226e616d65223a22486f6c69646179222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a2252656e6f766174696f6e222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22436c6f74686573202f20706572736f6e616c222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a2246756e202f20666c657869626c65222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a2250726f70657274792072657365727665222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22427573696e6573732072657365727665222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d5d2c2261637475616c73223a7b7d2c22637573746f6d657250726576696577436c65616e56657273696f6e223a312c22656d657267656e6379436f6e7461637473223a5b7b226e616d65223a22222c2270686f6e65223a22227d2c7b226e616d65223a22222c2270686f6e65223a22227d2c7b226e616d65223a22222c2270686f6e65223a22227d5d2c22696e636f6d654f74686572223a7b226e616d65223a22222c22616d6f756e74223a307d2c2266696e616e6369616c476f616c73223a7b2277697368223a2249206f77652052312c373530206d696c6c696f6e206f6e206d7920686f75736520617420392c37352520696e7465726573742e20492077616e74206d7920686f7573652070616964206f666620696e2031302079656172732e204d7920736574746c656d656e7420696e206d7920636172206973205236302074686f7573616e642e20492077616e742074686174207061696420627920446563656d62657220323032392e2049206861766520322063726564697420636172647320746f20706179206f66662e20544f54414c205233372074686f7573616e642072616e642e20492077616e742069742070616964206f666620627920446563656d62657220323032372e205468656e20492077616e7420746f20736176652052356d696c6c696f6e2072616e64206279207468652074696d65204920616d2036352e222c22686f6d654e616d65223a22486f6d65206c6f616e20222c226361724e616d65223a2256656869636c6520222c22636172644e616d65223a224372656469742043617264222c22676f616c4e616d65223a2246696e616e6369616c2066726565646f6d222c2263617368666c6f7757697368223a22222c2263617368666c6f77546172676574223a302c2263617368666c6f7743757272656e74223a302c22616765223a34382c22746172676574416765223a36352c22746172676574223a323032372c22696e766573746564223a36303030302c2272657475726e52617465223a302c22686f6d655965617273223a31302c226361725965617273223a312c22636172645965617273223a312c2263617368223a302c2272657365727665223a302c227374617274223a22227d2c2270726f66696c65223a7b2274797065223a22756e737065636966696564222c227072696d617279223a22756e737065636966696564222c22737570706f7274696e67223a5b5d2c22746f6e65223a2262616c616e636564222c22737472756374757265223a2264657461696c6564222c22666f637573223a2266696e616e636573222c22646973706c61794e616d65223a2256616e65737361222c226461696c79546f6e65223a7b22323032362d31302d3130223a22646972656374227d2c2261676552616e6765223a223435e280933534222c22756e697453797374656d223a226d6574726963222c2270686f746f223a22222c22617661746172223a2263726f776e222c227072696f726974696573223a5b2266696e616e636573225d2c22737570706f72744e616d65223a2220566565222c2277656c636f6d65436f6d706c657465223a747275652c2272656d696e646572507265666572656e636573223a7b226461696c79223a66616c73652c22676f616c73223a66616c73652c227765656b6c79223a747275652c2274696d65223a2230383a3030227d7d2c226c696665223a7b22737461746573223a7b7d2c2268696464656e223a5b5d2c22636865636b696e73223a7b22323032362d31302d3037223a7b226d6f6f64223a22737465616479227d2c22323032362d31302d3038223a7b226d6f6f64223a22737465616479227d2c22323032362d31302d3131223a7b226d6f6f64223a22676f6f64222c22656e65726779223a2268696768222c22737472657373223a226d6f646572617465222c226e656564223a2249206e65656420746f20656e6a6f79207468652064617920616e64206c656176652074686520776f727269657320666f72204d6f6e6461792e227d7d2c227461736b73223a5b5d2c227072696f726974696573223a7b7d2c226170706f696e746d656e7473223a5b5d2c2272656d696e64657273223a7b7d2c22656e7472696573223a5b5d2c22676f616c73223a5b5d2c2272657669657773223a7b7d2c2273706972697475616c507261637469636573223a5b5d2c227175696574223a66616c73657d2c226865616c7468223a7b226d6561737572656d656e7473223a5b7b2264617465223a22323032362d31302d3130222c22776569676874223a35392c22686569676874223a3136362c226d7573636c65223a32322c22666174223a32377d5d2c22676f616c73223a5b7b226e616d65223a2246756c6c20626f647920746f6e6564222c22746172676574223a2247796d20332074696d65732061207765656b2e204379636c65206f6e20536174757264617973222c2264617465223a22323032362d31322d3135222c22646f6e65223a66616c73657d5d2c2264617973223a7b7d2c226d656469636174696f6e73223a5b5d7d2c226164646974696f6e616c496e636f6d65223a5b5d2c2266696e616e6369616c50726f6772657373223a7b22626173656c696e65223a7b227374617274223a22323032362d3130222c226665617369626c65223a747275652c22676f616c73223a5b7b226964223a22686f6d65222c226e616d65223a22486f6d65206c6f616e222c22646972656374696f6e223a22646f776e222c226f70656e696e67223a313735303030303030302c22746172676574223a302c22706c616e6e6564223a5b313735303030303030302c313734313333333935372e363134363433332c313733323539373530332e363334393035362c313732333739303036352e393636353832332c313731343931313036372e3836373230342c313730353935393932372e393038323638322c313639363933363035392e393337313636322c313638373833383837332e303338373938382c313637383636373737312e343936383832322c313636393432323135342e373534393337362c313636303130313431372e333736393634382c313635303730343934392e303037373935382c313634313233323133342e333333313237352c313633313638323335332e303339323237352c313632323035343937392e373732333134352c313631323334393338342e303937363037392c313630323536343933302e3435383034342c313539323730303937382e3133323635392c313538323735363838312e313934363330312c313537323733313938382e343638393739382c313536323632353634332e343839393333352c313535323433373138342e343537393332352c313534323136353934342e313936323936352c313533313831313235302e313037353334362c313532313337323432342e313239333031352c313531303834383738322e363839393935332c313530303233393633362e363633393934382c313438393534343239312e3332363533332c313437383736323034362e333038323034342c313436373839323139352e353439313031382c313435363933343032372e323532353831362c313434353838363832332e383338363532312c313433343734393836312e383936393834332c313432333532323431322e313339353430372c313431323230333733392e333532383137382c313430303739333130322e333439373032362c313338393238393735332e3932303933372c313337373639323934302e3738363138382c313336363030313930332e3534343731392c313335343231353837362e3632353636332c313334323333343038382e323337383839382c313333303335353736302e333139343635392c313331383238303130382e343836373034382c313330363130363334312e393832383032362c313239333833333636332e363236303536322c313238313436313236392e3735373636312c313236383938383335302e313839303835322c313235363431343038382e313439303134372c313234333733373636302e323239383638372c313233303935383233362e333333383739372c313231383037343937392e363138373335382c313230353038373034362e343432373831322c313139313939333538362e3330393737322c313137383739333734312e3831333138322c313136353438363634382e353830303537342c313135323037313433352e323134343133362c313133383534373232332e3234303137342c313132343931333132372e303433363433372c313131313136383235332e383135353136352c313039373331313730332e3439323431312c313038333334323536382e36393739332c313036393235393933342e3638333234342c313035353036323837392e323637313838352c313034303735303437322e373735383737372c313032363332313737372e3938313832352c313031313737353835302e303432353730362c3939373131313733362e343338383039382c3938323332383437362e393132303138332c3936373432353130332e343031353731382c3935323430303633392e393831333532382c3933373235343130322e373935383434362c3932313938343439392e3939353730342c3930363539303833312e363732383132352c3839313037323038392e373934373937332c3837353432373235382e313339303233332c3835393635353331322e323236303436322c3834333735353231392e323532353236322c3832373732353933382e303233353936322c3831313536363431382e383834363831322c3739353237353630332e363532373632352c3737383835323432352e353437303834362c3736323239353830392e313139323937392c3734353630343637302e313833303335352c3732383737373931352e3734323931362c3731313831343434332e393232393730342c3639343731333134332e383934343837392c3637373437323839352e383033323733392c3636303039323537302e363936333138392c3634323537313033302e343437383639382c3632343930373132372e363834393032312c3630373039393730352e373131393835322c3538393134373539382e343335353338342c3537313034393633302e323837343730352c3535323830343631362e313438313939342c3533343431313336312e32363930343638342c3531353836383636312e31393430303131342c3439373137353330312e363830383435362c3437383333303035382e36323136343537352c3435393333313639372e39363235383938362c3434303137383937352e36323331373931342c3432303837303633372e343134373630372c3430313430353431382e393538333938392c3338313738323034352e363032303739312c3336313939393233322e33333732333932372c3334323035353638332e373134363232362c3332313935303039332e37353934343731362c3330313638313134352e383835383835392c3238313234373531322e3831303835322c3236303634373835362e343637303833342c3233393838303832372e39313535323137342c3231383934353036372e32353639373836332c3139373833393230332e35343330383438362c3137363536313835342e363836353135372c3135353131313632372e33373034383639322c3133333438373131362e393537353135342c3131313638363930372e33393734333835312c38393730393537312e31333436383539382c36373535333636392e30313437393835382c34353231373735302e31393031383731312c32323730303335322e3032353132353636372c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c305d2c22647565223a3132307d2c7b226964223a22636172222c226e616d65223a2256656869636c65222c22646972656374696f6e223a22646f776e222c226f70656e696e67223a36303030302c22746172676574223a302c22706c616e6e6564223a5b36303030302c35373434392e39393939393939393939392c35343837322e3337343939393939393938352c35323236362e3832353732393136363634352c34393633332e30343936373435363539352c34363937302e3734313034363034303430362c34343237392e35393037343037303538342c33373732382e39383338303430323930312c32353831392e3039393831383631353335322c31333738302e3139323039303032363337362c313631302e383632383631303434333535372c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c305d2c22647565223a31327d2c7b226964223a226361726473222c226e616d65223a224372656469742043617264222c22646972656374696f6e223a22646f776e222c226f70656e696e67223a34373030302c22746172676574223a302c22706c616e6e6564223a5b34373030302c34353030302c34333030302c34313030302c33393030302c33373030302c33353030302c33333030302c33313030302c32393030302c32373030302c31343330392e3639393233323038313733372c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c302c305d2c22647565223a31327d2c7b226964223a22736176696e6773222c226e616d65223a2246696e616e6369616c2066726565646f6d222c22646972656374696f6e223a227570222c226f70656e696e67223a36303030302c22746172676574223a323032372c22706c616e6e6564223a5b36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030382e393135343131323038392c37343332372e35333030353434393935342c38383634362e31343436393737393031382c3130323936342e37353933343130383038322c3131373238332e33373339383433373134362c3133313630312e393838363237363632312c3134353932302e36303332373039353237342c3136303233392e32313739313432343333372c3137343535372e3833323535373533342c3138383837362e34343732303038323436352c3230333139352e303631383434313135332c3231373531332e36373634383734303539332c3233313833322e32393131333036393635372c3234363135302e393035373733393837322c3236303436392e35323034313732373738352c3237343738382e31333530363035363834362c3238393130362e373439373033383539312c3330333432352e33363433343731343937332c3331373734332e393738393930343430342c3333323036322e3539333633333733312c3334363338312e32303832373730323136352c3336303639392e383232393230333132332c3337353031382e343337353633363032392c3338393333372e30353232303638393335372c3430333635352e363636383530313834322c3431373937342e32383134393334373438352c3433323239322e383936313336373635352c3434363631312e353130373830303536312c3436303933302e31323534323333343637362c3437353234382e373430303636363337342c3438393536372e33353437303939323830342c3530333838352e393639333533323138372c3531383230342e353833393936353039332c3533323532332e313938363339382c3534363834312e383133323833303930362c3536313136302e343237393236333831322c3537353437392e303432353639363731392c3538393739372e363537323132393632352c3630343131362e323731383536323533322c3631383433342e383836343939353433382c3633323735332e353031313432383334342c3634373037322e313135373836313235312c3636313339302e373330343239343135372c3637353730392e333435303732373036332c3639303032372e3935393731353939372c3730343334362e353734333539323837362c3731383636352e313839303032353738332c3733323938332e383033363435383638392c3734373330322e343138323839313539352c3736313632312e303332393332343530322c3737353933392e363437353735373430382c3739303235382e323632323139303331352c3830343537362e383736383632333232312c3831383839352e343931353035363132372c3833333231342e313036313438393033342c3834373533322e3732303739323139342c3836313835312e333335343335343834372c3837363136392e393530303738373735332c3839303438382e353634373232303635392c3930343830372e313739333635333536362c3931393132352e373934303038363437322c3933333434342e343038363531393337382c3934373736332e303233323935323238352c3936323038312e363337393338353139312c3937363430302e323532353831383039382c3939303731382e383637323235313030342c313030353033372e3438313836383339312c313031393335362e303936353131363831372c313033333637342e373131313534393732332c313034373939332e3332353739383236332c313036323331312e393430343431353533352c313037363633302e353535303834383434312c313039303934392e313639373238313334382c313130353236372e373834333731343235342c313131393538362e3339393031343731362c313133333930352e303133363538303036372c313134383232332e363238333031323937332c313136323534322e3234323934343538382c313137363836302e383537353837383738362c313139313137392e343732323331313639322c313230353439382e303836383734343539392c313231393831362e373031353137373530352c313233343133352e333136313631303431312c313234383435332e393330383034333331382c313236323737322e353435343437363232342c313237373039312e3136303039303931332c313239313430392e373734373334323033372c313330353732382e333839333737343934332c313332303034372e3030343032303738352c313333343336352e363138363634303735362c313334383638342e323333333037333636332c313336333030322e3834373935303635372c313337373332312e343632353933393437352c313339313634302e303737323337323338322c313430353935382e363931383830353238382c313432303237372e333036353233383139352c313433343539352e39323131363731312c313434383931342e353335383130343030372c313436333233332e313530343533363931342c313437373535312e3736353039363938322c313439313837302e333739373430323732362c313530363138382e393934333833353633332c313532303530372e3630393032363835342c313533343832362e323233363730313434362c313534393134342e383338333133343335322c313536333436332e343532393536373235382c313537373738322e303637363030303136352c313539323130302e363832323433333037312c313630363431392e323936393030333235352c32343530353533302e3239363930303332352c34373430343634312e3239363930303332352c37303330333735322e32393639303033332c39333230323836332e32393639303033332c3131363130313937342e32393639303033332c3133393030313038352e32393639303033332c3136313930303139362e32393639303033332c3138343739393330372e32393639303033332c3230373639383431382e32393639303033332c3233303539373532392e32393639303033332c3235333439363634302e32393639303033332c3237363339353735312e32393639303033332c3239393239343836322e32393639303033332c3332323139333937332e32393639303033332c3334353039333038342e32393639303033332c3336373939323139352e32393639303033332c3339303839313330362e32393639303033332c3431333739303431372e32393639303033332c3433363638393532382e32393639303033332c3435393538383633392e32393639303033332c3438323438373735302e32393639303033332c3530353338363836312e32393639303033332c3532383238353937322e32393639303033332c3535313138353038332e323936393030332c3537343038343139342e323936393030332c3539363938333330352e323936393030332c3631393838323431362e323936393030332c3634323738313532372e323936393030332c3636353638303633382e323936393030332c3638383537393734392e323936393030332c3731313437383836302e323936393030332c3733343337373937312e323936393030332c3735373237373038322e323936393030332c3738303137363139332e323936393030332c3830333037353330342e323936393030332c3832353937343431352e323936393030332c3834383837333532362e323936393030332c3837313737323633372e323936393030332c3839343637313734382e323936393030332c3931373537303835392e323936393030332c3934303436393937302e323936393030332c3936333336393038312e323936393030332c3938363236383139322e323936393030332c313030393136373330332e323936393030332c313033323036363431342e323936393030332c313035343936353532352e323936393030332c313037373836343633362e323936393030332c313130303736333734372e323936393030332c313132333636323835382e323936393030332c313134363536313936392e323936393030332c313136393436313038302e323936393030332c313139323336303139312e323936393030332c313231353235393330322e323936393030332c313233383135383431332e323936393030332c313236313035373532342e323936393030332c313238333935363633352e323936393030332c313330363835353734362e323936393030332c313332393735343835372e323936393030332c313335323635333936382e323936393030332c313337353535333037392e323936393030332c313339383435323139302e323936393030332c313432313335313330312e323936393030332c313434343235303431322e323936393030332c313436373134393532332e323936393030332c313439303034383633342e323936393030332c313531323934373734352e323936393030332c313533353834363835362e323936393030332c313535383734353936372e323936393030332c313538313634353037382e323936393030332c313630343534343138392e323936393030332c313632373434333330302e323936393030332c313635303334323431312e323936393030332c313637333234313532322e323936393030332c313639363134303633332e323936393030332c313731393033393734342e323936393030332c313734313933383835352e323936393030332c313736343833373936362e323936393030332c313738373733373037372e323936393030332c313831303633363138382e323936393030332c313833333533353239392e323936393030332c313835363433343431302e323936393030332c313837393333333532312e323936393030332c313930323233323633322e323936393030332c313932353133313734332e323936393030335d2c22647565223a3230347d2c7b226964223a2272657365727665222c226e616d65223a22456d657267656e63792043757368696f6e222c22646972656374696f6e223a227570222c226f70656e696e67223a302c22746172676574223a36303030302c22706c616e6e6564223a5b302c393131382e3631343634333239303633392c31383233372e3232393238363538313237382c32373335352e3834333932393837313931372c33363437342e3435383537333136323535362c34353539332e3037333231363435333139352c35343731312e36383738353937343338332c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030302c36303030305d2c22647565223a6e756c6c7d5d7d2c226d6f6e746873223a7b22323032362d3130223a7b22686f6d65223a32323030302c22636172223a31303030302c226361726473223a34373030302c22736176696e6773223a302c2272657365727665223a36303030307d7d7d7d' AS TEXT),170);
INSERT INTO "roadmap" ("id","data","revision") VALUES (CAST(X'757365723a6e696d65746f7040676d61696c2e636f6d' AS TEXT),CAST(X'7b22617373756d7074696f6e73223a7b2235223a302c2236223a302c2238223a302c2239223a302c223130223a302c223131223a302c223132223a302c223133223a302c223134223a302c223135223a302c223136223a302c223137223a302c223138223a302c223139223a302c223230223a302c223231223a302c223232223a302c223233223a302c223234223a302c223235223a302c223236223a302c223237223a302c223238223a302c223239223a302c223330223a302c223331223a302c223332223a307d2c22627564676574223a5b7b226e616d65223a22446562742072657061796d656e7473222c22616d6f756e74223a307d2c7b226e616d65223a22486f7573696e67222c22616d6f756e74223a307d2c7b226e616d65223a225574696c6974696573222c22616d6f756e74223a307d2c7b226e616d65223a224d65646963616c20616964222c22616d6f756e74223a307d2c7b226e616d65223a2247726f636572696573222c22616d6f756e74223a307d2c7b226e616d65223a225472616e73706f7274222c22616d6f756e74223a307d2c7b226e616d65223a22496e7465726e6574222c22616d6f756e74223a307d2c7b226e616d65223a22496e737572616e6365222c22616d6f756e74223a307d5d2c22676f616c73223a5b5d2c2266756e6473223a5b7b226e616d65223a22486f6c69646179222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a2252656e6f766174696f6e222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22436c6f74686573202f20706572736f6e616c222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a2246756e202f20666c657869626c65222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a2250726f70657274792072657365727665222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22427573696e6573732072657365727665222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d5d2c2261637475616c73223a7b7d2c22696e636f6d654f74686572223a7b226e616d65223a22222c22616d6f756e74223a307d2c2266696e616e6369616c476f616c73223a7b2277697368223a22222c22616765223a6e756c6c2c22746172676574416765223a36352c22746172676574223a302c22696e766573746564223a302c2272657475726e52617465223a302c22686f6d655965617273223a31302c226361725965617273223a322c22636172645965617273223a352c2263617368223a302c2272657365727665223a302c227374617274223a22227d2c2270726f66696c65223a7b2274797065223a22756e737065636966696564222c227072696d617279223a22756e737065636966696564222c22737570706f7274696e67223a5b5d2c22746f6e65223a2262616c616e636564222c22737472756374757265223a2273696d706c65222c22666f637573223a226d656e74616c222c22646973706c61794e616d65223a224e20546f70222c226461696c79546f6e65223a7b7d2c2261676552616e6765223a22756e737065636966696564222c22756e697453797374656d223a226d6574726963222c2270686f746f223a22222c22617661746172223a2263726f776e222c227072696f726974696573223a5b226d656e74616c222c22656d6f74696f6e616c222c22706879736963616c222c2273706972697475616c222c2272656c6174696f6e7368697073222c2266696e616e636573225d2c22737570706f72744e616d65223a22222c2277656c636f6d65436f6d706c657465223a747275652c2272656d696e646572507265666572656e636573223a7b226461696c79223a66616c73652c22676f616c73223a66616c73652c227765656b6c79223a66616c73652c2274696d65223a2230383a3030227d7d2c226c696665223a7b22737461746573223a7b226d656e74616c223a2277656c6c222c2266696e616e636573223a227061757365222c22656d6f74696f6e616c223a2277656c6c222c22706879736963616c223a2263617265227d2c2268696464656e223a5b5d2c22636865636b696e73223a7b22323032362d31302d3037223a7b226d6f6f64223a22676f6f64222c226e656564223a2243616c6d6e657373227d7d2c227461736b73223a5b5d2c227072696f726974696573223a7b7d2c226170706f696e746d656e7473223a5b5d2c2272656d696e64657273223a7b7d2c22656e7472696573223a5b5d2c22676f616c73223a5b5d2c2272657669657773223a7b7d2c2273706972697475616c507261637469636573223a5b5d2c227175696574223a66616c73657d2c226865616c7468223a7b226d6561737572656d656e7473223a5b5d2c22676f616c73223a5b5d2c2264617973223a7b7d7d7d' AS TEXT),15);
INSERT INTO "roadmap" ("id","data","revision") VALUES (CAST(X'757365723a6a706e656c2e6a40676d61696c2e636f6d' AS TEXT),CAST(X'7b22617373756d7074696f6e73223a7b2235223a302c2236223a302c2238223a302c2239223a302c223130223a302c223131223a302c223132223a302c223133223a302c223134223a302c223135223a302c223136223a302c223137223a302c223138223a302c223139223a302c223230223a302c223231223a302c223232223a302c223233223a302c223234223a302c223235223a302c223236223a302c223237223a302c223238223a302c223239223a302c223330223a302c223331223a302c223332223a307d2c22627564676574223a5b7b226e616d65223a22446562742072657061796d656e7473222c22616d6f756e74223a307d2c7b226e616d65223a22486f7573696e67222c22616d6f756e74223a307d2c7b226e616d65223a225574696c6974696573222c22616d6f756e74223a307d2c7b226e616d65223a224d65646963616c20616964222c22616d6f756e74223a307d2c7b226e616d65223a2247726f636572696573222c22616d6f756e74223a307d2c7b226e616d65223a225472616e73706f7274222c22616d6f756e74223a307d2c7b226e616d65223a22496e7465726e6574222c22616d6f756e74223a307d2c7b226e616d65223a22496e737572616e6365222c22616d6f756e74223a307d5d2c22676f616c73223a5b5d2c2266756e6473223a5b7b226e616d65223a22486f6c69646179222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a2252656e6f766174696f6e222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22436c6f74686573202f20706572736f6e616c222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a2246756e202f20666c657869626c65222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a2250726f70657274792072657365727665222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22427573696e6573732072657365727665222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d5d2c2261637475616c73223a7b7d2c22637573746f6d657250726576696577436c65616e56657273696f6e223a312c22656d657267656e6379436f6e7461637473223a5b7b226e616d65223a22222c2270686f6e65223a22227d2c7b226e616d65223a22222c2270686f6e65223a22227d2c7b226e616d65223a22222c2270686f6e65223a22227d5d2c226164646974696f6e616c496e636f6d65223a5b5d2c22696e636f6d654f74686572223a7b226e616d65223a22222c22616d6f756e74223a307d2c2266696e616e6369616c476f616c73223a7b2277697368223a22222c22616765223a6e756c6c2c22746172676574416765223a302c22746172676574223a302c22696e766573746564223a302c2272657475726e52617465223a302c22686f6d655965617273223a302c226361725965617273223a302c22636172645965617273223a302c2263617368223a302c2272657365727665223a302c227374617274223a22227d2c2270726f66696c65223a7b2274797065223a22756e737065636966696564222c227072696d617279223a22756e737065636966696564222c22737570706f7274696e67223a5b5d2c22746f6e65223a2262616c616e636564222c22737472756374757265223a2273696d706c65222c22666f637573223a226d656e74616c222c22646973706c61794e616d65223a224a5020222c226461696c79546f6e65223a7b7d2c2261676552616e6765223a22756e737065636966696564222c22756e697453797374656d223a226d6574726963222c2270686f746f223a22222c22617661746172223a2263726f776e222c227072696f726974696573223a5b5d2c22737570706f72744e616d65223a22222c2277656c636f6d65436f6d706c657465223a747275652c2272656d696e646572507265666572656e636573223a7b226461696c79223a66616c73652c22676f616c73223a66616c73652c227765656b6c79223a66616c73652c2274696d65223a2230383a3030227d7d2c226c696665223a7b22737461746573223a7b7d2c2268696464656e223a5b5d2c22636865636b696e73223a7b7d2c227461736b73223a5b5d2c227072696f726974696573223a7b7d2c226170706f696e746d656e7473223a5b5d2c2272656d696e64657273223a7b7d2c22656e7472696573223a5b5d2c22676f616c73223a5b5d2c2272657669657773223a7b7d2c2273706972697475616c507261637469636573223a5b5d2c227175696574223a66616c73657d2c226865616c7468223a7b226d6561737572656d656e7473223a5b5d2c22676f616c73223a5b5d2c2264617973223a7b7d7d7d' AS TEXT),2);
INSERT INTO "roadmap" ("id","data","revision") VALUES (CAST(X'757365723a73616e6574637240676d61696c2e636f6d' AS TEXT),CAST(X'7b22617373756d7074696f6e73223a7b2235223a302c2236223a302c2238223a302c2239223a302c223130223a302c223131223a302c223132223a302c223133223a302c223134223a302c223135223a302c223136223a302c223137223a302c223138223a302c223139223a302c223230223a302c223231223a302c223232223a302c223233223a302c223234223a302c223235223a302c223236223a302c223237223a302c223238223a302c223239223a302c223330223a302c223331223a302c223332223a307d2c22627564676574223a5b7b226e616d65223a22446562742072657061796d656e7473222c22616d6f756e74223a307d2c7b226e616d65223a22486f7573696e67222c22616d6f756e74223a307d2c7b226e616d65223a225574696c6974696573222c22616d6f756e74223a307d2c7b226e616d65223a224d65646963616c20616964222c22616d6f756e74223a307d2c7b226e616d65223a2247726f636572696573222c22616d6f756e74223a307d2c7b226e616d65223a225472616e73706f7274222c22616d6f756e74223a307d2c7b226e616d65223a22496e7465726e657420262050686f6e65222c22616d6f756e74223a307d2c7b226e616d65223a22496e737572616e6365222c22616d6f756e74223a307d5d2c22676f616c73223a5b5d2c2266756e6473223a5b7b226e616d65223a22222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d2c7b226e616d65223a22222c22616d6f756e74223a302c2262616c616e6365223a302c227370656e74223a307d5d2c2261637475616c73223a7b7d2c22637573746f6d657250726576696577436c65616e56657273696f6e223a312c22656d657267656e6379436f6e7461637473223a5b7b226e616d65223a22222c2270686f6e65223a22227d2c7b226e616d65223a22222c2270686f6e65223a22227d2c7b226e616d65223a22222c2270686f6e65223a22227d5d2c226164646974696f6e616c496e636f6d65223a5b5d2c22696e636f6d654f74686572223a7b226e616d65223a22222c22616d6f756e74223a307d2c2266696e616e6369616c476f616c73223a7b2277697368223a22222c22686f6d654e616d65223a22222c226361724e616d65223a22222c22636172644e616d65223a22222c22676f616c4e616d65223a22222c2263617368666c6f7757697368223a22222c2263617368666c6f77546172676574223a302c2263617368666c6f7743757272656e74223a302c22616765223a6e756c6c2c22746172676574416765223a302c22746172676574223a302c22696e766573746564223a302c2272657475726e52617465223a302c22686f6d655965617273223a302c226361725965617273223a302c22636172645965617273223a302c2263617368223a302c2272657365727665223a302c227374617274223a22227d2c2270726f66696c65223a7b2274797065223a22756e737065636966696564222c227072696d617279223a22756e737065636966696564222c22737570706f7274696e67223a5b5d2c22746f6e65223a2262616c616e636564222c22737472756374757265223a2273696d706c65222c22666f637573223a226d656e74616c222c22646973706c61794e616d65223a2253616e6574222c226461696c79546f6e65223a7b7d2c2261676552616e6765223a22756e737065636966696564222c22756e697453797374656d223a226d6574726963222c2270686f746f223a22222c22617661746172223a2263726f776e222c227072696f726974696573223a5b226d656e74616c222c2266696e616e636573222c22706879736963616c225d2c22737570706f72744e616d65223a22222c2277656c636f6d65436f6d706c657465223a747275652c2272656d696e646572507265666572656e636573223a7b226461696c79223a66616c73652c22676f616c73223a66616c73652c227765656b6c79223a66616c73652c2274696d65223a2230383a3030227d7d2c226c696665223a7b22737461746573223a7b7d2c2268696464656e223a5b5d2c22636865636b696e73223a7b7d2c227461736b73223a5b5d2c227072696f726974696573223a7b7d2c226170706f696e746d656e7473223a5b5d2c2272656d696e64657273223a7b7d2c22656e7472696573223a5b5d2c22676f616c73223a5b5d2c2272657669657773223a7b7d2c2273706972697475616c507261637469636573223a5b5d2c227175696574223a66616c73657d2c226865616c7468223a7b226d6561737572656d656e7473223a5b5d2c22676f616c73223a5b5d2c2264617973223a7b7d7d7d' AS TEXT),6);
CREATE INDEX `idx_emergency_alerts_user_time` ON `emergency_alerts` (`user_id`,`created_at`);
CREATE INDEX `idx_payment_receipts_subscription` ON `payment_receipts` (`subscription_id`);
CREATE INDEX `idx_payment_subscriptions_user_plan` ON `payment_subscriptions` (`user_email`,`plan`);
CREATE UNIQUE INDEX `support_groups_invite_unique` ON `support_groups` (`invite`);
CREATE UNIQUE INDEX `support_members_group_user` ON `support_members` (`group_id`,`user_id`);
CREATE INDEX `support_messages_group_time` ON `support_messages` (`group_id`,`created_at`);
CREATE UNIQUE INDEX `uniq_payment_pending_user_plan_mode` ON `payment_subscriptions` (`user_email`,`plan`,`mode`) WHERE "payment_subscriptions"."status" = 'pending';
COMMIT;
PRAGMA foreign_keys=ON;