[icinga-checkins] icinga.org: icingaweb2/feature/setup-wizard-7163: Drop old schema files

git at icinga.org git at icinga.org
Tue Nov 4 13:53:48 CET 2014


Module: icingaweb2
Branch: feature/setup-wizard-7163
Commit: e463ca836e2dcb0a3838e8f1d8e74ea2b754c803
URL:    https://git.icinga.org/?p=icingaweb2.git;a=commit;h=e463ca836e2dcb0a3838e8f1d8e74ea2b754c803

Author: Johannes Meyer <johannes.meyer at netways.de>
Date:   Tue Nov  4 12:41:17 2014 +0100

Drop old schema files

---

 etc/schema/mysql.sql |   14 --------------
 etc/schema/pgsql.sql |   22 ----------------------
 2 files changed, 36 deletions(-)

diff --git a/etc/schema/mysql.sql b/etc/schema/mysql.sql
deleted file mode 100644
index fcf2780..0000000
--- a/etc/schema/mysql.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-create table account (
-  `username`    varchar(255) COLLATE latin1_general_ci NOT NULL,
-  `salt`        varchar(255) NOT NULL,
-  `password`    varchar(255) NOT NULL,
-  `active`      tinyint(1)   DEFAULT NULL,
-  PRIMARY KEY (`username`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
-create table `preference`(
-  `username`    VARCHAR(255) COLLATE latin1_general_ci NOT NULL,
-  `key`         VARCHAR(100) COLLATE latin1_general_ci NOT NULL,
-  `value`       VARCHAR(255) NOT NULL,
-  PRIMARY KEY (`username`, `key`)
-) ENGINE=InnoDB;
\ No newline at end of file
diff --git a/etc/schema/pgsql.sql b/etc/schema/pgsql.sql
deleted file mode 100644
index f83517d..0000000
--- a/etc/schema/pgsql.sql
+++ /dev/null
@@ -1,22 +0,0 @@
-create table "account" (
-  "username"   character varying(255)  NOT NULL,
-  "salt"       character varying(255),
-  "password"   character varying(255)  NOT NULL,
-  "active"     boolean
-);
-
-ALTER TABLE ONLY "account"
-    ADD CONSTRAINT account_pkey PRIMARY KEY ("username");
-
-CREATE UNIQUE INDEX username_lower_unique_idx ON "account" USING btree (lower((username)::text));
-
-create table "preference"(
-  "username"    VARCHAR(255) NOT NULL,
-  "key"         VARCHAR(100) NOT NULL,
-  "value"       VARCHAR(255) NOT NULL
-);
-
-ALTER TABLE ONLY "preference"
-  ADD CONSTRAINT preference_pkey PRIMARY KEY ("username", "key");
-
-CREATE UNIQUE INDEX username_and_key_lower_unique_idx ON "preference" USING btree (lower((username)::text), lower((key)::text));
\ No newline at end of file



More information about the icinga-checkins mailing list