-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 09, 2026 at 08:47 PM
-- Server version: 10.11.16-MariaDB-cll-lve
-- PHP Version: 8.4.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `cornerst_cs-store`
--

-- --------------------------------------------------------

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `platform` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL,
  `download_url` varchar(255) DEFAULT NULL,
  `icon_path` varchar(255) DEFAULT NULL,
  `downloads` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `applications`
--

INSERT INTO `applications` (`id`, `category_id`, `name`, `slug`, `description`, `platform`, `version`, `download_url`, `icon_path`, `downloads`, `created_at`, `updated_at`) VALUES
(2, 1, 'NetBrix', 'netbrix-1778373778', 'NetBrix is a premium streaming companion designed specifically for Android, bringing a massive library of global cinema, trending television series, and exclusive indie content right to your fingertips.', 'Android', '1.0.1', 'apps/files/NetBrix-1778132019.apk', 'apps/icons/1stSOlKcgGgduC6OhdjPEA2BaZGmnP1VygJrAlDZ.jpg', 1, '2026-05-07 09:33:39', '2026-05-10 04:42:58'),
(3, 1, 'Super App Movies', 'super-app-movies-1778234822', 'Super App Movies  is a premium PC/Laptop streaming companion designed specifically for Windows Laptop/PC, bringing a massive library of global cinema, trending television series, and exclusive indie content right to your fingertips.', 'PC', '1.0.0', 'apps/files/SuperAppMovies_Installer_New-1778132368.exe', 'apps/icons/5Qp2TFfERREQSeF27KSMWDDoM3TaIXt2lNhlmoOp.png', 1, '2026-05-07 09:39:28', '2026-05-08 14:07:02'),
(4, 1, 'Super App Movies', 'super-app-movies-1778132968', 'Super App Movies is a premium streaming companion designed specifically for Android, bringing a massive library of global cinema, trending television series, and exclusive indie content right to your fingertips.', 'Android', '1.0.0', 'apps/files/SuperAppMovies-1778132968.apk', 'apps/icons/vRbrulr4LC1kmUl7XXn2ZdRIYDxIJ3VxxNzMjH3f.png', 25, '2026-05-07 09:49:28', '2026-05-09 10:18:07'),
(5, 1, 'NetBrix', 'netbrix-1778234871', 'NetBrix is a premium streaming companion designed specifically for Windows Laptop/PC, bringing a massive library of global cinema, trending television series, and exclusive indie content right to your fingertips.', 'PC', '1.0.0', 'apps/files/NetBrix_Installer_New-1778137156.exe', 'apps/icons/A3lI5IjL5Bu9mHRLBNuNtQdvp4huCPJ8oPs7phTQ.jpg', 0, '2026-05-07 10:59:16', '2026-05-08 14:07:51'),
(6, 1, 'Stream Vault Movies', 'stream-vault-movies-1778234553', 'Stream Vault Movies is a premium streaming companion designed specifically for Android, bringing a massive library of global cinema, trending television series, and exclusive indie content right to your fingertips.', 'Android', '1.0.0', 'apps/files/app-release-1778234553.apk', 'apps/icons/Q1NfR3VCoBgf2uZqZKAR9KTFxk1aubvNe44eyWDh.png', 2, '2026-05-08 14:02:33', '2026-05-08 22:42:49'),
(7, 1, 'Stream Vault Movies PC', 'stream-vault-movies-pc-1778234882', 'Stream Vault Movies is a premium streaming companion designed specifically for Windows Laptop/PC, bringing a massive library of global cinema, trending television series, and exclusive indie content right to your fingertips.', 'PC', '1.0.0', 'apps/files/StreamVault_Installer-1778234824.exe', 'apps/icons/IYmVpNznsDX3D8nHfFiwrrQYrSJlGlnYPXMUBBWk.png', 5, '2026-05-08 14:07:04', '2026-05-09 10:09:10'),
(8, 2, 'Playtime Automation Betting', 'playtime-automation-betting-1778236121', 'Playtime Automation Betting is a specialized utility designed to streamline and automate betting workflows on the Android platform. By reducing manual input and human error, this tool allows users to execute predefined strategies with precision and speed.', 'Android', '1.0.0', 'apps/files/AutoBet_Playtime_1.0[1]-1778236058.apk', 'apps/icons/4O8co8R1bXkdumeIxIoiYk0jA5UpUXQeS0gUAsTy.png', 0, '2026-05-08 14:27:38', '2026-05-08 14:28:41'),
(9, 2, 'Stake Automation Betting', 'stake-automation-betting-1778236199', 'Stake Automation Betting is a specialized utility designed to streamline and automate betting workflows on the Android platform. By reducing manual input and human error, this tool allows users to execute predefined strategies with precision and speed.', 'Android', '1.0.0', 'apps/files/Stake_AutoBet_App_2.0[1]-1778236199.apk', 'apps/icons/OiLwtMTFtH8FkurkvQl90b6pilJm5alMsxyLZGex.png', 0, '2026-05-08 14:29:59', '2026-05-08 14:30:05');

-- --------------------------------------------------------

--
-- Table structure for table `application_files`
--

CREATE TABLE `application_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `application_id` bigint(20) UNSIGNED NOT NULL,
  `architecture` varchar(255) NOT NULL DEFAULT 'Universal',
  `file_path` varchar(255) NOT NULL,
  `file_size` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `application_files`
--

INSERT INTO `application_files` (`id`, `application_id`, `architecture`, `file_path`, `file_size`, `created_at`, `updated_at`) VALUES
(2, 2, 'Universal', 'apps/files/NetBrix-1778132019.apk', 98505115, '2026-05-07 09:33:45', '2026-05-07 09:33:45'),
(3, 3, 'Universal', 'apps/files/SuperAppMovies_Installer_New-1778132368.exe', 28950713, '2026-05-07 09:39:49', '2026-05-07 09:39:49'),
(4, 4, 'Universal', 'apps/files/SuperAppMovies-1778132968.apk', 100308323, '2026-05-07 09:49:34', '2026-05-07 09:49:34'),
(5, 5, 'Universal', 'apps/files/NetBrix_Installer_New-1778137156.exe', 27557481, '2026-05-07 10:59:21', '2026-05-07 10:59:21'),
(6, 6, 'Universal', 'apps/files/app-release-1778234553.apk', 100941863, '2026-05-08 14:02:39', '2026-05-08 14:02:39'),
(7, 7, 'Universal', 'apps/files/StreamVault_Installer-1778234824.exe', 29691107, '2026-05-08 14:07:10', '2026-05-08 14:07:10'),
(8, 8, 'Universal', 'apps/files/AutoBet_Playtime_1.0[1]-1778236058.apk', 81418825, '2026-05-08 14:27:43', '2026-05-08 14:27:43'),
(9, 9, 'Universal', 'apps/files/Stake_AutoBet_App_2.0[1]-1778236199.apk', 64472695, '2026-05-08 14:30:05', '2026-05-08 14:30:05');

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'Entertainment', 'entertainment', '2026-05-07 06:53:01', '2026-05-07 06:53:01'),
(2, 'Utility', 'utility', '2026-05-08 14:16:54', '2026-05-08 14:16:54');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `applications`
--
ALTER TABLE `applications`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `applications_slug_unique` (`slug`),
  ADD KEY `applications_category_id_foreign` (`category_id`);

--
-- Indexes for table `application_files`
--
ALTER TABLE `application_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `application_files_application_id_foreign` (`application_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_slug_unique` (`slug`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `applications`
--
ALTER TABLE `applications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `application_files`
--
ALTER TABLE `application_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `applications`
--
ALTER TABLE `applications`
  ADD CONSTRAINT `applications_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `application_files`
--
ALTER TABLE `application_files`
  ADD CONSTRAINT `application_files_application_id_foreign` FOREIGN KEY (`application_id`) REFERENCES `applications` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
