· 6 years ago · Sep 04, 2019, 02:56 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Aug 10, 2019 at 02:15 PM
7-- Server version: 10.1.37-MariaDB
8-- PHP Version: 7.3.1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `bic_db`
23--
24CREATE DATABASE IF NOT EXISTS bic_db;
25USE bic_db;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `accountability`
31--
32
33CREATE TABLE `accountability` (
34 `AccountibilityID` int(11) NOT NULL,
35 `FirmName` varchar(255) DEFAULT NULL,
36 `ContactName` varchar(255) DEFAULT NULL,
37 `Telephone` varchar(255) DEFAULT NULL,
38 `Email` varchar(255) DEFAULT NULL,
39 `PhysicalAddress` varchar(255) DEFAULT NULL,
40 `PostalAddress` varchar(255) DEFAULT NULL,
41 `BusinessID` int(11) DEFAULT NULL
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `application`
48--
49
50CREATE TABLE `application` (
51 `ApplicationID` int(11) NOT NULL,
52 `IDDocuments` varchar(10000) DEFAULT NULL,
53 `BEECertificate` varchar(1000) DEFAULT NULL,
54 `BusinessAgreement` varchar(1000) DEFAULT NULL,
55 `BusinessPlan` varchar(1000) DEFAULT NULL,
56 `MarketingPlan` varchar(1000) DEFAULT NULL,
57 `RegistrationCertificate` varchar(1000) DEFAULT NULL,
58 `VATCertificate` varchar(1000) DEFAULT NULL,
59 `SARSCertificate` varchar(1000) DEFAULT NULL,
60 `FinancialStatement` varchar(1000) DEFAULT NULL,
61 `BankStatement` varchar(10000) DEFAULT NULL,
62 `EmployeeTaxRegistration` varchar(1000) DEFAULT NULL,
63 `UIFCertificate` varchar(1000) DEFAULT NULL,
64 `COIDRegistration` varchar(1000) DEFAULT NULL,
65 `WaterAccount` varchar(1000) DEFAULT NULL,
66 `ElectricityAccount` varchar(1000) DEFAULT NULL,
67 `RatesandTaxes` varchar(1000) DEFAULT NULL,
68 `BusinessID` int(11) DEFAULT NULL
69) ENGINE=InnoDB DEFAULT CHARSET=latin1;
70
71-- --------------------------------------------------------
72
73--
74-- Table structure for table `audit`
75--
76
77CREATE TABLE `audit` (
78 `AuditID` int(11) NOT NULL,
79 `Audited` varchar(3) DEFAULT NULL,
80 `NoAuditReason` varchar(255) DEFAULT NULL,
81 `ContactName` varchar(255) DEFAULT NULL,
82 `Telephone` varchar(255) DEFAULT NULL,
83 `PhysicalAddress` varchar(255) DEFAULT NULL,
84 `PostalAddress` varchar(255) DEFAULT NULL,
85 `BusinessID` int(11) DEFAULT NULL
86) ENGINE=InnoDB DEFAULT CHARSET=latin1;
87
88-- --------------------------------------------------------
89
90--
91-- Table structure for table `banking`
92--
93
94CREATE TABLE `banking` (
95 `BankingID` int(11) NOT NULL,
96 `Active` varchar(3) DEFAULT NULL,
97 `OpenDate` date DEFAULT NULL,
98 `AccountHolderName` varchar(255) DEFAULT NULL,
99 `BankName` varchar(255) DEFAULT NULL,
100 `AccountNumber` varchar(255) DEFAULT NULL,
101 `AccountType` varchar(255) DEFAULT NULL,
102 `BranchName` varchar(255) DEFAULT NULL,
103 `BranchCode` varchar(255) DEFAULT NULL,
104 `BankProof` varchar(1000) DEFAULT NULL,
105 `BusinessID` int(11) DEFAULT NULL
106) ENGINE=InnoDB DEFAULT CHARSET=latin1;
107
108-- --------------------------------------------------------
109
110--
111-- Table structure for table `beneficiary`
112--
113
114CREATE TABLE `beneficiary` (
115 `BeneficiaryID` int(11) NOT NULL,
116 `TotalEmployedFull` int(11) DEFAULT NULL,
117 `MenFullTime` int(11) DEFAULT NULL,
118 `WomenFullTime` int(11) DEFAULT NULL,
119 `YouthFullTime` int(11) DEFAULT NULL,
120 `SeniorFullTime` int(11) DEFAULT NULL,
121 `DisabledFullTime` int(11) DEFAULT NULL,
122 `TotalEmployedPartTime` int(11) DEFAULT NULL,
123 `MenPartTime` int(11) DEFAULT NULL,
124 `WomenPartTime` int(11) DEFAULT NULL,
125 `YouthPartTime` int(11) DEFAULT NULL,
126 `SeniorPartTime` int(11) DEFAULT NULL,
127 `DisabledPartTime` int(11) DEFAULT NULL,
128 `BusinessID` int(11) DEFAULT NULL
129) ENGINE=InnoDB DEFAULT CHARSET=latin1;
130
131-- --------------------------------------------------------
132
133--
134-- Table structure for table `business`
135--
136
137CREATE TABLE `business` (
138 `BusinessID` int(11) NOT NULL,
139 `TradeName` varchar(255) DEFAULT NULL,
140 `RegisteredName` varchar(255) DEFAULT NULL,
141 `RegistrationDate` date DEFAULT NULL,
142 `RegistrationNumber` varchar(255) DEFAULT NULL,
143 `Sector` varchar(255) DEFAULT NULL,
144 `IncomeTaxNumber` varchar(255) DEFAULT NULL,
145 `VATNumber` varchar(255) DEFAULT NULL,
146 `Province` varchar(255) DEFAULT NULL,
147 `Town` varchar(255) DEFAULT NULL,
148 `Municipality` varchar(255) DEFAULT NULL,
149 `Objectives` varchar(1000) DEFAULT NULL,
150 `ProductService` varchar(255) DEFAULT NULL,
151 `OperationArea` varchar(255) DEFAULT NULL,
152 `BusinessDays` varchar(255) DEFAULT NULL,
153 `OpenHours` varchar(255) DEFAULT NULL,
154 `ClosedHours` varchar(255) DEFAULT NULL,
155 `AssetDescription` varchar(1000) DEFAULT NULL,
156 `AssetValue` decimal(10,0) DEFAULT NULL,
157 `PhysicalAddress` varchar(255) DEFAULT NULL,
158 `PostalCode` int(11) DEFAULT NULL,
159 `PostalAddress` varchar(255) DEFAULT NULL,
160 `PostalAddressCode` int(11) DEFAULT NULL,
161 `Telephone` varchar(255) DEFAULT NULL,
162 `LegalStatus` varchar(255) DEFAULT NULL,
163 `BusinessDescription` varchar(1000) DEFAULT NULL,
164 `PrimaryTargetMarket` varchar(255) DEFAULT NULL,
165 `SecondaryTargetMarket` varchar(255) DEFAULT NULL,
166 `Evaluated` varchar(1000) DEFAULT NULL,
167 `OwnerPhoto` varchar(1000) DEFAULT NULL,
168 `ManagementPhoto` varchar(1000) DEFAULT NULL,
169 `EmployeePhoto` varchar(1000) DEFAULT NULL
170) ENGINE=InnoDB DEFAULT CHARSET=latin1;
171
172--
173-- Dumping data for table `business`
174--
175
176INSERT INTO `business` (`BusinessID`, `TradeName`, `RegisteredName`, `RegistrationDate`, `RegistrationNumber`, `Sector`, `IncomeTaxNumber`, `VATNumber`, `Province`, `Town`, `Municipality`, `Objectives`, `ProductService`, `OperationArea`, `BusinessDays`, `OpenHours`, `ClosedHours`, `AssetDescription`, `AssetValue`, `PhysicalAddress`, `PostalCode`, `PostalAddress`, `PostalAddressCode`, `Telephone`, `LegalStatus`, `BusinessDescription`, `PrimaryTargetMarket`, `SecondaryTargetMarket`, `Evaluated`, `OwnerPhoto`, `ManagementPhoto`, `EmployeePhoto`) VALUES
177(8, 'Trade T Name', 'Reg Name for Biz', '1956-08-09', '0477843667', 'Agriculture', NULL, NULL, 'Eastern Cape', 'Umtata', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
178
179-- --------------------------------------------------------
180
181--
182-- Table structure for table `contactperson`
183--
184
185CREATE TABLE `contactperson` (
186 `UserID` int(11) NOT NULL,
187 `Cell` varchar(20) DEFAULT NULL,
188 `CompetitionExposure` varchar(255) DEFAULT NULL,
189 `Position` varchar(255) DEFAULT NULL,
190 `Gender` varchar(255) DEFAULT NULL,
191 `Diet` varchar(255) DEFAULT NULL,
192 `Disability` varchar(255) DEFAULT NULL,
193 `ClosestTransport` varchar(255) DEFAULT NULL,
194 `BusinessID` int(11) DEFAULT NULL
195) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196
197-- --------------------------------------------------------
198
199--
200-- Table structure for table `feasibility`
201--
202
203CREATE TABLE `feasibility` (
204 `FeasibilityID` int(11) NOT NULL,
205 `YearsOperational` int(11) DEFAULT NULL,
206 `FeasibilityPlan` varchar(1000) DEFAULT NULL,
207 `AveEmployeeSalary` decimal(10,0) DEFAULT NULL,
208 `AveManagementSalary` decimal(10,0) DEFAULT NULL,
209 `Strength` varchar(1000) DEFAULT NULL,
210 `Weakness` varchar(1000) DEFAULT NULL,
211 `Opportunities` varchar(1000) DEFAULT NULL,
212 `Threats` varchar(1000) DEFAULT NULL,
213 `JobsIn3Months` int(11) DEFAULT NULL,
214 `JobsIn6Months` int(11) DEFAULT NULL,
215 `JobsIn12Months` int(11) DEFAULT NULL,
216 `ImprovementMotivationWinner` varchar(3000) DEFAULT NULL,
217 `ImprovementMotivationRunner` varchar(3000) DEFAULT NULL,
218 `BusinessID` int(11) DEFAULT NULL
219) ENGINE=InnoDB DEFAULT CHARSET=latin1;
220
221-- --------------------------------------------------------
222
223--
224-- Table structure for table `funding`
225--
226
227CREATE TABLE `funding` (
228 `FundingID` int(11) NOT NULL,
229 `ReceivedEskomGrant` varchar(3) DEFAULT NULL,
230 `FundedDate` date DEFAULT NULL,
231 `Amount` decimal(10,0) DEFAULT NULL,
232 `FundReason` varchar(1000) DEFAULT NULL,
233 `ReceivedOtherFunding` varchar(3) DEFAULT NULL,
234 `FunderName` varchar(255) DEFAULT NULL,
235 `Type` varchar(255) DEFAULT NULL,
236 `AmountFromOther` decimal(10,0) DEFAULT NULL,
237 `BusinessID` int(11) DEFAULT NULL
238) ENGINE=InnoDB DEFAULT CHARSET=latin1;
239
240-- --------------------------------------------------------
241
242--
243-- Table structure for table `infrastructure`
244--
245
246CREATE TABLE `infrastructure` (
247 `InfrastructureID` int(11) NOT NULL,
248 `Rooms` decimal(10,0) DEFAULT NULL,
249 `PremisesSize` decimal(10,0) DEFAULT NULL,
250 `Facilities` varchar(1000) DEFAULT NULL,
251 `ExteriorPhoto` varchar(1000) DEFAULT NULL,
252 `InteriorPhoto` varchar(1000) DEFAULT NULL,
253 `EquipmentPhoto` varchar(1000) DEFAULT NULL,
254 `ProductServicePhoto` varchar(1000) DEFAULT NULL,
255 `Ownership` varchar(255) DEFAULT NULL,
256 `MonthlyAmount` decimal(10,0) DEFAULT NULL,
257 `RatesTaxes` decimal(10,0) DEFAULT NULL,
258 `WaterCost` decimal(10,0) DEFAULT NULL,
259 `ElectricityCost` decimal(10,0) DEFAULT NULL,
260 `ElectricityType` varchar(255) DEFAULT NULL,
261 `ElectricityPhase` varchar(255) DEFAULT NULL,
262 `ElectricitySupplier` varchar(255) DEFAULT NULL,
263 `ClosestOffice` varchar(255) DEFAULT NULL,
264 `CompanyAccountNumber` varchar(255) DEFAULT NULL,
265 `BusinessID` int(11) DEFAULT NULL
266) ENGINE=InnoDB DEFAULT CHARSET=latin1;
267
268-- --------------------------------------------------------
269
270--
271-- Table structure for table `management`
272--
273
274CREATE TABLE `management` (
275 `ManagementID` int(11) NOT NULL,
276 `Qualifications` varchar(1000) DEFAULT NULL,
277 `IDNumber` varchar(255) DEFAULT NULL
278) ENGINE=InnoDB DEFAULT CHARSET=latin1;
279
280-- --------------------------------------------------------
281
282--
283-- Table structure for table `propertyowner`
284--
285
286CREATE TABLE `propertyowner` (
287 `PropertyOwnerID` int(11) NOT NULL,
288 `Name` varchar(255) DEFAULT NULL,
289 `Telephone` varchar(255) DEFAULT NULL,
290 `LeaseContract` varchar(1000) DEFAULT NULL,
291 `BusinessID` int(11) DEFAULT NULL
292) ENGINE=InnoDB DEFAULT CHARSET=latin1;
293
294-- --------------------------------------------------------
295
296--
297-- Table structure for table `sales`
298--
299
300CREATE TABLE `sales` (
301 `SalesID` int(11) NOT NULL,
302 `MonthlyIncomeSales` decimal(10,0) DEFAULT NULL,
303 `SalesExpenses` decimal(10,0) DEFAULT NULL,
304 `SalesTotal` decimal(10,0) DEFAULT NULL,
305 `ProductionCosts` decimal(10,0) DEFAULT NULL,
306 `Profits` decimal(10,0) NOT NULL,
307 `BusinessID` int(11) NOT NULL
308) ENGINE=InnoDB DEFAULT CHARSET=latin1;
309
310-- --------------------------------------------------------
311
312--
313-- Table structure for table `shareholder`
314--
315
316CREATE TABLE `shareholder` (
317 `ShareholderID` int(11) NOT NULL,
318 `IDNumber` varchar(255) DEFAULT NULL,
319 `SharePercentage` decimal(10,0) DEFAULT NULL,
320 `Qualifications` varchar(1000) DEFAULT NULL,
321 `StakeholderID` int(11) DEFAULT NULL
322) ENGINE=InnoDB DEFAULT CHARSET=latin1;
323
324-- --------------------------------------------------------
325
326--
327-- Table structure for table `signatories`
328--
329
330CREATE TABLE `signatories` (
331 `SignatoryID` int(11) NOT NULL,
332 `Name` varchar(255) DEFAULT NULL,
333 `Surname` varchar(255) DEFAULT NULL,
334 `BankingID` int(11) DEFAULT NULL
335) ENGINE=InnoDB DEFAULT CHARSET=latin1;
336
337-- --------------------------------------------------------
338
339--
340-- Table structure for table `staff`
341--
342
343CREATE TABLE `staff` (
344 `StaffID` int(11) NOT NULL,
345 `Initials` varchar(255) NOT NULL
346) ENGINE=InnoDB DEFAULT CHARSET=latin1;
347
348-- --------------------------------------------------------
349
350--
351-- Table structure for table `stakeholder`
352--
353
354CREATE TABLE `stakeholder` (
355 `StakeholderID` int(11) NOT NULL,
356 `Name` varchar(255) DEFAULT NULL,
357 `Surname` varchar(255) DEFAULT NULL,
358 `Position` varchar(255) DEFAULT NULL,
359 `Title` varchar(255) DEFAULT NULL,
360 `FormalSkills` varchar(1000) DEFAULT NULL,
361 `StakeholderType` varchar(255) DEFAULT NULL,
362 `BusinessID` int(11) DEFAULT NULL
363) ENGINE=InnoDB DEFAULT CHARSET=latin1;
364
365-- --------------------------------------------------------
366
367--
368-- Table structure for table `targetmarket`
369--
370
371CREATE TABLE `targetmarket` (
372 `MarketID` int(11) NOT NULL,
373 `NeedsMet` varchar(1000) DEFAULT NULL,
374 `KeyCustomers` varchar(255) DEFAULT NULL,
375 `MarketStrategy` varchar(1000) DEFAULT NULL,
376 `PotentialCustomers` varchar(255) DEFAULT NULL,
377 `Competition` varchar(255) DEFAULT NULL,
378 `UniqueProposition` varchar(255) DEFAULT NULL,
379 `MaterialsDescription` varchar(1000) DEFAULT NULL,
380 `AuthoritySupport` varchar(3) DEFAULT NULL,
381 `AuthorityName` varchar(255) DEFAULT NULL,
382 `AuthorityPerson` varchar(255) DEFAULT NULL,
383 `ContactNo` varchar(255) DEFAULT NULL,
384 `BusinessID` int(11) DEFAULT NULL
385) ENGINE=InnoDB DEFAULT CHARSET=latin1;
386
387-- --------------------------------------------------------
388
389--
390-- Table structure for table `undertaking`
391--
392
393CREATE TABLE `undertaking` (
394 `UndertakingID` int(11) NOT NULL,
395 `InitialsSurname` varchar(255) DEFAULT NULL,
396 `Designation` varchar(255) DEFAULT NULL,
397 `DATE` varchar(255) DEFAULT NULL,
398 `BusinessID` int(11) DEFAULT NULL
399) ENGINE=InnoDB DEFAULT CHARSET=latin1;
400
401-- --------------------------------------------------------
402
403--
404-- Table structure for table `user`
405--
406
407CREATE TABLE `user` (
408 `UserID` int(11) NOT NULL,
409 `Title` varchar(255) DEFAULT NULL,
410 `FirstName` varchar(255) DEFAULT NULL,
411 `Surname` varchar(255) DEFAULT NULL,
412 `Email` varchar(255) DEFAULT NULL,
413 `Usertype` int(11) DEFAULT NULL,
414 `Password` varchar(255) DEFAULT NULL,
415 `inActive` int(11) NOT NULL DEFAULT '1',
416 `isDeleted` int(11) NOT NULL DEFAULT '1'
417) ENGINE=InnoDB DEFAULT CHARSET=latin1;
418
419-- --------------------------------------------------------
420
421--
422-- Table structure for table `usertype`
423--
424
425CREATE TABLE `usertype` (
426 `type_id` int(11) NOT NULL,
427 `type` varchar(25) NOT NULL
428) ENGINE=InnoDB DEFAULT CHARSET=latin1;
429
430--
431-- Dumping data for table `usertype`
432--
433
434INSERT INTO `usertype` (`type_id`, `type`) VALUES
435(1, 'admin'),
436(2, 'judge'),
437(3, 'competitor');
438
439--
440-- Indexes for dumped tables
441--
442
443--
444-- Indexes for table `accountability`
445--
446ALTER TABLE `accountability`
447 ADD PRIMARY KEY (`AccountibilityID`),
448 ADD KEY `BusinessID` (`BusinessID`);
449
450--
451-- Indexes for table `application`
452--
453ALTER TABLE `application`
454 ADD PRIMARY KEY (`ApplicationID`),
455 ADD KEY `BusinessID` (`BusinessID`);
456
457--
458-- Indexes for table `audit`
459--
460ALTER TABLE `audit`
461 ADD PRIMARY KEY (`AuditID`),
462 ADD KEY `BusinessID` (`BusinessID`);
463
464--
465-- Indexes for table `banking`
466--
467ALTER TABLE `banking`
468 ADD PRIMARY KEY (`BankingID`),
469 ADD KEY `BusinessID` (`BusinessID`);
470
471--
472-- Indexes for table `beneficiary`
473--
474ALTER TABLE `beneficiary`
475 ADD PRIMARY KEY (`BeneficiaryID`),
476 ADD KEY `BusinessID` (`BusinessID`);
477
478--
479-- Indexes for table `business`
480--
481ALTER TABLE `business`
482 ADD PRIMARY KEY (`BusinessID`),
483 ADD UNIQUE KEY `TradeName` (`TradeName`),
484 ADD UNIQUE KEY `RegisteredName` (`RegisteredName`);
485
486--
487-- Indexes for table `contactperson`
488--
489ALTER TABLE `contactperson`
490 ADD PRIMARY KEY (`UserID`),
491 ADD KEY `BusinessID` (`BusinessID`);
492
493--
494-- Indexes for table `feasibility`
495--
496ALTER TABLE `feasibility`
497 ADD PRIMARY KEY (`FeasibilityID`),
498 ADD KEY `BusinessID` (`BusinessID`);
499
500--
501-- Indexes for table `funding`
502--
503ALTER TABLE `funding`
504 ADD PRIMARY KEY (`FundingID`),
505 ADD KEY `BusinessID` (`BusinessID`);
506
507--
508-- Indexes for table `infrastructure`
509--
510ALTER TABLE `infrastructure`
511 ADD PRIMARY KEY (`InfrastructureID`),
512 ADD KEY `BusinessID` (`BusinessID`);
513
514--
515-- Indexes for table `management`
516--
517ALTER TABLE `management`
518 ADD PRIMARY KEY (`ManagementID`);
519
520--
521-- Indexes for table `propertyowner`
522--
523ALTER TABLE `propertyowner`
524 ADD PRIMARY KEY (`PropertyOwnerID`),
525 ADD KEY `BusinessID` (`BusinessID`);
526
527--
528-- Indexes for table `sales`
529--
530ALTER TABLE `sales`
531 ADD PRIMARY KEY (`SalesID`),
532 ADD KEY `BusinessID` (`BusinessID`);
533
534--
535-- Indexes for table `shareholder`
536--
537ALTER TABLE `shareholder`
538 ADD PRIMARY KEY (`ShareholderID`),
539 ADD KEY `StakeholderID` (`StakeholderID`);
540
541--
542-- Indexes for table `signatories`
543--
544ALTER TABLE `signatories`
545 ADD PRIMARY KEY (`SignatoryID`),
546 ADD KEY `BankingID` (`BankingID`);
547
548--
549-- Indexes for table `staff`
550--
551ALTER TABLE `staff`
552 ADD PRIMARY KEY (`StaffID`);
553
554--
555-- Indexes for table `stakeholder`
556--
557ALTER TABLE `stakeholder`
558 ADD PRIMARY KEY (`StakeholderID`),
559 ADD KEY `BusinessID` (`BusinessID`);
560
561--
562-- Indexes for table `targetmarket`
563--
564ALTER TABLE `targetmarket`
565 ADD PRIMARY KEY (`MarketID`),
566 ADD KEY `BusinessID` (`BusinessID`);
567
568--
569-- Indexes for table `undertaking`
570--
571ALTER TABLE `undertaking`
572 ADD PRIMARY KEY (`UndertakingID`),
573 ADD KEY `BusinessID` (`BusinessID`);
574
575--
576-- Indexes for table `user`
577--
578ALTER TABLE `user`
579 ADD PRIMARY KEY (`UserID`),
580 ADD KEY `Usertype` (`Usertype`);
581
582--
583-- Indexes for table `usertype`
584--
585ALTER TABLE `usertype`
586 ADD PRIMARY KEY (`type_id`),
587 ADD KEY `type_id` (`type_id`);
588
589--
590-- AUTO_INCREMENT for dumped tables
591--
592
593--
594-- AUTO_INCREMENT for table `accountability`
595--
596ALTER TABLE `accountability`
597 MODIFY `AccountibilityID` int(11) NOT NULL AUTO_INCREMENT;
598
599--
600-- AUTO_INCREMENT for table `application`
601--
602ALTER TABLE `application`
603 MODIFY `ApplicationID` int(11) NOT NULL AUTO_INCREMENT;
604
605--
606-- AUTO_INCREMENT for table `audit`
607--
608ALTER TABLE `audit`
609 MODIFY `AuditID` int(11) NOT NULL AUTO_INCREMENT;
610
611--
612-- AUTO_INCREMENT for table `banking`
613--
614ALTER TABLE `banking`
615 MODIFY `BankingID` int(11) NOT NULL AUTO_INCREMENT;
616
617--
618-- AUTO_INCREMENT for table `beneficiary`
619--
620ALTER TABLE `beneficiary`
621 MODIFY `BeneficiaryID` int(11) NOT NULL AUTO_INCREMENT;
622
623--
624-- AUTO_INCREMENT for table `business`
625--
626ALTER TABLE `business`
627 MODIFY `BusinessID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
628
629--
630-- AUTO_INCREMENT for table `feasibility`
631--
632ALTER TABLE `feasibility`
633 MODIFY `FeasibilityID` int(11) NOT NULL AUTO_INCREMENT;
634
635--
636-- AUTO_INCREMENT for table `funding`
637--
638ALTER TABLE `funding`
639 MODIFY `FundingID` int(11) NOT NULL AUTO_INCREMENT;
640
641--
642-- AUTO_INCREMENT for table `infrastructure`
643--
644ALTER TABLE `infrastructure`
645 MODIFY `InfrastructureID` int(11) NOT NULL AUTO_INCREMENT;
646
647--
648-- AUTO_INCREMENT for table `propertyowner`
649--
650ALTER TABLE `propertyowner`
651 MODIFY `PropertyOwnerID` int(11) NOT NULL AUTO_INCREMENT;
652
653--
654-- AUTO_INCREMENT for table `sales`
655--
656ALTER TABLE `sales`
657 MODIFY `SalesID` int(11) NOT NULL AUTO_INCREMENT;
658
659--
660-- AUTO_INCREMENT for table `signatories`
661--
662ALTER TABLE `signatories`
663 MODIFY `SignatoryID` int(11) NOT NULL AUTO_INCREMENT;
664
665--
666-- AUTO_INCREMENT for table `stakeholder`
667--
668ALTER TABLE `stakeholder`
669 MODIFY `StakeholderID` int(11) NOT NULL AUTO_INCREMENT;
670
671--
672-- AUTO_INCREMENT for table `targetmarket`
673--
674ALTER TABLE `targetmarket`
675 MODIFY `MarketID` int(11) NOT NULL AUTO_INCREMENT;
676
677--
678-- AUTO_INCREMENT for table `undertaking`
679--
680ALTER TABLE `undertaking`
681 MODIFY `UndertakingID` int(11) NOT NULL AUTO_INCREMENT;
682
683--
684-- AUTO_INCREMENT for table `user`
685--
686ALTER TABLE `user`
687 MODIFY `UserID` int(11) NOT NULL AUTO_INCREMENT;
688
689--
690-- Constraints for dumped tables
691--
692
693--
694-- Constraints for table `accountability`
695--
696ALTER TABLE `accountability`
697 ADD CONSTRAINT `accountability_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
698
699--
700-- Constraints for table `application`
701--
702ALTER TABLE `application`
703 ADD CONSTRAINT `application_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
704
705--
706-- Constraints for table `audit`
707--
708ALTER TABLE `audit`
709 ADD CONSTRAINT `audit_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
710
711--
712-- Constraints for table `banking`
713--
714ALTER TABLE `banking`
715 ADD CONSTRAINT `banking_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
716
717--
718-- Constraints for table `beneficiary`
719--
720ALTER TABLE `beneficiary`
721 ADD CONSTRAINT `beneficiary_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
722
723--
724-- Constraints for table `contactperson`
725--
726ALTER TABLE `contactperson`
727 ADD CONSTRAINT `contactperson_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `user` (`UserID`),
728 ADD CONSTRAINT `contactperson_ibfk_2` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
729
730--
731-- Constraints for table `feasibility`
732--
733ALTER TABLE `feasibility`
734 ADD CONSTRAINT `feasibility_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
735
736--
737-- Constraints for table `funding`
738--
739ALTER TABLE `funding`
740 ADD CONSTRAINT `funding_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
741
742--
743-- Constraints for table `infrastructure`
744--
745ALTER TABLE `infrastructure`
746 ADD CONSTRAINT `infrastructure_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
747
748--
749-- Constraints for table `management`
750--
751ALTER TABLE `management`
752 ADD CONSTRAINT `management_ibfk_1` FOREIGN KEY (`ManagementID`) REFERENCES `stakeholder` (`StakeholderID`);
753
754--
755-- Constraints for table `propertyowner`
756--
757ALTER TABLE `propertyowner`
758 ADD CONSTRAINT `propertyowner_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
759
760--
761-- Constraints for table `sales`
762--
763ALTER TABLE `sales`
764 ADD CONSTRAINT `sales_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
765
766--
767-- Constraints for table `shareholder`
768--
769ALTER TABLE `shareholder`
770 ADD CONSTRAINT `shareholder_ibfk_1` FOREIGN KEY (`StakeholderID`) REFERENCES `stakeholder` (`StakeholderID`);
771
772--
773-- Constraints for table `signatories`
774--
775ALTER TABLE `signatories`
776 ADD CONSTRAINT `signatories_ibfk_1` FOREIGN KEY (`BankingID`) REFERENCES `banking` (`BankingID`);
777
778--
779-- Constraints for table `staff`
780--
781ALTER TABLE `staff`
782 ADD CONSTRAINT `staff_ibfk_1` FOREIGN KEY (`StaffID`) REFERENCES `stakeholder` (`StakeholderID`);
783
784--
785-- Constraints for table `stakeholder`
786--
787ALTER TABLE `stakeholder`
788 ADD CONSTRAINT `stakeholder_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
789
790--
791-- Constraints for table `targetmarket`
792--
793ALTER TABLE `targetmarket`
794 ADD CONSTRAINT `targetmarket_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
795
796--
797-- Constraints for table `undertaking`
798--
799ALTER TABLE `undertaking`
800 ADD CONSTRAINT `undertaking_ibfk_1` FOREIGN KEY (`BusinessID`) REFERENCES `business` (`BusinessID`);
801
802--
803-- Constraints for table `user`
804--
805ALTER TABLE `user`
806 ADD CONSTRAINT `user_ibfk_1` FOREIGN KEY (`Usertype`) REFERENCES `usertype` (`type_id`);
807COMMIT;
808
809/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
810/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
811/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;