Ceriwis  

Go Back   Ceriwis > HOBI > Komputer & Teknologi > Programming

Programming Share, tanya jawab, saling bantu antar programmer dengan berbagai macam bahasa pemrograman.

Reply
 
Thread Tools
  #1  
Old 11th November 2011
Braincode's Avatar
Braincode Braincode is offline
Ceriwis Addicted
 
Join Date: Nov 2011
Posts: 4,638
Rep Power: 21
Braincode mempunyai hidup yang Normal
Default [SQL]Bantuin dong, ada yang error nih....

Code:

#
# Table structure for table 'Rsc'
#

DROP TABLE Rsc;

CREATE TABLE Rsc (
RscID int(11) NOT NULL auto_increment,
RscMD5 varchar(8) DEFAULT '' NOT NULL,
RscTypeID int(11) DEFAULT '0' NOT NULL,
RscName varchar(127) DEFAULT '' NOT NULL,
IsURL smallint(6) DEFAULT '-1' NOT NULL,
RscStateID int(11) DEFAULT '0' NOT NULL,
InCache smallint(6) DEFAULT '-1' NOT NULL,
Size int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (RscID),
KEY RscTypeID (RscTypeID),
KEY RscMD5 (RscName),
KEY RscName (RscName)
);

#
# Table structure for table 'RscComp'
#

DROP TABLE RscComp;

CREATE TABLE RscComp (
RscCompID int(11) NOT NULL auto_increment,
RscID int(11) DEFAULT '0' NOT NULL,
RscCompTypeID int(11) DEFAULT '0' NOT NULL,
Position int(11) DEFAULT '0' NOT NULL,
Size int(11) DEFAULT '0' NOT NULL,
Filename char(255),
PRIMARY KEY (RscCompID),
KEY RscID (RscID),
KEY RscCompTypeID (RscCompTypeID),
KEY Position (Position),
KEY Size (Size)
);

#
# Table structure for table 'RscCompType'
#

DROP TABLE RscCompType;

CREATE TABLE RscCompType (
RscCompTypeID int(11) NOT NULL auto_increment,
RscCompType char(50) DEFAULT '' NOT NULL,
PRIMARY KEY (RscCompTypeID)
);

#
# Dumping data for table 'RscCompType'
#

INSERT INTO RscCompType VALUES (1,'Gif');
INSERT INTO RscCompType VALUES (2,'Jpeg');
INSERT INTO RscCompType VALUES (3,'HTML');
INSERT INTO RscCompType VALUES (4,'Text');

#
# Table structure for table 'RscCompView'
#

DROP TABLE RscCompView;

CREATE TABLE RscCompView (
RscCompViewID int(11) NOT NULL auto_increment,
RscCompID int(11) DEFAULT '0' NOT NULL,
req_date timestamp(14),
PRIMARY KEY (RscCompViewID),
KEY req_date (req_date),
KEY RscCompID (RscCompID)
);

#
# Table structure for table 'RscFetch'
#

DROP TABLE RscFetch;

CREATE TABLE RscFetch (
RscFetchID int(11) NOT NULL auto_increment,
RscID int(11) DEFAULT '0' NOT NULL,
FetchDate timestamp(14),
FetchSeconds double(16,4) DEFAULT '0.0000' NOT NULL,
FromCache smallint(6) DEFAULT '0' NOT NULL,
Size int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (RscFetchID),
KEY RscID (RscID),
KEY FetchDate (FetchDate)
);

#
# Table structure for table 'RscMail'
#

DROP TABLE RscMail;

CREATE TABLE RscMail (
RscMailID int(11) NOT NULL auto_increment,
RscMD5 varchar(8) DEFAULT '' NOT NULL,
Position int(11) DEFAULT '0' NOT NULL,
RendID int(11) DEFAULT '0' NOT NULL,
Mailfrom varchar(127) DEFAULT '' NOT NULL,
Mailto varchar(127) DEFAULT '' NOT NULL,
Comment text,
req_date timestamp(14),
PRIMARY KEY (RscMailID),
KEY RscMD5 (RscMD5),
KEY Position (Position),
KEY RendID (RendID),
KEY Mailto (Mailto),
KEY req_date (req_date)
);

#
# Table structure for table 'RscType'
#

DROP TABLE RscType;

CREATE TABLE RscType (
RscTypeID int(11) NOT NULL auto_increment,
RscType char(50) DEFAULT '' NOT NULL,
PRIMARY KEY (RscTypeID)
);

#
# Dumping data for table 'RscType'
#

INSERT INTO RscType VALUES (1,'(Unknown)');
INSERT INTO RscType VALUES (2,'Postscript');
INSERT INTO RscType VALUES (3,'PDF');
INSERT INTO RscType VALUES (4,'Word');
INSERT INTO RscType VALUES (5,'RTF');
INSERT INTO RscType VALUES (6,'Jpeg');
INSERT INTO RscType VALUES (7,'Gif');

#
# Table structure for table 'RscTypeRend'
#

DROP TABLE RscTypeRend;

CREATE TABLE RscTypeRend (
RscTypeRendID int(11) NOT NULL auto_increment,
RscTypeID int(11) DEFAULT '0' NOT NULL,
RendDefault smallint(6) DEFAULT '0' NOT NULL,
RscTypeRend char(50),
RendCmd char(127),
PRIMARY KEY (RscTypeRendID),
KEY RscTypeID (RscTypeID),
KEY RendDefault (RendDefault)
);

#
# Dumping data for table 'RscTypeRend'
#

INSERT INTO RscTypeRend VALUES (1,1,-1,'Plain','');
INSERT INTO RscTypeRend VALUES (2,2,-1,'As images','');
INSERT INTO RscTypeRend VALUES (3,3,-1,'As images','');
INSERT INTO RscTypeRend VALUES (4,4,-1,'As html','');
INSERT INTO RscTypeRend VALUES (5,5,-1,'As html','');

bantuin dong gan....

pas upload ke phpmyadmin

ada tulisan error...

mungkin agan mau bantuin saya

</div>
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Terkait
Thread Thread Starter Forum Replies Last Post
[help]TweetDeck error,bantuin dong gan [CENDOL INSIDE] KernPanic Shareware & Freeware 0 24th October 2012 12:51 PM
yang udah pernah ke Jogja, bantuin dong... AnakPulau Travel, Wisata, Liburan 0 3rd October 2012 10:27 AM
gan tolong bantuin ane dong, ada yang mau ane tanyain sleepingbaby Lounge 0 28th May 2012 06:34 AM
bantuin dek bela yang lucu ini dong gan (yang mo bantuin dpt cendol ) lumpiabasah Lounge 0 27th May 2012 05:34 PM
[Help] yang paham actionscript 2.0 bantuin ane dong Guesuper Programming 0 20th November 2011 09:24 AM

 


All times are GMT +7. The time now is 09:44 AM.