Login   Register  
PHP Classes
elePHPant
Icontem

File: SQL.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ersin Gven  >  SEO link factory class  >  SQL.sql  >  Download  
File: SQL.sql
Role: Auxiliary data
Content type: text/plain
Description: sql file
Class: SEO link factory class
Retrieve friendly URLs from a database
Author: By
Last change: use seo_example added
Date: 5 years ago
Size: 684 bytes
 

Contents

Class file image Download
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');