--- 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)
);