namibia
70bc99896b9aaaa4e6eb3f875f7443896f85d758
namibia / data / old_b4c stuff / owners.sql
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
-- phpMyAdmin SQL Dump -- version 3.5.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 05, 2013 at 06:50 PM -- Server version: 5.1.63-community -- PHP Version: 5.4.11 SET FOREIGN_KEY_CHECKS=0; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `mig_db` -- -- -------------------------------------------------------- -- -- Table structure for table `company_owner` -- DROP TABLE IF EXISTS `company_owner`; CREATE TABLE IF NOT EXISTS `company_owner` ( `id` int(11) NOT NULL AUTO_INCREMENT, `company_id` int(11) DEFAULT NULL, `first_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `family_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `id_number` varchar(13) COLLATE utf8_unicode_ci NOT NULL, `created` datetime NOT NULL, `updated` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_88914419979B1AD6` (`company_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ; -- -- Constraints for dumped tables -- -- -- Constraints for table `company_owner` -- ALTER TABLE `company_owner` ADD CONSTRAINT `FK_88914419979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`); SET FOREIGN_KEY_CHECKS=1; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
Commits for namibia/data/old_b4c stuff/owners.sql
Revision | Author | Commited | Message |
---|---|---|---|
df0489 ... | Mark | Fri 14 Oct, 2016 10:01:00 +0000 | initial commit |