-### Structure of table `0_dashboard_reminders` ###
-
-DROP TABLE IF EXISTS `0_dashboard_reminders`;
-
-CREATE TABLE `0_dashboard_reminders` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `role_id` int(11) NOT NULL,
- `next_date` date NOT NULL,
- `description` text COLLATE utf8_unicode_ci,
- `frequency` varchar(20) NOT NULL,
- `param` text COLLATE utf8_unicode_ci,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB ;
-
-### Data of table `0_dashboard_reminders` ###
-
-
-### Structure of table `0_dashboard_widgets` ###
-
-DROP TABLE IF EXISTS `0_dashboard_widgets`;
-
-CREATE TABLE `0_dashboard_widgets` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `app` varchar(50) NOT NULL,
- `column_id` int(11) NOT NULL,
- `sort_no` int(11) NOT NULL,
- `collapsed` tinyint(1) NOT NULL,
- `widget` varchar(100) NOT NULL,
- `description` varchar(100) NOT NULL,
- `param` text COLLATE utf8_unicode_ci,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=40 ;
-
-### Data of table `0_dashboard_widgets` ###
-
-INSERT INTO `0_dashboard_widgets` VALUES
-('1', '1', 'AP', '1', '1', '0', 'weeklysales', 'Top 10 Sales Weeks', '{"top":"10","orderby":"Gross Sales","orderby_seq":"desc","graph_type":"Table","data_filter":"dm.payment_terms = -1"}'),
-('2', '1', 'AP', '1', '0', '0', 'weeklysales', 'Weekly Sales', '{"top":"","orderby":"Week End","orderby_seq":"asc","graph_type":"LineChart","data_filter":""}'),
-('3', '1', 'AP', '2', '1', '0', 'weeklysales', 'Lowest weeks sales', '{"top":"10","orderby":"Gross Sales","orderby_seq":"asc","graph_type":"Table","data_filter":""}'),
-('6', '1', 'AP', '2', '0', '0', 'dailysales', 'Daily Sales', '{"top":"10","data_filter":"dm.payment_terms = -1","graph_type":"LineChart"}'),
-('7', '1', 'orders', '1', '0', '0', 'customers', 'Top 10 Customers', '{"top":"10","data_filter":"","graph_type":"Table"}'),
-('9', '1', 'orders', '1', '1', '0', 'salesinvoices', 'Overdue invoices', '{"data_filter":""}'),
-('10', '1', 'AP', '1', '0', '0', 'suppliers', 'Top 10 Suppliers', '{"top":"","data_filter":"","graph_type":"Table"}'),
-('11', '1', 'AP', '2', '0', '0', 'suppliers', 'Top 10 Suppliers', '{"top":"","data_filter":"","graph_type":"ColumnChart"}'),
-('12', '1', 'GL', '2', '1', '0', 'glreturn', 'Return', '{"graph_type":"Table","data_filter":""}'),
-('13', '1', 'GL', '2', '0', '0', 'glreturn', 'Return', '{"graph_type":"PieChart","data_filter":""}'),
-('14', '1', 'stock', '1', '0', '0', 'items', 'Top 10 Items', '{"top":"","item_type":"stock","graph_type":"Table","data_filter":""}'),
-('15', '1', 'stock', '2', '0', '0', 'items', 'Top 10 Items', '{"top":"","item_type":"stock","graph_type":"PieChart","data_filter":""}'),
-('16', '1', 'manuf', '1', '0', '0', 'items', 'Top 10 items', '{"top":"","item_type":"manuf","graph_type":"Table","data_filter":""}'),
-('17', '1', 'manuf', '2', '0', '0', 'items', 'Top 10 Items', '{"top":"","item_type":"manuf","graph_type":"PieChart","data_filter":""}'),
-('18', '1', 'orders', '2', '0', '0', 'customers', 'Top 10 Customers', '{"top":"","data_filter":"","graph_type":"ColumnChart"}'),
-('19', '1', 'GL', '2', '2', '0', 'bankbalances', 'Bank Balances', '{"data_filter":""}'),
-('20', '1', 'GL', '1', '1', '0', 'dailybankbalances', 'Daily Current Account Balance', '{"days_past":"","days_future":"","bank_act":"0","graph_type":"ColumnChart"}'),
-('21', '1', 'GL', '1', '0', '0', 'banktransactions', 'Current Account Transactions', '{"days_past":"15","days_future":"15","bank_act":"0","data_filter":""}'),
-('22', '2', 'AP', '1', '1', '0', 'weeklysales', 'Top 10 Sales Weeks', '{"top":"10","orderby":"Gross Sales","orderby_seq":"desc","graph_type":"Table","data_filter":"dm.payment_terms = -1"}'),
-('23', '2', 'AP', '1', '0', '0', 'weeklysales', 'Weekly Sales', '{"top":"","orderby":"Week End","orderby_seq":"asc","graph_type":"LineChart","data_filter":""}'),
-('24', '2', 'AP', '2', '1', '0', 'weeklysales', 'Lowest weeks sales', '{"top":"10","orderby":"Gross Sales","orderby_seq":"asc","graph_type":"Table","data_filter":""}'),
-('25', '2', 'AP', '2', '0', '0', 'dailysales', 'Daily Sales', '{"top":"10","data_filter":"dm.payment_terms = -1","graph_type":"LineChart"}'),
-('26', '2', 'orders', '1', '0', '0', 'customers', 'Top 10 Customers', '{"top":"10","data_filter":"","graph_type":"Table"}'),
-('27', '2', 'orders', '1', '1', '0', 'salesinvoices', 'Overdue invoices', '{"data_filter":""}'),
-('28', '2', 'AP', '1', '0', '0', 'suppliers', 'Top 10 Suppliers', '{"top":"","data_filter":"","graph_type":"Table"}'),
-('29', '2', 'AP', '2', '0', '0', 'suppliers', 'Top 10 Suppliers', '{"top":"","data_filter":"","graph_type":"ColumnChart"}'),
-('30', '2', 'GL', '2', '1', '0', 'glreturn', 'Return', '{"graph_type":"Table","data_filter":""}'),
-('31', '2', 'GL', '2', '0', '0', 'glreturn', 'Return', '{"graph_type":"PieChart","data_filter":""}'),
-('32', '2', 'stock', '1', '0', '0', 'items', 'Top 10 Items', '{"top":"","item_type":"stock","graph_type":"Table","data_filter":""}'),
-('33', '2', 'stock', '2', '0', '0', 'items', 'Top 10 Items', '{"top":"","item_type":"stock","graph_type":"PieChart","data_filter":""}'),
-('34', '2', 'manuf', '1', '0', '0', 'items', 'Top 10 items', '{"top":"","item_type":"manuf","graph_type":"Table","data_filter":""}'),
-('35', '2', 'manuf', '2', '0', '0', 'items', 'Top 10 Items', '{"top":"","item_type":"manuf","graph_type":"PieChart","data_filter":""}'),
-('36', '2', 'orders', '2', '0', '0', 'customers', 'Top 10 Customers', '{"top":"","data_filter":"","graph_type":"ColumnChart"}'),
-('37', '2', 'GL', '2', '2', '0', 'bankbalances', 'Bank Balances', '{"data_filter":""}'),
-('38', '2', 'GL', '1', '1', '0', 'dailybankbalances', 'Daily Current Account Balance', '{"days_past":"","days_future":"","bank_act":"0","graph_type":"ColumnChart"}'),
-('39', '2', 'GL', '1', '0', '0', 'banktransactions', 'Current Account Transactions', '{"days_past":"15","days_future":"15","bank_act":"0","data_filter":""}');
-
-### Structure of table `0_debtor_trans` ###