mysql_select_db("nombre-base-de-datos", $con);
mysql_query("CREATE TABLE
catalogue (
id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id),
idadmin VARCHAR(25) CHARACTER SET utf8 COLLATE
utf8_general_ci,
date_entry VARCHAR(100)
CHARACTER SET utf8 COLLATE utf8_general_ci,
date_update VARCHAR(100) CHARACTER SET utf8 COLLATE
utf8_general_ci,
uri VARCHAR(500) CHARACTER SET utf8 COLLATE
utf8_general_ci,
typedocid
VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci,
typedoc VARCHAR(255) CHARACTER SET utf8 COLLATE
utf8_general_ci,
subtypedoc
VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
signature_decimal VARCHAR(50) CHARACTER SET utf8
COLLATE utf8_general_ci,
signature_surname VARCHAR(50) CHARACTER SET utf8
COLLATE utf8_general_ci,
signature_head VARCHAR(50)
CHARACTER SET utf8 COLLATE utf8_general_ci,
title
VARCHAR(500)
CHARACTER SET utf8 COLLATE utf8_general_ci,
title_alf
VARCHAR(500) CHARACTER SET utf8 COLLATE
utf8_general_ci,
subtitle
VARCHAR(500) CHARACTER SET utf8 COLLATE
utf8_general_ci,
othertitle VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci,
uniformtitle VARCHAR(500)
CHARACTER SET utf8 COLLATE utf8_general_ci,
uniformtitle_alf VARCHAR(500) CHARACTER SET utf8 COLLATE
utf8_general_ci,
translatetitle VARCHAR(500)
CHARACTER SET utf8 COLLATE utf8_general_ci,
language
VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
edition VARCHAR(255) CHARACTER SET utf8 COLLATE
utf8_general_ci,
authorities
TEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
authorities_alf
VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci,
lawtype VARCHAR(255) CHARACTER SET utf8 COLLATE
utf8_general_ci,
lawdate VARCHAR(100) CHARACTER SET utf8 COLLATE
utf8_general_ci,
lawcode VARCHAR(255) CHARACTER SET utf8 COLLATE
utf8_general_ci,
lawcountry VARCHAR(255)
CHARACTER SET utf8 COLLATE utf8_general_ci,
lawregion
VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
lawcity VARCHAR(255) CHARACTER SET utf8 COLLATE
utf8_general_ci,
periodicity
VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
pubplace
VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
pubdate VARCHAR(100) CHARACTER SET utf8 COLLATE
utf8_general_ci,
date1 VARCHAR(100) CHARACTER SET utf8 COLLATE
utf8_general_ci,
date2 VARCHAR(100) CHARACTER SET utf8 COLLATE
utf8_general_ci,
serie
VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci,
nserie VARCHAR(25) CHARACTER SET utf8 COLLATE
utf8_general_ci,
physical
VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_general_ci,
npages VARCHAR(25) CHARACTER SET utf8 COLLATE
utf8_general_ci,
ncms
VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci,
summary TEXT CHARACTER
SET utf8 COLLATE utf8_general_ci,
fulltext1
MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
fulltext2
MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
fulltext3
MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
fulltext4
MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
fulltext5
MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
notes TEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
rights VARCHAR(500) CHARACTER SET utf8 COLLATE
utf8_general_ci,
rightscases VARCHAR(500) CHARACTER SET utf8 COLLATE
utf8_general_ci,
decimalid1 VARCHAR(10) CHARACTER SET utf8 COLLATE
utf8_general_ci,
decimalnumber1 VARCHAR(50) CHARACTER SET utf8 COLLATE
utf8_general_ci,
decimaltext1 VARCHAR(300)
CHARACTER SET utf8 COLLATE utf8_general_ci,
decimalid2 VARCHAR(10) CHARACTER SET utf8 COLLATE
utf8_general_ci,
decimalnumber2 VARCHAR(50) CHARACTER SET utf8 COLLATE
utf8_general_ci,
decimaltext2 VARCHAR(300)
CHARACTER SET utf8 COLLATE utf8_general_ci,
categoryid
VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci,
category1
VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
category2
VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
category3
VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
category4
VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
bagtags TEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
edocument VARCHAR(500) CHARACTER SET utf8 COLLATE
utf8_general_ci,
urlresources TEXT CHARACTER SET
utf8 COLLATE utf8_general_ci,
reference
TEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
cite
VARCHAR(255) CHARACTER SET
utf8 COLLATE utf8_general_ci,
relationid1
VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci,
relationtype1 VARCHAR(50)
CHARACTER SET utf8 COLLATE utf8_general_ci,
relationprop1 VARCHAR(150)
CHARACTER SET utf8 COLLATE utf8_general_ci,
relationtitle1 VARCHAR(300)
CHARACTER SET utf8 COLLATE utf8_general_ci,
relationid2
VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci,
relationtype2 VARCHAR(50)
CHARACTER SET utf8 COLLATE utf8_general_ci,
relationprop2 VARCHAR(150)
CHARACTER SET utf8 COLLATE utf8_general_ci,
relationtitle2 VARCHAR(300)
CHARACTER SET utf8 COLLATE utf8_general_ci,
relationid3
VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci,
relationtype3 VARCHAR(50)
CHARACTER SET utf8 COLLATE utf8_general_ci,
relationprop3 VARCHAR(150)
CHARACTER SET utf8 COLLATE utf8_general_ci,
relationtitle3 VARCHAR(300)
CHARACTER SET utf8 COLLATE utf8_general_ci,
indexer LONGTEXT CHARACTER
SET utf8 COLLATE utf8_general_ci,
FULLTEXT(indexer)
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE
utf8_general_ci",$con);
echo "<div><li>La tabla
<b>catalogue</b> fue creada
correctamente.</li></div>";
|