· 7 years ago · Sep 04, 2018, 11:28 AM
1CREATE TABLE IF NOT EXISTS `guests` (
2 `guests_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3 `guest_id` int(11) unsigned NOT NULL,
4 `club_id` int(11) NOT NULL,
5 PRIMARY KEY (`guests_id`),
6 KEY `guest_id` (`guest_id`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
8
9--
10-- Zrzut danych tabeli `guests`
11--
12
13INSERT INTO `guests` (`guests_id`, `guest_id`, `club_id`) VALUES
14(1, 1, 4),
15(2, 1, 3),
16(3, 1, 3);