Custom DataBase Tables

Custom DataBase Tables is commonly called "CDBT", it is the plugin for the WordPress. Using this plugin, you can create new table on the database of the WordPress as you like. Then you can do input, output and data updating to created table. Also you can do import and export by format of CSV, TSV, JSON and SQL, and duplicate specific table. Those operation is able to be done easily from the GUI tools on the administration screen of WordPress. In addition, you can provide the functional data manipulation interface to the Web front-end by using some shortcodes or APIs.

• Latest: 2.1.32beta
• Stable: 2.1.31
• Source: https://github.com/ka215/cdbt
• Public SVN Repository: http://wordpress.org/plugins/custom-database-tables/
• Home Page: https://ka2.org/cdbt/
• Twitter: @ka2bowy
• Forum: WordPress.org
• Donate link: PayPal Donations

Requirements

Prerequisite	How to check	How to install
PHP >= 5.4.x	php -v	php.net(English/Japanese)
Node.js >=5.4.x	node -v	nodejs.org
gulp >= 3.9.x	gulp -v	npm install -g gulp
Bower >= 1.7.2	bower -v	npm install -g bower

For more installation notes, refer to the Install gulp and Bower section in this document.

Install gulp and Bower {#install-gulp-and-bower}

Building the theme requires node.js. We recommend you update to the latest version of npm: npm install -g npm@latest.

From the command line:

1. Install gulp and Bower globally with npm install -g gulp bower
2. Navigate to the theme directory, then run npm install
3. Run bower install

You now have all the necessary dependencies to run the build process.

Installation

Install after downloaded from WordPress admin panel or download here and put the plugins directory.

How to install WordPress provisions are as follows.

1. Upload custom-database-tables directory to the /wp-content/plugins/ directory
2. Activate the plugin through the 'Plugins' menu in WordPress
3. Navigate to the Custom DB Tables submenu in setting menu

That's it. Now you can easily start creating custom table in database of WordPress

Usage

Navigate to the Custom DB Tables submenu in setting menu of WordPress admin panel.

First of all, please try to create the database required for the first.

Please see the tutorial for more use of the plugin (Sorry, Japanese only)

Documentation

Plugin Documentation (Sorry, Japanese only)

• Plugin Basic Information
• Plugin Structure
• Plugin Method Reference
• Plugin Action Reference
• Plugin Filter Reference

Features

• You can create newly tables on the database. (CREATE TABLE)
• You can entry data from on the web to your created table. At that time, the entry form will be created automatically in accordance with the table structure.
• You can edit and remove data in the specific table from on the web.
• You can customize the viewing data as a table listed.
• It is corresponding to the input and output of binary data to the table.
• You can import and export with choosing a format of CSV, TSV, JSON and SQL.
• You can duplicate the specific table.
• Using the shortcodes, you can render the interactive data operation interface on the front-end WEB.
• You can set the permission as viewable users, registerable users and editable users to each tables.
• You can manage the core tables built-in WordPress, since the plugin version 2.0.
• Ofcourse, you can remove your created tables. (DROP TABLE)
• You can initialize data of the specific table. (TRUNCATE TABLE)
• You can modify table. (ALTER TABLE)
• Using built-in plugin methods can connect to various core processes as like CRUD.

License

GPLv2 or later

Contributing

1. Fork it

• Create your feature branch (git checkout -b my-new-feature)
• Install the dependencies and run gulp (npm i && gulp)
• Commit your changes (git commit -am 'Add some feature')
• Push to the branch (git push origin my-new-feature)
• Create new Pull Request

2. Donate

• If you thought this plugin felt to be useful, you want to cooperate in the development, or would like to contribute, I'm very happy that you make a donation to me. The magnitude of the amount of the donation is not a problem. Your feelings will become motivation of myself to develop this plugin.
  PayPal Donations

Thanks to the following:

• Bootstrap for the foundation of UI/UX.
• Fuel UX for outputting main components as UX.
• Underscore.js for operating data source at frontend.
• moment.js for viewing localization date on the components.
• Font Awesome for building an intuitive UI.
• kinetic for viewing component to multidevice.
• clipboard.js for improving the usability of data.
• phpMyAdmin for the inspiration.

Support

I've prepared a support forum. Please to slip issuance in here questions about plugin.

Crafted by ka2 (@ka2bowy).