Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.7.4
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1
- -- Generation Time: 25.01.2018 klo 23:21
- -- Palvelimen versio: 10.1.26-MariaDB
- -- PHP Version: 7.1.9
- 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: `lopputyo`
- --
- -- --------------------------------------------------------
- --
- -- Rakenne taululle `users`
- --
- CREATE TABLE `users` (
- `id` INT(11) NOT NULL,
- `kayttajatunnus` VARCHAR(300) DEFAULT NULL,
- `salasana` VARCHAR(300) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Vedos taulusta `users`
- --
- INSERT INTO `users` (`id`, `kayttajatunnus`, `salasana`) VALUES
- (1, 'testi', 'f1e1c6ea766397606475ab41d7f124258da887b9');
- -- --------------------------------------------------------
- --
- -- Rakenne taululle `vieraskirja`
- --
- CREATE TABLE `vieraskirja` (
- `id` INT(11) NOT NULL,
- `kayttajatunnus` VARCHAR(255) NOT NULL,
- `viesti` text NOT NULL,
- `aika` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Vedos taulusta `vieraskirja`
- --
- INSERT INTO `vieraskirja` (`id`, `kayttajatunnus`, `viesti`, `aika`) VALUES
- (12, 'kirsi', 'moikka mä kävin täällä', '2017-12-29 20:52:43'),
- (13, 'testi', 'niin mäkin', '2017-12-29 20:53:10'),
- (15, 'mikko', 'Moikka kaikille!', '2018-01-08 11:31:11'),
- (17, 'testi', 'haippatihei.....', '2018-01-25 22:12:52');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `users`
- --
- ALTER TABLE `users`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `vieraskirja`
- --
- ALTER TABLE `vieraskirja`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `users`
- --
- ALTER TABLE `users`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `vieraskirja`
- --
- ALTER TABLE `vieraskirja`
- MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
- 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