| Index: branches/RL2/extensions/Gadgets/sql/gadgets.sql |
| — | — | @@ -3,10 +3,13 @@ |
| 4 | 4 | CREATE TABLE /*_*/gadgets ( |
| 5 | 5 | -- Name of gadget. Cannot be changed, ever. |
| 6 | 6 | gd_name varchar(255) binary NOT NULL PRIMARY KEY, |
| 7 | | - -- JSON blob with gadget properties. See (TODO: fill this) for documentation on the format |
| | 7 | + -- JSON blob with gadget properties. See Gadget::__construct() for documentation on the format |
| 8 | 8 | gd_blob mediumblob NOT NULL, |
| 9 | | - -- Whether or not this gadget is global (called 'shared' in the interface) |
| 10 | | - gd_global bool NOT NULL |
| | 9 | + -- Whether or not this gadget is allowed to be shared through a foreign repository |
| | 10 | + gd_shared bool NOT NULL, |
| | 11 | + -- The timestamp of when the metadata was last changed. Used for conflict detection and cache invalidation |
| | 12 | + gd_timestamp binary(14) NOT NULL |
| 11 | 13 | ) /*$wgDBTableOptions*/; |
| 12 | 14 | |
| 13 | | -CREATE INDEX /*i*/gd_global_name ON /*_*/gadgets (gd_global, gd_name); |
| | 15 | +CREATE INDEX /*i*/gd_shared_name ON /*_*/gadgets (gd_shared, gd_name); |
| | 16 | +CREATE INDEX /*i*/gd_name_timestamp ON /*_*/gadgets (gd_name, gd_timestamp); |