File: pdt.sql

package info (click to toggle)
openser 1.1.0-9etch1
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 9,828 kB
  • ctags: 11,809
  • sloc: ansic: 120,528; sh: 5,249; yacc: 1,716; makefile: 1,261; php: 656; perl: 205; sql: 190
file content (16 lines) | stat: -rw-r--r-- 277 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
-- SQL script for PDT module

DROP DATABASE IF EXISTS pdt;

CREATE DATABASE pdt;

USE pdt;

-- create table
CREATE TABLE pd_multidomain (
	sdomain VARCHAR(255) NOT NULL,
	prefix VARCHAR(32) NOT NULL,
	domain VARCHAR(255) NOT NULL DEFAULT "",
	PRIMARY KEY (sdomain, prefix)
);