cake_expense database for cakephp 3 application development tutorial
Tutorial link : https://www.youtube.com/watch?v=E8hnc4v-8hA
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; -- -- Database: `cake_expense` -- -- -------------------------------------------------------- -- -- Table structure for table `expenses` -- CREATE TABLE `expenses` ( `id` int(11) NOT NULL, `expenses_category_id` int(11) NOT NULL, `amount` float NOT NULL, `purpose` varchar(100) NOT NULL, `created` datetime NOT NULL, `modified` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `expenses_categories` -- CREATE TABLE `expenses_categories` ( `id` int(6) NOT NULL, `name` varchar(50) NOT NULL, `created` datetime NOT NULL, `modified` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `incomes` -- CREATE TABLE `incomes` ( `id` int(11) NOT NULL, `income_category_id` int(11) NOT NULL, `amount` float NOT NULL, `purpose` varchar(100) NOT NULL, `created` datetime NOT NULL, `modified` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `income_categories` -- CREATE TABLE `income_categories` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `created` datetime NOT NULL, `modified` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `username` varchar(30) NOT NULL, `email` varchar(40) NOT NULL, `password` varchar(100) NOT NULL, `created` datetime NOT NULL, `modified` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Indexes for dumped tables -- -- -- Indexes for table `expenses` -- ALTER TABLE `expenses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expenses_categories` -- ALTER TABLE `expenses_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `incomes` -- ALTER TABLE `incomes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `income_categories` -- ALTER TABLE `income_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `expenses` -- ALTER TABLE `expenses` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `expenses_categories` -- ALTER TABLE `expenses_categories` MODIFY `id` int(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `incomes` -- ALTER TABLE `incomes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `income_categories` -- ALTER TABLE `income_categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT;