Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- CREATE TABLE `expected_services` (
- `id` INT(255) NOT NULL,
- `cli` VARCHAR(999) NOT NULL,
- `supplier` VARCHAR(999) NOT NULL,
- `service` VARCHAR(999) NOT NULL,
- `cost` VARCHAR(999) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- CREATE TABLE `ignore_services` (
- `id` INT(255) NOT NULL,
- `cli` VARCHAR(999) NOT NULL,
- `supplier` VARCHAR(999) NOT NULL,
- `service` VARCHAR(999) NOT NULL,
- `cost` VARCHAR(999) NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- CREATE TABLE `monthly_services` (
- `id` INT(255) NOT NULL,
- `upload_date` VARCHAR(999) NOT NULL,
- `cli` VARCHAR(999) NOT NULL,
- `supplier` VARCHAR(999) NOT NULL,
- `service` VARCHAR(999) NOT NULL,
- `cost` VARCHAR(999) NOT NULL,
- `date` VARCHAR(999) NOT NULL,
- `hidden` VARCHAR(999) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- CREATE TABLE `related_services` (
- `id` INT(255) NOT NULL,
- `cli` VARCHAR(999) NOT NULL,
- `supplier` VARCHAR(999) NOT NULL,
- `service` VARCHAR(999) NOT NULL,
- `service_sell` VARCHAR(999) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- ALTER TABLE `expected_services`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `ignore_services`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `monthly_services`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `related_services`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `expected_services`
- MODIFY `id` INT(255) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `ignore_services`
- MODIFY `id` INT(255) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `monthly_services`
- MODIFY `id` INT(255) NOT NULL AUTO_INCREMENT;
- ALTER TABLE `related_services`
- MODIFY `id` INT(255) NOT NULL AUTO_INCREMENT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement