Title: Initial database tables
Last modified: December 29, 2021

---

# Initial database tables

 *  Resolved [eimisbass](https://wordpress.org/support/users/eimisbass/)
 * (@eimisbass)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/initial-database-tables/)
 * Hello,
 * My WP version: `5.8.2`
    MySQL version: `5.7.36-0ubuntu0.18.04.1` PHP version:`
   8.1` Woocommerce version: `6.0.0`
 * I am using my own droplet at Digital Ocean.
 * I’m a senior Python developer with 5+ years of experience and I was looking for
   something straightforward for my e-commerce project, so I decided to go with 
   WP + Woocommerce (so not having to build everything from scratch by myself). 
   I was expecting to set it up quickly and for everything to work out of the box,
   but that unfortunately wasn’t the case.
 * I set up the WP + NGINX + MySQL stack easily, but the main problem that I was
   dealing with was Woocoomerce not being to create initial database tables. All
   the WP tables were created during installation, but the Woocommerce plugin did
   not create any tables, I had to create such tables by hand:
 * `wp_actionscheduler_actions`
    `wp_actionscheduler_claims` `wp_actionscheduler_groups``
   wp_actionscheduler_logs`
 * And then:
    `wp_wc_admin_notes` `wp_wc_admin_note_actions` `wp_wc_category_lookup``
   wp_wc_customer_lookup` `wp_wc_download_log` `wp_wc_order_coupon_lookup` `wp_wc_order_product_lookup``
   wp_wc_order_stats` `wp_wc_order_tax_lookup` <. . .> etc.etc. etc.
 * I have no other plugins, just Woocommerce installed.
 * I created these initial tables, but then in Sentry I got another error message:`
   Unknown column 'is_deleted' in 'where clause'` at `/wp-content/plugins/woocommerce/
   packages/woocommerce-admin/src/Notes/DataStore.php in Automattic\WooCommerce\
   Admin\Notes\DataStore::get_notes`
 * I know that my question is a bit vague, but is there a workflow with Woocommerce
   that would just work “out of the box” ? Or maybe there’s a plugin or whatever
   that would help me to understand why Woocommerce isn’t creating initial database
   tables? I know I can read the database logs, but I am starting to feel a bit 
   helpless. Is there a flow that would just work out of the box?
    -  This topic was modified 4 years, 4 months ago by [eimisbass](https://wordpress.org/support/users/eimisbass/).

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [eimisbass](https://wordpress.org/support/users/eimisbass/)
 * (@eimisbass)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/initial-database-tables/#post-15203805)
 * Update: I if anyone needs it, I ended up browsing Woocommerce 6.0.0 code and 
   creating all the tables by myself: [https://gist.github.com/Eimis/5cdde144947885aafc92ef17f26275fd](https://gist.github.com/Eimis/5cdde144947885aafc92ef17f26275fd)
 * Now it works well. Feel free to lock the thread and apologies for spam. Just 
   still surprised it doesn’t work out of the box.
 *  [mother.of.code](https://wordpress.org/support/users/imazed/)
 * (@imazed)
 * The Mother of Code
 * [4 years, 4 months ago](https://wordpress.org/support/topic/initial-database-tables/#post-15204059)
 * Hey there [@eimisbass](https://wordpress.org/support/users/eimisbass/) – this
   is something WooCommerce certainly should be doing out of the box. Creating database
   tables is something users should not have to do.
 * Were you able to go through the setup wizard without any issues?
 *  Thread Starter [eimisbass](https://wordpress.org/support/users/eimisbass/)
 * (@eimisbass)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/initial-database-tables/#post-15209337)
 * No I was not, unfortunately since the db tables were missing, I wasn’t even able
   to access Woocommerce settings, I got “permission denied” errors. Although after
   creating those tables (see Github Gist in my previous message) all works fine
   now.
 *  [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
 * (@rainfallnixfig)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/initial-database-tables/#post-15209408)
 * Hi [@eimisbass](https://wordpress.org/support/users/eimisbass/),
 * It seems like some sort of limitation on your database since all the tables you
   shared in Gist were automatically created on my WC test database and it was not
   the case to create them manually. It’s good to hear that is all working fine 
   now. Thank you for letting us know!
 * Feel free to start a new thread if you have any more questions.
 * Cheers.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Initial database tables’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 4 replies
 * 3 participants
 * Last reply from: [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
 * Last activity: [4 years, 4 months ago](https://wordpress.org/support/topic/initial-database-tables/#post-15209408)
 * Status: resolved