Hello,

I'm trying to install a database for mediawiki 1.13 with the sql below:

CREATE TABLE user ( user_id int NOT NULL IDENTITY(1,1), user_name varchar(255) NOT NULL default '', user_real_name varchar(255) NOT NULL default '', user_password text NOT NULL, user_newpassword text NOT NULL, user_newpass_time varchar(5) NULL, user_email text NOT NULL, user_options text NOT NULL, user_touched varchar(5) NOT NULL default '', user_token varchar(10) NOT NULL default '', user_email_authenticated varchar(5) NULL, user_email_token varchar(10) NULL, user_email_token_expires varchar(5) NULL, user_registration varchar(5) NULL, user_editcount int, PRIMARY KEY (user_id) );

CREATE TABLE user_groups ( ug_user int NOT NULL default '0', ug_group varchar(5) NOT NULL default '', PRIMARY KEY (ug_user,ug_group) );

CREATE TABLE user_newtalk ( user_id int NOT NULL default '0', user_ip varchar(13) NOT NULL default '', user_last_timestamp varchar(5) NOT NULL default '' );

CREATE TABLE page ( page_id int NOT NULL IDENTITY(1,1), page_namespace int NOT NULL, page_title varchar(255) NOT NULL, page_restrictions text NOT NULL, page_counter bigint NOT NULL default '0', page_is_redirect tinyint NOT NULL default '0', page_is_new tinyint NOT NULL default '0', page_random real NOT NULL, page_touched varchar(5) NOT NULL default '', page_latest int NOT NULL, page_len int NOT NULL, PRIMARY KEY (page_id) );

CREATE TABLE revision ( rev_id int NOT NULL IDENTITY(1,1), rev_page int NOT NULL, rev_text_id int NOT NULL, rev_comment text NOT NULL, rev_user int NOT NULL default '0', rev_user_text varchar(255) NOT NULL default '', rev_timestamp varchar(5) NOT NULL default '', rev_minor_edit tinyint NOT NULL default '0', rev_deleted tinyint NOT NULL default '0', rev_len int, rev_parent_id int default NULL, PRIMARY KEY (rev_page, rev_id) );

CREATE TABLE text ( old_id int NOT NULL IDENTITY(1,1), old_text text NOT NULL, old_flags text NOT NULL, PRIMARY KEY (old_id) );

CREATE TABLE archive ( ar_namespace int NOT NULL default '0', ar_title varchar(255) NOT NULL default '', ar_text text NOT NULL, ar_comment text NOT NULL, ar_user int NOT NULL default '0', ar_user_text varchar(255) NOT NULL, ar_timestamp varchar(5) NOT NULL default '', ar_minor_edit tinyint NOT NULL default '0', ar_flags text NOT NULL, ar_rev_id int, ar_text_id int, ar_deleted tinyint NOT NULL default '0', ar_len int, ar_page_id int, ar_parent_id int default NULL );

CREATE TABLE pagelinks ( pl_from int NOT NULL default '0', pl_namespace int NOT NULL default '0', pl_title varchar(255) NOT NULL default '' );

CREATE TABLE templatelinks ( tl_from int NOT NULL default '0', tl_namespace int NOT NULL default '0', tl_title varchar(255) NOT NULL default '' );

CREATE TABLE imagelinks ( il_from int NOT NULL default '0', il_to varchar(255) NOT NULL default '' );

CREATE TABLE categorylinks ( cl_from int NOT NULL default '0', cl_to varchar(255) NOT NULL default '', cl_sortkey varchar(70) NOT NULL default '', cl_timestamp timestamp NOT NULL );

CREATE TABLE category ( cat_id int NOT NULL IDENTITY(1,1), cat_title varchar(255) NOT NULL, cat_pages int NOT NULL default 0, cat_subcats int NOT NULL default 0, cat_files int NOT NULL default 0, cat_hidden tinyint NOT NULL default 0, PRIMARY KEY (cat_id) );

CREATE TABLE externallinks ( el_from int NOT NULL default '0', el_to text NOT NULL, el_index text NOT NULL );

CREATE TABLE langlinks ( ll_from int NOT NULL default '0', ll_lang varchar(7) NOT NULL default '', ll_title varchar(255) NOT NULL default '' );

CREATE TABLE site_stats ( ss_row_id int NOT NULL, ss_total_views bigint default '0', ss_total_edits bigint default '0', ss_good_articles bigint default '0', ss_total_pages bigint default '-1', ss_users bigint default '-1', ss_admins int default '-1', ss_images int default '0' );

CREATE TABLE hitcounter ( hc_id int NOT NULL );

CREATE TABLE ipblocks ( ipb_id int NOT NULL IDENTITY(1,1), ipb_address text NOT NULL, ipb_user int NOT NULL default '0', ipb_by int NOT NULL default '0', ipb_by_text varchar(255) NOT NULL default '', ipb_reason text NOT NULL, ipb_timestamp varchar(5) NOT NULL default '', ipb_auto bit NOT NULL default 0, ipb_anon_only bit NOT NULL default 0, ipb_create_account bit NOT NULL default 1, ipb_enable_autoblock bit NOT NULL default '1', ipb_expiry varchar(5) NOT NULL default '', ipb_range_start text NOT NULL, ipb_range_end text NOT NULL, ipb_deleted bit NOT NULL default 0, ipb_block_email bit NOT NULL default 0, PRIMARY KEY (ipb_id) );

CREATE TABLE image ( img_name varchar(255) NOT NULL default '', img_size int NOT NULL default '0', img_width int NOT NULL default '0', img_height int NOT NULL default '0', img_metadata text NOT NULL, img_bits int NOT NULL default '0', img_media_type TEXT default NULL, img_major_mime TEXT NOT NULL default "unknown", img_minor_mime varchar(10) NOT NULL default "unknown", img_description text NOT NULL, img_user int NOT NULL default '0', img_user_text varchar(255) NOT NULL, img_timestamp varchar(5) NOT NULL default '', img_sha1 varchar(10) NOT NULL default '', PRIMARY KEY (img_name) );

CREATE TABLE oldimage ( oi_name varchar(255) NOT NULL default '', oi_archive_name varchar(255) NOT NULL default '', oi_size int NOT NULL default 0, oi_width int NOT NULL default 0, oi_height int NOT NULL default 0, oi_bits int NOT NULL default 0, oi_description text NOT NULL, oi_user int NOT NULL default '0', oi_user_text varchar(255) NOT NULL, oi_timestamp varchar(5) NOT NULL default '', oi_metadata text NOT NULL, oi_media_type TEXT default NULL, oi_major_mime TEXT NOT NULL default "unknown", oi_minor_mime varchar(10) NOT NULL default "unknown", oi_deleted tinyint NOT NULL default '0', oi_sha1 varchar(10) NOT NULL default '' );

CREATE TABLE filearchive ( fa_id int NOT NULL IDENTITY(1,1), fa_name varchar(255) NOT NULL default '', fa_archive_name varchar(255) NULL default '', fa_storage_group varchar(5) NULL, fa_storage_key varchar(17) NULL default '', fa_deleted_user int, fa_deleted_timestamp varchar(5) NULL default '', fa_deleted_reason text, fa_size int default '0', fa_width int default '0', fa_height int default '0', fa_metadata text, fa_bits int default '0', fa_media_type TEXT default NULL, fa_major_mime TEXT default "unknown", fa_minor_mime varchar(10) NULL default "unknown", fa_description text, fa_user int default '0', fa_user_text varchar(255) NULL, fa_timestamp varchar(5) NULL default '', fa_deleted tinyint NOT NULL default '0', PRIMARY KEY (fa_id) );

CREATE TABLE recentchanges ( rc_id int NOT NULL IDENTITY(1,1), rc_timestamp varchar(5) NOT NULL default '', rc_cur_time varchar(5) NOT NULL default '', rc_user int NOT NULL default '0', rc_user_text varchar(255) NOT NULL, rc_namespace int NOT NULL default '0', rc_title varchar(255) NOT NULL default '', rc_comment varchar(255) NOT NULL default '', rc_minor tinyint NOT NULL default '0', rc_bot tinyint NOT NULL default '0', rc_new tinyint NOT NULL default '0', rc_cur_id int NOT NULL default '0', rc_this_oldid int NOT NULL default '0', rc_last_oldid int NOT NULL default '0', rc_type tinyint NOT NULL default '0', rc_moved_to_ns tinyint NOT NULL default '0', rc_moved_to_title varchar(255) NOT NULL default '', rc_patrolled tinyint NOT NULL default '0', rc_ip varchar(13) NOT NULL default '', rc_old_len int, rc_new_len int, rc_deleted tinyint NOT NULL default '0', rc_logid int NOT NULL default '0', rc_log_type varchar(17) NULL default NULL, rc_log_action varchar(17) NULL default NULL, rc_params text NULL, PRIMARY KEY (rc_id) );

CREATE TABLE watchlist ( wl_user int NOT NULL, wl_namespace int NOT NULL default '0', wl_title varchar(255) NOT NULL default '', wl_notificationtimestamp varchar(5) NULL );

CREATE TABLE math ( math_inputhash varchar(5) NOT NULL, math_outputhash varchar(5) NOT NULL, math_html_conservativeness tinyint NOT NULL, math_html text, math_mathml text );

CREATE TABLE searchindex ( si_page int NOT NULL, si_title varchar(255) NOT NULL default '', si_text text NOT NULL );

CREATE TABLE interwiki ( iw_prefix varchar(32) NOT NULL, iw_url text NOT NULL, iw_local bit NOT NULL, iw_trans tinyint NOT NULL default 0 );

CREATE TABLE querycache ( qc_type varchar(10) NOT NULL, qc_value int NOT NULL default '0', qc_namespace int NOT NULL default '0', qc_title varchar(255) NOT NULL default '' );

CREATE TABLE objectcache ( keyname varchar(17) NOT NULL default '', value text, exptime datetime );

CREATE TABLE transcache ( tc_url varchar(17) NOT NULL, tc_contents text, tc_time int NOT NULL );

CREATE TABLE logging ( log_id int NOT NULL IDENTITY(1,1), log_type varchar(4) NOT NULL default '', log_action varchar(4) NOT NULL default '', log_timestamp varchar(5) NOT NULL default '19700101000000', log_user int NOT NULL default 0, log_namespace int NOT NULL default 0, log_title varchar(255) NOT NULL default '', log_comment varchar(255) NOT NULL default '', log_params text NOT NULL, log_deleted tinyint NOT NULL default '0', PRIMARY KEY (log_id) );

CREATE TABLE trackbacks ( tb_id int IDENTITY(1,1), tb_page int REFERENCES page(page_id) ON DELETE CASCADE, tb_title varchar(255) NOT NULL, tb_url text NOT NULL, tb_ex text, tb_name varchar(255) NULL, PRIMARY KEY (tb_id) );

CREATE TABLE job ( job_id int NOT NULL IDENTITY(1,1), job_cmd varchar(17) NOT NULL default '', job_namespace int NOT NULL, job_title varchar(255) NOT NULL, job_params text NOT NULL, PRIMARY KEY (job_id) );

CREATE TABLE querycache_info ( qci_type varchar(10) NOT NULL default '', qci_timestamp varchar(5) NOT NULL default '19700101000000' );

CREATE TABLE redirect ( rd_from int NOT NULL default '0', rd_namespace int NOT NULL default '0', rd_title varchar(255) NOT NULL default '', PRIMARY KEY (rd_from) );

CREATE TABLE querycachetwo ( qcc_type varchar(10) NOT NULL, qcc_value int NOT NULL default '0', qcc_namespace int NOT NULL default '0', qcc_title varchar(255) NOT NULL default '', qcc_namespacetwo int NOT NULL default '0', qcc_titletwo varchar(255) NOT NULL default '' );

CREATE TABLE page_restrictions ( pr_page int NOT NULL, pr_type varchar(17) NOT NULL, pr_level varchar(17) NOT NULL, pr_cascade tinyint NOT NULL, pr_user int NULL, pr_expiry varchar(5) NULL, pr_id int NOT NULL IDENTITY(1,1), PRIMARY KEY (pr_page,pr_type) );

CREATE TABLE protected_titles ( pt_namespace int NOT NULL, pt_title varchar(255) NOT NULL, pt_user int NOT NULL, pt_reason text, pt_timestamp varchar(5) NOT NULL, pt_expiry varchar(5) NOT NULL default '', pt_create_perm varchar(17) NOT NULL, PRIMARY KEY (pt_namespace,pt_title) );

CREATE TABLE page_props ( pp_page int NOT NULL, pp_propname varchar(17) NOT NULL, pp_value text NOT NULL, PRIMARY KEY (pp_page,pp_propname) );

CREATE TABLE updatelog ( ul_key varchar(255) NOT NULL, PRIMARY KEY (ul_key) );

I get a error that there is a fault in my code, but I copied it right out /mantance/ could somebody tell me whats wrong?

Huib