From 5f41936b00f5a3df3254720d1539471937849d50 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Wed, 25 Oct 2017 17:22:03 +0100 Subject: [PATCH] share/db/sys.sql --- share/db/sys.sql | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/share/db/sys.sql b/share/db/sys.sql index 39c0f99a..0e707c12 100644 --- a/share/db/sys.sql +++ b/share/db/sys.sql @@ -5,8 +5,7 @@ DROP TABLE IF EXISTS service; -- NB 25.10.17 PRIMARY KEY (port,name) -- NB 25.10.17 ); ---DROP TABLE IF EXISTS service_port; -DROP TABLE IF EXISTS service_port; +-- NB 25.10.17 DROP TABLE IF EXISTS service_port; DROP TABLE IF EXISTS port; CREATE TABLE IF NOT EXISTS port ( port INT, @@ -16,7 +15,7 @@ CREATE TABLE IF NOT EXISTS port ( FOREIGN KEY(name) REFERENCES service(name) ); ---DROP TABLE IF EXISTS http_status; +-- DROP TABLE IF EXISTS http_status; CREATE TABLE IF NOT EXISTS http_status ( id int PRIMARY KEY, name varchar(100), @@ -29,7 +28,7 @@ CREATE TABLE shell_function ( code BLOB ); -DROP TABLE IF EXISTS ovh_dedicated; +-- NB 25.10.17 DROP TABLE IF EXISTS ovh_dedicated; -- NB 25.10.17 CREATE TABLE ovh_dedicated ( -- NB 25.10.17 offer VARCHAR(80), -- NB 25.10.17 proc VARCHAR(150), -- 2.47.3