[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