aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
Diffstat (limited to 'install')
-rw-r--r--install/schema_mysql.sql39
-rw-r--r--install/schema_postgres.sql42
2 files changed, 60 insertions, 21 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 977d26232..17ad1767e 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1097,16 +1097,35 @@ CREATE TABLE IF NOT EXISTS `profile_check` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `register` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `hash` char(191) NOT NULL DEFAULT '',
- `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
- `uid` int(10) unsigned NOT NULL DEFAULT 0 ,
- `password` char(191) NOT NULL DEFAULT '',
- `lang` char(16) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- KEY `hash` (`hash`),
- KEY `created` (`created`),
- KEY `uid` (`uid`)
+ `reg_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `reg_vital` int(10) unsigned NOT NULL DEFAULT 1,
+ `reg_flags` int(10) unsigned NOT NULL DEFAULT 0,
+ `reg_didx` char(1) NOT NULL DEFAULT '',
+ `reg_did2` char(191) NOT NULL DEFAULT '',
+ `reg_hash` char(191) NOT NULL DEFAULT '',
+ `reg_email` char(191) NOT NULL DEFAULT '',
+ `reg_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
+ `reg_startup` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
+ `reg_expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
+ `reg_byc` int(10) unsigned NOT NULL DEFAULT 0 ,
+ `reg_uid` int(10) unsigned NOT NULL DEFAULT 0 ,
+ `reg_atip` char(191) NOT NULL DEFAULT '',
+ `reg_pass` char(191) NOT NULL DEFAULT '',
+ `reg_lang` char(16) NOT NULL DEFAULT '',
+ `reg_stuff` text NOT NULL,
+ PRIMARY KEY (`reg_id`),
+ KEY `ix_reg_vital` (`reg_vital`),
+ KEY `ix_reg_flags` (`reg_flags`),
+ KEY `ix_reg_didx` (`reg_didx`),
+ KEY `ix_reg_did2` (`reg_did2`),
+ KEY `ix_reg_hash` (`reg_hash`),
+ KEY `ix_reg_email` (`reg_email`),
+ KEY `ix_reg_created` (`reg_created`),
+ KEY `ix_reg_startup` (`reg_startup`),
+ KEY `ix_reg_expires` (`reg_expires`),
+ KEY `ix_reg_byc` (`reg_byc`),
+ KEY `ix_reg_uid` (`reg_uid`),
+ KEY `ix_reg_atip` (`reg_atip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `session` (
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index c04ba9c67..cdca79cfc 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -1092,17 +1092,37 @@ create index "pc_sec" on profile_check ("sec");
create index "pc_expire" on profile_check ("expire");
CREATE TABLE "register" (
- "id" serial NOT NULL,
- "hash" text NOT NULL,
- "created" timestamp NOT NULL,
- "uid" bigint NOT NULL,
- "password" text NOT NULL,
- "lang" varchar(16) NOT NULL,
- PRIMARY KEY ("id")
-);
-create index "reg_hash" on register ("hash");
-create index "reg_created" on register ("created");
-create index "reg_uid" on register ("uid");
+ "reg_id" serial NOT NULL,
+ "reg_vital" int DEFAULT 1 NOT NULL,
+ "reg_flags_" bigint DEFAULT 0 NOT NULL,
+ "reg_didx" char(1) DEFAULT '' NOT NULL,
+ "reg_did2" text DEFAULT '' NOT NULL,
+ "reg_hash" text DEFAULT '' NOT NULL,
+ "reg_email" text DEFAULT '' NOT NULL,
+ "reg_created" timestamp NOT NULL,
+ "reg_startup" timestamp NOT NULL,
+ "reg_expires" timestamp NOT NULL,
+ "reg_byc" bigint DEFAULT 0 NOT NULL,
+ "reg_uid" bigint DEFAULT 0 NOT NULL,
+ "reg_atip" text DEFAULT '' NOT NULL,
+ "reg_pass" text DEFAULT '' NOT NULL,
+ "reg_lang" varchar(16) DEFAULT '' NOT NULL,
+ "reg_stuff" text NOT NULL,
+ PRIMARY KEY ("reg_id")
+);
+create index "ix_reg_vital" on register ("reg_vital");
+create index "ix_reg_flags" on register ("reg_flags");
+create index "ix_reg_didx" on register ("reg_didx");
+create index "ix_reg_did2" on register ("reg_did2");
+create index "ix_reg_hash" on register ("reg_hash");
+create index "ix_reg_email" on register ("reg_email");
+create index "ix_reg_created" on register ("reg_created");
+create index "ix_reg_startup" on register ("reg_startup");
+create index "ix_reg_expires" on register ("reg_expires");
+create index "ix_reg_byc" on register ("reg_byc");
+create index "ix_reg_uid" on register ("reg_uid");
+create index "ix_reg_atip" on register ("reg_atip");
+
CREATE TABLE "session" (
"id" serial,
"sid" text NOT NULL,