|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /proc/21573/task/21573/root/home/queenjbs/www/FusionChart/Code/RoR/SampleApp/db/ |
Upload File : |
DROP TABLE IF EXISTS `factory_masters`; CREATE TABLE `factory_masters` ( `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `factory_output_quantities`; CREATE TABLE `factory_output_quantities` ( `id` int(11) unsigned NOT NULL auto_increment, `factory_master_id` int(11) unsigned NOT NULL, `date_pro` datetime default NULL, `quantity` double default NULL, PRIMARY KEY (`id`), KEY `FK_output_master` (`factory_master_id`), CONSTRAINT `FK_output_master` FOREIGN KEY (`factory_master_id`) REFERENCES `factory_masters` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;