NE8wpn5s

1CREATE TABLE IF NOT EXISTS testimonials(
2`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
3`first` VARCHAR(30) NOT NULL,
4`last` VARCHAR(30) NOT NULL,
5`email` VARCHAR(50) NOT NULL,
6`testimonial` TEXT NOT NULL,
7`order` INT(5) DEFAULT 0,
8`image` VARCHAR(100) DEFAULT "",
9`post` VARCHAR(50) DEFAULT "",
10`approved` TINYINT DEFAULT 0,
11`website` VARCHAR(100) DEFAULT "",
12`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
13);
14
15CREATE TABLE IF NOT EXISTS `press_releases` (
16`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
17`title` VARCHAR(255) NOT NULL,
18`snippet`TEXT NOT NULL,
19`content` TEXT NOT NULL,
20`sef_url` VARCHAR(255) NOT NULL,
21`date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
22`twitter` VARCHAR(100) DEFAULT "",
23`facebook` VARCHAR(100) DEFAULT "",
24UNIQUE (`sef_url`)
25);
26
27CREATE TABLE IF NOT EXISTS `media_coverage` (
28`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
29`title` VARCHAR(255) NOT NULL,
30`url` VARCHAR(255) NOT NULL,
31`icon` VARCHAR(255) NOT NULL
32);