Added SQL to create wrreport table.

git-svn-id: http://www.winterrodeln.org/svn/servermediawiki/trunk/extensions/wrreport@320 7aebc617-e5e2-0310-91dc-80fb5f6d2477

diff --git a/wrreport.sql b/wrreport.sql
new file mode 100644 (file)
index 0000000..719849d
--- /dev/null
+++ b/wrreport.sql
@@ -0,0 +1,18 @@
+--- SQL command to create the wrreport table, that is necessary to use the wrreport extension.
+CREATE TABLE wrreport (
+  id serial NOT NULL,
+  page_id integer,
+  page_title character varying(255),
+  date_report date,
+  date_entry timestamp with time zone DEFAULT now(),
+  date_invalid timestamp with time zone DEFAULT (now() + '9 days'::interval),
+  condition integer,
+  description text,
+  author_name character varying(30),
+  author_ip inet,
+  author_userid integer,
+  author_username character varying(30),
+  CONSTRAINT wrreport_pkey PRIMARY KEY (id),
+  CONSTRAINT condition_check CHECK (condition >= 1 AND condition <= 5)
+);
+