lib/create_db.sql
branchxbelweb
changeset 26 17b0cd274530
parent 21 345ee7421989
child 38 c30e2402deca
--- a/lib/create_db.sql	Sat Sep 27 01:44:43 2003 -0400
+++ b/lib/create_db.sql	Sat Sep 27 03:17:30 2003 -0400
@@ -14,9 +14,9 @@
 CREATE TABLE bookmarks (
   id int NOT NULL,
   userid int NOT NULL,
-  url varchar(255) DEFAULT '' NOT NULL,
-  name varchar(255) DEFAULT '' NOT NULL,
-  ldesc varchar(255) DEFAULT '' NOT NULL,
+  url varchar(1023) DEFAULT '' NOT NULL,
+  name varchar(1023) DEFAULT '' NOT NULL,
+  ldesc varchar(1023) DEFAULT '' NOT NULL,
   added date DEFAULT '1998-01-01' NOT NULL,
   PRIMARY KEY (id, userid)
 );
@@ -29,7 +29,7 @@
 CREATE TABLE keywords (
   id int DEFAULT '0' NOT NULL,
   userid int DEFAULT '0' NOT NULL,
-  name varchar(30) DEFAULT '' NOT NULL,
+  name varchar(255) DEFAULT '' NOT NULL,
   PRIMARY KEY (id, userid)
 );