Posted By

Balamir on 04/29/10


Tagged


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

dantreacy


DB Sample


 / Published in: MySQL
 

  1. -- Table: ce_mak
  2.  
  3. -- DROP TABLE IF EXISTS `ce_mak`;
  4.  
  5. CREATE TABLE `ce_mak` (
  6. `Mak_ID` INT(10) AUTO_INCREMENT NOT NULL,
  7. `Mak_Baslik` LONGTEXT,
  8. `Mak_KulID` INT(10),
  9. /* Keys */
  10. PRIMARY KEY (`Mak_ID`)
  11. ) ENGINE = MyISAM
  12. CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
  13.  
  14. INSERT INTO `ce_mak` (`Mak_ID`, `Mak_Baslik`, `Mak_KulID`) VALUES (1, 'Deneme', 93);
  15. INSERT INTO `ce_mak` (`Mak_ID`, `Mak_Baslik`, `Mak_KulID`) VALUES (2, 'Deneme1', 75);
  16. INSERT INTO `ce_mak` (`Mak_ID`, `Mak_Baslik`, `Mak_KulID`) VALUES (3, 'Deneme2', 75);
  17. INSERT INTO `ce_mak` (`Mak_ID`, `Mak_Baslik`, `Mak_KulID`) VALUES (3, 'Deneme2', 85);
  18.  
  19.  
  20. -- Table: ce_yaz
  21.  
  22. -- DROP TABLE IF EXISTS `ce_yaz`;
  23.  
  24. CREATE TABLE `ce_yaz` (
  25. `Yaz_ID` INT(10) AUTO_INCREMENT NOT NULL,
  26. `Yaz_Isim` LONGTEXT,
  27. /* Keys */
  28. PRIMARY KEY (`Yaz_ID`)
  29. ) ENGINE = MyISAM
  30. CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
  31.  
  32. INSERT INTO `ce_yaz` (`Yaz_ID`, `Yaz_Isim`) VALUES (85, 'Ali');
  33. INSERT INTO `ce_yaz` (`Yaz_ID`, `Yaz_Isim`) VALUES (2, 'Veli');
  34. INSERT INTO `ce_yaz` (`Yaz_ID`, `Yaz_Isim`) VALUES (3, 'Ahmet');
  35. INSERT INTO `ce_yaz` (`Yaz_ID`, `Yaz_Isim`) VALUES (4, 'Mehmet');
  36.  
  37.  
  38. -- Table: ce_uye
  39.  
  40. -- DROP TABLE IF EXISTS `ce_uye`;
  41.  
  42. CREATE TABLE `ce_uye` (
  43. `Uye_ID` INT(10) AUTO_INCREMENT NOT NULL,
  44. `Uye_Isim` LONGTEXT,
  45. /* Keys */
  46. PRIMARY KEY (`Uye_ID`)
  47. ) ENGINE = MyISAM
  48. CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
  49.  
  50. INSERT INTO `ce_uye` (`Uye_ID`, `Uye_Isim`) VALUES (93, 'Cetin');
  51. INSERT INTO `ce_uye` (`Uye_ID`, `Uye_Isim`) VALUES (75, 'Metin');
  52. INSERT INTO `ce_uye` (`Uye_ID`, `Uye_Isim`) VALUES (3, 'Ekin');
  53. INSERT INTO `ce_uye` (`Uye_ID`, `Uye_Isim`) VALUES (4, 'Gulin');

Report this snippet  

You need to login to post a comment.