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

Problem with create_tables.sql #27

Open
boesiii opened this issue Mar 18, 2016 · 1 comment
Open

Problem with create_tables.sql #27

boesiii opened this issue Mar 18, 2016 · 1 comment

Comments

@boesiii
Copy link

boesiii commented Mar 18, 2016

I am trying to create my table on my Yahoo web host and when I try and run


CREATE TABLE audit (
  modified_by_ip   VARCHAR(39)  NOT NULL DEFAULT '',
  modified_by_user VARCHAR(50)  NOT NULL DEFAULT '',
  modified_when    BIGINT(14)   NOT NULL,
  modified_from    BIGINT(14)   NOT NULL,
  modified_to      BIGINT(14)   NOT NULL,
  modified_why     VARCHAR(250) NOT NULL DEFAULT '',
  user_modified    VARCHAR(50)  NOT NULL DEFAULT '',
  PRIMARY KEY (modified_when),
  UNIQUE KEY modified_when (modified_when)
)
  ENGINE =MyISAM;

I get and error mesage, "Unclosed quote" and #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''',
modified_by_user VARCHAR(50) NOT NULL DEFAULT '',
modified_when ' at line 2

@boelle
Copy link

boelle commented Apr 6, 2016

when i export my empty audit table i get:

-- phpMyAdmin SQL Dump
-- version 4.5.4.1

-- http://www.phpmyadmin.net

-- Host: localhost
-- Generation Time: Apr 06, 2016 at 01:58 PM
-- Server version: 5.6.29
-- PHP Version: 5.6.18

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

-- Database: *********


-- Table structure for table audit

CREATE TABLE audit (
modified_by_ip varchar(39) NOT NULL DEFAULT '',
modified_by_user varchar(50) NOT NULL DEFAULT '',
modified_when bigint(14) NOT NULL,
modified_from bigint(14) NOT NULL,
modified_to bigint(14) NOT NULL,
modified_why varchar(250) NOT NULL DEFAULT '',
user_modified varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Indexes for dumped tables

-- Indexes for table audit

ALTER TABLE audit
ADD PRIMARY KEY (modified_when),
ADD UNIQUE KEY modified_when (modified_when);

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

2 participants