diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-04-28 20:53:42 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-04-28 20:53:42 +0000 |
| commit | fd37c0db4bf4fdc7b870525bd568b7f21c88c5c4 (patch) | |
| tree | 73a99ca4c53552bf24879643c3775b856bd37550 | |
| parent | 31d8b14969b58769f03eae2ecbf0cb2a1c1152fa (diff) | |
| download | brdo-fd37c0db4bf4fdc7b870525bd568b7f21c88c5c4.tar.gz brdo-fd37c0db4bf4fdc7b870525bd568b7f21c88c5c4.tar.bz2 | |
- Added default table values to MSSQL database scheme. Patch by Moshe. Fixes bug #1571.
| -rw-r--r-- | database/database.mssql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/database/database.mssql b/database/database.mssql index 54b223383..d4749d165 100644 --- a/database/database.mssql +++ b/database/database.mssql @@ -442,6 +442,26 @@ ALTER TABLE [dbo].[watchdog] WITH NOCHECK ADD CONSTRAINT [DF__watchdog__timest__47A6A41B] DEFAULT ('0') FOR [timestamp] GO +-- +-- Insert some default values +-- + +INSERT INTO system VALUES ('modules/admin.module','admin','module','',1); +INSERT INTO system VALUES ('modules/block.module','block','module','',1); +INSERT INTO system VALUES ('modules/comment.module','comment','module','',1); +INSERT INTO system VALUES ('modules/help.module','help','module','',1); +INSERT INTO system VALUES ('modules/node.module','node','module','',1); +INSERT INTO system VALUES ('modules/page.module','page','module','',1); +INSERT INTO system VALUES ('modules/story.module','story','module','',1); +INSERT INTO system VALUES ('modules/taxonomy.module','taxonomy','module','',1); +INSERT INTO system VALUES ('themes/marvin/marvin.theme','marvin','theme','Internet explorer, Netscape, Opera',1); + +INSERT INTO variable(name,value) VALUES('update_start', '2002-05-15'); +INSERT INTO variable(name,value) VALUES('theme_default','s:6:"marvin";'); + +INSERT INTO blocks(module,delta,status) VALUES('user', '0', '1'); +INSERT INTO blocks(module,delta,status) VALUES('user', '1', '1'); + --- --- Functions. Functions first available in SQL Server 2000. GREATEST() used by forum.module, tracker.module at the moment. --- |