File: SQL.sql

CREATE DATABASE IF NOT EXISTS seo_example;
USE seo_example;

CREATE TABLE IF NOT EXISTS `articles` (
  `article_id` int(11) NOT NULL auto_increment,
  `title` varchar(500) character set utf8 NOT NULL,
  `article` text character set utf8 NOT NULL,
  `link` varchar(600) character set utf8 NOT NULL,
  PRIMARY KEY  (`article_id`),
  KEY `link` (`link`)
);

INSERT INTO `articles` (`article_id`, `title`, `article`, `link`) VALUES
(1, 'çğü._eğş08ÀØñ', 'blablabla blab lbal balb la', 'cgu-_egs08aqn'),
(2, 'i See dead peoPle', 'i see bla bla bla blab bla', ''),
(3, 'çğü._eğş08ÀØñ', 'test test test 123 blab bla bla', 'cgu-_egs08aqn-1');