Changeset 1266 for branches

Timestamp:

02/12/06 22:58:42 (3 years ago)

Author:

spetersen

Message:

PostgreSQL update to dbstruct from chach (Francois)

Files:

• branches/postgresql/dbstruct.pgsql.sql (modified) (4 diffs)

branches/postgresql/dbstruct.pgsql.sql

@@ -17 +17 @@
   position integer NOT NULL default '0',
   mode integer NOT NULL default '1',
+  itemsincache text NULL,
+  daterefreshed timestamp default NULL,
+  refreshinterval integer NOT NULL default '60',
+  etag varchar(255) NULL,
+  lastmodified varchar(255) default NULL,
   PRIMARY KEY  (id)
 );
@@ -59 +64 @@
   pubdate timestamp default NULL,
   author varchar(255) default NULL,
+  md5sum varchar(32) NULL,
+  guid text NULL,
   PRIMARY KEY  (id)
 );
@@ -143 +150 @@
     lastip varchar(255) default NULL,
     lastlogin timestamp NULL,
-    PRIMARY KEY  (uid),
-    KEY (uname)
-);
+    PRIMARY KEY  (uid)
+);
+CREATE UNIQUE INDEX users_uname_u
+ON users (uname);
 
 INSERT INTO  users  (uname,password,ulevel,realname) VALUES ('admin','',99,'Administrator');
@@ -207 +215 @@
 
 CREATE OR REPLACE FUNCTION DATE_SUB(TIMESTAMP WITH TIME ZONE, INTERVAL)
-RETURNS TIMESTAMP WITH TIMEZONE
+RETURNS TIMESTAMP WITH TIME ZONE
 LANGUAGE SQL
 IMMUTABLE STRICT