WordPress.org

Arbitrary section

Tables creation from SQL:

These tables are created automatically within the wordpress database

--

-- Table structure for table Accounts

CREATE TABLE Accounts ( id tinyint(4) NOT NULL auto_increment, date date NOT NULL default '0000-00-00', name varchar(50) NOT NULL default '', type varchar(20) NOT NULL default '', data varchar(25) NOT NULL default '', class varchar(255) NOT NULL default '', PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--

-- Table structure for table Journal

CREATE TABLE IF NOT EXISTS Journal ( date date NOT NULL default '0000-00-00', ref tinyint(4) NOT NULL default '0', account varchar(50) NOT NULL default '', debit decimal(10,2) NOT NULL default '0.00', credit decimal(10,2) NOT NULL default '0.00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- Table structure for table Ledger

CREATE TABLE IF NOT EXISTS Ledger ( id tinyint(4) NOT NULL auto_increment, name varchar(255) NOT NULL default '', date date NOT NULL default '0000-00-00', note varchar(255) NOT NULL default '', ref double NOT NULL default '0', data decimal(10,2) NOT NULL default '0.00', credit decimal(10,2) NOT NULL default '0.00', balance decimal(10,2) NOT NULL default '0.00', type varchar(10) NOT NULL default '', PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Testing:

Create a page with the following shortcode, [bestbooks-sample-1] then check your database tables for the validation.

If you get an error, please report it!

Credits

We make honorable mention to anyone who helps make Bestbooks for WordPress a better plugin!

Contact

Support is provided at http://support.phkcorp.com. Please request membership in the "Bestbooks" forum.

Please contact phkcorp2005@gmail.com or visit http://www.phkcorp.com?do=wordpress with questions, comments, or requests.