0000023: Database schema rot ...

Viewing Issue Simple Details [ Jump to Notes ]

[ << ] [ >> ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000023

[Starfish PBX] Debian Package

minor

have not tried

2009-09-16 14:19

2009-09-16 17:13

Reporter

dazza

View Status

public

Assigned To

Priority

normal

Resolution

open

Status

acknowledged

Summary

0000023: Database schema rot ...

Description

I installed the latest .deb, but it looks like you've made some changes to the database schema. Current source code says:

--
-- Table structure for table `Admins`
--

DROP TABLE IF EXISTS `Admins`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE IF NOT EXISTS `Admins` (
  `PK_Admin` int(10) unsigned NOT NULL auto_increment,
  `Username` varchar(20) NOT NULL,
  `Password` varchar(100) NOT NULL,
  `Protected` tinyint(1) NOT NULL,
  `DateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY (`PK_Admin`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
SET character_set_client = @saved_cs_client;

Whereas I only have:

mysql> describe Admins
    -> ;
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| PK_User | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | | NULL | |
| password | varchar(100) | NO | | NULL | |
+----------+------------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

Should I just hand-crank the SQL schema changes, or is there an upgrade procedure I missed?

Additional Information

Tags

No tags attached.

Attached Files

Relationships

Notes
(0000032) rgavril (administrator) 2009-09-16 17:13	I was too lazy to add the sql update to the deb package. I suggest doing the changes manually or installing with a clean database. I will take care of the sql schema updates soon as I have a clear release cycle, now I consider the debs a developer releases.

Issue History
Date Modified	Username	Field	Change
2009-09-16 14:19	dazza	New Issue
2009-09-16 17:13	rgavril	Note Added: 0000032
2009-09-16 17:13	rgavril	Status	new => acknowledged

Mantis 1.1.8[^]