[rt-users] Questions on custom table

[Forrest Stanley]

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
>.
>.
>.
>
>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