full-sql

[ Pobierz całość w formacie PDF ]
CREATE TABLE ally (id int(11) NOT NULL AUTO_INCREMENT,name varchar(200) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,short varchar(100) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,points int(20) NOT NULL,rank int(11) NOT NULL,best_points int(20) NOT NULL,members int(11) NOT NULL,villages int(11) NOT NULL,intern_text text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,description text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,homepage varchar(640) COLLATE utf8_unicode_ci NOT NULL,irc varchar(640) COLLATE utf8_unicode_ci NOT NULL,image varchar(20) COLLATE utf8_unicode_ci NOT NULL,intro_igm text COLLATE utf8_unicode_ci NOT NULL,PRIMARY KEY (id),KEY rank (rank),KEY name (name),KEY short (short)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;CREATE TABLE ally_contracts (from_ally int(11) NOT NULL,type varchar(10) COLLATE latin1_general_ci NOT NULL,to_ally int(11) NOT NULL,short varchar(6) COLLATE latin1_general_ci NOT NULL,id int(11) NOT NULL AUTO_INCREMENT,PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;CREATE TABLE ally_events (id int(11) NOT NULL AUTO_INCREMENT,ally int(11) NOT NULL,time varchar(200) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,message text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,PRIMARY KEY (id),KEY ally (ally),KEY time (time)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;CREATE TABLE ally_invites (id int(11) NOT NULL AUTO_INCREMENT,from_ally int(11) NOT NULL,to_userid int(11) NOT NULL,to_username varchar(200) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,time int(40) NOT NULL,PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;CREATE TABLE announcement (id int(11) NOT NULL AUTO_INCREMENT,text text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,link varchar(320) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,graphic varchar(100) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,time int(15) NOT NULL,PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;CREATE TABLE build (id int(11) NOT NULL AUTO_INCREMENT,mode varchar(30) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,building varchar(30) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,villageid int(11) DEFAULT NULL,end_time int(25) NOT NULL,build_time int(25) NOT NULL,PRIMARY KEY (id),KEY villageid (villageid)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;CREATE TABLE create_village (nw_c int(10) NOT NULL DEFAULT '1',no_c int(10) NOT NULL DEFAULT '1',so_c int(10) NOT NULL DEFAULT '1',sw_c int(10) NOT NULL DEFAULT '1',nw int(10) NOT NULL DEFAULT '0',no int(10) NOT NULL DEFAULT '0',so int(10) NOT NULL DEFAULT '0',sw int(10) NOT NULL DEFAULT '0',no_alpha int(10) NOT NULL DEFAULT '0',nw_alpha int(10) NOT NULL DEFAULT '0',so_alpha int(10) NOT NULL DEFAULT '0',sw_alpha int(10) NOT NULL DEFAULT '0',next_left int(15) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;INSERT INTO `create_village` VALUES (1, 3, 3, 1, 0, 1, 1, 0, 0, 0, 0, 0, 6);CREATE TABLE dealers (id int(11) NOT NULL AUTO_INCREMENT,from_userid int(11) NOT NULL,to_userid int(11) NOT NULL,from_village int(11) NOT NULL,to_village int(11) NOT NULL,wood int(11) NOT NULL,stone int(11) NOT NULL,iron int(11) NOT NULL,start_time int(11) NOT NULL,end_time int(11) NOT NULL,is_offer int(1) NOT NULL DEFAULT '0',dealers int(6) NOT NULL DEFAULT '0',type varchar(4) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,PRIMARY KEY (id),KEY from_village (from_village),KEY to_village (to_village)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;CREATE TABLE destroy (id int(11) NOT NULL AUTO_INCREMENT,building varchar(30) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,villageid int(11) NOT NULL,end_time int(25) NOT NULL,build_time int(25) NOT NULL,PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;CREATE TABLE events (id int(11) NOT NULL AUTO_INCREMENT,event_time int(11) DEFAULT '0',event_type varchar(15) CHARACTER SET latin1 COLLATE latin1_german1_ci DEFAULT NULL,event_id int(11) NOT NULL,user_id int(11) NOT NULL,villageid int(15) DEFAULT NULL,knot_event int(15) NOT NULL,cid varchar(32) CHARACTER SET latin1 COLLATE latin1_german1_ci DEFAULT '0',can_knot int(1) NOT NULL DEFAULT '0',is_locked int(1) NOT NULL,PRIMARY KEY (id),KEY event_type (event_type),KEY event_id (event_id),KEY event_time (event_time),KEY user_id (user_id),KEY villageid (villageid)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;CREATE TABLE groups (id int(11) unsigned NOT NULL AUTO_INCREMENT,group_name varchar(255) COLLATE latin1_general_ci NOT NULL,user_id int(11) unsigned NOT NULL,PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;CREATE TABLE `knight_items` (`uid` INT(11) NOT NULL ,`chosen` VARCHAR(150) NULL ,`progress` INT(3) NULL ,`last_actu` INT(35) NULL ,`spear` ENUM('false','true') NOT NULL DEFAULT 'false',`sword` ENUM('false','true') NOT NULL DEFAULT 'false',`axe` ENUM('false','true') NOT NULL DEFAULT 'false',`archer` ENUM('false','true') NOT NULL DEFAULT 'false',`spy` ENUM('false','true') NOT NULL DEFAULT 'false',`light` ENUM('false','true') NOT NULL DEFAULT 'false',`heavy` ENUM('false','true') NOT NULL DEFAULT 'false',`marcher` ENUM('false','true') NOT NULL DEFAULT 'false',`ram` ENUM('false','true') NOT NULL DEFAULT 'false',`catapult` ENUM('false','true') NOT NULL DEFAULT 'false',`snob` ENUM('false','true') NOT NULL DEFAULT 'false',PRIMARY KEY (uid)) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;CREATE TABLE login (login_locked enum('yes','no') CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT 'no',start varchar(50) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,first_visit tinyint(1) NOT NULL DEFAULT '0',extern_auth varchar(32) COLLATE utf8_unicode_ci NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;CREATE TABLE logins (id int(11) NOT NULL AUTO_INCREMENT,username varchar(250) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,time int(33) NOT NULL,ip varchar(30) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,userid int(11) NOT NULL,uv varchar(250) COLLATE utf8_unicode_ci NOT NULL,PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;CREATE TABLE logs (id int(11) NOT NULL AUTO_INCREMENT,user varchar(320) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,village varchar(320) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,time int(40) NOT NULL,log text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,event_id int(11) NOT NULL,event_type varchar(25) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;CREATE TABLE mail_archiv (id int(11) NOT NULL AUTO_INCREMENT,from_id int(11) NOT NULL DEFAULT '0',from_username varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',to_id int(11) NOT NULL DEFAULT '0',to_username varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',subject varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT '',text text CHARACTER SET latin1 NOT NULL,time int(35) NOT NULL DEFAULT '0',owner int(11) NOT NULL,type varchar(3) CHARACTER SET latin1 NOT NULL,PRIMARY KEY (id),KEY to_id (to_id)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;CREATE TABLE mail_block (id int(11) NOT NULL AUTO_INCREMENT,userid int(11) NOT NULL,blocked_id int(11) NOT NULL,blocked_name varchar(150) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,PRIMARY KEY (id),KEY blocked_id (blocked_id),KEY blocked_name (blocked_name)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;CREATE TABLE mail_in (id int(11) NOT NULL AUTO_INCREMENT,from_id int(11) NOT NULL DEFAULT '0',from_username varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',to_id int(11) NOT NULL DEFAULT '0',to_username varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',subject varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT '',text text CHARACTER SET latin1 NOT NULL,is_read int(1) NOT NULL DEFAULT '0',is_answered int(1) NOT NULL DEFAULT '0',output_id int(11) NOT NULL DEFAULT '0',time int(35) NOT NULL DEFAULT '0',PRIMARY KEY (id),KEY to_id (to_id)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;CREATE TABLE mail_out (id int(11) NOT NULL AUTO_INCREMENT,from_id int(11) NOT NULL DEFAULT '0',from_username varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',to_id int(11) NOT NULL DEFAULT '0',to_username varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',subject varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT '',text text CHARACTER SET latin1 NOT NULL,is_read int(1) NOT NULL DEFAULT '0',time int(35) NOT NULL DEFAULT '0',PRIMARY KEY (id),KEY from_id (from_id)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;CREATE TABLE map_styling (id int(11) NOT NULL AUTO_INCREMENT,x int(11) NOT NULL,y int(11) NOT NULL,type varchar(32) COLLATE latin1_general_ci NOT NULL,name varchar(32) COLLATE latin1_general_ci NOT NULL,PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;CREATE TABLE movements (id int(11) NOT NULL AUTO_INCREMENT,from_village int(11) DEFAULT NULL,to_village int(11) DEFAULT NULL,units varchar(350) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,type varchar(15) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,start_time int(25) NOT NULL,e... [ Pobierz całość w formacie PDF ]

zanotowane.pl

doc.pisz.pl

pdf.pisz.pl

radiodx.htw.pl