Improved PostgreSQL compatibility default tip
authorphirox
Sun, 10 Jan 2010 17:35:19 -0500
changeset 5 7977508aeda3
parent 4 58780df3147b
Improved PostgreSQL compatibility
Gorilla.php
--- a/Gorilla.php	Sun Jul 05 00:27:56 2009 -0400
+++ b/Gorilla.php	Sun Jan 10 17:35:19 2010 -0500
@@ -22,8 +22,7 @@
 function gorilla_setupcore(&$paths, &$session)
 {
   // register our paste namespace
-  $nssep = substr($paths->nslist['Special'], -1);
-  $paths->create_namespace('Paste', 'Paste' . $nssep);
+  $paths->create_namespace('Paste', 'Paste:');
   
   // create our ACLs
   /**
@@ -787,6 +786,31 @@
   ));
 }
 
+/**!install dbms="pgsql"; **
+CREATE TABLE pastes (
+    paste_id integer NOT NULL,
+    paste_title text,
+    paste_text text DEFAULT ''::text NOT NULL,
+    paste_author integer DEFAULT 1 NOT NULL,
+    paste_author_name character varying(255) DEFAULT 'Anonymous'::character varying NOT NULL,
+    paste_author_ip character varying(39) NOT NULL,
+    paste_language character varying(32) DEFAULT 'plaintext'::character varying NOT NULL,
+    paste_timestamp integer DEFAULT 0 NOT NULL,
+    paste_ttl integer DEFAULT 86400 NOT NULL,
+    paste_flags integer DEFAULT 0 NOT NULL,
+    paste_parent integer DEFAULT 0 NOT NULL
+);
+CREATE SEQUENCE pastes_paste_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+ALTER SEQUENCE pastes_paste_id_seq OWNED BY pastes.paste_id;
+ALTER TABLE pastes ALTER COLUMN paste_id SET DEFAULT nextval('pastes_paste_id_seq'::regclass);
+ALTER TABLE ONLY pastes ADD CONSTRAINT pastes_pkey PRIMARY KEY (paste_id);
+**!*/
+
 /**!install dbms="mysql"; **
 CREATE TABLE {{TABLE_PREFIX}}pastes(
   paste_id int(18) NOT NULL auto_increment,