[Cs-cms-commits] SF.net SVN: cs-cms:[13] trunk/0.1

[<cra...@us...>]

Revision: 13
          http://cs-cms.svn.sourceforge.net/cs-cms/?rev=13&view=rev
Author:   crazedsanity
Date:     2009-02-23 17:36:31 +0000 (Mon, 23 Feb 2009)

Log Message:
-----------
Far too complicated... I'll make my own or find a simpler one somewhere else.

Modified Paths:
--------------
    trunk/0.1/schema/pgsql.schema.sql

Removed Paths:
-------------
    trunk/0.1/gacl/

Modified: trunk/0.1/schema/pgsql.schema.sql
===================================================================
--- trunk/0.1/schema/pgsql.schema.sql	2009-02-23 17:33:37 UTC (rev 12)
+++ trunk/0.1/schema/pgsql.schema.sql	2009-02-23 17:36:31 UTC (rev 13)
@@ -1,90 +1,61 @@
 
 --begin;
 
-CREATE TABLE cs_authentication_table (
-	uid serial NOT NULL PRIMARY KEY,
-	username text NOT NULL UNIQUE,
-	passwd varchar(32),
+CREATE TABLE cms_user_id_table (
+	user_id serial NOT NULL PRIMARY KEY,
+	display_name text NOT NULL,
+	email text NOT NULL,
 	is_active boolean DEFAULT true NOT NULL,
-	date_created date DEFAULT CURRENT_TIMESTAMP NOT NULL,
-	last_login timestamp with time zone,
-	email text
+	date_created date DEFAULT CURRENT_TIMESTAMP NOT NULL
 );
-CREATE TABLE csblog_location_table (
-	location_id serial NOT NULL PRIMARY KEY,
-	location text NOT NULL UNIQUE
-);
-create table csblog_blog_table (
-	blog_id serial NOT NULL PRIMARY KEY,
-	uid integer NOT NULL REFERENCES cs_authentication_table(uid),
-	blog_name text NOT NULL,
-	blog_display_name text NOT NULL,
-	--blog_location text NOT NULL,
-	location_id integer NOT NULL REFERENCES csblog_location_table(location_id),
-	is_active boolean NOT NULL DEFAULT true,
-	last_post_timestamp timestamp without time zone
-);
 
-CREATE TABLE csblog_access_table (
-	access_id serial NOT NULL PRIMARY KEY,
-	blog_id integer NOT NULL REFERENCES csblog_blog_table(blog_id),
-	uid integer NOT NULL REFERENCES cs_authentication_table(uid)
+CREATE TABLE cms_status_table (
+	status_id serial NOT NULL PRIMARY KEY,
+	description text NOT NULL,
+	page_is_active boolean NOT NULL,
+	page_is_visible_anonymous boolean NOT NULL
 );
-CREATE TABLE csblog_entry_table (
-	entry_id serial NOT NULL PRIMARY KEY,
-	blog_id integer NOT NULL REFERENCES csblog_blog_table(blog_id),
-	author_uid integer NOT NULL REFERENCES cs_authentication_table(uid),
+
+CREATE TABLE cms_page_table (
+	page_name text NOT NULL PRIMARY KEY,
+	owner_user_id integer NOT NULL REFERENCES cms_user_table(user_id),
 	create_date timestamp NOT NULL DEFAULT NOW(),
 	content text NOT NULL,
 	post_timestamp timestamp NOT NULL DEFAULT NOW(),
-	permalink text NOT NULL,
 	title text NOT NULL,
-	is_draft boolean NOT NULL DEFAULT false
+	status_id integer NOT NULL REFERENCES cms_status_table(status_id)
 );
-CREATE UNIQUE INDEX csblog_entry_table_permalink_blog_id_uidx ON csblog_entry_table USING btree (permalink,blog_id);
 
 
-CREATE TABLE cs_session_table (
-	session_id character varying(32) NOT NULL PRIMARY KEY,
-	uid integer NOT NULL REFERENCES cs_authentication_table(uid),
-	create_date timestamp NOT NULL,
-	last_checkin timestamp,
-	num_checkins  integer NOT NULL DEFAULT 0,
-	ip varchar(15) NOT NULL
-);
 
+
+
+
+------------------------------------
+--  PERMISSIONS STUFF
 --
--- Table for storing basic permissions.
---
-CREATE TABLE csblog_permission_table (
+--  NOTE: the default is DENY, so users are denied unless something specifically gives them access. 
+--  NOTE2: I intended to use PHPGACL for this... 
+------------------------------------
+
+
+
+
+
+CREATE TABLE cms_permission_table (
 	permission_id serial NOT NULL PRIMARY KEY,
-	blog_id integer NOT NULL REFERENCES csblog_blog_table(blog_id),
-	uid integer NOT NULL REFERENCES cs_authentication_table(uid)
+	name varchar(32) NOT NULL UNIQUE,
+	description text NOT NULL
 );
 
---
--- Table for holding comments.
--- NOTE: even though the author is required (i.e. they must be logged-in), "is_anonymous" is set to make it appear as though it were anonymous.
--- NOTE2: "ancestry" is for denoting how a comment is linked to other comments.  "10:12:15" indicates it's immediate parent is 15, grandparent 
---		is 12, and thread origin is 10 (all numbers pertain to comment_id's). 
---
-CREATE TABLE csblog_comment_table (
-	comment_id serial NOT NULL PRIMARY KEY,
-	entry_id int NOT NULL REFERENCES csblog_entry_table(entry_id),
-	author_uid int NOT NULL REFERENCES cs_authentication_table(uid),
-	is_anonymous boolean NOT NULL DEFAULT false,
-	create_timestamp timestamp NOT NULL DEFAULT NOW(),
-	ancestry text,
-	title text NOT NULL,
-	comment text NOT NULL
-);
 
 
+-- Table that defines groups.
+CREATE TABLE cms_group_table (
+	group_id serial NOT NULL PRIMARY KEY,
+	name varchar(32) NOT NULL UNIQUE,
+	description text NOT NULL
+);
 
--- Add entries for users.
---NOTE: password for "test" is "test".
-INSERT INTO cs_authentication_table (username, passwd) VALUES('test','a0d987ef6826c00ff6e4ac0851ea4744');
 
--- SET NEXT UID TO BE > 100...
-select setval('cs_authentication_table_uid_seq',100);
---abort;
+


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.