[rt-users] Questions on custom table
Forrest Stanley
fstanley at netburner.com
Wed Nov 27 14:59:24 EST 2002
At 10:39 AM 11/27/2002 -0800, Forrest Stanley wrote:
>At 09:27 AM 11/27/2002 -0800, Forrest Stanley wrote:
>>I have created a custom table that stores serial numbers and customer
>>expiration dates. Most of it seems to be working fine, but I have run
>>into a problem or two.
>>
>> How can I maintain set the owner automatically when a serial
>> number is created? (Similair to the ways Owner and Creator are
>> automatically set in the Tickets Table) My first guess is that it has
>> something to do with Indexes in MySQL. For reference, here is how my
>> SerialNumber table is set up inside MySQL (in the rt2 database):
>>
>>CREATE TABLE SerialNumbers
>>(
>> id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
>> Number varchar(30) NOT NULL UNIQUE,
>> Owner int(11) NULL,
>> DateEntered timestamp default "00000000000000",
>> SptExpires timestamp default "00000000000000",
>> UpdExpires timestamp default "00000000000000",
>> Disabled smallint default "0"
>>)
>>type InnoDB;
>
>Well, as with the rule of asking for help, I solved this problem as soon
>as I posted it on the board... Work on it for a couple days, and the
>minute you ask for help, the answer just comes to you :) Still workin on
>the second problem though
>-FS
>
>
>
>
>> Also, I created a custom Serial Number page in the SelfService
>> Area. I added the page in
>> /WebRT/html/SelfService/SerialNumbers.html When I load this page, I
>> always get the entire SelfService front page, and then my
>> SerialNumber.html page on the bottom. Is there anything special I need
>> to do with Mason to say that I have added a new page? My header on
>> SerialNumber.html looks like this:
>>
>><& SelfService/Elements/Header, title => 'Serial Numbers' &>
>><& Elements/ListActions, actions => \@actions &>
>><& Elements/TitleBoxStart, title => "Modify Serial Numbers" &>
>>
>>html
>>.
>>.
typical, solved this one too :)
-FS
>>.
>>
>>Thanks for any help that I can get.
>>-Forrest Stanley
>>
>>_______________________________________________
>>rt-users mailing list
>>rt-users at lists.fsck.com
>>http://lists.fsck.com/mailman/listinfo/rt-users
>>
>>Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>
>_______________________________________________
>rt-users mailing list
>rt-users at lists.fsck.com
>http://lists.fsck.com/mailman/listinfo/rt-users
>
>Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
More information about the rt-users
mailing list