<?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());
 
 
 
?>
 
 |