· 5 years ago · Feb 13, 2020, 02:36 AM
1-- phpMyAdmin SQL Dump
2-- version 4.9.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Feb 13, 2020 at 02:26 AM
7-- Server version: 10.4.10-MariaDB
8-- PHP Version: 7.4.0
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `tiapi`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `client`
29--
30
31DROP TABLE IF EXISTS `client`;
32CREATE TABLE IF NOT EXISTS `client` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `name` varchar(255) NOT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
37
38--
39-- Dumping data for table `client`
40--
41
42INSERT INTO `client` (`id`, `name`) VALUES
43(1, 'XDNA'),
44(2, 'TIAPI'),
45(3, 'Test');
46
47-- --------------------------------------------------------
48
49--
50-- Table structure for table `failed_jobs`
51--
52
53DROP TABLE IF EXISTS `failed_jobs`;
54CREATE TABLE IF NOT EXISTS `failed_jobs` (
55 `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
56 `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
57 `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
58 `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
59 `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
60 `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
61 PRIMARY KEY (`id`)
62) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
63
64-- --------------------------------------------------------
65
66--
67-- Table structure for table `insurancecompany`
68--
69
70DROP TABLE IF EXISTS `insurancecompany`;
71CREATE TABLE IF NOT EXISTS `insurancecompany` (
72 `id` int(11) NOT NULL AUTO_INCREMENT,
73 `name` varchar(255) NOT NULL,
74 PRIMARY KEY (`id`)
75) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
76
77--
78-- Dumping data for table `insurancecompany`
79--
80
81INSERT INTO `insurancecompany` (`id`, `name`) VALUES
82(1, 'Medicare'),
83(2, 'TPS');
84
85-- --------------------------------------------------------
86
87--
88-- Table structure for table `invoice`
89--
90
91DROP TABLE IF EXISTS `invoice`;
92CREATE TABLE IF NOT EXISTS `invoice` (
93 `id` int(11) NOT NULL AUTO_INCREMENT,
94 `insuranceCompany` int(11) NOT NULL,
95 `invoiceDate` varchar(255) NOT NULL,
96 `dueDate` varchar(255) NOT NULL,
97 `invoiceNumber` varchar(255) NOT NULL,
98 `salesRep` varchar(255) NOT NULL,
99 `client` int(11) NOT NULL,
100 `productClass` varchar(10) NOT NULL,
101 `productLine` varchar(10) NOT NULL,
102 `policyType` varchar(50) NOT NULL,
103 `policyNumber` varchar(150) NOT NULL,
104 `description` longtext NOT NULL,
105 `inceptionDate` varchar(255) NOT NULL,
106 `expiryDate` varchar(255) NOT NULL,
107 `netPremium` varchar(255) NOT NULL,
108 `grossPremium` varchar(255) NOT NULL,
109 `commRate` varchar(255) NOT NULL,
110 `commAmount` varchar(255) NOT NULL,
111 `notes` longtext NOT NULL,
112 PRIMARY KEY (`id`)
113) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
114
115--
116-- Dumping data for table `invoice`
117--
118
119INSERT INTO `invoice` (`id`, `insuranceCompany`, `invoiceDate`, `dueDate`, `invoiceNumber`, `salesRep`, `client`, `productClass`, `productLine`, `policyType`, `policyNumber`, `description`, `inceptionDate`, `expiryDate`, `netPremium`, `grossPremium`, `commRate`, `commAmount`, `notes`) VALUES
120(1, 1, '2020-01-31', '2020-01-31', 'Invoice-1', '1-Admin Admin', 1, 'Non-Life', 'Fire', 'New Organization', 'Policy123', 'This is just a test', '2020-01-31', '2020-01-31', '400000', '420000', '0.123', '49200', 'This is just a test');
121
122-- --------------------------------------------------------
123
124--
125-- Table structure for table `migrations`
126--
127
128DROP TABLE IF EXISTS `migrations`;
129CREATE TABLE IF NOT EXISTS `migrations` (
130 `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
131 `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
132 `batch` int(11) NOT NULL,
133 PRIMARY KEY (`id`)
134) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
135
136--
137-- Dumping data for table `migrations`
138--
139
140INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
141(4, '2014_10_12_000000_create_users_table', 1),
142(5, '2014_10_12_100000_create_password_resets_table', 1),
143(6, '2019_08_19_000000_create_failed_jobs_table', 1);
144
145-- --------------------------------------------------------
146
147--
148-- Table structure for table `password_resets`
149--
150
151DROP TABLE IF EXISTS `password_resets`;
152CREATE TABLE IF NOT EXISTS `password_resets` (
153 `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
154 `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
155 `created_at` timestamp NULL DEFAULT NULL,
156 KEY `password_resets_email_index` (`email`(250))
157) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
158
159-- --------------------------------------------------------
160
161--
162-- Table structure for table `users`
163--
164
165DROP TABLE IF EXISTS `users`;
166CREATE TABLE IF NOT EXISTS `users` (
167 `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
168 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
169 `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
170 `email_verified_at` timestamp NULL DEFAULT NULL,
171 `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
172 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
173 `created_at` timestamp NULL DEFAULT NULL,
174 `updated_at` timestamp NULL DEFAULT NULL,
175 PRIMARY KEY (`id`),
176 UNIQUE KEY `users_email_unique` (`email`) USING HASH
177) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
178
179--
180-- Dumping data for table `users`
181--
182
183INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
184(1, 'Admin Admin', 'admin@black.com', '2020-01-16 04:10:53', '$2y$10$KnUOgHXlme9lAtjYPqiYn.K66PfH6LVzRws2xUVewYDdy2Q26zHiq', NULL, '2020-01-16 04:10:53', '2020-01-16 04:10:53');
185COMMIT;
186
187/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
188/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
189/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;