Questions on custom table

RT Users
1

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;

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

2

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 :slight_smile: Still workin on the
second problem though
-FS

3

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 :slight_smile: 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 :slight_smile:
-FS

4

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 :slight_smile: Still workin on
the second problem though

typical, solved this one too :slight_smile:

And the solutions for those following the archives are?

( if you find a solution, we’d love to see it in case it helps other
people )

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B             Operations/Security