1 -- $Id: database.4.1.mysql 144 2007-03-28 07:52:20Z thierry $
4 -- Table structure for table 'access'
7 aid tinyint(10) NOT NULL auto_increment,
8 mask varchar(255) NOT NULL default '',
9 type varchar(255) NOT NULL default '',
10 status tinyint(2) NOT NULL default '0',
13 DEFAULT CHARACTER SET utf8;
16 -- Table structure for table 'accesslog'
19 CREATE TABLE accesslog (
20 aid int(10) NOT NULL auto_increment,
21 sid varchar(32) NOT NULL default '',
22 title varchar(255) default NULL,
23 path varchar(255) default NULL,
24 url varchar(255) default NULL,
25 hostname varchar(128) default NULL,
26 uid int(10) unsigned default '0',
27 timer int(10) unsigned NOT NULL default '0',
28 timestamp int(11) unsigned NOT NULL default '0',
29 KEY accesslog_timestamp (timestamp),
32 DEFAULT CHARACTER SET utf8;
35 -- Table structure for table 'aggregator_category'
38 CREATE TABLE aggregator_category (
39 cid int(10) NOT NULL auto_increment,
40 title varchar(255) NOT NULL default '',
41 description longtext NOT NULL,
42 block tinyint(2) NOT NULL default '0',
44 UNIQUE KEY title (title)
46 DEFAULT CHARACTER SET utf8;
49 -- Table structure for table 'aggregator_category_feed'
52 CREATE TABLE aggregator_category_feed (
53 fid int(10) NOT NULL default '0',
54 cid int(10) NOT NULL default '0',
57 DEFAULT CHARACTER SET utf8;
60 -- Table structure for table 'aggregator_category_item'
63 CREATE TABLE aggregator_category_item (
64 iid int(10) NOT NULL default '0',
65 cid int(10) NOT NULL default '0',
68 DEFAULT CHARACTER SET utf8;
71 -- Table structure for table 'aggregator_feed'
74 CREATE TABLE aggregator_feed (
75 fid int(10) NOT NULL auto_increment,
76 title varchar(255) NOT NULL default '',
77 url varchar(255) NOT NULL default '',
78 refresh int(10) NOT NULL default '0',
79 checked int(10) NOT NULL default '0',
80 link varchar(255) NOT NULL default '',
81 description longtext NOT NULL,
82 image longtext NOT NULL,
83 etag varchar(255) NOT NULL default '',
84 modified int(10) NOT NULL default '0',
85 block tinyint(2) NOT NULL default '0',
87 UNIQUE KEY link (url),
88 UNIQUE KEY title (title)
90 DEFAULT CHARACTER SET utf8;
93 -- Table structure for table 'aggregator_item'
96 CREATE TABLE aggregator_item (
97 iid int(10) NOT NULL auto_increment,
98 fid int(10) NOT NULL default '0',
99 title varchar(255) NOT NULL default '',
100 link varchar(255) NOT NULL default '',
101 author varchar(255) NOT NULL default '',
102 description longtext NOT NULL,
103 timestamp int(11) default NULL,
106 DEFAULT CHARACTER SET utf8;
109 -- Table structure for table 'authmap'
112 CREATE TABLE authmap (
113 aid int(10) unsigned NOT NULL auto_increment,
114 uid int(10) NOT NULL default '0',
115 authname varchar(128) NOT NULL default '',
116 module varchar(128) NOT NULL default '',
118 UNIQUE KEY authname (authname)
120 DEFAULT CHARACTER SET utf8;
123 -- Table structure for table 'blocks'
126 CREATE TABLE blocks (
127 module varchar(64) DEFAULT '' NOT NULL,
128 delta varchar(32) NOT NULL default '0',
129 theme varchar(255) NOT NULL default '',
130 status tinyint(2) DEFAULT '0' NOT NULL,
131 weight tinyint(1) DEFAULT '0' NOT NULL,
132 region varchar(64) DEFAULT 'left' NOT NULL,
133 custom tinyint(2) DEFAULT '0' NOT NULL,
134 throttle tinyint(1) DEFAULT '0' NOT NULL,
135 visibility tinyint(1) DEFAULT '0' NOT NULL,
136 pages text DEFAULT '' NOT NULL
138 DEFAULT CHARACTER SET utf8;
141 -- Table structure for table 'book'
145 vid int(10) unsigned NOT NULL default '0',
146 nid int(10) unsigned NOT NULL default '0',
147 parent int(10) NOT NULL default '0',
148 weight tinyint(3) NOT NULL default '0',
153 DEFAULT CHARACTER SET utf8;
156 -- Table structure for table 'boxes'
160 bid tinyint(4) NOT NULL auto_increment,
161 title varchar(64) NOT NULL default '',
163 info varchar(128) NOT NULL default '',
164 format int(4) NOT NULL default '0',
166 UNIQUE KEY info (info)
168 DEFAULT CHARACTER SET utf8;
171 -- Table structure for table 'cache'
175 cid varchar(255) NOT NULL default '',
177 expire int(11) NOT NULL default '0',
178 created int(11) NOT NULL default '0',
181 INDEX expire (expire)
183 DEFAULT CHARACTER SET utf8;
186 -- Table structure for table 'comments'
189 CREATE TABLE comments (
190 cid int(10) NOT NULL auto_increment,
191 pid int(10) NOT NULL default '0',
192 nid int(10) NOT NULL default '0',
193 uid int(10) NOT NULL default '0',
194 subject varchar(64) NOT NULL default '',
195 comment longtext NOT NULL,
196 hostname varchar(128) NOT NULL default '',
197 timestamp int(11) NOT NULL default '0',
198 score mediumint(9) NOT NULL default '0',
199 status tinyint(3) unsigned NOT NULL default '0',
200 format int(4) NOT NULL default '0',
201 thread varchar(255) NOT NULL,
203 name varchar(60) default NULL,
204 mail varchar(64) default NULL,
205 homepage varchar(255) default NULL,
209 DEFAULT CHARACTER SET utf8;
212 -- Table structre for table 'contact'
215 CREATE TABLE contact (
216 cid int(10) unsigned NOT NULL auto_increment,
217 category varchar(255) NOT NULL default '',
218 recipients longtext NOT NULL default '',
219 reply longtext NOT NULL default '',
220 weight tinyint(3) NOT NULL default '0',
221 selected tinyint(1) NOT NULL default '0',
223 UNIQUE KEY category (category)
225 DEFAULT CHARACTER SET utf8;
228 -- Table structre for table 'node_comment_statistics'
231 CREATE TABLE node_comment_statistics (
232 nid int(10) unsigned NOT NULL auto_increment,
233 last_comment_timestamp int(11) NOT NULL default '0',
234 last_comment_name varchar(60) default NULL,
235 last_comment_uid int(10) NOT NULL default '0',
236 comment_count int(10) unsigned NOT NULL default '0',
238 KEY node_comment_timestamp (last_comment_timestamp)
240 DEFAULT CHARACTER SET utf8;
243 -- Table structure for table 'client'
246 CREATE TABLE client (
247 cid int(10) unsigned NOT NULL auto_increment,
248 link varchar(255) NOT NULL default '',
249 name varchar(128) NOT NULL default '',
250 mail varchar(128) NOT NULL default '',
251 slogan longtext NOT NULL,
252 mission longtext NOT NULL,
253 users int(10) NOT NULL default '0',
254 nodes int(10) NOT NULL default '0',
255 version varchar(35) NOT NULL default'',
256 created int(11) NOT NULL default '0',
257 changed int(11) NOT NULL default '0',
260 DEFAULT CHARACTER SET utf8;
263 -- Table structure for table 'client_system'
266 CREATE TABLE client_system (
267 cid int(10) NOT NULL default '0',
268 name varchar(255) NOT NULL default '',
269 type varchar(255) NOT NULL default '',
270 PRIMARY KEY (cid,name)
272 DEFAULT CHARACTER SET utf8;
275 -- Table structure for table 'files'
279 fid int(10) unsigned NOT NULL default 0,
280 nid int(10) unsigned NOT NULL default 0,
281 filename varchar(255) NOT NULL default '',
282 filepath varchar(255) NOT NULL default '',
283 filemime varchar(255) NOT NULL default '',
284 filesize int(10) unsigned NOT NULL default 0,
287 DEFAULT CHARACTER SET utf8;
290 -- Table structure for table 'file_revisions'
293 CREATE TABLE file_revisions (
294 fid int(10) unsigned NOT NULL default 0,
295 vid int(10) unsigned NOT NULL default 0,
296 description varchar(255) NOT NULL default '',
297 list tinyint(1) unsigned NOT NULL default 0,
298 PRIMARY KEY (fid, vid)
300 DEFAULT CHARACTER SET utf8;
303 -- Table structure for table 'filter_formats'
306 CREATE TABLE filter_formats (
307 format int(4) NOT NULL auto_increment,
308 name varchar(255) NOT NULL default '',
309 roles varchar(255) NOT NULL default '',
310 cache tinyint(2) NOT NULL default '0',
311 PRIMARY KEY (format),
314 DEFAULT CHARACTER SET utf8;
317 -- Table structure for table 'filters'
320 CREATE TABLE filters (
321 format int(4) NOT NULL default '0',
322 module varchar(64) NOT NULL default '',
323 delta tinyint(2) DEFAULT '0' NOT NULL,
324 weight tinyint(2) DEFAULT '0' NOT NULL,
327 DEFAULT CHARACTER SET utf8;
330 -- Table structure for table 'flood'
334 event varchar(64) NOT NULL default '',
335 hostname varchar(128) NOT NULL default '',
336 timestamp int(11) NOT NULL default '0'
338 DEFAULT CHARACTER SET utf8;
341 -- Table structure for table 'forum'
345 nid int(10) unsigned NOT NULL default '0',
346 vid int(10) unsigned NOT NULL default '0',
347 tid int(10) unsigned NOT NULL default '0',
352 DEFAULT CHARACTER SET utf8;
355 -- Table structure for table 'history'
358 CREATE TABLE history (
359 uid int(10) NOT NULL default '0',
360 nid int(10) NOT NULL default '0',
361 timestamp int(11) NOT NULL default '0',
362 PRIMARY KEY (uid,nid)
364 DEFAULT CHARACTER SET utf8;
367 -- Table structure for table 'locales_meta'
370 CREATE TABLE locales_meta (
371 locale varchar(12) NOT NULL default '',
372 name varchar(64) NOT NULL default '',
373 enabled int(2) NOT NULL default '0',
374 isdefault int(2) NOT NULL default '0',
375 plurals int(1) NOT NULL default '0',
376 formula varchar(128) NOT NULL default '',
379 DEFAULT CHARACTER SET utf8;
382 -- Table structure for table 'locales_source'
385 CREATE TABLE locales_source (
386 lid int(11) NOT NULL auto_increment,
387 location varchar(255) NOT NULL default '',
388 source blob NOT NULL,
391 DEFAULT CHARACTER SET utf8;
394 -- Table structure for table 'locales_target'
397 CREATE TABLE locales_target (
398 lid int(11) NOT NULL default '0',
399 translation blob NOT NULL,
400 locale varchar(12) NOT NULL default '',
401 plid int(11) NOT NULL default '0',
402 plural int(1) NOT NULL default '0',
408 DEFAULT CHARACTER SET utf8;
411 -- Table structure for table 'menu'
415 mid int(10) unsigned NOT NULL default '0',
416 pid int(10) unsigned NOT NULL default '0',
417 path varchar(255) NOT NULL default '',
418 title varchar(255) NOT NULL default '',
419 description varchar(255) NOT NULL default '',
420 weight tinyint(4) NOT NULL default '0',
421 type int(2) unsigned NOT NULL default '0',
424 DEFAULT CHARACTER SET utf8;
427 -- Table structure for table 'node'
431 nid int(10) unsigned NOT NULL auto_increment,
432 vid int(10) unsigned NOT NULL default '0',
433 type varchar(32) NOT NULL default '',
434 title varchar(128) NOT NULL default '',
435 uid int(10) NOT NULL default '0',
436 status int(4) NOT NULL default '1',
437 created int(11) NOT NULL default '0',
438 changed int(11) NOT NULL default '0',
439 comment int(2) NOT NULL default '0',
440 promote int(2) NOT NULL default '0',
441 moderate int(2) NOT NULL default '0',
442 sticky int(2) NOT NULL default '0',
443 PRIMARY KEY (nid, vid),
444 UNIQUE KEY vid (vid),
445 KEY node_type (type(4)),
446 KEY node_title_type (title, type(4)),
449 KEY node_moderate (moderate),
450 KEY node_promote_status (promote, status),
451 KEY node_created (created),
452 KEY node_changed (changed),
453 KEY node_status_type (status, type, nid),
456 DEFAULT CHARACTER SET utf8;
459 -- Table structure for table `node_access`
462 CREATE TABLE node_access (
463 nid int(10) unsigned NOT NULL default '0',
464 gid int(10) unsigned NOT NULL default '0',
465 realm varchar(255) NOT NULL default '',
466 grant_view tinyint(1) unsigned NOT NULL default '0',
467 grant_update tinyint(1) unsigned NOT NULL default '0',
468 grant_delete tinyint(1) unsigned NOT NULL default '0',
469 PRIMARY KEY (nid,gid,realm)
471 DEFAULT CHARACTER SET utf8;
474 -- Table structure for table 'node_revisions'
477 CREATE TABLE node_revisions (
478 nid int(10) unsigned NOT NULL,
479 vid int(10) unsigned NOT NULL,
480 uid int(10) NOT NULL default '0',
481 title varchar(128) NOT NULL default '',
482 body longtext NOT NULL default '',
483 teaser longtext NOT NULL default '',
484 log longtext NOT NULL default '',
485 timestamp int(11) NOT NULL default '0',
486 format int(4) NOT NULL default '0',
491 DEFAULT CHARACTER SET utf8;
494 -- Table structure for table 'profile_fields'
497 CREATE TABLE profile_fields (
498 fid int(10) NOT NULL auto_increment,
499 title varchar(255) default NULL,
500 name varchar(128) default NULL,
501 explanation TEXT default NULL,
502 category varchar(255) default NULL,
503 page varchar(255) default NULL,
504 type varchar(128) default NULL,
505 weight tinyint(1) DEFAULT '0' NOT NULL,
506 required tinyint(1) DEFAULT '0' NOT NULL,
507 register tinyint(1) DEFAULT '0' NOT NULL,
508 visibility tinyint(1) DEFAULT '0' NOT NULL,
509 autocomplete tinyint(1) DEFAULT '0' NOT NULL,
511 KEY category (category),
512 UNIQUE KEY name (name),
515 DEFAULT CHARACTER SET utf8;
518 -- Table structure for table 'profile_values'
521 CREATE TABLE profile_values (
522 fid int(10) unsigned default '0',
523 uid int(10) unsigned default '0',
528 DEFAULT CHARACTER SET utf8;
532 -- Table structure for table 'url_alias'
535 CREATE TABLE url_alias (
536 pid int(10) unsigned NOT NULL auto_increment,
537 src varchar(128) NOT NULL default '',
538 dst varchar(128) NOT NULL default '',
540 UNIQUE KEY dst (dst),
543 DEFAULT CHARACTER SET utf8;
546 -- Table structure for table 'permission'
549 CREATE TABLE permission (
550 rid int(10) unsigned NOT NULL default '0',
552 tid int(10) unsigned NOT NULL default '0',
555 DEFAULT CHARACTER SET utf8;
558 -- Table structure for table 'poll'
562 nid int(10) unsigned NOT NULL default '0',
563 runtime int(10) NOT NULL default '0',
564 active int(2) unsigned NOT NULL default '0',
567 DEFAULT CHARACTER SET utf8;
570 -- Table structure for table 'poll_votes'
573 CREATE TABLE poll_votes (
574 nid int(10) unsigned NOT NULL,
575 uid int(10) unsigned NOT NULL default 0,
576 hostname varchar(128) NOT NULL default '',
581 DEFAULT CHARACTER SET utf8;
584 -- Table structure for table 'poll_choices'
587 CREATE TABLE poll_choices (
588 chid int(10) unsigned NOT NULL auto_increment,
589 nid int(10) unsigned NOT NULL default '0',
590 chtext varchar(128) NOT NULL default '',
591 chvotes int(6) NOT NULL default '0',
592 chorder int(2) NOT NULL default '0',
596 DEFAULT CHARACTER SET utf8;
599 -- Table structure for table 'role'
603 rid int(10) unsigned NOT NULL auto_increment,
604 name varchar(32) NOT NULL default '',
606 UNIQUE KEY name (name)
608 DEFAULT CHARACTER SET utf8;
611 -- Table structure for table 'search_dataset'
613 CREATE TABLE search_dataset (
614 sid int(10) unsigned NOT NULL default '0',
615 type varchar(16) default NULL,
616 data longtext NOT NULL,
617 KEY sid_type (sid, type)
619 DEFAULT CHARACTER SET utf8;
622 -- Table structure for table 'search_index'
625 CREATE TABLE search_index (
626 word varchar(50) NOT NULL default '',
627 sid int(10) unsigned NOT NULL default '0',
628 type varchar(16) default NULL,
629 fromsid int(10) unsigned NOT NULL default '0',
630 fromtype varchar(16) default NULL,
631 score float default NULL,
632 KEY sid_type (sid, type),
633 KEY from_sid_type (fromsid, fromtype),
636 DEFAULT CHARACTER SET utf8;
639 -- Table structure for table 'search_total'
642 CREATE TABLE search_total (
643 word varchar(50) NOT NULL default '',
644 count float default NULL,
647 DEFAULT CHARACTER SET utf8;
650 -- Table structure for table 'sessions'
654 CREATE TABLE sessions (
655 uid int(10) unsigned NOT NULL,
656 sid varchar(32) NOT NULL default '',
657 hostname varchar(128) NOT NULL default '',
658 timestamp int(11) NOT NULL default '0',
659 cache int(11) NOT NULL default '0',
663 KEY timestamp (timestamp)
665 DEFAULT CHARACTER SET utf8;
668 -- Table structure for table 'sequences'
671 CREATE TABLE sequences (
672 name varchar(255) NOT NULL default '',
673 id int(10) unsigned NOT NULL default '0',
676 DEFAULT CHARACTER SET utf8;
679 -- Table structure for table 'node_counter'
682 CREATE TABLE node_counter (
683 nid int(10) NOT NULL default '0',
684 totalcount bigint(20) unsigned NOT NULL default '0',
685 daycount mediumint(8) unsigned NOT NULL default '0',
686 timestamp int(11) unsigned NOT NULL default '0',
688 KEY totalcount (totalcount),
689 KEY daycount (daycount),
690 KEY timestamp (timestamp)
692 DEFAULT CHARACTER SET utf8;
695 -- Table structure for table 'system'
698 CREATE TABLE system (
699 filename varchar(255) NOT NULL default '',
700 name varchar(255) NOT NULL default '',
701 type varchar(255) NOT NULL default '',
702 description varchar(255) NOT NULL default '',
703 status int(2) NOT NULL default '0',
704 throttle tinyint(1) DEFAULT '0' NOT NULL,
705 bootstrap int(2) NOT NULL default '0',
706 schema_version smallint(3) NOT NULL default -1,
707 weight int(2) NOT NULL default '0',
708 PRIMARY KEY (filename),
711 DEFAULT CHARACTER SET utf8;
714 -- Table structure for table 'term_data'
717 CREATE TABLE term_data (
718 tid int(10) unsigned NOT NULL auto_increment,
719 vid int(10) unsigned NOT NULL default '0',
720 name varchar(255) NOT NULL default '',
721 description longtext,
722 weight tinyint(4) NOT NULL default '0',
726 DEFAULT CHARACTER SET utf8;
729 -- Table structure for table 'term_hierarchy'
732 CREATE TABLE term_hierarchy (
733 tid int(10) unsigned NOT NULL default '0',
734 parent int(10) unsigned NOT NULL default '0',
737 PRIMARY KEY (tid, parent)
739 DEFAULT CHARACTER SET utf8;
742 -- Table structure for table 'term_node'
745 CREATE TABLE term_node (
746 nid int(10) unsigned NOT NULL default '0',
747 tid int(10) unsigned NOT NULL default '0',
750 PRIMARY KEY (tid,nid)
752 DEFAULT CHARACTER SET utf8;
755 -- Table structure for table 'term_relation'
758 CREATE TABLE term_relation (
759 tid1 int(10) unsigned NOT NULL default '0',
760 tid2 int(10) unsigned NOT NULL default '0',
764 DEFAULT CHARACTER SET utf8;
767 -- Table structure for table 'term_synonym'
770 CREATE TABLE term_synonym (
771 tid int(10) unsigned NOT NULL default '0',
772 name varchar(255) NOT NULL default '',
776 DEFAULT CHARACTER SET utf8;
779 -- Table structure for table 'users'
783 uid int(10) unsigned NOT NULL default '0',
784 name varchar(60) NOT NULL default '',
785 pass varchar(32) NOT NULL default '',
786 mail varchar(64) default '',
787 mode tinyint(1) NOT NULL default '0',
788 sort tinyint(1) default '0',
789 threshold tinyint(1) default '0',
790 theme varchar(255) NOT NULL default '',
791 signature varchar(255) NOT NULL default '',
792 created int(11) NOT NULL default '0',
793 access int(11) NOT NULL default '0',
794 login int(11) NOT NULL default '0',
795 status tinyint(4) NOT NULL default '0',
796 timezone varchar(8) default NULL,
797 language varchar(12) NOT NULL default '',
798 picture varchar(255) NOT NULL DEFAULT '',
799 init varchar(64) default '',
802 UNIQUE KEY name (name),
805 DEFAULT CHARACTER SET utf8;
808 -- Table structure for table 'users_roles'
811 CREATE TABLE users_roles (
812 uid int(10) unsigned NOT NULL default '0',
813 rid int(10) unsigned NOT NULL default '0',
814 PRIMARY KEY (uid, rid)
816 DEFAULT CHARACTER SET utf8;
819 -- Table structure for table 'variable'
822 CREATE TABLE variable (
823 name varchar(48) NOT NULL default '',
824 value longtext NOT NULL,
827 DEFAULT CHARACTER SET utf8;
830 -- Table structure for table 'vocabulary'
833 CREATE TABLE vocabulary (
834 vid int(10) unsigned NOT NULL auto_increment,
835 name varchar(255) NOT NULL default '',
836 description longtext,
837 help varchar(255) NOT NULL default '',
838 relations tinyint(3) unsigned NOT NULL default '0',
839 hierarchy tinyint(3) unsigned NOT NULL default '0',
840 multiple tinyint(3) unsigned NOT NULL default '0',
841 required tinyint(3) unsigned NOT NULL default '0',
842 tags tinyint(3) unsigned NOT NULL default '0',
843 module varchar(255) NOT NULL default '',
844 weight tinyint(4) NOT NULL default '0',
847 DEFAULT CHARACTER SET utf8;
850 -- Table structure for table 'vocabulary_node_types'
853 CREATE TABLE vocabulary_node_types (
854 vid int(10) unsigned NOT NULL DEFAULT '0',
855 type varchar(32) NOT NULL DEFAULT '',
856 PRIMARY KEY (vid, type)
858 DEFAULT CHARACTER SET utf8;
861 -- Table structure for table 'watchdog'
864 CREATE TABLE watchdog (
865 wid int(5) NOT NULL auto_increment,
866 uid int(10) NOT NULL default '0',
867 type varchar(16) NOT NULL default '',
868 message longtext NOT NULL,
869 severity tinyint(3) unsigned NOT NULL default '0',
870 link varchar(255) NOT NULL default '',
871 location varchar(128) NOT NULL default '',
872 referer varchar(128) NOT NULL default '',
873 hostname varchar(128) NOT NULL default '',
874 timestamp int(11) NOT NULL default '0',
877 DEFAULT CHARACTER SET utf8;
880 -- Insert some default values
883 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/block.module', 'block', 'module', '', 1, 0, 0, 0);
884 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/comment.module', 'comment', 'module', '', 1, 0, 0, 0);
885 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/filter.module', 'filter', 'module', '', 1, 0, 0, 0);
886 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/help.module', 'help', 'module', '', 1, 0, 0, 0);
887 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/menu.module', 'menu', 'module', '', 1, 0, 0, 0);
888 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/node.module', 'node', 'module', '', 1, 0, 0, 0);
889 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/page.module', 'page', 'module', '', 1, 0, 0, 0);
890 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/story.module', 'story', 'module', '', 1, 0, 0, 0);
891 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/system.module', 'system', 'module', '', 1, 0, 0, 0);
892 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/taxonomy.module', 'taxonomy', 'module', '', 1, 0, 0, 0);
893 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/user.module', 'user', 'module', '', 1, 0, 0, 0);
894 INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/watchdog.module', 'watchdog', 'module', '', 1, 0, 0, 0);
895 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);
896 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);
897 INSERT INTO users (uid, name, mail) VALUES ('0', '', '');
899 INSERT INTO role (rid, name) VALUES (1, 'anonymous user');
900 INSERT INTO role (rid, name) VALUES (2, 'authenticated user');
902 INSERT INTO permission VALUES (1,'access content',0);
903 INSERT INTO permission VALUES (2,'access comments, access content, post comments, post comments without approval',0);
905 INSERT INTO variable (name, value) VALUES ('theme_default', 's:10:"bluemarine";');
907 INSERT INTO blocks (module, delta, theme, status, pages) VALUES ('user', '0', 'bluemarine', '1', '');
908 INSERT INTO blocks (module, delta, theme, status, pages) VALUES ('user', '1', 'bluemarine', '1', '');
910 INSERT INTO sequences (name, id) VALUES ('menu_mid', 2);
912 INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0);
914 INSERT INTO filter_formats VALUES (1,'Filtered HTML',',1,2,',1);
915 INSERT INTO filter_formats VALUES (2,'PHP code','',0);
916 INSERT INTO filter_formats VALUES (3,'Full HTML','',1);
917 INSERT INTO filters VALUES (1,'filter',0,0);
918 INSERT INTO filters VALUES (1,'filter',2,1);
919 INSERT INTO filters VALUES (2,'filter',1,0);
920 INSERT INTO filters VALUES (3,'filter',2,0);
921 INSERT INTO variable (name,value) VALUES ('filter_html_1','i:1;');
923 INSERT INTO locales_meta (locale, name, enabled, isdefault) VALUES ('en', 'English', '1', '1');
925 INSERT INTO variable (name, value) VALUES ('node_options_forum', 'a:1:{i:0;s:6:"status";}');
927 INSERT INTO menu VALUES (2, 0, '', 'Primary links', '', 0, 115);
928 INSERT INTO variable VALUES ('menu_primary_menu', 'i:2;');
929 INSERT INTO variable VALUES ('menu_secondary_menu', 'i:2;');