Enlightenment CVS committal
Author : titan
Project : e17
Module : proto
Dir : e17/proto/ephoto/src
Modified Files:
ephoto.c
Log Message:
A.Bout.Time. CHange around order of query to fix it.
===================================================================
RCS file: /cvs/e/e17/proto/ephoto/src/ephoto.c,v
retrieving revision 1.62
retrieving revision 1.63
diff -u -3 -r1.62 -r1.63
--- ephoto.c 20 Jul 2006 07:30:31 -0000 1.62
+++ ephoto.c 20 Jul 2006 09:11:09 -0000 1.63
@@ -37,21 +37,21 @@
if (!ecore_file_exists(database))
{
sqlite3_open(database, &db);
- sqlite3_exec(db, "CREATE TABLE albums(id INTEGER AUTOINCREMENT PRIMARY KEY,"
+ sqlite3_exec(db, "CREATE TABLE albums(id INTEGER PRIMARY KEY AUTOINCREMENT,"
"name VARCHAR(255));", NULL, NULL, NULL);
- sqlite3_exec(db, "CREATE TABLE a_images(id INTEGER AUTOINCREMENT PRIMARY
KEY,"
+ sqlite3_exec(db, "CREATE TABLE a_images(id INTEGER PRIMARY KEY
AUTOINCREMENT,"
"name VARCHAR(255));", NULL, NULL, NULL);
- sqlite3_exec(db, "CREATE TABLE albums_full(id INTEGER AUTOINCREMENT PRIMARY
KEY,"
+ sqlite3_exec(db, "CREATE TABLE albums_full(id INTEGER PRIMARY KEY
AUTOINCREMENT,"
"album_id INTEGER, image_id INTEGER);", NULL, NULL,
NULL);
- sqlite3_exec(db, "CREATE TABLE slideshows(id INTEGER AUTOINCREMENT PRIMARY
KEY,"
+ sqlite3_exec(db, "CREATE TABLE slideshows(id INTEGER PRIMARY KEY
AUTOINCREMENT,"
"name VARCHAR(255));", NULL, NULL, NULL);
- sqlite3_exec(db, "CREATE TABLE s_images(id INTEGER AUTOINCREMENT PRIMARY
KEY,"
+ sqlite3_exec(db, "CREATE TABLE s_images(id INTEGER PRIMARY KEY
AUTOINCREMENT,"
"name VARCHAR(255));", NULL, NULL, NULL);
- sqlite3_exec(db, "CREATE TABLE slideshows_images_full(id INTEGER
AUTOINCREMENT PRIMARY KEY,"
+ sqlite3_exec(db, "CREATE TABLE slideshows_images_full(id INTEGER PRIMARY KEY
AUTOINCREMENT,"
"slideshows_id INTEGER, images_id INTEGER);", NULL, 0,
0);
- sqlite3_exec(db, "CREATE TABLE s_settings(id INTEGER AUTOINCREMENT PRIMARY
KEY,"
+ sqlite3_exec(db, "CREATE TABLE s_settings(id INTEGER PRIMARY KEY
AUTOINCREMENT,"
"name VARCHAR(255));", NULL, NULL, NULL);
- sqlite3_exec(db, "CREATE TABLE slideshows_settings_full(id INTEGER
AUTOINCREMENT PRIMARY KEY,"
+ sqlite3_exec(db, "CREATE TABLE slideshows_settings_full(id INTEGER PRIMARY
KEY AUTOINCREMENT,"
"slideshows_id INTEGER, settings_id INTEGER);", NULL,
NULL, NULL);
sqlite3_close(db);
}
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
enlightenment-cvs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/enlightenment-cvs