Changeset 165 for trunk/sql/mvblog.sql

Timestamp:

06/15/06 21:01:07 (3 years ago)

Author:

michiel

Message:

prepare for 1.7
update default sql file to the latest database schema

Files:

• trunk/sql/mvblog.sql (modified) (3 diffs)

trunk/sql/mvblog.sql

@@ -48 +48 @@
 );
 
+CREATE TABLE blog_users (
+    id serial NOT NULL,
+    username character varying(255),
+    "password" character varying(255),
+    realname character varying(255),
+    email character varying(255),
+    website character varying(255),
+    regcode character varying(255),
+    active smallint DEFAULT 0
+);
 
 --
@@ -83 +93 @@
     ping_sent smallint,
     tb_uri character varying(255),
-    aside smallint DEFAULT 0
+    aside smallint DEFAULT 0,
+    allowanoncomments smallint DEFAULT 0
 );
 
@@ -307 +318 @@
     ADD CONSTRAINT authors_pkey PRIMARY KEY (id);
 
+ALTER TABLE ONLY blog_users
+    ADD CONSTRAINT blog_users_id_pkey PRIMARY KEY (id);
 
 --