NP8kSx4D

1<?php
2require 'db.inc1.php'
3
4$db = mysql_connect(MYSQL_HOT, MYSQL_USER, MYSQL_PASSWORD) or
5	die ('unable to connect. Check your connection parameters.');
6mysql_select_db(MYSQL_DB, $db) or die(mysql_error($db));
7
8//crea la tabella comic_character
9$query = 'CREATE TABLE IF NOT EXISTS comic_character (
10	character_id	INTEGER UNSIGNED	NOT NULL AUTO_INCREMENT,
11	alias			VARCHAR(40)			NOT NULL DEFAULT "",
12	real_name		VARCHAR(80)			NOT NULL DEFAULT "",
13	lair_id			INTEGER UNSIGNED	NOT NULL DEFAULT 0,
14	alignment	ENUM("good", "evil") 	NOT NULL DEFAULT "good",
15	
16	PRIMARY KEY (character_id)
17	)
18	ENGINE=MyISAM';
19mysql_query($query, $db) or die (mysql_error($db));
20
21//crea la tabella comic_power
22$query ='CREATE TABLE IF NOT EXISTS comic_power (
23	power_id	INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
24	power		VARCHAR(40)		 NOT NULL DEFAULT "",
25	
26	PRIMARY KEY (power_id)
27	)
28	ENGINE=MyISAM';
29mysql_query($query, $db) or die (mysql_error($db));
30
31//crea la tabella di collegamento comic_character_power
32$query = 'CREATE TABLE IF NOT EXISTS comic_character_power (
33	character_id	INTEGER UNSIGNED NOT NULL DEFAULT 0,
34	power_id		INTEGER UNSIGNED NOT NULL DEFAUL 0,
35	
36	PRIMARY KEY (character_id, power_id)
37	)
38	ENGINE=MyISAM';
39mysql_query($query, $db) or die (mysql_error($db));
40
41//crea la tabella comic_lair
42$query ='CREATE TABLE IF NOT EXIST comic_lair (
43	lair_id		INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
44	zipcode_id	CHAR(5)			 NOT NULL DEFAULT "00000",
45	address		VARCHAR(40)		 NOT NULL DEFAULT "",
46	
47	PRIMARY KEY (lair_id)
48	)
49	ENGINE=MyISAM';
50mysql_query($query, $db) or die (mysql_error($db));
51
52//crea tabella comic_zipcode
53$query = 'CREATE TABLE IF NOT EXISTS comic_zipcode (
54	zipcode_id	CHAR(5)		NOT NULL DEFAULT "00000",
55	city		VARCHAR(40)	NOT NULL DEFAULT "",
56	state		CHAR(2)		NOT NULL DEFAULT "",
57	
58	PRIMAY KEY (zipcode_id)
59	)
60	ENGINE=MyISAM';
61mysql_query($query, $db) or die (mysql_error($db));
62
63//crea la tabella comic_rivalry
64$query = 'CREATE TABLE IF NOT EXISTS comic_rivalry (
65	hero_id		INTEGER UNSIGNED NOT NULL DEFAULT 0,
66	villain_id	INTEGER UNSIGNED NOT NULL DEFAULT 0,
67	
68	PRIMARY KEY (hero_id, villain_id)
69	)
70	ENGINE=MyISAM';
71mysql_query($query, $db) or die (mysql_error($db));
72
73echo 'Done.';
74?>