<?php
@mysql_connect('localhost', 'root', '');
@mysql_select_db('Put here the dabase name');
@mysql_query("drop table if exists products");
@mysql_query("
create table products(
productid int(10) unsigned not null auto_increment,
title varchar(100) not null,
version varchar(100) not null,
url varchar(100) not null,
description text,
installcode text,
unistallcode text,
PRIMARY KEY (productid)
)") or die(mysql_error());
@mysql_query("drop table if exists plugins");
@mysql_query("
create table plugins(
pluginid int(10) unsigned not null auto_increment,
productid int(100) not null default '0',
place varchar(100) not null,
title varchar(100) not null,
phpcode text,
status int(100) not null default '0',
PRIMARY KEY (pluginid)
)") or die(mysql_error());
?>
|