08:26.39 | *** join/#debian-bots simonrvn_ (i=simon@unaffiliated/simonrvn) |
08:28.48 | *** join/#debian-bots simonrvn1 (n=simon@219.55-ppp.3menatwork.com) |
08:45.56 | *** join/#debian-bots ravenbird (i=ravenbir@unaffiliated/simonrvn/bot/ravenbird) |
11:04.52 | *** join/#debian-bots dpkg (n=dpkg@unaffiliated/dpkg) |
11:10.53 | *** join/#debian-bots streuner (n=streuner@p54A5CEC0.dip.t-dialin.net) |
11:14.27 | *** join/#debian-bots _z_ (n=chatzill@85.222.163.190) |
11:16.00 | _z_ | folks, anybody tried blootbot with sqlite? |
11:19.56 | *** part/#debian-bots _z_ (n=chatzill@85.222.163.190) |
12:35.14 | *** join/#debian-bots greycat (i=rfc1413@wooledge.org) |
17:33.17 | troubled | dondelelcaro: for your viewing pleasure: http://picpaste.com/box.jpg :) |
19:47.54 | CIA-45 | 03timriker * r1642 10/trunk/src/CommandStubs.pl: revert partial messagecount patch |
19:56.15 | *** join/#debian-bots ravenbird (i=ravenbir@unaffiliated/simonrvn/bot/ravenbird) |
20:30.37 | CIA-45 | 03djmcgrath * r1643 10/trunk/setup/ (mysql/seen.sql pgsql/seen.sql sqlite/seen.sql): |
20:30.37 | CIA-45 | * Synced schema for seen table in other engines to match sqlite2 schema (PKEY only nick now) |
20:30.37 | CIA-45 | * Removed extra pgsql fields in schema for stats |
21:09.31 | *** part/#debian-bots streuner (n=streuner@p54A5CEC0.dip.t-dialin.net) |
21:25.09 | dondelelcaro | troubled: heh |
21:29.28 | troubled | btw, I checked a "select max(length(created_by)) from factoids;" (and modified/requested/locked_by) for tim's db, and the biggest he has is a 93. But ill set everything to 100 just for people carrying legacy db's should they decide to convert. I think the caclulated max for freenode should be like 79 or 80 (16!8@63). just thought you should know |
21:30.47 | troubled | also, im about to commit a patch for allowing nulls in most of the fields, and make it the default. should also help import a db with mixed nulls. |
21:30.55 | dondelelcaro | yeah, mine is 79 |
21:33.24 | troubled | ya, tim seems to have a db with entries from so many diff code revs it kinda needs to take him into consideration too. 100's safe anyways. its only a varchar, not a char so its not like its wasting space |
21:36.46 | troubled | dondelelcaro: could you do a max(length) check on your factoid_key field? tim seems to have a 78 there and the schema is 64. Might bump to 100 as well if you see no problems with that |
21:45.14 | dondelelcaro | yeah, I've got 64 |
21:50.10 | CIA-45 | 03djmcgrath * r1644 10/trunk/setup/ (4 files in 4 dirs): |
21:50.10 | CIA-45 | * Moved all VARCHAR fields to 100 size for easier legacy db upgrades (should handle max freenode sizes and then some) |
21:50.10 | CIA-45 | * Removed pgsql specific REVOKE from PUBLIC sql (users should make that decision) |
21:50.10 | CIA-45 | * Removed NOT NULL constraint from all but requested_count in factoids table |
21:50.10 | CIA-45 | * Most fields now default to NULL to allow for easier finding of problems, DB cleanup and importing of inconsisting |
21:50.15 | CIA-45 | DBs |
23:24.44 | CIA-45 | 03djmcgrath * r1645 10/branches/don/proposed/ (33 files in 10 dirs): * Merged r1634:1644 from trunk |