Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add SQL Structure #3

Open
frommMoritz opened this issue Jan 22, 2020 · 1 comment
Open

Add SQL Structure #3

frommMoritz opened this issue Jan 22, 2020 · 1 comment

Comments

@frommMoritz
Copy link
Contributor

frommMoritz commented Jan 22, 2020

It would be nice to have an database.sql containing and structural dump of the Table used in writeToDatabase.php.

@frommMoritz
Copy link
Contributor Author

I've created a table that seems to be working. @f2k1de would you mind to check that real quick, then I'd create a PR with it.

-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 27, 2020 at 09:29 AM
-- Server version: 10.1.41-MariaDB-0+deb9u1
-- PHP Version: 7.3.12-1+0~20191128.49+debian9~1.gbp24559b

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Database: `blahaj`
--

-- --------------------------------------------------------

--
-- Table structure for table `sharks`
--

CREATE TABLE `sharks` (
  `id` int(11) NOT NULL,
  `markt` int(4) NOT NULL,
  `date` datetime NOT NULL,
  `number` int(11) NOT NULL,
  `size` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `sharks`
--
ALTER TABLE `sharks`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `sharks`
--
ALTER TABLE `sharks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant