/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'); |