1 -- $Id: database.pgsql 144 2007-03-28 07:52:20Z thierry $
3 -- Do not show NOTICE: messages, it's hard to spot errors.
4 set client_min_messages = 'warning';
7 -- Table structure for access
12 mask varchar(255) NOT NULL default '',
13 type varchar(255) NOT NULL default '',
14 status smallint NOT NULL default '0',
19 -- Table structure for accesslog
22 CREATE TABLE accesslog (
24 sid varchar(32) NOT NULL default '',
25 title varchar(255) default NULL,
26 path text default NULL,
27 url text default NULL,
28 hostname varchar(128) default NULL,
29 uid integer default '0',
30 timer integer NOT NULL default '0',
31 timestamp integer NOT NULL default '0',
34 CREATE INDEX accesslog_timestamp_idx ON accesslog (timestamp);
37 -- Table structure for table 'aggregator_category'
40 CREATE TABLE aggregator_category (
42 title varchar(255) NOT NULL default '',
44 block smallint NOT NULL default '0',
50 -- Table structure for table 'aggregator_category_feed'
53 CREATE TABLE aggregator_category_feed (
54 fid integer NOT NULL default '0',
55 cid integer NOT NULL default '0',
60 -- Table structure for table 'aggregator_category_item'
63 CREATE TABLE aggregator_category_item (
64 iid integer NOT NULL default '0',
65 cid integer NOT NULL default '0',
70 -- Table structure for table 'aggregator_feed'
73 CREATE TABLE aggregator_feed (
75 title varchar(255) NOT NULL default '',
76 url varchar(255) NOT NULL default '',
77 refresh integer NOT NULL default '0',
78 checked integer NOT NULL default '0',
79 link varchar(255) NOT NULL default '',
82 etag varchar(255) NOT NULL default '',
83 modified integer NOT NULL default '0',
84 block smallint NOT NULL default '0',
91 -- Table structure for table 'aggregator_item'
94 CREATE TABLE aggregator_item (
96 fid integer NOT NULL default '0',
97 title varchar(255) NOT NULL default '',
98 link varchar(255) NOT NULL default '',
99 author varchar(255) NOT NULL default '',
101 timestamp integer default NULL,
106 -- Table structure for authmap
109 CREATE TABLE authmap (
111 uid integer NOT NULL default '0',
112 authname varchar(128) NOT NULL default '',
113 module varchar(128) NOT NULL default '',
119 -- Table structure for blocks
122 CREATE TABLE blocks (
123 module varchar(64) NOT NULL default '',
124 delta varchar(32) NOT NULL default '0',
125 theme varchar(255) NOT NULL default '',
126 status smallint NOT NULL default '0',
127 weight smallint NOT NULL default '0',
128 region varchar(64) DEFAULT 'left' NOT NULL,
129 custom smallint NOT NULL default '0',
130 throttle smallint NOT NULL default '0',
131 visibility smallint NOT NULL default '0',
132 pages text NOT NULL default ''
136 -- Table structure for book
140 vid integer NOT NULL default '0',
141 nid integer NOT NULL default '0',
142 parent integer NOT NULL default '0',
143 weight smallint NOT NULL default '0',
146 CREATE INDEX book_nid_idx ON book(nid);
147 CREATE INDEX book_parent_idx ON book(parent);
150 -- Table structure for boxes
155 title varchar(64) NOT NULL default '',
156 body text default '',
157 info varchar(128) NOT NULL default '',
158 format smallint NOT NULL default '0',
164 -- Table structure for cache
168 cid varchar(255) NOT NULL default '',
169 data bytea default '',
170 expire integer NOT NULL default '0',
171 created integer NOT NULL default '0',
172 headers text default '',
175 CREATE INDEX cache_expire_idx ON cache(expire);
178 -- Table structure for comments
181 CREATE TABLE comments (
183 pid integer NOT NULL default '0',
184 nid integer NOT NULL default '0',
185 uid integer NOT NULL default '0',
186 subject varchar(64) NOT NULL default '',
187 comment text NOT NULL default '',
188 hostname varchar(128) NOT NULL default '',
189 timestamp integer NOT NULL default '0',
190 score integer NOT NULL default '0',
191 status smallint NOT NULL default '0',
192 format smallint NOT NULL default '0',
193 thread varchar(255) default '',
194 users text default '',
195 name varchar(60) default NULL,
196 mail varchar(64) default NULL,
197 homepage varchar(255) default NULL,
200 CREATE INDEX comments_nid_idx ON comments(nid);
203 -- Table structre for table 'contact'
206 CREATE TABLE contact (
208 category varchar(255) NOT NULL default '',
209 recipients text NOT NULL default '',
210 reply text NOT NULL default '',
211 weight smallint NOT NULL default '0',
212 selected smallint NOT NULL default '0',
218 -- Table structre for table 'node_comment_statistics'
221 CREATE TABLE node_comment_statistics (
222 nid integer NOT NULL,
223 last_comment_timestamp integer NOT NULL default '0',
224 last_comment_name varchar(60) default NULL,
225 last_comment_uid integer NOT NULL default '0',
226 comment_count integer NOT NULL default '0',
229 CREATE INDEX node_comment_statistics_last_comment_timestamp_idx ON node_comment_statistics(last_comment_timestamp);
232 -- Table structure for directory
235 CREATE TABLE client (
237 link varchar(255) NOT NULL default '',
238 name varchar(128) NOT NULL default '',
239 mail varchar(128) NOT NULL default '',
240 slogan text NOT NULL default '',
241 mission text NOT NULL default '',
242 users integer NOT NULL default '0',
243 nodes integer NOT NULL default '0',
244 version varchar(35) NOT NULL default'',
245 created integer NOT NULL default '0',
246 changed integer NOT NULL default '0',
251 -- Table structure for table 'client_system'
254 CREATE TABLE client_system (
255 cid integer NOT NULL,
256 name varchar(255) NOT NULL default '',
257 type varchar(255) NOT NULL default '',
258 PRIMARY KEY (cid,name)
262 -- Table structure for table 'files'
267 nid integer NOT NULL default 0,
268 filename varchar(255) NOT NULL default '',
269 filepath varchar(255) NOT NULL default '',
270 filemime varchar(255) NOT NULL default '',
271 filesize integer NOT NULL default 0,
276 -- Table structure for table 'file_revisions'
279 CREATE TABLE file_revisions (
280 fid integer NOT NULL default 0,
281 vid integer NOT NULL default 0,
282 description varchar(255) NOT NULL default '',
283 list smallint NOT NULL default 0,
284 PRIMARY KEY (fid, vid)
288 -- Table structure for table 'filter_formats'
291 CREATE TABLE filter_formats (
293 name varchar(255) NOT NULL default '',
294 roles varchar(255) NOT NULL default '',
295 cache smallint NOT NULL default '0',
296 PRIMARY KEY (format),
301 -- Table structure for table 'filters'
304 CREATE TABLE filters (
305 format integer NOT NULL DEFAULT '0',
306 module varchar(64) NOT NULL DEFAULT '',
307 delta smallint NOT NULL DEFAULT 0,
308 weight smallint DEFAULT '0' NOT NULL
310 CREATE INDEX filters_weight_idx ON filters(weight);
313 -- Table structure for table 'flood'
317 event varchar(64) NOT NULL default '',
318 hostname varchar(128) NOT NULL default '',
319 timestamp integer NOT NULL default '0'
323 -- Table structure for table 'forum'
327 nid integer NOT NULL default '0',
328 vid integer NOT NULL default '0',
329 tid integer NOT NULL default '0',
332 CREATE INDEX forum_tid_idx ON forum(tid);
333 CREATE INDEX forum_nid_idx ON forum(nid);
336 -- Table structure for history
339 CREATE TABLE history (
340 uid integer NOT NULL default '0',
341 nid integer NOT NULL default '0',
342 timestamp integer NOT NULL default '0',
343 PRIMARY KEY (uid,nid)
347 -- Table structure for locales_meta
350 CREATE TABLE locales_meta (
351 locale varchar(12) NOT NULL default '',
352 name varchar(64) NOT NULL default '',
353 enabled int4 NOT NULL default '0',
354 isdefault int4 NOT NULL default '0',
355 plurals int4 NOT NULL default '0',
356 formula varchar(128) NOT NULL default '',
361 -- Table structure for locales_source
365 CREATE TABLE locales_source (
367 location varchar(255) NOT NULL default '',
368 source text NOT NULL,
373 -- Table structure for locales_target
376 CREATE TABLE locales_target (
377 lid int4 NOT NULL default '0',
378 translation text DEFAULT '' NOT NULL,
379 locale varchar(12) NOT NULL default '',
380 plid int4 NOT NULL default '0',
381 plural int4 NOT NULL default '0'
383 CREATE INDEX locales_target_lid_idx ON locales_target(lid);
384 CREATE INDEX locales_target_locale_idx ON locales_target(locale);
385 CREATE INDEX locales_target_plid_idx ON locales_target(plid);
386 CREATE INDEX locales_target_plural_idx ON locales_target(plural);
389 -- Table structure for table 'menu'
393 CREATE SEQUENCE menu_mid_seq START 2;
395 mid integer NOT NULL DEFAULT nextval('menu_mid_seq'),
396 pid integer NOT NULL default '0',
397 path varchar(255) NOT NULL default '',
398 title varchar(255) NOT NULL default '',
399 description varchar(255) NOT NULL default '',
400 weight smallint NOT NULL default '0',
401 type smallint NOT NULL default '0',
406 -- Table structure for node
411 vid integer NOT NULL default '0',
412 type varchar(32) NOT NULL default '',
413 title varchar(128) NOT NULL default '',
414 uid integer NOT NULL default '0',
415 status integer NOT NULL default '1',
416 created integer NOT NULL default '0',
417 changed integer NOT NULL default '0',
418 comment integer NOT NULL default '0',
419 promote integer NOT NULL default '0',
420 moderate integer NOT NULL default '0',
421 sticky integer NOT NULL default '0',
422 PRIMARY KEY (nid, vid)
424 CREATE INDEX node_nid_idx ON node(nid);
425 CREATE INDEX node_type_idx ON node(type);
426 CREATE INDEX node_title_type_idx ON node(title,type);
427 CREATE INDEX node_status_idx ON node(status);
428 CREATE INDEX node_uid_idx ON node(uid);
429 CREATE UNIQUE INDEX node_vid_idx ON node(vid);
430 CREATE INDEX node_moderate_idx ON node (moderate);
431 CREATE INDEX node_promote_status_idx ON node (promote, status);
432 CREATE INDEX node_created_idx ON node(created);
433 CREATE INDEX node_changed_idx ON node(changed);
434 CREATE INDEX node_status_type_nid_idx ON node(status,type,nid);
437 -- Table structure for table `node_access`
440 CREATE TABLE node_access (
442 gid integer NOT NULL default '0',
443 realm varchar(255) NOT NULL default '',
444 grant_view smallint NOT NULL default '0',
445 grant_update smallint NOT NULL default '0',
446 grant_delete smallint NOT NULL default '0',
447 PRIMARY KEY (nid,gid,realm)
451 -- Table structure for table 'node_revisions'
454 CREATE TABLE node_revisions (
455 nid integer NOT NULL default '0',
456 vid integer NOT NULL default '0',
457 uid integer NOT NULL default '0',
458 title varchar(128) NOT NULL default '',
459 body text NOT NULL default '',
460 teaser text NOT NULL default '',
461 log text NOT NULL default '',
462 timestamp integer NOT NULL default '0',
463 format int NOT NULL default '0',
466 CREATE INDEX node_revisions_nid_idx ON node_revisions(nid);
467 CREATE INDEX node_revisions_uid_idx ON node_revisions(uid);
468 CREATE SEQUENCE node_revisions_vid_seq INCREMENT 1 START 1;
471 -- Table structure for table 'url_alias'
474 CREATE TABLE profile_fields (
476 title varchar(255) default NULL,
477 name varchar(128) default NULL,
478 explanation TEXT default NULL,
479 category varchar(255) default NULL,
480 page varchar(255) default NULL,
481 type varchar(128) default NULL,
482 weight smallint DEFAULT '0' NOT NULL,
483 required smallint DEFAULT '0' NOT NULL,
484 register smallint DEFAULT '0' NOT NULL,
485 visibility smallint DEFAULT '0' NOT NULL,
486 autocomplete smallint DEFAULT '0' NOT NULL,
491 CREATE INDEX profile_fields_category_idx ON profile_fields (category);
494 -- Table structure for table 'profile_values'
497 CREATE TABLE profile_values (
498 fid integer default '0',
499 uid integer default '0',
502 CREATE INDEX profile_values_uid ON profile_values (uid);
503 CREATE INDEX profile_values_fid ON profile_values (fid);
505 CREATE TABLE url_alias (
507 src varchar(128) NOT NULL default '',
508 dst varchar(128) NOT NULL default '',
511 CREATE UNIQUE INDEX url_alias_dst_idx ON url_alias(dst);
512 CREATE INDEX url_alias_src_idx ON url_alias(src);
515 -- Table structure for permission
518 CREATE TABLE permission (
519 rid integer NOT NULL default '0',
520 perm text default '',
521 tid integer NOT NULL default '0'
523 CREATE INDEX permission_rid_idx ON permission(rid);
526 -- Table structure for poll
530 nid integer NOT NULL default '0',
531 runtime integer NOT NULL default '0',
532 active integer NOT NULL default '0',
537 -- Table structure for poll_votes
540 CREATE TABLE poll_votes (
542 uid int NOT NULL default 0,
543 hostname varchar(128) NOT NULL default ''
545 CREATE INDEX poll_votes_nid_idx ON poll_votes (nid);
546 CREATE INDEX poll_votes_uid_idx ON poll_votes (uid);
547 CREATE INDEX poll_votes_hostname_idx ON poll_votes (hostname);
550 -- Table structure for poll_choices
553 CREATE TABLE poll_choices (
555 nid integer NOT NULL default '0',
556 chtext varchar(128) NOT NULL default '',
557 chvotes integer NOT NULL default '0',
558 chorder integer NOT NULL default '0',
561 CREATE INDEX poll_choices_nid_idx ON poll_choices(nid);
564 -- Table structure for role
569 name varchar(32) NOT NULL default '',
575 -- Table structure for table 'search_dataset'
577 CREATE TABLE search_dataset (
578 sid integer NOT NULL default '0',
579 type varchar(16) default NULL,
580 data text NOT NULL default ''
582 CREATE INDEX search_dataset_sid_type_idx ON search_dataset(sid, type);
585 -- Table structure for search_index
588 CREATE TABLE search_index (
589 word varchar(50) NOT NULL default '',
590 sid integer NOT NULL default '0',
591 type varchar(16) default NULL,
592 fromsid integer NOT NULL default '0',
593 fromtype varchar(16) default NULL,
594 score float default NULL
596 CREATE INDEX search_index_sid_type_idx ON search_index(sid, type);
597 CREATE INDEX search_index_fromsid_fromtype_idx ON search_index(fromsid, fromtype);
598 CREATE INDEX search_index_word_idx ON search_index(word);
601 -- Table structures for search_total
604 CREATE TABLE search_total (
605 word varchar(50) NOT NULL default '',
606 count float default NULL,
611 -- Table structure for sessions
614 CREATE TABLE sessions (
615 uid integer not null,
616 sid varchar(32) NOT NULL default '',
617 hostname varchar(128) NOT NULL default '',
618 timestamp integer NOT NULL default '0',
619 cache integer NOT NULL default '0',
623 CREATE INDEX sessions_uid_idx ON sessions(uid);
624 CREATE INDEX sessions_timestamp_idx ON sessions(timestamp);
627 -- Table structure for sequences
628 -- This is only used under MySQL, co commented out
631 -- CREATE TABLE sequences (
632 -- name varchar(255) NOT NULL,
633 -- id integer NOT NULL,
634 -- PRIMARY KEY (name)
638 -- Table structure for table 'node_counter'
641 CREATE TABLE node_counter (
642 nid integer NOT NULL default '0',
643 totalcount integer NOT NULL default '0',
644 daycount integer NOT NULL default '0',
645 timestamp integer NOT NULL default '0',
648 CREATE INDEX node_counter_totalcount_idx ON node_counter(totalcount);
649 CREATE INDEX node_counter_daycount_idx ON node_counter(daycount);
650 CREATE INDEX node_counter_timestamp_idx ON node_counter(timestamp);
653 -- Table structure for system
656 CREATE TABLE system (
657 filename varchar(255) NOT NULL default '',
658 name varchar(255) NOT NULL default '',
659 type varchar(255) NOT NULL default '',
660 description varchar(255) NOT NULL default '',
661 status integer NOT NULL default '0',
662 throttle smallint NOT NULL default '0',
663 bootstrap integer NOT NULL default '0',
664 schema_version smallint NOT NULL default -1,
665 weight smallint NOT NULL default 0,
666 PRIMARY KEY (filename)
668 CREATE INDEX system_weight_idx ON system(weight);
671 -- Table structure for term_data
674 CREATE TABLE term_data (
676 vid integer NOT NULL default '0',
677 name varchar(255) NOT NULL default '',
678 description text default '',
679 weight smallint NOT NULL default '0',
682 CREATE INDEX term_data_vid_idx ON term_data(vid);
685 -- Table structure for term_hierarchy
688 CREATE TABLE term_hierarchy (
689 tid integer NOT NULL default '0',
690 parent integer NOT NULL default '0',
691 PRIMARY KEY (tid, parent)
693 CREATE INDEX term_hierarchy_tid_idx ON term_hierarchy(tid);
694 CREATE INDEX term_hierarchy_parent_idx ON term_hierarchy(parent);
697 -- Table structure for term_node
700 CREATE TABLE term_node (
701 nid integer NOT NULL default '0',
702 tid integer NOT NULL default '0',
703 PRIMARY KEY (tid,nid)
705 CREATE INDEX term_node_nid_idx ON term_node(nid);
706 CREATE INDEX term_node_tid_idx ON term_node(tid);
709 -- Table structure for term_relation
712 CREATE TABLE term_relation (
713 tid1 integer NOT NULL default '0',
714 tid2 integer NOT NULL default '0'
716 CREATE INDEX term_relation_tid1_idx ON term_relation(tid1);
717 CREATE INDEX term_relation_tid2_idx ON term_relation(tid2);
720 -- Table structure for term_synonym
723 CREATE TABLE term_synonym (
724 tid integer NOT NULL default '0',
725 name varchar(255) NOT NULL default ''
727 CREATE INDEX term_synonym_tid_idx ON term_synonym(tid);
728 CREATE INDEX term_synonym_name_idx ON term_synonym(name);
731 -- Table structure for users
735 uid integer NOT NULL default '0',
736 name varchar(60) NOT NULL default '',
737 pass varchar(32) NOT NULL default '',
738 mail varchar(64) default '',
739 mode smallint NOT NULL default '0',
740 sort smallint default '0',
741 threshold smallint default '0',
742 theme varchar(255) NOT NULL default '',
743 signature varchar(255) NOT NULL default '',
744 created integer NOT NULL default '0',
745 access integer NOT NULL default '0',
746 login integer NOT NULL default '0',
747 status smallint NOT NULL default '0',
748 timezone varchar(8) default NULL,
749 language varchar(12) NOT NULL default '',
750 picture varchar(255) NOT NULL DEFAULT '',
751 init varchar(64) default '',
752 data text default '',
756 CREATE INDEX users_access_idx ON users(access);
758 CREATE SEQUENCE users_uid_seq INCREMENT 1 START 1;
761 -- Table structure for users_roles
764 CREATE TABLE users_roles (
765 uid integer NOT NULL default '0',
766 rid integer NOT NULL default '0',
767 PRIMARY KEY (uid, rid)
771 -- Table structure for variable
774 CREATE TABLE variable (
775 name varchar(48) NOT NULL default '',
776 value text NOT NULL default '',
781 -- Table structure for vocabulary
784 CREATE TABLE vocabulary (
786 name varchar(255) NOT NULL default '',
787 description text default '',
788 help varchar(255) NOT NULL default '',
789 relations smallint NOT NULL default '0',
790 hierarchy smallint NOT NULL default '0',
791 multiple smallint NOT NULL default '0',
792 required smallint NOT NULL default '0',
793 tags smallint NOT NULL default '0',
794 module varchar(255) NOT NULL default '',
795 weight smallint NOT NULL default '0',
800 -- Table structure for vocabulary_node_types
803 CREATE TABLE vocabulary_node_types (
804 vid integer NOT NULL default '0',
805 type varchar(32) NOT NULL default '',
806 PRIMARY KEY (vid, type)
810 -- Table structure for watchdog
813 CREATE TABLE watchdog (
815 uid integer NOT NULL default '0',
816 type varchar(16) NOT NULL default '',
817 message text NOT NULL default '',
818 severity smallint NOT NULL default '0',
819 link text NOT NULL default '',
820 location text NOT NULL default '',
821 referer text NOT NULL default '',
822 hostname varchar(128) NOT NULL default '',
823 timestamp integer NOT NULL default '0',
828 -- Insert some default values
831 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/block.module', 'block', 'module', '', 1, 0, 0, 0);
832 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/comment.module', 'comment', 'module', '', 1, 0, 0, 0);
833 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/filter.module', 'filter', 'module', '', 1, 0, 0, 0);
834 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/help.module', 'help', 'module', '', 1, 0, 0, 0);
835 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/menu.module', 'menu', 'module', '', 1, 0, 0, 0);
836 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/node.module', 'node', 'module', '', 1, 0, 0, 0);
837 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/page.module', 'page', 'module', '', 1, 0, 0, 0);
838 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/story.module', 'story', 'module', '', 1, 0, 0, 0);
839 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/system.module', 'system', 'module', '', 1, 0, 0, 0);
840 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/taxonomy.module', 'taxonomy', 'module', '', 1, 0, 0, 0);
841 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/user.module', 'user', 'module', '', 1, 0, 0, 0);
842 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/watchdog.module', 'watchdog', 'module', '', 1, 0, 0, 0);
843 -- PlanetLab: Enable path and planetlab modules
844 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/path.module', 'path', 'module', '', 1, 0, 0, 0);
845 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/planetlab.module', 'planetlab', 'module', '', 1, 0, 0, 0);
846 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('themes/engines/phptemplate/phptemplate.engine', 'phptemplate', 'theme_engine', '', 1, 0, 0, 0);
847 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('themes/bluemarine/page.tpl.php', 'bluemarine', 'theme', 'themes/engines/phptemplate/phptemplate.engine', 1, 0, 0, 0);
849 INSERT INTO users(uid,name,mail) VALUES(0,'','');
850 -- PlanetLab: Create a default superuser
851 INSERT INTO users(uid,name,mail) VALUES(1,'drupal','');
853 INSERT INTO role (name) VALUES ('anonymous user');
854 INSERT INTO role (name) VALUES ('authenticated user');
856 INSERT INTO permission VALUES (1,'access content',0);
857 INSERT INTO permission VALUES (2,'access comments, access content, post comments, post comments without approval',0);
859 INSERT INTO variable(name,value) VALUES('theme_default', 's:10:"bluemarine";');
861 -- PlanetLab: Replace default user login block with PlanetLab login block
862 -- INSERT INTO blocks(module,delta,theme,status) VALUES('user', 0, 'bluemarine', 1);
863 INSERT INTO blocks(module,delta,theme,status) VALUES('planetlab', 0, 'bluemarine', 1);
864 INSERT INTO blocks(module,delta,theme,status) VALUES('user', 1, 'bluemarine', 1);
866 INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0);
868 INSERT INTO filter_formats (name, roles, cache) VALUES ('Filtered HTML',',1,2,',1);
869 INSERT INTO filter_formats (name, roles, cache) VALUES ('PHP code','',0);
870 INSERT INTO filter_formats (name, roles, cache) VALUES ('Full HTML','',1);
871 INSERT INTO filters VALUES (1,'filter',0,0);
872 INSERT INTO filters VALUES (1,'filter',2,1);
873 INSERT INTO filters VALUES (2,'filter',1,0);
874 INSERT INTO filters VALUES (3,'filter',2,0);
875 INSERT INTO variable (name,value) VALUES ('filter_html_1','i:1;');
877 INSERT INTO locales_meta (locale, name, enabled, isdefault) VALUES ('en', 'English', '1', '1');
879 INSERT INTO variable (name, value) VALUES ('node_options_forum', 'a:1:{i:0;s:6:"status";}');
881 INSERT INTO menu(pid, path, title, description, weight, type) VALUES (0, '', 'Primary links', '', 0, 115);
882 INSERT INTO variable VALUES ('menu_primary_menu', 'i:2;');
883 INSERT INTO variable VALUES ('menu_secondary_menu', 'i:2;');
889 --- Always installed in 'public' as prefix isn't appended to function names
890 SET search_path TO public;
892 CREATE OR REPLACE FUNCTION "greatest"(numeric, numeric) RETURNS numeric AS '
893 SELECT CASE WHEN (($1 > $2) OR ($2 IS NULL)) THEN $1 ELSE $2 END;
896 CREATE OR REPLACE FUNCTION "greatest"(numeric, numeric, numeric) RETURNS numeric AS '
897 SELECT greatest($1, greatest($2, $3));
900 CREATE OR REPLACE FUNCTION "rand"() RETURNS float AS '
904 CREATE OR REPLACE FUNCTION "concat"(text, text) RETURNS text AS '
908 CREATE OR REPLACE FUNCTION "if"(boolean, text, text) RETURNS text AS '
909 SELECT CASE WHEN $1 THEN $2 ELSE $3 END;
912 CREATE OR REPLACE FUNCTION "if"(boolean, integer, integer) RETURNS integer AS '
913 SELECT CASE WHEN $1 THEN $2 ELSE $3 END;