MySQL Commands

create database pcs;    # Create the database.

use pcs;                # Use the newly created database.

create table item       # Create the item table.
(
    itemid int(10) unsigned auto_increment,
    item varchar(30) not null default '',
    specification varchar(100) not null default '',
    baseprice double not null default '0.00',
    actualprice double not null default '0.00',
    supplierid int(10) unsigned not null default '0',
    primary key(itemid),
    unique key(item, specification, supplierid)
);

create table supplier   # Create the supplier table.
(
    supplierid int(10) unsigned auto_increment,
    name varchar(50) not null default '',
    owner varchar(50) not null default '',
    address varchar(50) not null default '',
    phone1 varchar(15) not null default '',
    phone2 varchar(15),
    phone3 varchar(15),
    phone4 varchar(15),
    email varchar(25),
    primary key(supplierid),
    unique key(name, owner)
);

Back to ADO Tutorial

Copyright 2003-2004 Mark Jundo P. Documento