Changeset 1312 for branches/4.0
- Timestamp:
- 04/02/15 15:48:01 (9 years ago)
- Location:
- branches/4.0/LATMOS-Accounts
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/4.0/LATMOS-Accounts/bin/la-sql-log
r1299 r1312 56 56 57 57 foreach(@logs) { 58 printf("%s %s: %s/%s (%d) %s\n",58 printf("%s (%d), %s: %s/%s (%d) %s\n", 59 59 $_->{logdate}, 60 $_->{irev} || -1, 60 61 $_->{username}, 61 62 $_->{otype}, -
branches/4.0/LATMOS-Accounts/bin/la-sql-upgrade.in
r1225 r1312 202 202 ALTER TABLE revaliases ADD COLUMN description text; 203 203 }, 204 ],205 },206 {207 ver => 7,208 sql => [209 204 q{ 210 205 CREATE OR REPLACE FUNCTION group_sort_fields() … … 259 254 ], 260 255 }, 261 256 { 257 ver => 8, 258 sql => [ 259 q{ 260 CREATE TABLE objectslogs 261 ( 262 logkey SERIAL NOT NULL, 263 ikey bigint NOT NULL, 264 irev bigint, 265 otype text NOT NULL, 266 name text NOT NULL, 267 changetype text NOT NULL, 268 username text NOT NULL, 269 message text NOT NULL, 270 logdate timestamp with time zone NOT NULL DEFAULT now(), 271 CONSTRAINT objectlogs_pkey PRIMARY KEY (logkey) 272 );}, 273 q{ 274 CREATE INDEX objectlogs_name_idx 275 ON objectslogs 276 USING btree 277 (name); 278 }, 279 q{ 280 CREATE INDEX objectslogs_ikey_idx 281 ON objectslogs 282 USING btree 283 (ikey); 284 }, 285 q{ 286 CREATE INDEX objectslogs_otype_idx 287 ON objectslogs 288 USING btree 289 (otype); 290 } 291 ], 292 }, 262 293 ); 263 294 -
branches/4.0/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql.pm
r1310 r1312 649 649 650 650 my $sth = $self->db->prepare(q{ 651 INSERT into objectslogs (ikey, otype, name, changetype, username, message)652 VALUES (?,?,?,?,?,? )651 INSERT into objectslogs (ikey, irev, otype, name, changetype, username, message) 652 VALUES (?,?,?,?,?,?,?) 653 653 }); 654 654 655 655 $sth->execute( 656 656 $ref, 657 $self->current_rev, 657 658 $otype, 658 659 $name,
Note: See TracChangeset
for help on using the changeset viewer.