Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.3.13
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Jun 03, 2015 at 08:47 PM
- -- Server version: 5.5.40-0+wheezy1
- -- PHP Version: 5.4.36-0+deb7u1
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Database: `cronjobs`
- --
- CREATE DATABASE IF NOT EXISTS `cronjobs` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
- USE `cronjobs`;
- -- --------------------------------------------------------
- --
- -- Table structure for table `jobs`
- --
- CREATE TABLE IF NOT EXISTS `jobs` (
- `id` INT(5) NOT NULL COMMENT 'identificator',
- `show_name` VARCHAR(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'name',
- `station_name` VARCHAR(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'radio station name',
- `address` VARCHAR(120) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'stream address',
- `date_added` VARCHAR(14) COLLATE utf8_unicode_ci DEFAULT NULL,
- `start_date` VARCHAR(14) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'stream start date',
- `end_date` VARCHAR(14) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'stream end date',
- `save_path` VARCHAR(120) COLLATE utf8_unicode_ci DEFAULT NULL,
- `ripper` VARCHAR(35) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'ripper name'
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Scheduled jobs';
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `jobs`
- --
- ALTER TABLE `jobs`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `jobs`
- --
- ALTER TABLE `jobs`
- MODIFY `id` INT(5) NOT NULL AUTO_INCREMENT COMMENT 'identificator',AUTO_INCREMENT=8;
- SELECT * FROM jobs WHERE id = '$get_id'
- UPDATE jobs SET station_name = '$station_name', show_name = '$show_name', address = '$address', save_path = '$save_path', ripper = '$ripper', start_date = '$start_date', end_date = '$end_date' WHERE id = '$get_id'
- SELECT * FROM jobs WHERE address = '$address' AND start_date = '$start_date' AND end_date = '$end_date'
- INSERT INTO jobs (station_name, show_name, address, save_path, ripper, added, start_date, end_date) VALUES ('$station_name', '$show_name', '$address', '$save_path', '$ripper', '$date_added', '$start_date', '$end_date')
- DELETE FROM jobs WHERE id = '$get_id'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement