account – Proxies-free.com: 100% Free Daily Proxy Lists Every Day!

mysql – Need help with the table design to take into account when referring to an element from table_a in table_b

I have no idea. First, I want to tell everyone that I am in no way a DBA. Suppose I have table design like this:

table_a:
-------------------------------------------------- ------
- id - ref_no - date_added - added_by - void_record_id -
-------------------------------------------------- ------
- 1 - gb_001 - 2019-01-01 - 1 - 0 -
- 2 - gb_002 - 2019-01-01 - 1 - 0 -
- 3 - dt_003 - 2019-01-02 - 1 - 0 -
- 4 - dt_004 - 2019-01-02 - 1 - 0 -
- 5 - dt_005 - 2019-01-03 - 2 - 1 -
-------------------------------------------------- ------

Table_B:
-------------------------------------------------- ----------
- id - table_a_id - date_added - added_by - void_record_id -
-------------------------------------------------- ----------
- 1 - 1 - 2019-01-04 - 1 - 0 -
- 2 - 3 - 2019-01-04 - 1 - 0 -
-------------------------------------------------- ----------

void_record:
-------------------------------------------------- -
- id - void_by - date_added - remarks -
-------------------------------------------------- -
- 1 - 3 - 2019-01-05 - removed from records -
-------------------------------------------------- -

think of table_a as a kind of repository for all elements added to the database. Table_B Then serves as a log for the items that a user has taken table_a, void_record then contains all invalid logs that have taken place. This happens instead of deleting the line. So I still have a history of what happened to that particular item (was it invalidated, how often, by whom, and when, etc.). if void_record_id is set to 0, it means that the data is turned on Table 1 is valid. Otherwise, it is invalid or an invalid record.

Now the thing is, a module I'm working on displays all the records of table_a WHERE void_record_id = 0;, with records 1 and 3 from table_a now referenced in Table_BHow can I cancel it table_a without devaluing them, as they were "taken", not "devalued". These referenced items should no longer appear in the application because they are already in use.

I'm open to the idea of adding columns or tables. but the former would be better.

I'm sorry.

Cheers.

ios appstore – buy work iCloud + apps on personal apple account possible?

If you want to add the payment method of another person or company to your own Apple ID, this is fine. However, follow the guidelines of your company.
Go to Setting to add your Apple ID – Payment & Shipping – Payment Method, add a credit card, a debit card or Paypal as usual.

Personally, I think the best way is to buy a physical gift card, get an invoice, and then redeem the gift card on your Apple ID card.

You can also buy other Apple IDs and send a gift to your own Apple ID. ICloud Apple Music and other subscriptions are not available this way.

I think my phone and / or Google Account has been hacked

I have an Android smartphone. At certain times of the day, I need to open apps to see the push notifications. Some of my relatives have the same problem.

Amazon aws – How do I create an FTP account?

I have to ask that FTP IP should be similar to public IPv4 from AWS instance to access FTP account.

Actually, my client has FTP that I could not access because its IP address does not resemble any of the IP addresses of two running instances on aws.

How do I unlock my FB account by holding my email for 24 hours?

Can someone help me to unlock my FB account? that has a 24 hour stop
as soon as possible

PayPal Express Checkout 10606 Errors (PayPal account outside the US, US distributor)

Hello everyone, can anyone successfully do business with US customers while having a non-US PayPal account?

I have received many 10606 errors that have caused carts to stop being used. My Shopify store is set up to serve customers in the US. The error 10606 means, according to PayPal, that the transaction is rejected by the buyer and the buyer should be contacted.
SEMrush

Those shoppers who have taken the trouble to respond said that they easily managed to use their PayPal account on another website. A buyer even closed the transaction with her credit card (on my website) because the payment was declined with PayPal Express.

The last 4 canceled funds were all caused by this PayPal issue. Last month, about 10 funds failed, as the rejection of transactions by PayPal Express was displayed as a broken basket under my Shopify account Signal on Facebook messes up my advertising cycles.

Shopify has indicated that I need to speak with PayPal. So far, PayPal has indicated that everything is fine with me and asked customers to call PayPal to check for problems with their account. I do not think the problem is with the customers (for the reasons mentioned above), and given multiple rejections, this can not be a coincidence. I have sent another e-mail to PayPal. wait for an answer

Needless to say, this kills my business because I can not generate traction in terms of ads / sales and scaling.

Has anyone gone through this and if so, is there a solution? Many Thanks!

Zgen – Account Generator Template Script

Tutifruti has submitted a new resource:

Zgen – Account Generator Template Script – Script Account Generator

Display attachment 23647

overview

This provides a complete template that allows you to create an account generator for yourself. It also contains a default database. There is also a "README.TXT" file so …

Zgen – Account Generator Template Script

How do I recover the password or username of my Google Account (or Gmail)?

I forgot my password, but my browser remembers it

If your browser remembers your password (ie the password field pops up automatically when you sign in to your Google Account and you can sign in), you should be able to retrieve your password through your browser's password manager.

Read the instructions for your browser:

I forgot that password for my Private Google Account (Gmail)

Visit the Google Account Recovery page.
Choose I do not know my password Possibility;
Follow the instructions on the screen.

I forgot that Username (E-Mail Address for my Private Google Account (Gmail)

Visit the Google Account Recovery page.
Choose I do not know my username Possibility;
Follow the instructions on the screen.

To restore your Google username using this form, you must Got to have already specified a recovery email address or Recovery phone number.

If you did not specify recovery information, you may still be able to find your username if you recently accessed your email account through a browser. Gmail displays your email address in the title bar of your browser and browses the history of your browser inbox or Gmail You may enter your e-mail address.

I forgot the username / email address / password for mine job Google Account (Google Apps)

If you have an account with the Google Apps for Business service, you can still use the method described above. If this is unsuccessful, contact the administrator of your domain who can reset your password and / or find your username.

I forgot that Administrator Username / email address for a Google Apps for a Business account that I manage

First, try the methods described above. If this is unsuccessful, you can still reset the administrator password through domain validation.

I forgot my username / my email address / password, but I have a desktop / smartphone email client that can still retrieve emails from my account

If you have already set up an e-mail client to retrieve e-mail from your account, you may be able to extract the user name / password from this client.

The instructions depend on which client you use. Here are links to instructions for some of the most common customers:

I can not access my recovery email, my phone, or any other option

You may still be able to restore access to your account by manually verifying your identity.

Visit the Google Account Recovery page
Enter your e-mail address and click Continue,
When prompted to enter the last password you remember, click I dont know,
click confirm your identity This is among all other options. (It's a small link.)

Afterwards, you will be asked a series of questions that you must answer to the best of our ability. If you can provide enough accurate information, you will get your account back.

How do I prevent losing access to my account in the future?

See How do I protect my Google / Gmail account?

Start a successful freelance business with an approved Upwork account to earn money online

This thread is designed to help anyone who needs ideas for extra income, or who has difficulty surviving Upwork, or who is unable to create an approved Upwork account profile.

Who can join Upwork?

* If you are a freelancer and work on other freelance platforms, you can join Upwork to increase your income.

* If you are unemployed or underemployed and do not feel like going broke, you can learn a skill that is needed as a service on a freelance platform to serve as a source of revenue until you have the opportunity to get the job you want. It is important to mention that every student and graduate can work on Upwork in their free time. All you need is a PC or laptop, an Android phone, an internet connection, and learn about the freelance skills or discover your natural freelance talent through the training center, Google, YouTube, Lynda.com, Udemy.com.

* If you belong to the working class and have the ability to work as a freelance service provider, you can use your free time to earn more income with upwork.

* If you run a service-based company that can be expanded and promoted online as a freelance service, you can engage in freelance platforms to increase your revenue. Some of the companies that can be expanded online include graphic design, PowerPoint presentation design, web design, mobile app design, e-book and print cover design, online tutoring, data entry, data analysis and SEO consulting, translation business, Transcription business, audio and video editing business, animated video production service, songwriting service, music production business, CV and resume writing service, copywriting service, medical writing and editing service, accounting service, business plan writing service, legal & writing services, social media management service , digital marketing business, bulk survey business, building design business, architectural business, 3D modeling services, etc.

SEMrush

I'll update this thread regularly with more information, articles, and important tips to help Upwork users.

Received negative 15000EUR on Paypall account.

Hello. I'm new here, but I'm looking for explanations of what could happen.
The situation:
I was Sales Manager on my ex-job (3 weeks have passed since I left). I have sold on ebay, set up a business ebay account, but added my private paypal. Initially, my personal bank and debit card (no credit card available) was linked to me, and after they added me a bank account to paypal, I deleted my personal banks and cards, but left my address.
I have on ebay in my last week at Job Item for …

Received negative 15000EUR on Paypall account.