Changeset 665 for trunk/app/config/sql/postgresql/news.sql
- Timestamp:
- 07/22/08 12:58:53 (4 months ago)
- Files:
-
- 1 modified
-
trunk/app/config/sql/postgresql/news.sql (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/app/config/sql/postgresql/news.sql
r653 r665 6 6 created timestamp(0) with time zone DEFAULT now() NOT NULL, 7 7 reference varchar(350), 8 theme_id int NOT NULL REFERENCES themes(id) ON DELETE CASCADE,8 theme_id int NOT NULL REFERENCES themes(id), 9 9 status smallint NOT NULL, -- 0 = draft, 1 = published 10 10 user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE, … … 14 14 15 15 INSERT INTO news ("title", "body", "reference", "theme_id", "status", "user_id") VALUES ('Welcome to Karamelo!', 16 '<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>',16 '<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>', 17 17 'http://www.chipotle-software.com/', 18 18 3, 1, 1);
