TABLE PROBLEM

zacht8702

hey i got a script i needed.... it looks fine but i noticed things werent working so i checked the Database and of course the script hadnt installed tables on the db/
here is what i need installed though.
CREATE TABLE outwar_users (
  id int(10) unsigned NOT NULL auto_increment,
  name text NOT NULL,
  password text NOT NULL,
  link text NOT NULL,
  credits decimal(11,2) NOT NULL default '0.00',
  credits_earned int(11) NOT NULL default '0',
  hits_given int(11) NOT NULL default '0',
  last_noframe int(11) NOT NULL default '0',
  ads_removed int(11) NOT NULL default '0',
  hits_per_view decimal(11,2) NOT NULL default '0.80',
  member_type text NOT NULL,
  sec int(11) NOT NULL default '0',
  max_sec int(11) NOT NULL default '0',
  hit_sec int(11) NOT NULL default '0',
  ref text NOT NULL,
  num_referrals int(11) NOT NULL default '0',
  x1 text NOT NULL,
  x2 text NOT NULL,
  save int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `outwar_users`
#

INSERT INTO outwar_users VALUES (1, 'setup_1', '1', 'http://www.outwar.com/', '4', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (2, 'setup_2', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (3, 'setup_3', '1', 'http://www.outwar.com/', '3', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (4, 'setup_4', '1', 'http://www.outwar.com/', '2', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (5, 'setup_5', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (6, 'setup_6', '1', 'http://www.outwar.com/', '2', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (7, 'setup_7', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (8, 'setup_8', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (9, 'setup_9', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (10, 'setup_10', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (11, 'setup_11', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (12, 'setup_12', '1', 'http://www.outwar.com/', '2', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (13, 'setup_13', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (14, 'setup_14', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (15, 'setup_15', '1', 'http://www.outwar.com/', '5', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (16, 'setup_16', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (17, 'setup_17', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (18, 'setup_18', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0,
357A
 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (19, 'setup_19', '1', 'http://www.outwar.com/', '2', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (20, 'setup_20', '1', 'http://www.outwar.com/', '3', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (21, 'setup_21', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (22, 'setup_22', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);

INSERT INTO outwar_users VALUES (23, 'xsetup_1', '1', 'http://www.outwar.com/', '3', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (24, 'xsetup_2', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (25, 'xsetup_3', '1', 'http://www.outwar.com/', '3', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (26, 'xsetup_4', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (27, 'xsetup_5', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (28, 'xsetup_6', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (29, 'xsetup_7', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (30, 'xsetup_8', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (31, 'xsetup_9', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (32, 'xsetup_10', '1', 'http://www.outwar.com/', '2', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (33, 'xsetup_11', '1', 'http://www.outwar.com/', '4', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (34, 'xsetup_12', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (35, 'xsetup_13', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (36, 'xsetup_14', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (37, 'xsetup_15', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (38, 'xsetup_16', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (39, 'xsetup_17', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (40, 'xsetup_18', '1', 'http://www.outwar.com/', '3', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (41, 'xsetup_19', '1', 'http://www.outwar.com/', '5', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (42, 'xsetup_20', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (43, 'xsetup_21', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (44, 'xsetup_22', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);

INSERT INTO outwar_users VALUES (45, 'tsetup_1', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (46, 'tsetup_2', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (47, 'tsetup_3', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (48, 'tsetup_4', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (49, 'tsetup_5', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (50, 'tsetup_6', '1', 'http://www.outwar.com/', '2', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (51, 'tsetup_7', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (52, 'tsetup_8', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (53, 'tsetup_9', '1', 'http://www.outwar.com/', '1', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (54, 'tsetup_10', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (55, 'tsetup_11', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);
INSERT INTO outwar_users VALUES (56, 'tsetup_12', '1', 'http://www.outwar.com/', '0', 0, 0, 0, 0, '1.00', 'basic', 0, 0, 0, '', 0, '', '0', 0);




 I REMOVED A LOT OF THE INSERT THINGS ABOVE DUE TO GOING OVER CHARACTER LIMIT
is it possible to manually put that in tables? i think the install file was lost somewhere.. Anywyas thats a query.sql file. maybe itwould be easier to make a new installl?
Let me know what i can do.
zhabala

You can use mysqladmin or pgsqladmin to execute your script depending on what database system you are using.
Zdenek
zacht8702

how would i do that?
its running mysql on linux
rachel2004

Does the database already exist in your MySQL server? If yes, then simply save your file on the server and then SSH to your server and issue the following statement:
mysql db_name < /my/dir/to/script.sql -u username -p
In my example, script.sql is the name of the file for the SQL commands you posted.