wTr01RPp

1php app/console doctrine:mapping:convert yml ./src/Sifo/SchoolBundle/Resources/config/doctrine --from-database --force 
2php app/console doctrine:mapping:import --force SifoSchoolBundle yml
3php app/console doctrine:generate:entities SifoSchoolBundle --force 
4     
5Processing entity "DftAbsensi"
6Processing entity "DftGrup"
7Processing entity "DftGrupMapel"
8Processing entity "DftNilai"
9Processing entity "MstJabatan"
10Processing entity "MstKelas"
11Processing entity "MstKelompok"
12Processing entity "MstMapel"
13Processing entity "MstPegawai"
14Processing entity "MstPelajar"
15Processing entity "MstPeriode"
16Processing entity "MstProgram"
17Processing entity "MstSemester" 
18     
19--
20-- Table structure for table `dft_grup_pelajar`
21--
22
23CREATE TABLE IF NOT EXISTS `dft_grup_pelajar` (
24  `kode_grup` varchar(20) NOT NULL,
25  `kode_pelajar` varchar(20) NOT NULL,
26  `aktif` tinyint(1) NOT NULL DEFAULT '1',
27  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
28  `operator` varchar(20) NOT NULL,
29  PRIMARY KEY (`kode_grup`,`kode_pelajar`),
30  KEY `kode_pelajar` (`kode_pelajar`)
31) ENGINE=InnoDB DEFAULT CHARSET=latin1;
32
33
34--
35-- Constraints for table `dft_grup_pelajar`
36--
37ALTER TABLE `dft_grup_pelajar`
38  ADD CONSTRAINT `dft_grup_pelajar_ibfk_1` FOREIGN KEY (`kode_grup`) REFERENCES `dft_grup` (`kode`) ON UPDATE CASCADE,
39  ADD CONSTRAINT `dft_grup_pelajar_ibfk_2` FOREIGN KEY (`kode_pelajar`) REFERENCES `mst_pelajar` (`kode`) ON UPDATE CASCADE;