Help with MySQL script
| From: | wyonker at dcs dot penguinpowered dot com | Date: | Tue, 25 Jul 2000 12:37:36 +0000 |
| Subject: | Help with MySQL script | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1475@lists.php.net to get a copy of this message | ||
<?php
require('common.inc');
?>
<?php
$link = mysql_connect ($server, $username,
$password);
if($link == '1')
{
print ("Connected to database.<br>");
$result = mysql_db_query ($database ,
"CREATE TABLE Customers(
CustomerID INT(10) unsigned NOT NULL
DEFAULT 0 AUTO_INCREMENT,
PRIMARY KEY(CustomerID),
First varchar(30) NULL DEFAULT NULL,
Mid char(1) NULL DEFAULT NULL,
Last varchar(40) NULL DEFAULT NULL,
Address varchar(255) NULL DEFAULT NULL,
Telephone varchar(16) NULL DEFAULT NULL,
Fax varchar(16) NULL DEFAULT NULL,
Email varchar(100) NULL DEFAULT NULL,
City varchar(50) NULL DEFAULT NULL,
State char(2) NULL DEFAULT NULL,
Zip varchar(10) NULL DEFAULT NULL,
Status varchar(20) NULL DEFAULT NULL,
UNIQUE id (CustomerID))");
if($result == '1')
{
print("Customers table created.<br>");
}
$result = mysql_db_query ($database ,
"CREATE TABLE Invoices(
InvoiceID int(10) unsigned NOT NULL
DEFAULT 0 AUTO_INCREMENT,
PRIMARY KEY(InvoiceID),
UNIQUE InvoiceID (InvoiceID),
CustomerID int(10) unsigned NOT NULL
DEFAULT 0,
Description varchar(100) NULL DEFAULT NULL,
DateBilled date NULL DEFAULT NULL,
Amount float(5,2) NULL DEFAULT NULL)");
if($result == '1')
{
print("Invoices table created.<br>");
}
$result = mysql_db_query ($database ,
"CREATE TABLE Payments(
PaymentID int(10) unsigned NOT NULL
DEFAULT 0 AUTO_INCREMENT,
PRIMARY KEY(PaymentID),
UNIQUE PaymentID (PaymentID),
CustomerID int(10) unsigned NOT NULL
DEFAULT 0,
DatePaid date NULL DEFAULT NULL,
Type varchar(10) NULL DEFAULT NULL,
Number varchar(50) NULL DEFAULT NULL,
Amount float(5,2) NULL DEFAULT NULL)");
if($result == '1')
{
print("Payments table created.<br>");
}
$result = mysql_db_query ($database ,
"CREATE TABLE Tickets(
TicketID int(10) unsigned NOT NULL
DEFAULT 0 AUTO_INCREMENT,
PRIMARY KEY(TicketID),
UNIQUE TicketID (TicketID),
CustomerID int(10) unsigned NOT NULL
DEFAULT 0,
Description varchar(100) NULL DEFAULT
NULL,
Status varchar(10) NULL DEFALUT NULL,
OpenDate date NULL DEFAULT NULL,
OpenTime time NULL DEFAULT NULL,
CloseDate date NULL DEFAULT NULL,
CloseTime time NULL DEFAULT NULL,
Opener varchar(100) NULL DEFAULT
NULL)");
if($result == '1')
{
print("Tickets table created.<br>");
}
else
{
print($result);
}
$result = mysql_db_query ($database ,
"CREATE TABLE Rollback(
RollbackID int(10) unsigned NOT NULL
DEFAULT 0 AUTO_INCREMENT,
PRIMARY KEY(RollbackID),
Description varchar(100) NULL DEFAULT
NULL,
RestoreStatement blob NULL DEFAULT NULL,
When datetime NULL DEFAULT NULL)");
if($result == '1')
{
print("Rollback table created.<br>");
}
$result = mysql_db_query ($database ,
"CREATE TABLE Accounts(
AccountID int(10) unsigned NOT NULL
DEFAULT 0 AUTO_INCREMENT,
PRIMARY KEY(AccountID),
UNIQUE AccountID (AccountID),
CustomerID int(10) unsigned,
Username varchar(50),
Password varchar(50),
Description varhcar(100),
DateOpened date,
DateClosed date,
Price float(5,2),
Status varchar(25),
Charged varchar(15) DEFAULT '' NOT NULL)");
if($result == '1')
{
print("Accounts table created.<br>");
}
$result = mysql_db_query ($database ,
"CREATE TABLE Configuration(
Version varchar(50),
BillAhead enum('On','Off'),
Language varchar(50))");
if($result == '1')
{
print("Configuration table
created.<br>");
}
}
else
{
print("Unable to connect to database.
<br><br>Exiting.<br>");
}
?>
There is the script. It does not create the
Tickets or Accounts tables. I have no idea why.
Can someone enlighten me?