MrPiglr
25d584fd46
feat: Complete database migration and developer platform
...
- Applied all 31 pending Supabase migrations successfully
- Fixed 100+ policy/trigger/index duplication errors for shared database
- Resolved foundation_contributions schema mismatch (added user_id, contribution_type, resource_id, points columns)
- Added DROP IF EXISTS statements for all policies, triggers, and indexes
- Wrapped storage.objects operations in permission-safe DO blocks
Developer Platform (10 Phases Complete):
- API key management dashboard with RLS and SHA-256 hashing
- Complete API documentation (8 endpoint categories)
- 9 template starters + 9 marketplace products + 12 code examples
- Quick start guide and SDK distribution
- Testing framework and QA checklist
Database Schema Now Includes:
- Ethos: Artist/guild tracking, verification, tracks, storage
- GameForge: Games, assets, monetization
- Foundation: Courses, mentorship, resources, contributions
- Nexus: Creator marketplace, portfolios, contracts, escrow
- Corp Hub: Invoices, contracts, team management, projects
- Developer: API keys, usage logs, profiles
Platform Status: Production Ready ✅
2026-01-10 02:05:15 +00:00
sirpiglr
baee7b6787
Strengthen security policies for escrow and payouts
...
Update RLS policies in `20251213_strengthen_nexus_rls.sql` to enforce legal entity separation, restricting access to escrow ledgers and payouts to clients/admins only, and adding admin-only policies for managing payouts and viewing compliance events.
Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 9203795e-937a-4306-b81d-b4d5c78c240e
Replit-Commit-Checkpoint-Type: intermediate_checkpoint
Replit-Commit-Event-Id: 247c2875-7388-4bf9-a0cf-3283ed5fcf36
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/7c94b7a0-29c7-4f2e-94ef-44b2153872b7/9203795e-937a-4306-b81d-b4d5c78c240e/aPpJgbb
Replit-Helium-Checkpoint-Created: true
2025-12-13 03:20:49 +00:00
sirpiglr
e60e71476f
Add core architecture, API endpoints, and UI components for NEXUS
...
Introduces NEXUS Core architecture documentation, new API endpoints for escrow, payroll, talent profiles, time logs, and UI components for financial dashboards and compliance tracking.
Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 9203795e-937a-4306-b81d-b4d5c78c240e
Replit-Commit-Checkpoint-Type: intermediate_checkpoint
Replit-Commit-Event-Id: e82c1588-4c11-4961-b289-6ab581ed9691
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/7c94b7a0-29c7-4f2e-94ef-44b2153872b7/9203795e-937a-4306-b81d-b4d5c78c240e/aPpJgbb
Replit-Helium-Checkpoint-Created: true
2025-12-13 03:01:54 +00:00
sirpiglr
a4cf099b2c
Update AI personas to include new subscription tiers and unlockable badges
...
Introduce a new 'Pro' tier for AI personas, update database schemas with tier and Stripe fields, and create a 'badges' table to manage persona access through earned badges.
Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 9203795e-937a-4306-b81d-b4d5c78c240e
Replit-Commit-Checkpoint-Type: intermediate_checkpoint
Replit-Commit-Event-Id: 66a80a5c-6d47-429a-93e1-cf315013edf0
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/7c94b7a0-29c7-4f2e-94ef-44b2153872b7/9203795e-937a-4306-b81d-b4d5c78c240e/LFvmEVc
Replit-Helium-Checkpoint-Created: true
2025-12-12 23:12:45 +00:00
Builder.io
ee59b17859
Create provider_identities table for OAuth federation to Foundation Passports
...
cgen-b79736960bf448c29552233ade19338b
2025-11-17 08:38:20 +00:00
Builder.io
fd673c07e4
Add Foundation passport cache tracking columns
...
cgen-ce44ca53fefb42ebb720613170e4ead2
2025-11-17 03:54:34 +00:00
Builder.io
f372d248e7
CORP Client Hub schema for invoicing and contracts
...
cgen-a6404a00b3b041d2b9c61fa935d68ef4
2025-11-15 19:31:52 +00:00
Builder.io
3a67836c25
completionId: cgen-c8f28d9d2be94d73b1fb2544f80647ae
...
cgen-c8f28d9d2be94d73b1fb2544f80647ae
2025-11-15 19:31:06 +00:00
Builder.io
8409c0fbcf
Add Stripe payment fields to NEXUS tables
...
cgen-7740cad298bf4f2cbe57be2d75e99518
2025-11-15 19:30:50 +00:00
Builder.io
d821441005
Add GameForge sprints and tasks functionality
...
cgen-5531fa58665046dc892bcac60954d8b9
2025-11-15 17:02:11 +00:00
Builder.io
017fa8324e
Add onboarded column to user_profiles table
...
cgen-370e192718ad494db53d1689a348f458
2025-11-15 16:53:18 +00:00
Builder.io
c2423fb952
Create migration to expand user_profile fields
...
cgen-28e05c5ef8444b54a38182f426b59305
2025-11-15 16:37:12 +00:00
Builder.io
e9133cd1f9
Add wallet_address field to user_profiles for wallet verification
...
cgen-e1e8eec4fb7c45c8aa3ad1bd11ccdef9
2025-11-15 01:34:14 +00:00
Builder.io
4933692480
Feed Phase 1: arm_affiliation and arm_follows schema
...
cgen-5f80fb1966e44ce4b6d3ad9c2c8055a9
2025-11-14 22:24:02 +00:00
Builder.io
db97bb6952
Add Fourthwall integration tables
...
cgen-332d9be5d81d4b7ba1478ad638262e39
2025-11-13 08:54:43 +00:00
Builder.io
bb31916815
Create user_follows table for social follow functionality
...
cgen-b60250f6bd65488391df858996643cbb
2025-11-13 06:53:19 +00:00
Builder.io
7a2dad81bc
Create community_post_likes and community_comments tables
...
cgen-57af89b9a9704661a257932aa9b1cff8
2025-11-13 06:53:09 +00:00
Builder.io
a81280e23a
Create community_posts table with all necessary columns for feed functionality
...
cgen-fc9372861d734071b6db013825b59fb2
2025-11-13 06:53:04 +00:00
Builder.io
ead70c550d
Create migration for community post notifications system
...
cgen-6028cf6607c14f558c8d3972d9c4b51c
2025-11-13 06:35:33 +00:00
Builder.io
457ed6da8e
Create migration for collaboration posts and multi-author support
...
cgen-28a4f491a39b4e3b962b5d4f5044eb85
2025-11-13 06:35:05 +00:00
Builder.io
666278baca
Create migration for Discord channel webhook configuration
...
cgen-aab9f2b9c9154fca8a9e787a3af01f96
2025-11-13 06:34:22 +00:00
Builder.io
f35c5c892a
Create migration for community posts likes and comments counters
...
cgen-ec7c0a488e3142738797a2bed6725053
2025-11-13 06:32:43 +00:00
Builder.io
2eeff17695
Add arm_affiliation to community_posts and create user_followed_arms table
...
cgen-f67c4f07c9314289bf922ce565446703
2025-11-13 06:19:11 +00:00
Builder.io
2c96aa5aaf
Add rating column to ethos_tracks table
...
cgen-3560d4cfc90a45ed8bd4d672140e9895
2025-11-12 05:46:15 +00:00
Builder.io
325c6cf525
completionId: cgen-381c869efb4d419bba612587c3fff4d2
...
cgen-381c869efb4d419bba612587c3fff4d2
2025-11-12 05:41:21 +00:00
Builder.io
1075909e70
Add Spotify portfolio URL to aethex_creators
...
cgen-30736dda5db542099e4ec99d38e75ddd
2025-11-12 05:41:13 +00:00
Builder.io
c788675a3c
Add Spotify portfolio URL to artist profiles
...
cgen-d4876cd0aa9d4f81b5f6f8dae20e87b1
2025-11-12 05:38:37 +00:00
Builder.io
813b33437c
Nexus - Full Talent Marketplace System
...
cgen-8b270903186d4504a665f8736c70ab1c
2025-11-12 03:32:29 +00:00
Builder.io
2e7a74bee8
Foundation - Complete Education & Mentorship System
...
cgen-5055edce0fe341c28f6ca2241a4d4240
2025-11-12 03:31:57 +00:00
Builder.io
6276433828
Create GameForge studio management schema with projects, builds, team, and metrics
...
cgen-4ce1324db8d84b03a78e2d734fa5a91a
2025-11-12 03:08:27 +00:00
Builder.io
6749b26c8d
Create ethos_service_requests table for artist commission tracking
...
cgen-b38a296273e34e39bda13eb5bfe943d6
2025-11-12 02:40:40 +00:00
Builder.io
b8d093842e
Add service pricing and ecosystem license tracking to Ethos artists
...
cgen-e42e33def43e40dab4363bf7c157e173
2025-11-12 02:31:58 +00:00
Builder.io
58d201efd1
Set up Supabase Storage bucket for Ethos tracks
...
cgen-2cbf75c2ebe24d57bce3f72f3f311a9c
2025-11-11 23:27:00 +00:00
Builder.io
ead01a34e3
Create Ethos artist verification tracking tables
...
cgen-10489769eb804fa9842f1b063967c0c5
2025-11-11 23:24:15 +00:00
Builder.io
59926547fa
Fix blog_posts migration - remove non-existent sequence grant
...
cgen-32392745fc664f0084092624f35c013d
2025-11-11 22:59:49 +00:00
Builder.io
733ccf2df6
completionId: cgen-a48df6046fc248f6b36cc72b455e51a2
...
cgen-a48df6046fc248f6b36cc72b455e51a2
2025-11-11 22:09:03 +00:00
Builder.io
b8f367e8ab
Add email linking system for account unification
...
cgen-2b636a35c5ec4e31a77cc4b25df383f9
2025-11-11 22:08:14 +00:00
Builder.io
da0bdb7091
Ethos Guild - Database Schema (Tracks & Artist Profiles)
...
cgen-52cc030d8717465eb861f3fb42bdd3d5
2025-11-11 21:00:52 +00:00
Builder.io
71d420b4c8
Create blog_posts table for blog management
...
cgen-29a5256304a947bb8de019a1fdad262c
2025-11-11 03:23:04 +00:00
Builder.io
c7f2056073
Add location column to staff_members table
...
cgen-a0881347e7af47fc8c9d0c5dea113bec
2025-11-11 03:03:50 +00:00
Builder.io
35fb1b11b1
completionId: cgen-9154af170710432593fffd5bd89bbc90
...
cgen-9154af170710432593fffd5bd89bbc90
2025-11-11 03:03:47 +00:00
Builder.io
db0593ce8d
completionId: cgen-57730e6e529247b6afde2b23b621f923
...
cgen-57730e6e529247b6afde2b23b621f923
2025-11-11 02:31:39 +00:00
Builder.io
f7f6e9e9aa
completionId: cgen-973e77ecc6594b2b836d94a41d6f394c
...
cgen-973e77ecc6594b2b836d94a41d6f394c
2025-11-11 02:31:36 +00:00
Builder.io
4780f26838
Create database migration for staff members and contractors
...
cgen-52057812f0ed4e9db8bc747f52cc676e
2025-11-10 04:48:53 +00:00
Builder.io
1b17bf9cfe
completionId: cgen-bee6cd2cd3a14dd988523987c7d029ec
...
cgen-bee6cd2cd3a14dd988523987c7d029ec
2025-11-10 02:43:36 +00:00
Builder.io
5bccad60f4
Create Discord integration database tables and RLS policies
...
cgen-52c94bb809be4636b35ad0c3e13adc99
2025-11-08 10:44:24 +00:00
Builder.io
0872df7b05
Create Web3 and game integration tables
...
cgen-2ec91a1abd15412fa22dc68ca1115955
2025-11-08 09:55:01 +00:00
Builder.io
4e65bdaed5
completionId: cgen-5c71b70bcf804cbaa801663a6b768205
...
cgen-5c71b70bcf804cbaa801663a6b768205
2025-11-05 06:43:06 +00:00
Builder.io
0b903161ce
Add migration to include 'staff' in user_type_enum
...
cgen-6f34760fced84f778f69d019d2a0bb8f
2025-10-18 21:03:22 +00:00
Builder.io
29885683fe
Create moderation reports table
...
cgen-9461dd9ce64f4c7698c8ca08eafad552
2025-10-18 18:57:50 +00:00