Changeset 401 for trunk/app/config/sql/karamelo_postgres.sql

Timestamp:

04/16/08 03:07:25 (9 months ago)

Author:

aarkerio

Message:

Comment on new

Files:

• trunk/app/config/sql/karamelo_postgres.sql (modified) (3 diffs)

trunk/app/config/sql/karamelo_postgres.sql

@@ -139 +139 @@
 3, 1, 1);
 
--- Discutions on news
-CREATE TABLE commentnews (
- id serial PRIMARY KEY,
- new_id int NOT NULL REFERENCES news(id) ON DELETE CASCADE,
- name varchar(100),
- comment text NOT NULL,
+-- Discussions on portal news
+CREATE TABLE discussions (
+ "id" serial PRIMARY KEY,
+ "new_id" int NOT NULL REFERENCES news(id) ON DELETE CASCADE,
+ "name" varchar(100),
+ "comment" text NOT NULL,
  "created" timestamp(0) with time zone DEFAULT now() NOT NULL,
- level int NOT NULL,
- comentnew_id int NOT NULL,
- user_id int REFERENCES news(id) NOT NULL,
- status int NOT NULL DEFAULT 0
+ "level" int NOT NULL,
+ "discussion_id" int NOT NULL,
+ "user_id" int REFERENCES news(id) NOT NULL,
+ "status" int NOT NULL DEFAULT 0
 );
 
@@ -163 +163 @@
 INSERT INTO licenses (title) VALUES ('CopyRigth License');
 
---Edis (Educative elements)
-CREATE TABLE edis (
- id serial PRIMARY KEY,
- title varchar(150) NOT NULL,
- tags varchar(150) NOT NULL,
- description text,
- status smallint NOT NULL DEFAULT 0,
- created timestamp(0) with time zone DEFAULT now() NOT NULL,
- modified timestamp(0) with time zone DEFAULT now() NOT NULL,
- license_id integer NOT NULL REFERENCES licenses(id) ON DELETE CASCADE,
- user_id integer NOT NULL REFERENCES users(id) ON DELETE CASCADE
-);
-
 -- ** Forums tables beggins **
-CREATE TABLE catforums (  -- phorums categories
+CREATE TABLE catforums (  -- forums categories
  id serial PRIMARY KEY,
  title varchar(150) NOT NULL,
@@ -183 +170 @@
  created timestamp(0) with time zone DEFAULT now() NOT NULL,
  user_id integer NOT NULL REFERENCES users(id) ON DELETE CASCADE,
- status int NOT NULL DEFAULT 0 -- Activated = 1,  Deactivated=0
+ status int NOT NULL DEFAULT 0 -- Enabled = 1,  Disabled = 0
 );