I have written an article in the Ingres Community Wiki on how you can use syntax highlighting to make your code samples easier to read and download. Hop on over to http://community.ingres.com/wiki/Wiki_Syntax_Highlighting for information on how you can turn:
-- Ingres
-- SQL to create the base schema for MediaWiki
-- set autocommit on;
CREATE SEQUENCE user_user_id_seq MINVALUE 0 START WITH 0 NOCACHE;
CREATE TABLE mwuser (
user_id INTEGER DEFAULT user_user_id_seq.nextval NOT NULL PRIMARY KEY,
user_name VARCHAR(255) NOT NULL UNIQUE,
user_real_name VARCHAR(255),
user_password VARCHAR(1024),
user_newpassword VARCHAR(1024),
user_newpass_time TIMESTAMP,
user_token VARCHAR(255),
user_email VARCHAR(255),
user_email_token VARCHAR(255),
user_email_token_expires TIMESTAMP,
user_email_authenticated TIMESTAMP,
user_options CLOB,
user_touched TIMESTAMP,
user_registration TIMESTAMP,
user_editcount INTEGER
);
CREATE INDEX user_email_token_idx ON mwuser (user_email_token);
-- Create a dummy user to satisfy fk contraints especially with revisions
INSERT INTO mwuser
VALUES (DEFAULT,'Anonymous',,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,date('now'),date('now'),0);
into
-- Ingres
-- SQL to create the base schema for MediaWiki
-- set autocommit on;
CREATE SEQUENCE user_user_id_seq MINVALUE 0 START WITH 0 NOCACHE;
CREATE TABLE mwuser (
user_id INTEGER DEFAULT user_user_id_seq.nextval NOT NULL PRIMARY KEY,
user_name VARCHAR(255) NOT NULL UNIQUE,
user_real_name VARCHAR(255),
user_password VARCHAR(1024),
user_newpassword VARCHAR(1024),
user_newpass_time TIMESTAMP,
user_token VARCHAR(255),
user_email VARCHAR(255),
user_email_token VARCHAR(255),
user_email_token_expires TIMESTAMP,
user_email_authenticated TIMESTAMP,
user_options CLOB,
user_touched TIMESTAMP,
user_registration TIMESTAMP,
user_editcount INTEGER
);
CREATE INDEX user_email_token_idx ON mwuser (user_email_token);
-- Create a dummy user to satisfy fk contraints especially with revisions
INSERT INTO mwuser
VALUES (DEFAULT,'Anonymous',,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,date('now'),date('now'),0);
Nice huh?
