Changeset 665 for trunk/app/config/sql/postgresql/news.sql

Timestamp:

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

Author:

aarkerio

Message:

Update general

Files:

• trunk/app/config/sql/postgresql/news.sql (modified) (2 diffs)

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);