Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.8.5
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1
- -- Generation Time: Oct 21, 2019 at 04:15 PM
- -- Server version: 10.1.40-MariaDB
- -- PHP Version: 7.3.5
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Database: `code`
- --
- CREATE DATABASE IF NOT EXISTS `code` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
- USE `code`;
- -- --------------------------------------------------------
- --
- -- Table structure for table `drzava`
- --
- DROP TABLE IF EXISTS `drzava`;
- CREATE TABLE `drzava` (
- `id_drzave` int(11) NOT NULL,
- `naziv_drzave` varchar(50) NOT NULL,
- `glavni_grad` varchar(50) NOT NULL,
- `broj_stanovnika` int(11) NOT NULL,
- `povrsina` decimal(10,2) NOT NULL,
- `zastava` varchar(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `drzava`
- --
- INSERT INTO `drzava` (`id_drzave`, `naziv_drzave`, `glavni_grad`, `broj_stanovnika`, `povrsina`, `zastava`) VALUES
- (15, 'Srbija', 'Beograd', 68888, '74000.00', ''),
- (18, 'Rumunija', 'Bukurest', 20000, '350000.00', ''),
- (26, 'Australija', 'Kambera', 25000000, '3000000.00', ''),
- (42, 'Makedonija', 'Skoplje', 2000000, '21000.00', 'okokret.jpg'),
- (43, 'Slovenija', 'Ljubljana', 1024, '23000.00', 'zasekciju.PNG');
- -- --------------------------------------------------------
- --
- -- Table structure for table `korisnici`
- --
- DROP TABLE IF EXISTS `korisnici`;
- CREATE TABLE `korisnici` (
- `id` int(11) NOT NULL,
- `ime` varchar(30) NOT NULL,
- `prezime` varchar(30) NOT NULL,
- `email` varchar(55) NOT NULL,
- `dat_reg` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `privilegija` varchar(30) NOT NULL,
- `sifra` varchar(128) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `korisnici`
- --
- INSERT INTO `korisnici` (`id`, `ime`, `prezime`, `email`, `dat_reg`, `privilegija`, `sifra`) VALUES
- (4, 'Nemanja', 'Vidic', 'nemanja@vidic.rs', '2019-10-11 16:42:10', 'korisnik', 'nemanja1'),
- (5, 'user', 'user1', 'user@mail.com', '2019-10-11 17:14:19', 'korisnik', 'b95b9809110b1af5b987a0ed702b0b54b9c930c9'),
- (6, 'predrag', 'mijatovic', 'pedja@ptt.yu', '2019-10-11 17:29:30', 'korisnik', '547d28992fb22121a664318564b701b96d022d13'),
- (7, 'ljubinko', 'drulovic', 'ljube@ptt.rs', '2019-10-14 15:44:43', 'korisnik', 'd3d3820571f1dc6d14d682ad7648b7f5b4f7110d'),
- (8, 'admin', 'admin', 'admin@admin.admin', '2019-10-14 16:31:27', 'admin', 'e6dc425c27e80ce347e8e8ab73a43b3f22e1cddf'),
- (9, 'fsadf', 'fasdf', 'fdsafa@efdas', '2019-10-15 16:25:29', 'korisnik', 'a2ac11ec472d1741141a8eb62a1857479e2c0e77'),
- (10, 'fsadf', 'fasdf', 'fdsafa@efdas', '2019-10-15 16:26:21', 'korisnik', '84e3242a83a068166958faff4c9cbc6f936fefcb');
- -- --------------------------------------------------------
- --
- -- Table structure for table `marka`
- --
- DROP TABLE IF EXISTS `marka`;
- CREATE TABLE `marka` (
- `id_marke` int(11) NOT NULL,
- `naziv_marke` varchar(40) NOT NULL,
- `id_zemlje_porekla` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `marka`
- --
- INSERT INTO `marka` (`id_marke`, `naziv_marke`, `id_zemlje_porekla`) VALUES
- (1, 'MB', 18),
- (2, 'Nisan', 15);
- -- --------------------------------------------------------
- --
- -- Table structure for table `model`
- --
- DROP TABLE IF EXISTS `model`;
- CREATE TABLE `model` (
- `id_modela` int(11) NOT NULL,
- `id_marke` int(11) NOT NULL,
- `naziv_modela` varchar(50) NOT NULL,
- `godiste` smallint(4) NOT NULL,
- `snaga` int(11) NOT NULL,
- `cena` decimal(10,2) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `model`
- --
- INSERT INTO `model` (`id_modela`, `id_marke`, `naziv_modela`, `godiste`, `snaga`, `cena`) VALUES
- (1, 1, 'cls', 2001, 136, '2000.00'),
- (2, 2, 'skyline', 2002, 100, '3600.00');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `drzava`
- --
- ALTER TABLE `drzava`
- ADD PRIMARY KEY (`id_drzave`);
- --
- -- Indexes for table `korisnici`
- --
- ALTER TABLE `korisnici`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `marka`
- --
- ALTER TABLE `marka`
- ADD PRIMARY KEY (`id_marke`),
- ADD KEY `id_zemlje_porekla` (`id_zemlje_porekla`);
- --
- -- Indexes for table `model`
- --
- ALTER TABLE `model`
- ADD PRIMARY KEY (`id_modela`),
- ADD KEY `id_marke` (`id_marke`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `drzava`
- --
- ALTER TABLE `drzava`
- MODIFY `id_drzave` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
- --
- -- AUTO_INCREMENT for table `korisnici`
- --
- ALTER TABLE `korisnici`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
- --
- -- AUTO_INCREMENT for table `marka`
- --
- ALTER TABLE `marka`
- MODIFY `id_marke` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
- --
- -- AUTO_INCREMENT for table `model`
- --
- ALTER TABLE `model`
- MODIFY `id_modela` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `marka`
- --
- ALTER TABLE `marka`
- ADD CONSTRAINT `marka_ibfk_1` FOREIGN KEY (`id_zemlje_porekla`) REFERENCES `drzava` (`id_drzave`);
- --
- -- Constraints for table `model`
- --
- ALTER TABLE `model`
- ADD CONSTRAINT `model_ibfk_1` FOREIGN KEY (`id_marke`) REFERENCES `marka` (`id_marke`);
- COMMIT;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement