Revision 8065
Added by Aaron Marcuse-Kubitza over 11 years ago
| salvias_users.schema.sql | ||
|---|---|---|
| 28 | 28 |
"affiliation_id" integer NOT NULL, |
| 29 | 29 |
"description" varchar(200) NOT NULL DEFAULT '', |
| 30 | 30 |
PRIMARY KEY ("affiliation_id"),
|
| 31 |
"description_index" boolean
|
|
| 31 |
/*CONSTRAINT "description" */UNIQUE ("description")
|
|
| 32 | 32 |
); |
| 33 | 33 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 34 | 34 |
|
| ... | ... | |
| 46 | 46 |
"admin_email" varchar(100) DEFAULT NULL, |
| 47 | 47 |
"http_location" varchar(255) DEFAULT NULL, |
| 48 | 48 |
PRIMARY KEY ("app_id"),
|
| 49 |
"name_index" boolean
|
|
| 49 |
/*CONSTRAINT "name" */UNIQUE ("name")
|
|
| 50 | 50 |
); |
| 51 | 51 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 52 | 52 |
|
| ... | ... | |
| 152 | 152 |
"group_id" integer NOT NULL DEFAULT '0', |
| 153 | 153 |
"app_id" integer NOT NULL DEFAULT '0', |
| 154 | 154 |
PRIMARY KEY ("page","group_id"),
|
| 155 |
"app_id_index" boolean,
|
|
| 156 |
"page_index" boolean
|
|
| 155 |
/*KEY "app_id" ("app_id")*/CHECK (true),
|
|
| 156 |
/*FULLTEXT KEY "page" ("page")*/CHECK (true)
|
|
| 157 | 157 |
); |
| 158 | 158 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 159 | 159 |
|
| ... | ... | |
| 172 | 172 |
"allow_request" integer NOT NULL DEFAULT '0', |
| 173 | 173 |
"show_description" integer NOT NULL DEFAULT '0', |
| 174 | 174 |
PRIMARY KEY ("page","app_id"),
|
| 175 |
"allow_request_index" boolean,
|
|
| 176 |
"show_description_index" boolean
|
|
| 175 |
/*KEY "allow_request" ("allow_request")*/CHECK (true),
|
|
| 176 |
/*KEY "show_description" ("show_description")*/CHECK (true)
|
|
| 177 | 177 |
); |
| 178 | 178 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 179 | 179 |
|
| ... | ... | |
| 205 | 205 |
"ip" varchar(16) NOT NULL DEFAULT '', |
| 206 | 206 |
"app_id" integer DEFAULT NULL, |
| 207 | 207 |
PRIMARY KEY ("ip"),
|
| 208 |
"app_id_index" boolean
|
|
| 208 |
/*KEY "app_id" ("app_id")*/CHECK (true)
|
|
| 209 | 209 |
); |
| 210 | 210 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 211 | 211 |
|
| ... | ... | |
| 277 | 277 |
"group_admin_email" varchar(80) NOT NULL DEFAULT '', |
| 278 | 278 |
"allow_request" integer NOT NULL DEFAULT '0', |
| 279 | 279 |
PRIMARY KEY ("gid"),
|
| 280 |
"group_admin_email_index" boolean,
|
|
| 281 |
"allow_request_index" boolean
|
|
| 280 |
/*KEY "group_admin_email" ("group_admin_email")*/CHECK (true),
|
|
| 281 |
/*KEY "allow_request" ("allow_request")*/CHECK (true)
|
|
| 282 | 282 |
); |
| 283 | 283 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 284 | 284 |
|
| ... | ... | |
| 298 | 298 |
"action" varchar(40) DEFAULT NULL, |
| 299 | 299 |
"app_id" integer DEFAULT NULL, |
| 300 | 300 |
PRIMARY KEY ("log_id"),
|
| 301 |
"timestamp_index" boolean,
|
|
| 302 |
"app_id_index" boolean
|
|
| 301 |
/*CONSTRAINT "timestamp" */UNIQUE ("timestamp","ip"),
|
|
| 302 |
/*KEY "app_id" ("app_id")*/CHECK (true)
|
|
| 303 | 303 |
); |
| 304 | 304 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 305 | 305 |
|
| ... | ... | |
| 330 | 330 |
"Department" varchar(50) DEFAULT NULL, |
| 331 | 331 |
"spec_dq_priority" integer NOT NULL DEFAULT '0', |
| 332 | 332 |
PRIMARY KEY ("id"),
|
| 333 |
"login_index" boolean
|
|
| 333 |
/*CONSTRAINT "login" */UNIQUE ("username")
|
|
| 334 | 334 |
); |
| 335 | 335 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 336 | 336 |
|
| ... | ... | |
| 349 | 349 |
"tries" integer DEFAULT NULL, |
| 350 | 350 |
"nextlogin" integer DEFAULT NULL, |
| 351 | 351 |
PRIMARY KEY ("username","app_id"),
|
| 352 |
"ip_index" boolean
|
|
| 352 |
/*KEY "ip" ("ip")*/CHECK (true)
|
|
| 353 | 353 |
); |
| 354 | 354 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 355 | 355 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
Also available in: Unified diff
inputs/SALVIAS/: Regenerated salvias_*.schema.sql from the MySQL version, to take advantage of my2pg improvements. The placeholder *_index columns which take the place of MySQL's inline index definitions have now been replaced by no-op CHECK constraints, so that there are no longer lots of dummy *_index columns in the map spreadsheets.