Enlightenment CVS committal
Author : titan
Project : e17
Module : proto
Dir : e17/proto/ephoto/src
Modified Files:
ephoto.c ephoto_callbacks.c
Log Message:
Formatting.
===================================================================
RCS file: /cvs/e/e17/proto/ephoto/src/ephoto.c,v
retrieving revision 1.61
retrieving revision 1.62
diff -u -3 -r1.61 -r1.62
--- ephoto.c 20 Jul 2006 06:55:51 -0000 1.61
+++ ephoto.c 20 Jul 2006 07:30:31 -0000 1.62
@@ -37,14 +37,22 @@
if (!ecore_file_exists(database))
{
sqlite3_open(database, &db);
- sqlite3_exec(db, "create table albums (id INTEGER AUTOINCREMENT PRIMARY KEY,
name varchar(255));", NULL, 0, 0);
- sqlite3_exec(db, "create table a_images (id INTEGER AUTOINCREMENT PRIMARY
KEY, name varchar(255));", NULL, 0, 0);
- sqlite3_exec(db, "create table albums_full (id INTEGER AUTOINCREMENT PRIMARY
KEY, alubm_id int, image_id int);", NULL, 0, 0);
- sqlite3_exec(db, "create table slideshows (id INTEGER AUTOINCREMENT PRIMARY
KEY, name varchar(255));", NULL, 0, 0);
- sqlite3_exec(db, "create table s_images (id INTEGER AUTOINCREMENT PRIMARY
KEY, name varchar(255));", NULL, 0, 0);
- sqlite3_exec(db, "create_table slideshows_images_full (id INTEGER
AUTOINCREMENT PRIMARY KEY, slideshows_id int, images_id int);", NULL, 0, 0);
- sqlite3_exec(db, "create table s_settings (id INTEGER AUTOINCREMENT PRIMARY
KEY, name varchar(255));", NULL, 0, 0);
- sqlite3_exec(db, "create table slideshows_settings_full (id INTEGER
AUTOINCREMENT PRIMARY KEY, slideshows_id int, settings_id int);", NULL, 0, 0);
+ sqlite3_exec(db, "CREATE TABLE albums(id INTEGER AUTOINCREMENT PRIMARY KEY,"
+ "name VARCHAR(255));", NULL, NULL, NULL);
+ sqlite3_exec(db, "CREATE TABLE a_images(id INTEGER AUTOINCREMENT PRIMARY
KEY,"
+ "name VARCHAR(255));", NULL, NULL, NULL);
+ sqlite3_exec(db, "CREATE TABLE albums_full(id INTEGER AUTOINCREMENT PRIMARY
KEY,"
+ "album_id INTEGER, image_id INTEGER);", NULL, NULL,
NULL);
+ sqlite3_exec(db, "CREATE TABLE slideshows(id INTEGER AUTOINCREMENT PRIMARY
KEY,"
+ "name VARCHAR(255));", NULL, NULL, NULL);
+ sqlite3_exec(db, "CREATE TABLE s_images(id INTEGER AUTOINCREMENT PRIMARY
KEY,"
+ "name VARCHAR(255));", NULL, NULL, NULL);
+ sqlite3_exec(db, "CREATE TABLE slideshows_images_full(id INTEGER
AUTOINCREMENT PRIMARY KEY,"
+ "slideshows_id INTEGER, images_id INTEGER);", NULL, 0,
0);
+ sqlite3_exec(db, "CREATE TABLE s_settings(id INTEGER AUTOINCREMENT PRIMARY
KEY,"
+ "name VARCHAR(255));", NULL, NULL, NULL);
+ sqlite3_exec(db, "CREATE TABLE slideshows_settings_full(id INTEGER
AUTOINCREMENT PRIMARY KEY,"
+ "slideshows_id INTEGER, settings_id INTEGER);", NULL,
NULL, NULL);
sqlite3_close(db);
}
===================================================================
RCS file: /cvs/e/e17/proto/ephoto/src/ephoto_callbacks.c,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -3 -r1.4 -r1.5
--- ephoto_callbacks.c 20 Jul 2006 06:57:27 -0000 1.4
+++ ephoto_callbacks.c 20 Jul 2006 07:30:31 -0000 1.5
@@ -36,7 +36,7 @@
if (entry_text)
{
sqlite3_open(database, &db);
- sqlite3_exec(db, "insert into albums (name) values ('hello');", NULL, 0, 0);
+ sqlite3_exec(db, "INSERT OR IGNORE INTO albums (name) VALUES ('hello');",
NULL, NULL, NULL);
sqlite3_close(db);
m->icon = ewl_icon_new();
@@ -128,7 +128,7 @@
if (entry_text)
{
sqlite3_open(database, &db);
- sqlite3_exec(db, "insert into albums (name) values ('hello');", NULL, 0, 0);
+ sqlite3_exec(db, "INSERT OR IGNORE INTO albums (name) VALUES ('hello');",
NULL, NULL, NULL);
sqlite3_close(db);
m->icon = ewl_icon_new();
-------------------------------------------------------------------------
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
enlightenment-cvs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/enlightenment-cvs
