X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fcreate_pg.sql;h=41cd7cc2511d7da70b72dbe9ffc45646b19b52e8;hb=04f496715d73dda64a64c424bb830d80fc592817;hp=c0a38058841abcb1f461ad5052389ded685f0999;hpb=201e8e36d3cc17a3ec704c0da074942c97b919fe;p=mir.git

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index c0a38058..41cd7cc2 100755
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -152,17 +152,16 @@ CREATE TABLE "img_color" (
 	"name" character varying(30) NOT NULL
 );
 
---
--- TOC Entry ID 18 (OID 20063)
---
--- Name: language Type: TABLE Owner: postgres
---
 
+-- language
+
+CREATE SEQUENCE "language_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
+
 CREATE TABLE "language" (
-	"id" integer NOT NULL,
-	"name" character varying(40) NOT NULL,
-	"code" character varying(2) NOT NULL,
-	Constraint "language_pkey" Primary Key ("id")
+	"id" integer DEFAULT nextval('language_id_seq') NOT NULL,
+  "name" character varying(40) NOT NULL,
+  "code" character varying(2) NOT NULL,
+  Constraint "language_pkey" Primary Key ("id")
 );
 
 --
@@ -219,16 +218,15 @@ CREATE TABLE "content_x_topic" (
 	"topic_id" integer NOT NULL
 );
 
---
--- TOC Entry ID 23 (OID 20172)
---
--- Name: article_type Type: TABLE Owner: postgres
---
+-- article type
 
+CREATE SEQUENCE "article_type_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
+
 CREATE TABLE "article_type" (
-	"id" integer NOT NULL,
-	"name" character varying(20) NOT NULL
-);
+	"id" integer DEFAULT nextval('article_type_id_seq') NOT NULL,
+	"name" character varying(40) NOT NULL,
+	CONSTRAINT "article_type_pkey" PRIMARY KEY ("id")
+);
 
 --
 -- TOC Entry ID 24 (OID 20183)
@@ -268,6 +266,7 @@ CREATE TABLE "comment" (
 	"to_media" integer NOT NULL,
 	"to_comment_status" smallint,
 	"checksum" integer,
+	"is_html" boolean DEFAULT '0' NOT NULL,
 	Constraint "comment_pkey" Primary Key ("id")
 );
 
@@ -385,16 +384,17 @@ CREATE TABLE "messages" (
 	"webdb_create" timestamp with time zone NOT NULL
 );
 
---
--- TOC Entry ID 32 (OID 20577)
---
--- Name: comment_status Type: TABLE Owner: postgres
---
 
+-- comment_status
+
+CREATE SEQUENCE "comment_status_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
+
 CREATE TABLE "comment_status" (
-	"id" smallint NOT NULL,
-	"name" character varying(40) NOT NULL
+  "id" integer DEFAULT nextval('comment_status_id_seq') NOT NULL,
+  "name" character varying(40) NOT NULL,
+  CONSTRAINT "comment_status_pkey" PRIMARY KEY ("id")
 );
+
 
 --
 -- TOC Entry ID 33 (OID 20588)
@@ -695,4 +695,5 @@ CREATE  INDEX "idx_content_is_published" on "content" using btree ( "is_publishe
 
 CREATE  INDEX "idx_comment_tomedia_ispublished" on "comment" using btree ( "to_media" "int4_ops", "is_published" "bool_ops" );
 
+CREATE UNIQUE INDEX "idx_comment_id" on "comment" using btree ( "id" "int4_ops" );