Changeset 20411 for branches/version-2_5-dev/html

Timestamp:

2011/02/25 21:44:58 (15 years ago)

Author:

shutta

Message:

refs #1058
mtb_page_rowsの廃止

Location:

branches/version-2_5-dev/html/install/sql

Files:

• create_table_mysql.sql (modified) (1 diff)
• create_table_pgsql.sql (modified) (1 diff)
• drop_table.sql (modified) (1 diff)
• insert_data.sql (modified) (1 diff)

branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

@@ -984 +984 @@
 ) ENGINE=InnoDB;
 
-CREATE TABLE mtb_page_rows (
-    id smallint,
-    name text,
-    rank smallint NOT NULL DEFAULT 0,
-    PRIMARY KEY (id)
-) ENGINE=InnoDB;
-
 CREATE TABLE mtb_mail_type (
     id smallint,

branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

@@ -984 +984 @@
 );
 
-CREATE TABLE mtb_page_rows (
-    id smallint,
-    name text,
-    rank smallint NOT NULL DEFAULT 0,
-    PRIMARY KEY (id)
-);
-
 CREATE TABLE mtb_mail_type (
     id smallint,

branches/version-2_5-dev/html/install/sql/drop_table.sql

@@ -57 +57 @@
 DROP TABLE mtb_product_list_max;
 DROP TABLE mtb_permission;
-DROP TABLE mtb_page_rows;
 DROP TABLE mtb_page_max;
 DROP TABLE mtb_order_status_color;

branches/version-2_5-dev/html/install/sql/insert_data.sql

@@ -832 +832 @@
 INSERT INTO mtb_page_max (id, name, rank) VALUES (90, '90', 8);
 INSERT INTO mtb_page_max (id, name, rank) VALUES (100, '100', 9);
-
-INSERT INTO mtb_page_rows (id, name, rank) VALUES (10, '10', 0);
-INSERT INTO mtb_page_rows (id, name, rank) VALUES (20, '20', 1);
-INSERT INTO mtb_page_rows (id, name, rank) VALUES (30, '30', 2);
-INSERT INTO mtb_page_rows (id, name, rank) VALUES (40, '40', 3);
-INSERT INTO mtb_page_rows (id, name, rank) VALUES (50, '50', 4);
-INSERT INTO mtb_page_rows (id, name, rank) VALUES (60, '60', 5);
-INSERT INTO mtb_page_rows (id, name, rank) VALUES (70, '70', 6);
-INSERT INTO mtb_page_rows (id, name, rank) VALUES (80, '80', 7);
-INSERT INTO mtb_page_rows (id, name, rank) VALUES (90, '90', 8);
-INSERT INTO mtb_page_rows (id, name, rank) VALUES (100, '100', 9);
 
 INSERT INTO mtb_permission (id, name, rank) VALUES ('/admin/system/index.php', '0', 0);