diff options
author | Andrew Dolgov <[email protected]> | 2005-12-16 06:48:45 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-12-16 06:48:45 +0100 |
commit | 855d0ecfda212ef36f35fff63e93dc8c6afd1126 (patch) | |
tree | 7538a8d09a3e06ee19c9b72c83b64f57cf0d4675 /schema/ttrss_schema_mysql.sql | |
parent | e93a3c96bb7baf28be14918387839d172dbb5e9b (diff) |
schema: wrap table creation in transaction block
Diffstat (limited to 'schema/ttrss_schema_mysql.sql')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index db0e1b846..438d46054 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -16,6 +16,8 @@ drop table if exists ttrss_feed_categories; drop table if exists ttrss_users; drop table if exists ttrss_themes; +begin; + create table ttrss_themes(id integer not null primary key auto_increment, theme_name varchar(200) not null, theme_path varchar(200) not null) TYPE=InnoDB; @@ -235,4 +237,4 @@ create table ttrss_user_prefs ( index (pref_name), foreign key (pref_name) references ttrss_prefs(pref_name) ON DELETE CASCADE) TYPE=InnoDB; - +commit; |