Update of /cvsroot/refdb/refdb/src
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12647
Modified Files:
mods_dbfncs.c
Log Message:
added extended notes stuff for sqlite
Index: mods_dbfncs.c
===================================================================
RCS file: /cvsroot/refdb/refdb/src/mods_dbfncs.c,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -U2 -r1.1 -r1.2
--- mods_dbfncs.c 17 May 2004 23:12:51 -0000 1.1
+++ mods_dbfncs.c 20 Jun 2004 21:48:56 -0000 1.2
@@ -1872,4 +1872,54 @@
dbi_result_free(dbires);
+ /* create the extended notes table */
+ dbires = dbi_conn_query(conn, "CREATE TABLE t_xtnote \
+ (xtnote_id INTEGER PRIMARY KEY, \
+ xtnote_key TEXT UNIQUE, \
+ xtnote_title TEXT, \
+ xtnote_content_type TEXT, \
+ xtnote_content_xmllang TEXT, \
+ xtnote_user_id INTEGER, \
+ xtnote_date DATE, \
+ xtnote_content TEXT)");
+
+
+ if (!dbires) {
+ tiwrite(ptr_clrequest->fd, "create t_xtnote failed\n", TERM_NO);
+ return 1;
+ }
+
+ dbi_result_free(dbires);
+
+ /* create t_xtnote table indexes */
+ dbires = dbi_conn_query(conn, "CREATE INDEX i_xtnote_title ON t_xtnote (xtnote_title)");
+
+
+ if (!dbires) {
+ tiwrite(ptr_clrequest->fd, "create i_xtnote_title failed\n", TERM_NO);
+ return 1;
+ }
+
+ dbi_result_free(dbires);
+
+ dbires = dbi_conn_query(conn, "CREATE INDEX i_xtnote_xtnote_userid ON t_xtnote (xtnote_user_id)");
+
+
+ if (!dbires) {
+ tiwrite(ptr_clrequest->fd, "create i_xtnote_xtnote_userid failed\n", TERM_NO);
+ return 1;
+ }
+
+ dbi_result_free(dbires);
+
+ dbires = dbi_conn_query(conn, "CREATE INDEX i_xtnote_date ON t_xtnote (xtnote_date)");
+
+
+ if (!dbires) {
+ tiwrite(ptr_clrequest->fd, "create i_xtnote_date failed\n", TERM_NO);
+ return 1;
+ }
+
+ dbi_result_free(dbires);
+
return 0;
}
|
