Changeset 665 for trunk/app/config

Timestamp:

07/22/08 12:58:53 (4 months ago)

Author:

aarkerio

Message:

Update general

Location:

trunk/app/config/sql/postgresql

Files:

• entries.sql (modified) (1 diff)
• news.sql (modified) (2 diffs)

trunk/app/config/sql/postgresql/entries.sql

@@ -4 +4 @@
 title varchar(50) NOT NULL,
 body text NOT NULL,
-subject_id int REFERENCES subjects (id) ON DELETE CASCADE,
+subject_id int REFERENCES subjects(id) NOT NULL,
 created timestamp(0) with time zone DEFAULT now() NOT NULL,
 status int NOT NULL DEFAULT 0,

trunk/app/config/sql/postgresql/news.sql

@@ -6 +6 @@
   created timestamp(0) with time zone DEFAULT now() NOT NULL,
   reference varchar(350),
-  theme_id int NOT NULL REFERENCES themes(id) ON DELETE CASCADE,
+  theme_id int NOT NULL REFERENCES themes(id),
   status smallint NOT NULL,   -- 0 = draft, 1 = published
   user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
@@ -14 +14 @@
 
 INSERT INTO news ("title", "body", "reference", "theme_id", "status", "user_id") VALUES ('Welcome to Karamelo!', 
-'<p>The Maya site may have bee.</p><p>The city was first mentioned by Juan DiezThe site is of moderate size, with construction of modest sized buildings.</p>', 
+'<p>Karamelo is a cool eLearning platform.</p><p>Please follow the <a href="http://www.chipotle-software.com/">Admin</a> manual to publish news and events.</p>', 
 'http://www.chipotle-software.com/',
 3, 1, 1);