One platform connecting you to a world of services!
Finding a freelance service near you has just got easier! Gigme HQ all in one app saves you time finding great services at competitive prices.
Take control today! Whether you’re looking for a quick or more comprehensive solution, Gigme HQ is at your service!
We connect you to local and international freelancers, world wide, 24 hours a day. With services to meet every budget and every requirement!
Join us here!
', 1, '2020-02-11 15:01:25', '2022-08-23 08:02:08', NULL); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `faqs` -- CREATE TABLE `faqs` ( `id` bigint(20) UNSIGNED NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `question` text COLLATE utf8mb4_unicode_ci NOT NULL, `answer` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` int(11) NOT NULL DEFAULT '1', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `faqs` -- INSERT INTO `faqs` (`id`, `slug`, `question`, `answer`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, '61e96ae6967c761e96ae6967c8', 'How to change the language', 'Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.', 1, '2020-02-17 15:45:47', NULL, NULL), (2, '61e96ae6967c961e96ae6967ca', 'How to restore your chat history', 'Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.', 1, '2020-02-17 15:51:16', NULL, NULL), (3, '630337e7b83531661155303', 'aaabbb', 'aaaa\r\nvbbb', 1, '2022-08-22 08:01:43', '2022-08-23 07:14:28', NULL), (4, '630e51bc0a20f1661882812', 'What is Gigme?', 'Gigme is an online outsourcing platform that puts clients and businesses in contact with a global network of freelancers. Any member can post a project, whether a short- or long-term job, and choose from skilled freelancers who offer bid proposals with rate quotes and time estimates for completing the work. It\'s a mutually beneficial arrangement.\r\n\r\n\r\nClients can have their pick of thousands of freelancers who have the exact skills needed to get the job done, without undertaking the expense and commitment of hiring full-time employees in person.\r\n\r\nFreelancers can access a readily available source of constant part-time and full-time work opportunities from clients who are specifically seeking them out.', 1, '2022-08-30 18:06:52', '2022-08-30 18:06:52', NULL), (5, '630e54f62a7631661883638', 'Freelancer Fees and Charges', 'Freelancer Logo\r\nLog In Sign Up\r\nFreelancer Fees and Charges\r\nFor Employers\r\nProjects\r\nFreelancer is free to sign up, post a project, receive bids from freelancers, review the freelancer\'s portfolio and discuss the project requirements. If you choose to award the project, we charge you a small project fee relative to the value of the selected bid, as an introduction fee.\r\n\r\nThe cost and how this fee is charged depends on the type of project.\r\n\r\nFor fixed price projects, a fee of 3% or $3.00 USD (whichever is greater) is levied at the time a project has been awarded by you. If you subsequently pay the freelancer more than the original bid amount we will also charge the project fee on any overage payments.\r\n\r\nFor hourly projects, a fee of 3% is levied on each payment that you make to the freelancer.\r\n\r\nYou may cancel the project from your dashboard at any time for up to seven (7) days after the project has been accepted for a full refund of your fee.\r\n\r\nOptional project upgrades may be purchased.\r\n\r\nContests\r\nAt the time of posting a contest, employers must provide funds equivalent to the total contest prize. We have a Money Back Guarantee for this prize money.\r\n\r\nThe Money Back Guarantee entitles you to get your money back for up to 30 days from contest closing if you are not happy with the submitted entries. You can get refunded simply by contacting support.\r\n\r\nNote that refunds are not available on \'Guaranteed contests\', and this refund does not include any upgrades that you may have selected for the contest. If you\'ve already selected an entry as the winner and completed the contest handover, which has released the prize money to them, you are not eligible for a refund.\r\n\r\nThere is no contest fee for posting and awarding the contest for employers.\r\n\r\nEach additional awarded entry will also require payment of the prize for that entry.\r\n\r\nOptional contest upgrades may be purchased.\r\n\r\nServices\r\nAt the time of ordering a service, employers must provide funds equivalent to the total service price. The payment is protected by the Freelancer Milestone Payment System. Only release the payment once you are 100% happy with the work that has been delivered.\r\n\r\nFor Freelancers\r\nFreelancer is free to sign up, create a profile, select skills of projects you are interested in, upload a portfolio, receive project notifications, discuss project details with the employer, bid on projects (free members receive initially 6 bids per month) and enter contests.\r\n\r\nOptional bid upgrades may be purchased to promote a bid.\r\n\r\nProjects\r\nFor fixed price projects, if you are awarded a project, and you accept, we charge you a small project fee relative to the value of the selected bid, as an introduction fee. If you are subsequently paid more than the original bid amount, we will also charge the project fee on any overage payments.\r\n\r\nFor hourly projects, the fee is levied on each payment as it is made by the employer to you.\r\n\r\nThe fee for fixed price projects is 10% or $5.00 USD, whichever is greater, and 10% for hourly projects.\r\n\r\nContests\r\nSubmitting entries to a contest is free. Contest fee applies when you are awarded a contest prize. This fee is charged when the prize is released, which is after contest has been awarded to you and the handover of entry materials has been completed to the contest poster\'s satisfaction.\r\n\r\nThe freelancer contest fee is 10% or $5.00 USD, whichever is greater.\r\nServices\r\nIf you are subsequently hired to perform that Service, a 20% fee of the total service price is charged. This is charged when the service is ordered by way of a deduction from the payment you receive.\r\n\r\nPreferred Freelancer Program\r\nIf you are in the Preferred Freelancer Program, you will be charged 15% project fee when you are awarded and accept a Recruiter project. This will not be charged upfront, like on regular projects, but rather when you receive the payment.\r\n\r\nRefunds as Bonus Credit\r\nIn some instances, refund of fees may be done as bonus credit. This bonus may only be used on site, and can not be withdrawn or transferred. The bonus will expire in 90 days from the date of receipt.\r\n\r\n0% Fees Promotion\r\nFreelancer project commissions charged for freelancers who refer new employers that do not have an existing account on Freelancer.com and who join and create a new account, will be reduced from 10% to 0%, for all future projects performed by the referring freelancer for the referred employer.\r\n\r\nThis is subject to the following conditions:\r\n\r\nNew employers must be referred using the specific promotional links on https://www.freelancer.com/no-commission.\r\nFor the avoidance of doubt, the reduced freelancer project commission of 0% applies only in relation to new work performed by the freelancer who has successfully applied for this promotion for the specific employer to whom the application relates. The new projects must commence after the employer creates a new account on Freelancer.com and be initiated using that new account.\r\nProject commission fees for the freelancer only are lowered from 10% to 0% under this promotion. All other fees and charges remain unaffected including but not limited to employer commissions and transaction fees.\r\nThis promotion does not apply to contests.\r\nFreelancer reserves the right to review classifications of employers as new employers for the purpose of this promotion, to ensure fair use of this promotion. Employers must have worked with, and paid, the freelancer applying to use this promotion before the beginning of this promotion, for example from another platform. Freelancers may be required to provide evidence of this prior work and payment before being eligible for the commission reduction. To be eligible for this promotion, employers must not have had any active account on Freelancer.com from which a payment was made within the 6 months immediately prior to creating the new account.\r\nAll other elements of the User Agreement continue to apply - see https://www.freelancer.com/about/terms.\r\nAll other elements of the Fees and Charges component of the Additional Terms continue to apply - see https://www.freelancer.com/feesandcharges.\r\nFreelancer may require that both parties fill in and complete their profiles and/or pass identity checks before payments are released.\r\nFreelancer may require that the details for any project for which the commission reduction applies are appropriately complete.\r\nThis promotion may be withdrawn for a specific user, if significant reversals, fraud or chargebacks are observed, if Freelancer believes that there is a risk of funds being subject to reversal or chargeback, in cases of disputes between employer and freelancer, or for any other reason.\r\nFreelancer reserves the right to disallow use of this promotion in its sole and absolute discretion, with respect to fair use of this promotion, and to prevent any suspected fraud.\r\nFreelancer reserves the right to require submission of further information from any party applying to make use of this promotion, for investigating fraud and for risk management and related purposes.\r\nFreelancer reserves the right to cancel or amend this promotion at any time.\r\nFreelancer reserves the right to cancel the promotion in any region if it is deemed or becomes unlawful to offer the promotion to any resident of that region.\r\n3% Quote Fee\r\nFreelancer project commissions charged for freelancers who have a quote awarded by a new external Client will be 3% for all projects between the Freelancer and new Client. For new external Clients accepting a quote, 0% Freelancer project commissions will be charged.\r\n\r\n\"New Client\" refers to clients that have not created an account on Freelancer.com before.\r\nThe promotion does not apply if clients have multiple accounts on Freelancer.com.\r\nThis is subject to the following conditions:\r\n\r\nNew employers must be referred through accepting a quote and registering during the acceptance process.\r\nFor the avoidance of doubt, the reduced freelancer project commission of 3% applies only in relation to work performed by the freelancer who has successfully applied for this promotion for the specific employer to whom the application relates. Work must commence after the employer creates a new account on Freelancer.com and be initiated using that new account.\r\nProject commission fees for the freelancer only are lowered from 10% to 3% and client project commission fees are lowered from 3% to 0% under this promotion. All other fees and charges remain unaffected including but not limited to transaction fees.\r\nThis promotion does not apply to contests.\r\nFreelancer reserves the right to review classifications of employers as new employers for the purpose of this promotion, to ensure fair use of this promotion. To be eligible for this promotion, employers must not have had any active account on Freelancer.com from which a payment was made within the 6 months immediately prior to creating the new account.\r\nAll other elements of the User Agreement continue to apply - see https://www.freelancer.com/about/terms.\r\nAll other elements of the Fees and Charges component of the Additional Terms continue to apply - see https://www.freelancer.com/feesandcharges.\r\nFreelancer may require that both parties fill in and complete their profiles and/or pass identity checks before payments are released.\r\nFreelancer may require that the details for any project for which the commission reduction applies are appropriately complete.\r\nThis promotion may be withdrawn for a specific user, if significant reversals, fraud or chargebacks are observed, if Freelancer believes that there is a risk of funds being subject to reversal or chargeback, in cases of disputes between employer and freelancer, or for any other reason.\r\nFreelancer reserves the right to disallow use of this promotion in its sole and absolute discretion, with respect to fair use of this promotion, and to prevent any suspected fraud.\r\nFreelancer reserves the right to require submission of further information from any party applying to make use of this promotion, for investigating fraud and for risk management and related purposes.\r\nFreelancer reserves the right to cancel or amend this promotion at any time.\r\nFreelancer reserves the right to cancel the promotion in any region if it is deemed or becomes unlawful to offer the promotion to any resident of that region.\r\nMembership Plans\r\nSelect from a range of membership plans to determine the fees you pay for our service. You can work on the site as either an employer or freelancer as a free member, or gain additional benefits as a paid member by upgrading to a paid plan.\r\n\r\nMemberships will recur on either a monthly or annual basis on the anniversary of your subscription, unless cancelled. If funds are insufficient we will try to renew your membership for up to 30 days, until funds are made available.\r\n\r\nYou may cancel your membership at anytime from the user settings page, which will cease billing at the end of your subscription period without additional costs.\r\n\r\nView our membership plans\r\n\r\nOther Fees\r\nProjects\r\nThe following fees are optionally charged for additional services. Unless otherwise specified according to the benefits of a paid membership plan:\r\n\r\nPosting a Project FREE\r\nFeatured $9.00 USD\r\nUrgent $9.00 USD\r\nPrivate $19.00 USD\r\nFull Time $199.00 USD\r\nRecruiter $9.50 USD\r\nNon-Disclosure Agreement (NDA) $19.00 USD\r\nIP Agreement $19.00 USD\r\nSealed $9.00 USD\r\nPriority $5.00 USD\r\nExtend $9.00 USD\r\nContests\r\nThe following fees are optionally charged for additional services. Unless otherwise specified according to the benefits of a paid membership plan:\r\n\r\nPosting a Contest FREE\r\nAwarding contest FREE\r\nAwarding to additional freelancers FREE\r\nGuaranteed FREE\r\nFeatured $30.00 USD\r\nTop Contest $30.00 USD\r\nUrgent $35.00 USD\r\nHighlight $15.00 USD\r\nSealed $30.00 USD\r\nPrivate $25.00 USD\r\nNon-Disclosure Agreement (NDA) $20.00 USD\r\nExtend Costs:\r\n3 days = 15% of contest prize\r\n5 days = 20% of contest prize\r\n7 days = 30% of contest prize\r\n14 days = 40% of contest prize\r\n21 days = 50% of contest prize\r\nHalf of the costs will be used to increase the contest prize (rounded to the nearest whole number).\r\nBid Fees\r\nBidding on projects FREE\r\nSponsored bid 0.75% of bid amount (minimum $5.00 USD, maximum $20.00 USD)\r\nHighlight Bid $1.00 USD\r\nSealed Bid $0.10 USD\r\nContest Entry Fees\r\nSubmit an Entry FREE\r\nSealed Entry $0.50 USD\r\nHighlight Entry $0.50 USD\r\nDirectory Fees\r\nDirectory sponsorship As selected at time of sponsoring (minimum $50.00 USD)\r\nExams\r\nTaking an exam Dependent on exam. As specified prior to purchase. Typically either free, $5.00 USD, $10.00 USD, or $15.00 USD.\r\nTransaction Fees\r\nTransaction fees incurred for using Credit Card, PayPal or Skrill.* $0.30 USD + 2.3%\r\nLocal Bank Deposit FREE\r\nInternational Wire Transfer $15.00 USD*Australian users incur $0.30AUD + 0.99% for Credit/Debit card transactions.\r\nArbitration Fees\r\nThe arbitration fee for a milestone dispute is $5.00 USD or 5%, whichever is greater.\r\n\r\nOur dispute resolution system is designed to allow both parties to resolve issues regarding milestone payments amongst themselves without arbitration.\r\n\r\nAfter 4 days of a dispute being filed (or 7 days if the dispute is filed by the freelancer) either party may elect to move the dispute to paid arbitration. The other party will then have a further 4 days to agree to pay this fee and for both parties to submit any final evidence. If the other party fails to pay within time, they will lose the dispute.\r\n\r\nThe arbitration fee will then be refunded to the winner of the dispute.\r\n\r\nWithdrawal Fees\r\nFees may be optionally levied depending on the method of withdrawal. Additional fees may be levied by the third party offering the withdrawal method.\r\n\r\nExpress Withdrawal FREE\r\nPayPal FREE\r\nSkrill (Moneybookers) FREE\r\nPayoneer Debit Card FREE\r\nInternational Wire $25.00 USD\r\nWe impose a minimum withdrawal, after fees, of USD $30.\r\n\r\nMaintenance Fee\r\nUser Accounts that have not logged in for six months will incur a maintenance fee of up to $12.00 USD per month until either the account is terminated or reactivated for storage, bandwidth, support and management costs of providing hosting of the user\'s profile, portfolio storage, listing in directories, provision of the HireMe service, file storage and message storage. These fees will be refunded upon request by users on subsequent reactivation.\r\n\r\nTaxes\r\nTaxes are applied based on local rates and rules defined by the user\'s country of residence / registered country.\r\n\r\nAustralia - Goods and Service Tax (GST) 10%\r\nChile - Value Added Tax (VAT) 19%\r\nEuropean Union - Value Added Tax (VAT) VAT rates\r\nIndia - Tax Collected at Source (TCS) 1%\r\nIndia - Tax Deducted at Source (TDS) 1% / 5%\r\nMexico - Income Tax Withholding 1% / 20%\r\nMexico - Value Added Tax (VAT) 16%\r\nRussia - Value Added Tax (VAT) 20%\r\nSwitzerland - Value Added Tax (VAT) 7.7%\r\nIndia Equalisation Levy Reimbursement\r\nThe treaty relieves freelancers of withholding obligations, for the avoidance of doubt, the Equalisation Levy. You are not being charged or paying for this levy, it is a reimbursement.\r\nCLIENT\r\n\r\nIndian Resident\r\n\r\nFREELANCER\r\n\r\nIndian Resident\r\n\r\nWHO PAYS LEVY\r\n\r\nFreelancer\r\n\r\nLEVY DETAILS\r\n\r\n2% charged to Freelancer on gross earnings\r\n\r\nCLIENT\r\n\r\nIndian Resident\r\n\r\nFREELANCER\r\n\r\nOther\r\n\r\nWHO PAYS LEVY\r\n\r\nClient\r\n\r\nLEVY DETAILS\r\n\r\n2% charged to Client on gross milestone payments\r\n\r\nCLIENT\r\n\r\nOther\r\n\r\nFREELANCER\r\n\r\nIndian Resident\r\n\r\nWHO PAYS LEVY\r\n\r\nFreelancer\r\n\r\nLEVY DETAILS\r\n\r\n2% charged to Freelancer on gross earnings\r\n\r\nCLIENT\r\n\r\nOther\r\n\r\nFREELANCER\r\n\r\nOther\r\n\r\nWHO PAYS LEVY\r\n\r\nN/A\r\n\r\nLEVY DETAILS\r\n\r\nN/A\r\n\r\n* Freelancer and its affiliates do not provide tax, legal or accounting advice. This material has been prepared for informational purposes only, and is not intended to provide, and should not be relied on for, tax, legal or accounting advice. You should consult your own tax, legal and accounting advisors.\r\n\r\nUser Agreement\r\nThe fees and charges summarised on this page are governed by the terms of the Freelancer User Agreement and related site policies. The User Agreement includes other important terms and should be read in full. In particular section 23 of the User Agreement specifies the consequences of termination for violations of the User Agreement. Those consequences can include fines for damages that Freelancer will sustain as a result of actions that breach the User Agreement.', 1, '2022-08-30 18:20:38', '2022-08-30 18:23:21', NULL), (6, '630e58d4c78b61661884628', 'How do I sign up?', 'Fill out a short signup form. You will be asked to create a unique username for identification in our system, provide a valid email address, and confirm that you have read our Terms and Conditions. You don\'t have to give any personal information to start your Freelancer membership.\r\n\r\nConfirm your email address. When you submit the registration form, we will send a verification email to the email address you provided upon signing up. Follow the link provided on the email to activate your Freelancer account.\r\n\r\nCreate your profile. Fill out your profile correctly and completely to let the Freelancer community know who you are as a person and what you\'re looking for professionally.\r\n\r\nUsers with incomplete profiles will not be allowed to bid on projects. Here are a few tips to complete your profile and get noticed:\r\n\r\nBe sure to upload a photo on your profile. It\'s much easier to recognize and relate to a face than a username.\r\n\r\nYou might want to consider using your full name or company name as your display name.\r\n\r\nYour Professional Headline is a good place to make a solid first impression. It might be your company slogan or a list of the top skills you can offer to a client. It should make other users want to know more about you.\r\n\r\nUse the Summary section to give more details about yourself. This is your chance to really make your profile stand out from the crowd. Talk about your company mission or your work history. Highlight your skills and let people in the Freelancer.com community know why you\'re the best freelancer for the job.\r\n\r\n \r\n\r\nThe information you provide on your profile page will give other users an overview of your skills and/or needs. Gigme does not share your personal and contact information on your Profile Details page.', 1, '2022-08-30 18:37:08', '2022-08-30 18:37:08', NULL), (7, '630e5962ba20a1661884770', 'I am a client, how will Gigme work for me??', 'You can gain a competitive advantage over your competition by tapping into a skilled global workforce on demand.\r\n\r\n\r\nIf you are a small business and can\'t afford to hire a full-time staff, don\'t fret! The power of Freelancer is available for small to medium businesses! Whether it\'s a website that needs building, business cards or stationery that needs designing, a product that needs to be designed or manufactured, or research that needs to be done, this is the place for you!\r\n\r\n\r\nThousands of skilled workers are ready to start working right now! All you need to do is post a project!', 1, '2022-08-30 18:39:30', '2022-08-30 18:39:46', NULL), (8, '630e59c7576e11661884871', 'I am a freelancer, what will GIGme do for me?', 'With Freelancer, you can work at home and tap into a global network of businesses and projects across a huge range of industries - the ultimate opportunity in job flexibility!\r\n\r\n\r\nWork on what you want, when you want and where you want to! The lifestyle of a freelancer is taking off. By working as a Freelancer online, you can greatly increase your client base and job throughput.\r\n\r\n \r\n\r\nTo start, all you need to do is sign up and start bidding. It\'s FREE!', 1, '2022-08-30 18:41:11', '2022-08-30 18:41:11', NULL), (9, '630e5a87264dd1661885063', 'How do I get paid?', 'How do I get paid?\r\nPayments from completing projects and contests will be transferred to your Freelancer.com account. You can then have them requested to be withdrawn.\r\n\r\n \r\n\r\nYour clients can pay you via any of the following methods:\r\n\r\n \r\n\r\n \r\n\r\nMilestone Payments\r\n \r\n\r\nThe Milestone Payment System is the recommended mode of payment on the site. Your client can set funds aside for later payment once you have completed the project. The payment, called a Milestone Payment, can also be released to you by your client for every task met. Also, every Milestone Payment comes with an invoice which you can use for tax purposes.\r\n\r\n \r\n\r\nWe encourage using Proposed Milestones as early as bidding on projects to help your client see the payment schedule for the project per task in case they award you.\r\n\r\n \r\n\r\nUsing Milestone Payments also gives you and your client access to our Dispute Resolution Service in the event that your project does not go as planned.\r\n\r\n \r\n\r\nNote that quote items in quotations you send to clients turn into Milestone Payments once your client accepts your quote.\r\n\r\n \r\n\r\n \r\n\r\nTransfer Funds\r\n \r\n\r\nTransfer Funds allows your client to directly transfer payment to you via the Transfer Funds tab on their Financial Dashboard. However, we still recommend using the Milestone Payment System instead because this mode of payment is not eligible for our Dispute Resolution Service.\r\n\r\n \r\n\r\nTo ensure you have the best protection possible in an unlikely event of a dispute, keep your correspondences and payments within GIGme.com', 1, '2022-08-30 18:44:23', '2022-08-30 18:44:23', NULL); -- -------------------------------------------------------- -- -- Table structure for table `file_disputes` -- CREATE TABLE `file_disputes` ( `id` bigint(20) UNSIGNED NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `booking_id` bigint(20) UNSIGNED NOT NULL, `reason` text COLLATE utf8mb4_unicode_ci, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `gigs` -- CREATE TABLE `gigs` ( `id` bigint(20) UNSIGNED NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `category_id` int(11) NOT NULL, `is_delete` int(11) NOT NULL DEFAULT '0', `is_active` int(11) NOT NULL DEFAULT '1', `is_premium` int(11) NOT NULL DEFAULT '0', `status` enum('pending','accepted','rejected','completed','disputed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `gigs` -- INSERT INTO `gigs` (`id`, `slug`, `user_id`, `title`, `description`, `category_id`, `is_delete`, `is_active`, `is_premium`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'screen-writer-editor', 3, 'Screen Writer Editor', 'I am a professional screenwriter currently working for CBS, Paramount+, Amazon, and Paramount Pictures. I\'ve written features for 20th Century Fox, Warner Bros., Happy Madison, and Bad Robot. A pilot of mine was produced by NBC, as well as a children\'s episodic for Cartoon Network and an animated pilot for Adult Swim. I\'ve also done short-form comedy material for entities like The Onion, HBO, and National Lampoon.', 25, 0, 1, 0, 'pending', '2022-08-24 06:38:34', '2022-08-24 06:38:34', NULL), (2, 'biography-writer', 3, 'Biography writer', 'I have almost two decades of writing experience; from Ghost-writing and Editing, developing Accredited Educational Textbooks and Training Programs, to Script-writing and Proofreading. My experience also includes Business Plan and Pitch Deck Design and Development, as well as writing pitches for various industries and sectors, for multi-million Dollar projects.', 4, 0, 1, 0, 'pending', '2022-08-24 06:40:53', '2022-08-24 06:40:53', NULL), (3, 'research-articles-writer', 1, 'Research Articles writer', 'All my self-written articles include: - Previous thorough research of the topic - Original words created to appeal to your audience - A guarantee that the articles will be plagiarism-free - Proofreading and editing to ensure quality work All of my editing includes: - Article Flow - Fact Checking - Readability If you are willing to cooperate and outperform the competition, feel free to contact me. Let\'s get started!', 4, 0, 1, 0, 'pending', '2022-08-24 06:47:21', '2022-08-24 06:47:21', NULL), (4, 'test', 7, 'Test', 'Asdfsadfasfadsfasf', 29, 0, 1, 0, 'pending', '2022-09-06 11:57:03', '2022-09-06 11:57:03', NULL); -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `mail_templates` -- CREATE TABLE `mail_templates` ( `id` bigint(20) UNSIGNED NOT NULL, `identifier` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `wildcard` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `mail_templates` -- INSERT INTO `mail_templates` (`id`, `identifier`, `subject`, `body`, `wildcard`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'forgot-password', 'Forgot Password Confirmation', '\r\n
| \r\n
\r\n
| \r\n