Subversion Repositories oidplus

Compare Revisions

Regard whitespace Rev 1089 → Rev 1090

/trunk/setup/sql/struct_access.sql
65,8 → 65,7
[mobile] varchar(100) NULL,
[fax] varchar(100) NULL,
[privacy] bit NOT NULL,
[salt] varchar(100) NULL,
[authkey] varchar(100) NULL,
[authkey] varchar(250) NULL,
[registered] datetime NULL,
[updated] datetime NULL,
[last_login] datetime NULL,
122,4 → 121,4
)
);
 
INSERT INTO [config] ([name], [description], [value], [protected], [visible]) VALUES ('database_version', 'Version of the database tables', '1001', '1', '0');
INSERT INTO [config] ([name], [description], [value], [protected], [visible]) VALUES ('database_version', 'Version of the database tables', '1002', '1', '0');
/trunk/setup/sql/struct_mssql.sql
159,8 → 159,7
[mobile] [varchar](100) NULL,
[fax] [varchar](100) NULL,
[privacy] [bit] NOT NULL CONSTRAINT [DF__ra__privacy] DEFAULT ('0'),
[salt] [varchar](100) NULL,
[authkey] [varchar](100) NULL,
[authkey] [varchar](250) NULL,
[registered] [datetime] NULL,
[updated] [datetime] NULL,
[last_login] [datetime] NULL,
251,7 → 250,7
 
/****** Set database version ******/
 
INSERT INTO [config] (name, description, value, protected, visible) VALUES ('database_version', 'Version of the database tables', '1001', '1', '0');
INSERT INTO [config] (name, description, value, protected, visible) VALUES ('database_version', 'Version of the database tables', '1002', '1', '0');
 
SET ANSI_PADDING OFF
GO
/trunk/setup/sql/struct_mysql.sql
Cannot display: file marked as a binary type.
svn:mime-type = application/x-sql
/trunk/setup/sql/struct_oracle.sql
84,8 → 84,7
"MOBILE" VARCHAR2(100) NULL,
"FAX" VARCHAR2(100) NULL,
"PRIVACY" NUMBER(1) DEFAULT '0' NOT NULL,
"SALT" VARCHAR2(100) NULL,
"AUTHKEY" VARCHAR2(100) NULL,
"AUTHKEY" VARCHAR2(250) NULL,
"REGISTERED" TIMESTAMP,
"UPDATED" TIMESTAMP,
"LAST_LOGIN" TIMESTAMP,
136,4 → 135,4
 
/* -------------------------------------------------- */
 
INSERT INTO "CONFIG" ("NAME", "DESCRIPTION", "VALUE", "PROTECTED", "VISIBLE") VALUES ('database_version', 'Version of the database tables', '1001', '1', '0');
INSERT INTO "CONFIG" ("NAME", "DESCRIPTION", "VALUE", "PROTECTED", "VISIBLE") VALUES ('database_version', 'Version of the database tables', '1002', '1', '0');
/trunk/setup/sql/struct_pgsql.sql
75,8 → 75,7
"mobile" varchar(100) NULL,
"fax" varchar(100) NULL,
"privacy" boolean NOT NULL DEFAULT false,
"salt" varchar(100) NULL,
"authkey" varchar(100) NULL,
"authkey" varchar(250) NULL,
"registered" timestamp,
"updated" timestamp,
"last_login" timestamp
134,4 → 133,4
 
-------------------------------------------------------
 
INSERT INTO "config" ("name", "description", "value", "protected", "visible") VALUES ('database_version', 'Version of the database tables', '1001', true, false);
INSERT INTO "config" ("name", "description", "value", "protected", "visible") VALUES ('database_version', 'Version of the database tables', '1002', true, false);
/trunk/setup/sql/struct_sqlite.sql
57,7 → 57,6
`mobile` TEXT NULL,
`fax` TEXT NULL,
`privacy` INTEGER NOT NULL DEFAULT 0,
`salt` TEXT NULL,
`authkey` TEXT NULL,
`registered` TEXT, -- DateTime
`updated` TEXT, -- DateTime
90,4 → 89,4
UNIQUE (`log_id`,`object`)
);
 
INSERT INTO `config` (name, description, value, protected, visible) VALUES ('database_version', 'Version of the database tables', '1001', '1', '0');
INSERT INTO `config` (name, description, value, protected, visible) VALUES ('database_version', 'Version of the database tables', '1002', '1', '0');