create database vas2;
grant select,delete,update,insert on vas2.* to 'vasuser'@'localhost' identified by 'vaspass';
use vas2;
create table user(
username varchar(25) not null primary key,
password varchar(16) not null
);

create table links(
id int(3) not null auto_increment,
linkname varchar(50) not null,
position smallint(2) not null,
primary key(id)
);

create table sublink(
id int(3) not null auto_increment,
parentid int(3) not null,
linkname varchar(50) not null,
linkbody text,
picturepath varchar(50) not null,
primary key(id)
);

create table newscontent(
id int(3) not null auto_increment,
newsbody text,
priority enum('Lastest','New','Old') default 'Lastest',
primary key(id)
);

create table productlist(
id int(3)
);