diff options
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 56 |
1 files changed, 41 insertions, 15 deletions
diff --git a/database/database.mysql b/database/database.mysql index 1488dc513..e4c82f772 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -1,9 +1,3 @@ -# MySQL dump 8.14 -# -# Host: localhost Database: drupal -#-------------------------------------------------------- -# Server version 3.23.38 - # # Table structure for table 'access' # @@ -43,6 +37,7 @@ CREATE TABLE blocks ( region tinyint(1) NOT NULL default '0', remove tinyint(1) NOT NULL default '0', path varchar(255) NOT NULL default '', + custom tinyint(2) NOT NULL default '0', PRIMARY KEY (name) ) TYPE=MyISAM; @@ -71,8 +66,8 @@ CREATE TABLE boxes ( info varchar(128) NOT NULL default '', type tinyint(2) NOT NULL default '0', PRIMARY KEY (bid), - UNIQUE KEY subject (title), - UNIQUE KEY info (info) + UNIQUE KEY info (info), + UNIQUE KEY subject (title) ) TYPE=MyISAM; # @@ -168,8 +163,8 @@ CREATE TABLE feed ( link varchar(255) NOT NULL default '', description text NOT NULL, PRIMARY KEY (fid), - UNIQUE KEY link (url), - UNIQUE KEY title (title) + UNIQUE KEY title (title), + UNIQUE KEY link (url) ) TYPE=MyISAM; # @@ -387,8 +382,8 @@ CREATE TABLE site ( refresh int(11) NOT NULL default '0', threshold int(11) NOT NULL default '0', PRIMARY KEY (sid), - UNIQUE KEY url (link), - UNIQUE KEY title (name) + UNIQUE KEY title (name), + UNIQUE KEY url (link) ) TYPE=MyISAM; # @@ -551,6 +546,37 @@ CREATE TABLE watchdog ( # Insert some default values # -INSERT INTO variable SET name='update_start', value='2002-04-23 : roles cleanup'; -INSERT INTO blocks SET name='User information', module='user', delta='0', status='2', weight='0', region='1', remove='0', path=''; -INSERT INTO blocks SET name='Log in', module='user', delta='1', status='2', weight='0', region='1', remove='0', path=''; +INSERT INTO variable SET name='update_start', value='2002-05-15'; +INSERT INTO system VALUES ('archive.module','archive','module','',1); +INSERT INTO system VALUES ('block.module','block','module','',1); +INSERT INTO system VALUES ('blog.module','blog','module','',1); +INSERT INTO system VALUES ('bloggerapi.module','bloggerapi','module','',1); +INSERT INTO system VALUES ('book.module','book','module','',1); +INSERT INTO system VALUES ('cloud.module','cloud','module','',1); +INSERT INTO system VALUES ('comment.module','comment','module','',1); +INSERT INTO system VALUES ('forum.module','forum','module','',1); +INSERT INTO system VALUES ('help.module','help','module','',1); +INSERT INTO system VALUES ('import.module','import','module','',1); +INSERT INTO system VALUES ('jabber.module','jabber','module','',1); +INSERT INTO system VALUES ('locale.module','locale','module','',1); +INSERT INTO system VALUES ('node.module','node','module','',1); +INSERT INTO system VALUES ('notify.module','notify','module','',1); +INSERT INTO system VALUES ('page.module','page','module','',1); +INSERT INTO system VALUES ('poll.module','poll','module','',1); +INSERT INTO system VALUES ('queue.module','queue','module','',1); +INSERT INTO system VALUES ('rating.module','rating','module','',1); +INSERT INTO system VALUES ('search.module','search','module','',1); +INSERT INTO system VALUES ('statistics.module','statistics','module','',1); +INSERT INTO system VALUES ('story.module','story','module','',1); +INSERT INTO system VALUES ('taxonomy.module','taxonomy','module','',1); +INSERT INTO system VALUES ('themes/example/example.theme','example','theme','Internet explorer, Netscape, Opera, Lynx',1); +INSERT INTO system VALUES ('themes/goofy/goofy.theme','goofy','theme','Internetexplorer, Netscape, Opera',1); +INSERT INTO system VALUES ('themes/marvin/marvin.theme','marvin','theme','Internet explorer, Netscape, Opera',1); +INSERT INTO system VALUES ('themes/sosim/sosim.theme','sosim','theme','MSIE/NN/Opera',1); +INSERT INTO system VALUES ('themes/unconed/unconed.theme','unconed','theme','Internet explorer, Netscape, Opera',1); +INSERT INTO system VALUES ('tracker.module','tracker','module','',1); +INSERT INTO system VALUES ('weblogs.module','weblogs','module','',1); +REPLACE variable SET value = 'marvin', name = 'theme_default'; +REPLACE blocks SET name = 'User information', module = 'user', delta = '0', status = '1'; +REPLACE blocks SET name = 'Log in', module = 'user', delta = '1', status = '1'; + |