Silnik strony + galerii zdjęć Suczawa 2009
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

86 lines
3.1 KiB

  1. -- phpMyAdmin SQL Dump
  2. -- version 3.1.3.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Czas wygenerowania: 23 Paź 2009, 22:01
  7. -- Wersja serwera: 5.1.37
  8. -- Wersja PHP: 5.2.10-2.2
  9. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  10. --
  11. -- Baza danych: `galeria`
  12. --
  13. -- --------------------------------------------------------
  14. --
  15. -- Struktura tabeli dla `admins`
  16. --
  17. CREATE TABLE IF NOT EXISTS `admins` (
  18. `id` smallint(1) NOT NULL AUTO_INCREMENT,
  19. `nick` varchar(20) NOT NULL,
  20. `password` varchar(200) NOT NULL,
  21. `email` varchar(20) NOT NULL,
  22. `IP` varchar(80) NOT NULL,
  23. PRIMARY KEY (`id`)
  24. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
  25. --
  26. -- Zrzut danych tabeli `admins`
  27. --
  28. INSERT INTO `admins` (`id`, `nick`, `password`, `email`, `IP`) VALUES
  29. (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'root@localhost', '::ffff:127.0.0.1');
  30. -- --------------------------------------------------------
  31. --
  32. -- Struktura tabeli dla `photos`
  33. --
  34. CREATE TABLE IF NOT EXISTS `photos` (
  35. `id` smallint(4) NOT NULL AUTO_INCREMENT,
  36. `thumb_name` varchar(20) NOT NULL,
  37. `photo_name` varchar(20) NOT NULL,
  38. `author` varchar(30) NOT NULL,
  39. `description` text NOT NULL,
  40. PRIMARY KEY (`id`)
  41. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
  42. --
  43. -- Zrzut danych tabeli `photos`
  44. --
  45. INSERT INTO `photos` (`id`, `thumb_name`, `photo_name`, `author`, `description`) VALUES
  46. (1, 'DSC_0026_m.png', 'DSC_0026.png', '', 'Pod zamkiem - grupowo.'),
  47. (2, 'DSC_0132_m.png', 'DSC_0132.png', '', 'Pod szkołą.'),
  48. (3, 'DSC_0169_m.png', 'DSC_0169.png', '', 'Widoki na Monastyr'),
  49. (4, 'DSC_0294_m.png', 'DSC_0294.png', '', 'Bukowina Południowa'),
  50. (5, 'DSC_0378_m.png', 'DSC_0378.png', '', 'Pani Monika :)'),
  51. (6, 'DSC_0080_m.png', 'DSC_0080.png', '', 'Nasz Geniusz podczas rozdawania nagród'),
  52. (7, 'DSC_0672_m.png', 'DSC_0672.png', '', 'Wąwóz - jakaś góra.'),
  53. (8, 'DSCF0372_m.png', 'DSCF0372.png', '', ''),
  54. (9, 'dsc_0006_m.jpg', 'dsc_0006.jpg', '', 'W pracowni - tam pisaliśmy konkurs.'),
  55. (10, '07062009544_m.jpg', '07062009544.jpg', '', ''),
  56. (11, '07062009548_m.jpg', '07062009548.jpg', '', ''),
  57. (12, '07062009549_m.jpg', '07062009549.jpg', '', ''),
  58. (13, '07062009550_m.jpg', '07062009550.jpg', '', ''),
  59. (14, '07062009553_m.jpg', '07062009553.jpg', '', ''),
  60. (15, '07062009557_m.jpg', '07062009557.jpg', '', ''),
  61. (16, '07062009560_m.jpg', '07062009560.jpg', '', ''),
  62. (17, '07062009561_m.jpg', '07062009561.jpg', '', ''),
  63. (18, '07062009563_m.jpg', '07062009563.jpg', '', ''),
  64. (19, '07062009565_m.jpg', '07062009565.jpg', '', ''),
  65. (20, '07062009566_m.jpg', '07062009566.jpg', '', ''),
  66. (21, '07062009567_m.jpg', '07062009567.jpg', '', ''),
  67. (22, '07062009569_m.jpg', '07062009569.jpg', '', ''),
  68. (23, '07062009570_m.jpg', '07062009570.jpg', '', ''),
  69. (24, '07062009571_m.jpg', '07062009571.jpg', '', ''),
  70. (25, '08062009624_m.jpg', '08062009624.jpg', '', ''),
  71. (26, '08062009625_m.jpg', '08062009625.jpg', '', ''),
  72. (27, '08062009629_m.jpg', '08062009629.jpg', '', ''),
  73. (28, '08062009630_m.jpg', '08062009630.jpg', '', ''),
  74. (29, '08062009632_m.jpg', '08062009632.jpg', '', '');