/ Published in: MySQL
Expand |
Embed | Plain Text
-- Table: ce_mak -- DROP TABLE IF EXISTS `ce_mak`; CREATE TABLE `ce_mak` ( `Mak_ID` INT(10) AUTO_INCREMENT NOT NULL, `Mak_Baslik` LONGTEXT, `Mak_KulID` INT(10), /* Keys */ PRIMARY KEY (`Mak_ID`) ) ENGINE = MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`; INSERT INTO `ce_mak` (`Mak_ID`, `Mak_Baslik`, `Mak_KulID`) VALUES (1, 'Deneme', 93); INSERT INTO `ce_mak` (`Mak_ID`, `Mak_Baslik`, `Mak_KulID`) VALUES (2, 'Deneme1', 75); INSERT INTO `ce_mak` (`Mak_ID`, `Mak_Baslik`, `Mak_KulID`) VALUES (3, 'Deneme2', 75); INSERT INTO `ce_mak` (`Mak_ID`, `Mak_Baslik`, `Mak_KulID`) VALUES (3, 'Deneme2', 85); -- Table: ce_yaz -- DROP TABLE IF EXISTS `ce_yaz`; CREATE TABLE `ce_yaz` ( `Yaz_ID` INT(10) AUTO_INCREMENT NOT NULL, `Yaz_Isim` LONGTEXT, /* Keys */ PRIMARY KEY (`Yaz_ID`) ) ENGINE = MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`; INSERT INTO `ce_yaz` (`Yaz_ID`, `Yaz_Isim`) VALUES (85, 'Ali'); INSERT INTO `ce_yaz` (`Yaz_ID`, `Yaz_Isim`) VALUES (2, 'Veli'); INSERT INTO `ce_yaz` (`Yaz_ID`, `Yaz_Isim`) VALUES (3, 'Ahmet'); INSERT INTO `ce_yaz` (`Yaz_ID`, `Yaz_Isim`) VALUES (4, 'Mehmet'); -- Table: ce_uye -- DROP TABLE IF EXISTS `ce_uye`; CREATE TABLE `ce_uye` ( `Uye_ID` INT(10) AUTO_INCREMENT NOT NULL, `Uye_Isim` LONGTEXT, /* Keys */ PRIMARY KEY (`Uye_ID`) ) ENGINE = MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`; INSERT INTO `ce_uye` (`Uye_ID`, `Uye_Isim`) VALUES (93, 'Cetin'); INSERT INTO `ce_uye` (`Uye_ID`, `Uye_Isim`) VALUES (75, 'Metin'); INSERT INTO `ce_uye` (`Uye_ID`, `Uye_Isim`) VALUES (3, 'Ekin'); INSERT INTO `ce_uye` (`Uye_ID`, `Uye_Isim`) VALUES (4, 'Gulin');
You need to login to post a comment.
