merge

12 files changed, 59 insertions, 8 deletions

diff --git a/apps/web/db/prepare.sql b/apps/web/db/prepare.sql
index dcba4d40..4c8c2af6 100644
--- a/apps/web/db/prepare.sql
+++ b/apps/web/db/prepare.sql
@@ -13,15 +13,15 @@ CREATE TABLE `account` (
 	`session_state` text(255),
 	`oauth_token_secret` text,
 	`oauth_token` text,
-	FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action
+	FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
 );
 --> statement-breakpoint
 CREATE TABLE `contentToSpace` (
 	`contentId` integer NOT NULL,
 	`spaceId` integer NOT NULL,
 	PRIMARY KEY(`contentId`, `spaceId`),
-	FOREIGN KEY (`contentId`) REFERENCES `storedContent`(`id`) ON UPDATE no action ON DELETE no action,
-	FOREIGN KEY (`spaceId`) REFERENCES `space`(`id`) ON UPDATE no action ON DELETE no action
+	FOREIGN KEY (`contentId`) REFERENCES `storedContent`(`id`) ON UPDATE no action ON DELETE cascade,
+	FOREIGN KEY (`spaceId`) REFERENCES `space`(`id`) ON UPDATE no action ON DELETE cascade
 );
 --> statement-breakpoint
 CREATE TABLE `session` (
@@ -29,14 +29,14 @@ CREATE TABLE `session` (
 	`sessionToken` text(255) NOT NULL,
 	`userId` text(255) NOT NULL,
 	`expires` integer NOT NULL,
-	FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action
+	FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
 );
 --> statement-breakpoint
 CREATE TABLE `space` (
 	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
 	`name` text DEFAULT 'none' NOT NULL,
 	`user` text(255),
-	FOREIGN KEY (`user`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action
+	FOREIGN KEY (`user`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
 );
 --> statement-breakpoint
 CREATE TABLE `storedContent` (
@@ -50,7 +50,7 @@ CREATE TABLE `storedContent` (
 	`type` text DEFAULT 'page',
 	`image` text(255),
 	`user` text(255),
-	FOREIGN KEY (`user`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action
+	FOREIGN KEY (`user`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
 );
 --> statement-breakpoint
 CREATE TABLE `user` (
diff --git a/apps/web/db/wipe.sql b/apps/web/db/wipe.sql
new file mode 100644
index 00000000..456a48ad
--- /dev/null
+++ b/apps/web/db/wipe.sql
@@ -0,0 +1,7 @@
+DELETE FROM `account`;
+DELETE FROM `contentToSpace`;
+DELETE FROM `session`;
+DELETE FROM `space`;
+DELETE FROM `storedContent`;
+DELETE FROM `user`;
+DELETE FROM `verificationToken`;
\ No newline at end of file
diff --git a/apps/web/public/android-chrome-192x192.png b/apps/web/public/android-chrome-192x192.png
new file mode 100644
index 00000000..5e57b282
--- /dev/null
+++ b/apps/web/public/android-chrome-192x192.png
diff --git a/apps/web/public/android-chrome-512x512.png b/apps/web/public/android-chrome-512x512.png
new file mode 100644
index 00000000..2553425e
--- /dev/null
+++ b/apps/web/public/android-chrome-512x512.png
diff --git a/apps/web/public/apple-touch-icon.png b/apps/web/public/apple-touch-icon.png
new file mode 100644
index 00000000..d55c6339
--- /dev/null
+++ b/apps/web/public/apple-touch-icon.png
diff --git a/apps/web/public/favicon-16x16.png b/apps/web/public/favicon-16x16.png
new file mode 100644
index 00000000..67fbac93
--- /dev/null
+++ b/apps/web/public/favicon-16x16.png
diff --git a/apps/web/public/favicon-32x32.png b/apps/web/public/favicon-32x32.png
new file mode 100644
index 00000000..2fc8f0b3
--- /dev/null
+++ b/apps/web/public/favicon-32x32.png
diff --git a/apps/web/public/favicon.ico b/apps/web/public/favicon.ico
new file mode 100644
index 00000000..163c3627
--- /dev/null
+++ b/apps/web/public/favicon.ico
diff --git a/apps/web/public/og-image.png b/apps/web/public/og-image.png
new file mode 100644
index 00000000..1050ff19
--- /dev/null
+++ b/apps/web/public/og-image.png
diff --git a/apps/web/public/site.webmanifest b/apps/web/public/site.webmanifest
new file mode 100644
index 00000000..8d302080
--- /dev/null
+++ b/apps/web/public/site.webmanifest
@@ -0,0 +1,19 @@
+{
+  "name": "Supermemory - Your second brain",
+  "short_name": "Save your memories forever, build your own second brain.",
+  "icons": [
+    {
+      "src": "/android-chrome-192x192.png",
+      "sizes": "192x192",
+      "type": "image/png"
+    },
+    {
+      "src": "/android-chrome-512x512.png",
+      "sizes": "512x512",
+      "type": "image/png"
+    }
+  ],
+  "theme_color": "#ffffff",
+  "background_color": "#ffffff",
+  "display": "standalone"
+}
diff --git a/apps/web/src/app/favicon.ico b/apps/web/src/app/favicon.ico
deleted file mode 100644
index 718d6fea..00000000
--- a/apps/web/src/app/favicon.ico
+++ /dev/null
diff --git a/apps/web/src/app/layout.tsx b/apps/web/src/app/layout.tsx
index 42485461..e5a447dc 100644
--- a/apps/web/src/app/layout.tsx
+++ b/apps/web/src/app/layout.tsx
@@ -6,8 +6,33 @@ const roboto = Roboto({ weight: ["300", "400", "500"], subsets: ["latin"] });
 const inter = Inter({ weight: ["300", "400", "500"], subsets: ["latin"] });
 
 export const metadata: Metadata = {
-  title: "Create Next App",
-  description: "Generated by create next app",
+  title: "Supermemory - Your second brain",
+  description: "Save your memories forever, build your own second brain.",
+  openGraph: {
+    images: [
+      {
+        url: "https://supermemory.dhr.wtf/og-image.png",
+        width: 1200,
+        height: 630,
+      },
+    ],
+    siteName: "Supermemory",
+    title: "Supermemory - Your second brain",
+    description: "Save your memories forever, build your own second brain.",
+  },
+  twitter: {
+    card: "summary_large_image",
+    site: "https://supermemory.dhr.wtf",
+    creator: "@dhravyashah",
+    description: "Save your memories forever, build your own second brain.",
+    images: [
+      {
+        url: "https://supermemory.dhr.wtf/og-image.png",
+        width: 1200,
+        height: 630,
+      },
+    ],
+  },
 };
 
 export default function RootLayout({