· 8 years ago · Aug 04, 2018, 02:04 PM
1--
2-- Table structure for table `dashboards`
3--
4
5CREATE TABLE IF NOT EXISTS `dashboards` (
6 `id` int(10) NOT NULL auto_increment,
7 `name` varchar(255) default NULL,
8 `is_active` tinyint(4) default '1',
9 PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
11
12--
13-- Dumping data for table `dashboards`
14--
15
16INSERT INTO `dashboards` (`id`, `name`, `is_active`) VALUES
17(1, 'Incoming reels per day', 1),
18(2, 'Incoming reels per producer', 1),
19(3, 'Planned productions vs Consumed', 1),
20(4, 'Production per year', 1),
21(5, 'Incoming reels per month and grammage', 1),
22(6, 'Incoming reels per producer', 1),
23(9, 'Prepicked vs picked reels', 1),
24(7, 'Inventory : days in stock', 1),
25(8, 'Damage per type', 1),
26(10, 'Planned productions vs Consumed + Shift details', 1);