# SQLiteManager Dump
# Version: 1.2.0
# http://www.sqlitemanager.org/
#
# Host: localhost:8101
# Generation Time: Wednesday 17th 2017f May 2017 08:11 am
# SQLite Version: 2.8.17
# PHP Version: 5.2.6
# Database: Heroes.sqlite
# --------------------------------------------------------

#
# Table structure for table: Ability
#
DROP TABLE Ability;
CREATE TABLE Ability ( 'AbilityID' INTEGER NOT NULL PRIMARY KEY, 'CharacterID' INT, 'PowerID' INT );

#
# Dumping data for table: Ability
#
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('1', '1', '2');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('2', '1', '20');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('3', '1', '37');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('4', '2', '38');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('5', '2', '25');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('6', '3', '2');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('7', '4', '37');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('8', '6', '2');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('9', '6', '17');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('10', '7', '9');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('11', '7', '15');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('12', '8', '28');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('13', '8', '50');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('14', '8', '11');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('15', '9', '2');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('16', '9', '37');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('17', '10', '42');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('18', '11', '5');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('19', '11', '27');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('20', '12', '32');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('21', '13', '44');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('22', '13', '30');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('23', '14', '3');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('24', '14', '21');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('25', '15', '30');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('26', '15', '44');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('27', '16', '18');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('28', '16', '16');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('29', '17', '29');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('30', '17', '19');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('31', '18', '18');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('32', '18', '15');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('33', '18', '44');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('34', '19', '5');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('35', '19', '32');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('36', '19', '34');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('37', '19', '36');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('38', '20', '28');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('39', '20', '40');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('40', '21', '4');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('41', '21', '19');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('42', '22', '30');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('43', '22', '44');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('44', '23', '28');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('45', '23', '5');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('46', '23', '6');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('47', '24', '1');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('48', '25', '2');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('49', '25', '20');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('50', '26', '14');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('51', '26', '18');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('52', '26', '47');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('53', '27', '2');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('54', '27', '50');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('55', '27', '10');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('56', '28', '18');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('57', '28', '30');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('58', '29', '18');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('59', '29', '31');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('60', '29', '42');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('61', '29', '30');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('62', '29', '44');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('63', '30', '28');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('64', '30', '26');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('65', '31', '28');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('66', '32', '26');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('67', '33', '30');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('68', '33', '44');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('69', '34', '14');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('70', '34', '18');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('71', '34', '44');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('72', '34', '47');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('73', '35', '38');
INSERT INTO Ability (AbilityID, CharacterID, PowerID) VALUES ('74', '35', '43');
# --------------------------------------------------------


#
# Table structure for table: Alignment
#
DROP TABLE Alignment;
CREATE TABLE Alignment ( AlignmentID INTEGER NOT NULL PRIMARY KEY, Alignment TEXT );

#
# Dumping data for table: Alignment
#
INSERT INTO Alignment (AlignmentID, Alignment) VALUES ('1', 'Hero');
INSERT INTO Alignment (AlignmentID, Alignment) VALUES ('2', 'Villain');
INSERT INTO Alignment (AlignmentID, Alignment) VALUES ('3', 'Neutral');
# --------------------------------------------------------


#
# Table structure for table: Character
#
DROP TABLE Character;
CREATE TABLE Character ( Character VARCHAR(30) PRIMARY KEY, CharacterID INTEGER NOT NULL, Alias VARCHAR(80), Nickname VARCHAR(50), PublisherID INT, NationalityID INT, AlignmentID INT, Image TEXT DEFAULT 'NoImage.jpg' );

#
# Dumping data for table: Character
#
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Batman', '1', 'Bruce Wayne', 'the Dark Knight', '2', '1', '1', 'batman.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Blade', '2', 'Eric Brooks', 'the Daywalker', '1', '2', '3', 'superman.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Buffy', '3', 'Buffy Anne Summers', 'the VampireSlayer', '3', '1', '1', 'buffy.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Captain America', '4', 'Steve Rogers', 'the FirstAvenger', '1', '1', '1', 'captamerica.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Cyclops', '5', 'Scott Summers', 'Erik Red-Eye', '1', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Daredevil', '6', 'Matthew Michael Murdock', 'the Manwithout Fear', '1', '1', '1', 'daredevil.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Doctor Doom', '7', 'Victor Von Doom', 'The Master', '1', '5', '2', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Doctor Octopus', '8', 'Otto Octavius', 'The Master Planner', '1', '1', '2', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Elektra', '9', 'Elektra Natchios', 'Assassin', '1', '6', '3', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Flash', '10', 'Wallace Rudolph West', 'the Fastest Man Alive', '2', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Ghost Rider', '11', 'Jonathan Blaze', 'the Flaming Skull', '1', '7', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Green Goblin', '12', 'Barton Hamilton', 'Greenie', '1', '1', '2', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Hancock', '13', 'John Hancock', NULL, '4', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Hellboy', '14', 'Anung Un Rama', 'The Great Beast', '3', '7', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Hulk', '15', 'Robert Bruce Banner', NULL, '1', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Human Torch', '16', 'Jonathan Lowell Spencer Storm', 'Matchstick', '1', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Invisible Woman', '17', 'Susan Storm Richards', NULL, '1', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Iron Man', '18', 'Anthony Edward Stark', 'the Crimson Dynamo', '1', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Jean Grey', '19', 'Jean Grey-Summers', NULL, '1', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Loki', '20', 'Loki Laufeyson', 'God of Mischief', '1', '3', '2', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Magneto', '21', 'Erik Magnus Lensherr', 'Hammer-bearer', '1', '1', '2', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Mr Incredible', '22', 'Robert Parr', 'The Hero''s Hero', '3', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Professor X', '23', 'Charles Francis Xavier', 'Doctor X', '1', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Punisher', '24', 'Frank Castle (Francis Castiglione)', NULL, '1', '1', '3', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Robin', '25', 'Dick Grayson', 'the Boy Wonder', '2', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Silver Surfer', '26', 'Norrin Radd', 'Sentinel of the Spaceways', '1', '4', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Spiderman', '27', 'Peter Benjamin Parker', 'the Web-slinger', '1', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Supergirl', '28', 'Kara Zor-El', 'the Maid of Might', '2', '4', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Superman', '29', 'Clark Joseph Kent (Born Kal-El)', 'the Man of Steel', '2', '4', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('The Joker', '30', 'Jack Napier', 'the Clown Prince of Crime', '2', '1', '2', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('The Penguin', '31', 'Oswald Chesterfield Cobblepot', NULL, '2', '1', '2', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('The Riddler', '32', 'Edward Nigma', 'E.Nigma', '2', '1', '2', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Thing', '33', 'Benjamin Jacob Grimm', 'The ever loving blue-eyed Thing', '1', '1', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Thor', '34', 'Thor Odinson', 'the Prince of Asgard', '1', '3', '1', 'NoImage.jpg');
INSERT INTO Character (Character, CharacterID, Alias, Nickname, PublisherID, NationalityID, AlignmentID, Image) VALUES ('Wolverine', '35', 'James Howlett (Logan)', 'Weapon X', '1', '8', '1', 'NoImage.jpg');
# --------------------------------------------------------


#
# Table structure for table: Dummy
#
DROP TABLE Dummy;
CREATE TABLE Dummy ( DummyID TEXT );

#
# Dumping data for table: Dummy
#
INSERT INTO Dummy (DummyID) VALUES ('some text');
# --------------------------------------------------------


#
# Table structure for table: Nationality
#
DROP TABLE Nationality;
CREATE TABLE Nationality ( NationalityID INTEGER NOT NULL PRIMARY KEY, Nationality TEXT );

#
# Dumping data for table: Nationality
#
INSERT INTO Nationality (NationalityID, Nationality) VALUES ('1', 'American');
INSERT INTO Nationality (NationalityID, Nationality) VALUES ('2', 'British');
INSERT INTO Nationality (NationalityID, Nationality) VALUES ('3', 'Asgardian');
INSERT INTO Nationality (NationalityID, Nationality) VALUES ('4', 'Alien');
INSERT INTO Nationality (NationalityID, Nationality) VALUES ('5', 'Latverian');
INSERT INTO Nationality (NationalityID, Nationality) VALUES ('6', 'Greek');
INSERT INTO Nationality (NationalityID, Nationality) VALUES ('7', 'Demon');
INSERT INTO Nationality (NationalityID, Nationality) VALUES ('8', 'Canadian');
INSERT INTO Nationality (NationalityID, Nationality) VALUES ('9', 'Amazonian');
# --------------------------------------------------------


#
# Table structure for table: Power
#
DROP TABLE Power;
CREATE TABLE Power ( 'Power' VARCHAR(20), 'PowerID' INTEGER NOT NULL PRIMARY KEY );

#
# Dumping data for table: Power
#
INSERT INTO Power (Power, PowerID) VALUES ('Accuracy', '1');
INSERT INTO Power (Power, PowerID) VALUES ('Agility', '2');
INSERT INTO Power (Power, PowerID) VALUES ('Animal Attributes', '3');
INSERT INTO Power (Power, PowerID) VALUES ('Anti-Gravity', '4');
INSERT INTO Power (Power, PowerID) VALUES ('Astral Projection', '5');
INSERT INTO Power (Power, PowerID) VALUES ('Astral Travel', '6');
INSERT INTO Power (Power, PowerID) VALUES ('Camouflage', '7');
INSERT INTO Power (Power, PowerID) VALUES ('Clairvoyance', '8');
INSERT INTO Power (Power, PowerID) VALUES ('Cold Resistance', '9');
INSERT INTO Power (Power, PowerID) VALUES ('Danger Sense', '10');
INSERT INTO Power (Power, PowerID) VALUES ('Dexterity', '11');
INSERT INTO Power (Power, PowerID) VALUES ('Elasticity', '12');
INSERT INTO Power (Power, PowerID) VALUES ('Empathy', '13');
INSERT INTO Power (Power, PowerID) VALUES ('Endurance', '14');
INSERT INTO Power (Power, PowerID) VALUES ('Energy Blasts', '15');
INSERT INTO Power (Power, PowerID) VALUES ('Energy Manipulation', '16');
INSERT INTO Power (Power, PowerID) VALUES ('Enhanced Senses', '17');
INSERT INTO Power (Power, PowerID) VALUES ('Flight', '18');
INSERT INTO Power (Power, PowerID) VALUES ('Force Fields', '19');
INSERT INTO Power (Power, PowerID) VALUES ('Gliding', '20');
INSERT INTO Power (Power, PowerID) VALUES ('Healing Factor', '21');
INSERT INTO Power (Power, PowerID) VALUES ('Hearing', '22');
INSERT INTO Power (Power, PowerID) VALUES ('Illumination', '23');
INSERT INTO Power (Power, PowerID) VALUES ('Illusions', '24');
INSERT INTO Power (Power, PowerID) VALUES ('Immortality', '25');
INSERT INTO Power (Power, PowerID) VALUES ('Insanity', '26');
INSERT INTO Power (Power, PowerID) VALUES ('Intangibility', '27');
INSERT INTO Power (Power, PowerID) VALUES ('Intelligence', '28');
INSERT INTO Power (Power, PowerID) VALUES ('Invisibility', '29');
INSERT INTO Power (Power, PowerID) VALUES ('Invulnerability', '30');
INSERT INTO Power (Power, PowerID) VALUES ('Jump', '31');
INSERT INTO Power (Power, PowerID) VALUES ('Levitation', '32');
INSERT INTO Power (Power, PowerID) VALUES ('Magic', '33');
INSERT INTO Power (Power, PowerID) VALUES ('Mind Control', '34');
INSERT INTO Power (Power, PowerID) VALUES ('Night Vision', '35');
INSERT INTO Power (Power, PowerID) VALUES ('Psionic Powers', '36');
INSERT INTO Power (Power, PowerID) VALUES ('Reflexes', '37');
INSERT INTO Power (Power, PowerID) VALUES ('Regeneration', '38');
INSERT INTO Power (Power, PowerID) VALUES ('Resurrection', '39');
INSERT INTO Power (Power, PowerID) VALUES ('Shapeshifting', '40');
INSERT INTO Power (Power, PowerID) VALUES ('Size Changing', '41');
INSERT INTO Power (Power, PowerID) VALUES ('Speed', '42');
INSERT INTO Power (Power, PowerID) VALUES ('Stamina', '43');
INSERT INTO Power (Power, PowerID) VALUES ('Strength', '44');
INSERT INTO Power (Power, PowerID) VALUES ('Telekinesis', '45');
INSERT INTO Power (Power, PowerID) VALUES ('Telepathy', '46');
INSERT INTO Power (Power, PowerID) VALUES ('Teleportation', '47');
INSERT INTO Power (Power, PowerID) VALUES ('Time Travel', '48');
INSERT INTO Power (Power, PowerID) VALUES ('Underwater breathing', '49');
INSERT INTO Power (Power, PowerID) VALUES ('Wallcrawling', '50');
INSERT INTO Power (Power, PowerID) VALUES ('X-ray vision', '51');
# --------------------------------------------------------


#
# Table structure for table: Publisher
#
DROP TABLE Publisher;
CREATE TABLE Publisher ( PublisherID INTEGER NOT NULL PRIMARY KEY, Publisher TEXT );

#
# Dumping data for table: Publisher
#
INSERT INTO Publisher (PublisherID, Publisher) VALUES ('1', 'Marvel');
INSERT INTO Publisher (PublisherID, Publisher) VALUES ('2', 'DC Comics');
INSERT INTO Publisher (PublisherID, Publisher) VALUES ('3', 'Dark Horse Presents');
INSERT INTO Publisher (PublisherID, Publisher) VALUES ('4', 'Sony Pictures');
# --------------------------------------------------------


#
# View structure for view: Doctors
#
DROP VIEW ;
CREATE VIEW Doctors AS SELECT Character . Character , Character . Nickname , Character . Alias , Nationality . Nationality , Power . Power , Alignment . Alignment , Publisher . Publisher FROM Character NATURAL JOIN Ability NATURAL JOIN Power INNER JOIN Alignment ON Character . AlignmentID = Alignment . AlignmentID INNER JOIN Publisher ON Character . PublisherID = Publisher . PublisherID INNER JOIN Nationality ON Character . NationalityID = Nationality . NationalityID WHERE Character LIKE "%doc%" OR Nickname LIKE "%doc%" LIMIT 0 , 200;

#
# View structure for view: Flyers
#
DROP VIEW ;
CREATE VIEW Flyers AS SELECT Character . Character , Character . Nickname , Character . Alias , Nationality . Nationality , Power . Power , Alignment . Alignment , Publisher . Publisher FROM Character NATURAL JOIN Ability NATURAL JOIN Power INNER JOIN Alignment ON Character . AlignmentID = Alignment . AlignmentID INNER JOIN Publisher ON Character . PublisherID = Publisher . PublisherID INNER JOIN Nationality ON Character . NationalityID = Nationality . NationalityID WHERE Power.Power = "Flight" OR Power.Power="Levitation" OR Power.Power="Gliding" LIMIT 0 , 200;

#
# View structure for view: Heroes_Powers
#
DROP VIEW ;
CREATE VIEW Heroes_Powers AS SELECT Character.Character, Character.NickName, Power.Power FROM Character NATURAL JOIN Ability NATURAL JOIN Power LIMIT 0 , 20;

#
# View structure for view: Heroes_Rollcall
#
DROP VIEW ;
CREATE VIEW Heroes_Rollcall AS SELECT * FROM Character NATURAL JOIN Ability NATURAL JOIN Power INNER JOIN Alignment ON Character . AlignmentID = Alignment . AlignmentID INNER JOIN Publisher ON Character . PublisherID = Publisher . PublisherID INNER JOIN Nationality ON Character . NationalityID = Nationality . NationalityID WHERE Alignment . Alignment = "Hero" ORDER BY Nationality.Nationality DESC LIMIT 0 , 20;

#
# View structure for view: Heros
#
DROP VIEW ;
CREATE VIEW Heros AS SELECT Character . Character , Character . Nickname , Character . Alias , Nationality.Nationality, Power . Power, Alignment.Alignment, Publisher.Publisher FROM Character NATURAL JOIN Ability NATURAL JOIN Power INNER JOIN Alignment ON Character.AlignmentID = Alignment.AlignmentID INNER JOIN Publisher ON Character.PublisherID = Publisher.PublisherID INNER JOIN Nationality ON Character.NationalityID = Nationality.NationalityID WHERE Alignment.Alignment = "Hero" LIMIT 0 , 200;

#
# View structure for view: Non_Americans
#
DROP VIEW ;
CREATE VIEW Non_Americans AS SELECT Character . Character , Character . Nickname , Character . Alias , Nationality . Nationality , Power . Power , Alignment . Alignment , Publisher . Publisher FROM Character NATURAL JOIN Ability NATURAL JOIN Power INNER JOIN Alignment ON Character . AlignmentID = Alignment . AlignmentID INNER JOIN Publisher ON Character . PublisherID = Publisher . PublisherID INNER JOIN Nationality ON Character . NationalityID = Nationality . NationalityID WHERE Nationality != "American" AND Nationality !="Demon" AND Nationality != "Alien" LIMIT 0 , 200;

#
# View structure for view: SuperCharacters
#
DROP VIEW ;
CREATE VIEW SuperCharacters AS SELECT DISTINCT Character . CharacterID , Character . Character , Character . Nickname , Character . Alias , Character.Image, Nationality . Nationality , Alignment . Alignment , Publisher . Publisher FROM Character NATURAL JOIN Ability INNER JOIN Alignment ON Character . AlignmentID = Alignment . AlignmentID INNER JOIN Publisher ON Character . PublisherID = Publisher . PublisherID INNER JOIN Nationality ON Character . NationalityID = Nationality . NationalityID;

#
# View structure for view: SuperPoweredCharacters
#
DROP VIEW ;
CREATE VIEW SuperPoweredCharacters AS SELECT DISTINCT Character.CharacterID, Character . Character , Character . Nickname , Character . Alias , Nationality . Nationality , Alignment . Alignment , Publisher . Publisher FROM Character NATURAL JOIN Ability INNER JOIN Alignment ON Character . AlignmentID = Alignment . AlignmentID INNER JOIN Publisher ON Character . PublisherID = Publisher . PublisherID INNER JOIN Nationality ON Character . NationalityID = Nationality . NationalityID;

#
# View structure for view: Villains
#
DROP VIEW ;
CREATE VIEW Villains AS SELECT Character . Character , Character . Nickname , Character . Alias , Nationality . Nationality , Power . Power , Alignment . Alignment , Publisher . Publisher FROM Character NATURAL JOIN Ability NATURAL JOIN Power INNER JOIN Alignment ON Character . AlignmentID = Alignment . AlignmentID INNER JOIN Publisher ON Character . PublisherID = Publisher . PublisherID INNER JOIN Nationality ON Character . NationalityID = Nationality . NationalityID WHERE Alignment . Alignment = "Villain" LIMIT 0 , 200;

#
# User Defined Function properties: md5rev
#
/*
function md5_and_reverse($string) { return strrev(md5($string)); }
*/

#
# User Defined Function properties: IF
#
/*
function sqliteIf($compare, $good, $bad){ if ($compare) { return $good; } else { return $bad; } }
*/